Re: Report Generator Proposal

Sounds good ...it will save lot of emails floating around and time..

Regards,
Somasekhar Bangalore
Principal Software Engineer
ZenSutra Software Technologies Pvt. Ltd.
Suite 601, HM Geneva House
#14, Cunningham Road
Bangalore 560-052, India

Ph:+91-80-235-0481
Fax:+91-80-235-0486
Email: sbangalore@zensutra.com

Weaving the knowledge tapestry'


-----Original Message-----
From: Matt Clark [mailto:matt@ymogen.net]
Sent: Monday, September 15, 2003 11:00 PM
To: Gaetano Mendola; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Report Generator Proposal


I rather like it actually.  Cisco equipment has a 'show tech-support' command that does exactly that, dumps all the
config,HW/SW 
versions, current state, you name it.  If you have a problem you run that, attach the output to yr support email, and
99%of the 
time there's enough info there to solve the problem.

It'd be easy to automate all except the explain, a script that did everything else could then emit "If your preoblem
relatesto a 
specific query, then run 'explain analyze <query>' and attach it to your message as well".

> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Gaetano Mendola
> Sent: 15 September 2003 16:25
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Report Generator Proposal
>
>
> 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
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match