log_duration - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject log_duration
Date
Msg-id GNELIHDDFBOCMGBFGEFOIEHLCFAA.chriskl@familyhealth.com.au
Whole thread Raw
Responses Re: log_duration
List pgsql-hackers
Hi guys,

Looking at the log_duration postgresql.conf option.  How about adding an
option log_duration_min which is a value in milliseconds that is the minimum
time a query must run for before being logged.  Basically, what I'd be
interested in is "please log the SQL query and duration of all queries that
last longer than 500ms".

That way I can quickly find badly formed queries, index them, etc...

Idea?

Chris



pgsql-hackers by date:

Previous
From: Kevin Brown
Date:
Subject: Re: Irix 6.2, Postgres 7.3.1, some brokenness
Next
From: greg@turnstep.com
Date:
Subject: Re: PGP signing releases