Re: Report Generator Proposal - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Report Generator Proposal
Date
Msg-id 003d01c37b9d$85c1fa30$32add6c2@mm.eutelsat.org
Whole thread Raw
In response to Report Generator Proposal  ("Gaetano Mendola" <mendola@bigfoot.com>)
Responses Re: Report Generator Proposal  ("Matt Clark" <matt@ymogen.net>)
List pgsql-admin
Must I suppose that the idea rejected ?

----- Original Message -----
From: ""Gaetano Mendola"" <mendola@bigfoot.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@bigfoot.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@postgresql.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@postgresql.org
>


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres is not closing JDBC connection .. Please help
Next
From: "Matt Clark"
Date:
Subject: Re: Report Generator Proposal