Re: Report Generator Proposal

Oracle have something similar: RDA which generates HTML reports for the
hardware, SO, and database.
It doesn't do explains but does show which SQLs are the most expensive, etc.

It could be worth having a look at that for ideas on what and how to
report it.

Stephen.

Somasekhar Bangalore wrote:

>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(at)zensutra(dot)com
>
>Weaving the knowledge tapestry'
>
>
>-----Original Message-----
>From: Matt Clark [mailto:matt(at)ymogen(dot)net]
>Sent: Monday, September 15, 2003 11:00 PM
>To: Gaetano Mendola; pgsql-admin(at)postgresql(dot)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 relates to a
>specific query, then run 'explain analyze <query>' and attach it to your message as well".
>
>
>
>>-----Original Message-----
>>From: pgsql-admin-owner(at)postgresql(dot)org
>>[mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Gaetano Mendola
>>Sent: 15 September 2003 16:25
>>To: pgsql-admin(at)postgresql(dot)org
>>Subject: Re: [ADMIN] Report Generator Proposal
>>
>>
>>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
>>>
>>>
>>>
>>---------------------------(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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>