Re: Query Feromance

From: Marco Furetto
Subject: Re: Query Feromance
Date: ,
Msg-id: 441FCDD2.8010905@bluestudio.it
(view: Whole thread, Raw)
In response to: Re: Query Feromance  (Thomas Pundt)
Responses: Re: Query Feromance  (Thomas Pundt)
List: pgsql-performance

Tree view

Query Feromance  (Marco Furetto, )
 Re: Query Feromance  ("Reimer", )
  Re: Query Feromance  (Marco Furetto, )
   Re: Query Feromance  (Thomas Pundt, )
    Re: Query Feromance  (Marco Furetto, )
     Re: Query Feromance  (Thomas Pundt, )
    Re: Query Feromance  (Marco Furetto, )

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...


Thank's

Marco "Furetto" Berri


Thomas Pundt wrote:
> Hi,
>
> On Tuesday 21 March 2006 09:25, Marco Furetto wrote:
> | I'm managing the db of a "Content Management environment" and I'm
> | searching for a "Query analyzer" to improve performance because i don't
> | know how many and what type of queries are executing on the system (for
> | the "where and join" block).
>
> as a first step, I'd enable query duration logging; in postgresql.conf
> I have set
>
>   log_min_duration_statement = 3000
>
> this will log each query that needs more than 3 seconds to complete.
>
> The next step would be to "explain analyze" the problematic queries.
>
> Ciao,
> Thomas
>


pgsql-performance by date:

From: Adam Witney
Date:
Subject: Re: Best OS & Configuration for Dual Xeon w/4GB &
From: "Guillaume Smet"
Date:
Subject: Re: PostgreSQL and Xeon MP