On Tue, Dec 16, 2008 at 2:32 PM, Jaime Casanova <jcasa...@systemguards.com.ec> wrote: > we have a some bad queries (developers are working on that), some of > them run in 17 secs and that is the average but when analyzing logs i > found that from time to time some of them took upto 3 mins (the same > query that normally runs in 17secs). > > so my question is: how could i look for contention problems?
Is it the exact same query? Sometimes you might find that the query plan changes depending on the particular values you have in there; it is worth running "EXPLAIN ANALYZE" to look for such cases. You might also want to look at pg_locks. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
