Report Generator Proposal

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

Responses

Browse pgsql-admin by date

  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 ?