Re: Report Generator Proposal

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
>

In response to

Responses

Browse pgsql-admin by date

  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