From: Thomas Pundt <mlists@rp-online.de>
To: pgsql-performance@postgresql.org
Subject: Re: Query Feromance
Date: Tue, 21 Mar 2006 11:58:43 +0100
Message-ID: <200603211158.43887.mlists@rp-online.de> (raw)
In-Reply-To: <441FCDD2.8010905@bluestudio.it>
References: <441EC34D.1000901@bluestudio.it>
<200603210943.57454.mlists@rp-online.de>
<441FCDD2.8010905@bluestudio.it>
Hi,
On Tuesday 21 March 2006 10:56, Marco Furetto wrote:
| ok, I enable query duration logging in postgresql.conf.
|
| where is the instruments for analyze the statistics queries executing on
| my db?
|
| Eg.: Number of query executing, total time for executing a single query,
| etc...
I don't know if there are tools or settings available for PostgreSQL that do
such number-of-query-accounting; but you can set the
log_min_duration_statement value to 0 to log all statements with their
duration.
See http://www.postgresql.org/docs/8.1/interactive/runtime-config.html
for more options on runtime configuration, especially 17.7 and 17.8
might be of interest for you.
Ciao,
Thomas
--
Thomas Pundt <thomas.pundt@rp-online.de> ---- http://rp-online.de/ ----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mlists@rp-online.de
Subject: Re: Query Feromance
In-Reply-To: <200603211158.43887.mlists@rp-online.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox