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] 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 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"" <[EMAIL PROTECTED]> > > 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 > > > [EMAIL PROTECTED] , 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 [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
