Skip site navigation (1) Skip section navigation (2)

Re: Query Feromance

From: Thomas Pundt <mlists(at)rp-online(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query Feromance
Date: 2006-03-21 08:43:57
Message-ID: 200603210943.57454.mlists@rp-online.de (view raw or flat)
Thread:
Lists: pgsql-performance
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

-- 
Thomas Pundt <thomas(dot)pundt(at)rp-online(dot)de> ---- http://rp-online.de/ ----

In response to

Responses

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2006-03-21 09:50:49
Subject: Re: planner with index scan cost way off actual cost, advices to tweak cost constants?
Previous:From: Marco FurettoDate: 2006-03-21 08:25:50
Subject: Re: Query Feromance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group