Report Generator in PHP-GTK that work with Pear-db. It's very easy for users...
http://agata.codigolivre.org.br Creator: Pablo ([EMAIL PROTECTED]) []s Mauricio On Monday 15 September 2003 18:25, kaolin fire wrote: > On Monday, September 15, 2003, at 02:06 PM, Gaetano Mendola wrote: > > ""Matt Clark"" <[EMAIL PROTECTED]> wrote: > >> It'd be easy to automate all except the explain, a script that did > > > > everything else could then emit "If your preoblem relates to a > > > >> specific query, then run 'explain analyze <query>' and attach it to > >> your > > > > message as well". > > > > Well, must be charge of psql store somewhere all selects performed > > between the BEGIN REPORT and END REPORT and perform > > the explain command of that selects with the explain; may be the really > > difficult here is that psql > > shall know all tables involved in a select and insert in the report the > > descriptions of that tables. > > Before to work on it I want be sure that is a good idea. > > > > Regards > > Gaetano Mendola > > sounds good. maybe with the option (enabled by default?) to only show > the columns used in the queries for the tables pulled. ((wheat from > chaff and all that)) > > hmm. though there's still the (some small percentage of) things that > could be going wrong with custom stored procedures. dumping those > would be (I'm presuming, based on the scope of the task as it's been > described) reasonably simply, but figuring out what they touch could be > prohibitive? > > kudos for any attempt, though, all around. :) > > -kaolin fire > -postgresql novice > -http://poemranker.com > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Maurício de Castro Coordenador de Desenvolvimento em Software Livre SOLIS - Cooperativa de Soluções Livres http://www.solis.coop.br 51 3011 0610 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
