"slow lock" log in addition to log_min_duration_statement ? - Mailing list pgsql-sql

From Bryce Nesbitt
Subject "slow lock" log in addition to log_min_duration_statement ?
Date
Msg-id 4CDB007E.7010904@obviously.com
Whole thread Raw
Responses Re: "slow lock" log in addition to log_min_duration_statement ?  (Joshua Tolley <eggyknap@gmail.com>)
List pgsql-sql
I have a cluster with log_min_duration_statement set to log slow 
queries. Presently what I'm tracking down is almost certainly a lock 
problem.  Is there any analog of log_min_duration_statement for locks?  
If there is a lock on a certain critical tables for more than a few 
hundredths of a second I want to know.

Similarly in pg_stat_activity, is there a way to get the parameters to 
the current_query?  I see the placeholders (e.g. $1, $2) but not the data.

This is with PostgreSQL 8.3.4
Thanks!


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: unexpected ORDER BY
Next
From: "Ozer, Pam"
Date:
Subject: Overlapping Ranges- Query Alternative