Re: Report Generator Proposal
От | Gaetano Mendola |
---|---|
Тема | Re: Report Generator Proposal |
Дата | |
Msg-id | 003d01c37b9d$85c1fa30$32add6c2@mm.eutelsat.org обсуждение исходный текст |
Ответ на | Report Generator Proposal ("Gaetano Mendola" <mendola@bigfoot.com>) |
Ответы |
Re: Report Generator Proposal
|
Список | 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 по дате отправления: