From: | "Gaetano Mendola" <mendola(at)bigfoot(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Report Generator Proposal |
Date: | 2003-09-10 02:10:43 |
Message-ID: | 001501c37740$c0c564c0$15720b3e@mm.eutelsat.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2003-09-10 02:20:42 | Re: How to create schema-specific users? |
Previous Message | Ron Mayer | 2003-09-10 00:49:41 | Re: Are 50 million rows a problem for postgres ? |