Re: Report Generator Proposal
От | Mauricio de Castro |
---|---|
Тема | Re: Report Generator Proposal |
Дата | |
Msg-id | 200309160729.40290.mcastro@solis.coop.br обсуждение исходный текст |
Ответ на | Re: Report Generator Proposal (kaolin fire <cognosco@tentacle.net>) |
Список | pgsql-admin |
Report Generator in PHP-GTK that work with Pear-db. It's very easy for users... http://agata.codigolivre.org.br Creator: Pablo (pablo@php.net) []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"" <matt@ymogen.net> 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 majordomo@postgresql.org -- Maurício de Castro Coordenador de Desenvolvimento em Software Livre SOLIS - Cooperativa de Soluções Livres http://www.solis.coop.br 51 3011 0610
В списке pgsql-admin по дате отправления: