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: [EMAIL PROTECTED] Weaving the knowledge tapestry' -----Original Message----- From: Matt Clark [mailto:[EMAIL PROTECTED]] Sent: Monday, September 15, 2003 11:00 PM To: Gaetano Mendola; [EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gaetano Mendola Sent: 15 September 2003 16:25 To: [EMAIL PROTECTED] Subject: Re: [ADMIN] Report Generator Proposal Must I suppose that the idea rejected ? ----- Original Message ----- From: ""Gaetano Mendola"" <[EMAIL PROTECTED]> Newsgroups: comp.databases.postgresql.admin Sent: Thursday, September 11, 2003 11:52 PM Subject: Re: Report Generator ProposalNobody 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"" <[EMAIL PROTECTED]> Newsgroups: comp.databases.postgresql.admin Sent: Wednesday, September 10, 2003 4:10 AM Subject: Report Generator ProposalHi all, each time that someone say: this query is slow, this query take forever,blabla 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 [EMAIL PROTECTED] , may be something like:BEGIN REPORT TO FILE <file_name> SELECT ...... END REPORT;orBEGIN 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 [EMAIL PROTECTED]---------------------------(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
