explain analyze reports that my queries are fast but they run very slowly

From: Nikolas Everett <nik9000(at)gmail(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: explain analyze reports that my queries are fast but they run very slowly
Date: 2012-12-27 17:10:11
Message-ID: CAPmjWd2XgV9d3zy3zc8L9PJRdoVM720g2zSQWsDKZsJkOqKMjw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

We just upgraded from 8.3 to 9.1 and we're seeing some performance
problems. When we EXPLAIN ANALYZE our queries the explain result claim
that the queries are reasonably fast but the wall clock time is way way
longer. Does anyone know why this might happen?

Like so:
db=>\timing
db=>EXPLAIN ANALYZE SELECT max(id) FROM foo WHERE blah_id = 1209123;

The plan is sensible. The estimates are sensible. The actual DB time
reads like it is very sensible. But the wall clock time is like 11 seconds
and the \timing report confirms it.

Any ideas?

Thanks!

Nik

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message François Beausoleil 2012-12-27 17:21:18 Re: explain analyze reports that my queries are fast but they run very slowly
Previous Message Tom Lane 2012-12-27 17:05:18 Re: Why does the query planner use two full indexes, when a dedicated partial index exists?