Re: investigating slow queries through

From: Jacques Caron <jc(at)directinfos(dot)com>
To: Dan Harris <fbsd(at)drivefaster(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: investigating slow queries through
Date: 2005-06-20 18:45:54
Message-ID: 6.2.0.14.0.20050620204307.039e9e78@pop.interactivemediafactory.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

At 19:55 20/06/2005, Dan Harris wrote:
>Also, I'm sure some people will respond with "turn on query
>logging".. I've explored that option and the formatting of the log
>file and the fact that EVERY query is logged is not what I'm after
>for this project.

You can log just those queries that take "a little bit too much time". See
log_min_duration_statement in postgresql.conf. Set it really high, and
you'll only get those queries you're after.

Jacques.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-06-20 19:11:44 Re: investigating slow queries through pg_stat_activity
Previous Message Dan Harris 2005-06-20 17:55:59 investigating slow queries through pg_stat_activity