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

Re: measure database contention

From: "Robert Haas" <robertmhaas(at)gmail(dot)com>
To: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: "psql performance list" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: measure database contention
Date: 2008-12-17 14:18:54
Message-ID: 603c8f070812170618g3116a90du94cbf102f0336d59@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, Dec 16, 2008 at 2:32 PM, Jaime Casanova
<jcasanov(at)systemguards(dot)com(dot)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

In response to

Responses

pgsql-performance by date

Next:From: Merlin MoncureDate: 2008-12-17 14:49:26
Subject: Re: measure database contention
Previous:From: Albe LaurenzDate: 2008-12-17 07:34:23
Subject: Re: measure database contention

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