From: | Mauricio de Castro <mcastro(at)solis(dot)coop(dot)br> |
---|---|
To: | kaolin fire <cognosco(at)tentacle(dot)net>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Report Generator Proposal |
Date: | 2003-09-16 10:29:39 |
Message-ID: | 200309160729.40290.mcastro@solis.coop.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)php(dot)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(at)ymogen(dot)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(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Espenhain | 2003-09-16 11:54:54 | SQL-Statement |
Previous Message | Frédéric Burlet | 2003-09-16 07:38:23 | pg_ctl reload seems to not work |