From: | "Gaetano Mendola" <mendola(at)bigfoot(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Report Generator Proposal |
Date: | 2003-09-15 15:24:57 |
Message-ID: | 003d01c37b9d$85c1fa30$32add6c2@mm.eutelsat.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Must I suppose that the idea rejected ?
----- Original Message -----
From: ""Gaetano Mendola"" <mendola(at)bigfoot(dot)com>
Newsgroups: comp.databases.postgresql.admin
Sent: Thursday, September 11, 2003 11:52 PM
Subject: 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
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Matt Clark | 2003-09-15 17:30:18 | Re: Report Generator Proposal |
Previous Message | Tom Lane | 2003-09-15 14:29:54 | Re: Postgres is not closing JDBC connection .. Please help |