Re: Report Generator Proposal

Nobody entusiastic ? I'm wrong about my feeling ?
I think that have the psql able to generate a report
will increase the our better response to a user novice
or not ?

Regards
Gaetano Mendola

----- Original Message -----
From: ""Gaetano Mendola"" <mendola(at)bigfoot(dot)com>
Newsgroups: comp.databases.postgresql.admin
Sent: Wednesday, September 10, 2003 4:10 AM
Subject: Report Generator Proposal

> Hi all,
> each time that someone say: this query is slow, this query take forever,
bla
> bla bla
> all our request are:
>
> 1) Which version are you running ?
> 2) May I see your table definition?
> 3) May I see you configuration file?
> 4) May I see the explain ?
> 5) .......
>
> sometimes a beginner is scared about all these questions and even
> he/she don't know how do collect these informations and we lose
> important data about: "why that damn query is too slow"?
>
>
> may be is usefull generate an automatic report that take charge
> of collect all these informations and send it to a file or directly to
> pgsql-performance(at)postgresql(dot)org , may be something like:
>
>
> > BEGIN REPORT TO FILE <file_name>
> > SELECT ......
> > END REPORT;
>
>
> or
>
>
> > BEGIN REPORT TO EMAIL <address>
> > SELECT ......
> > END REPORT;
>
>
>
> Regards
> Gaetano Mendola
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>