From: Julius T <julius@nsoft.lt>
To: pgsql-admin@postgresql.org
Subject: query execution time
Date: Tue, 5 Oct 2010 22:56:49 +0300
Message-ID: <1e5d6016dca5b8022106577ec316208f@mail.nsoft.lt> (raw)
Hello, everybody
recently I have found that queries on our customer database take longer to
execute than normally.
First thing we did was to log long queries. This led to nothing as queries
logged are usually executed fast. On the other hand sometimes they take
considerable amount of time... Then we tried using EXPLAIN ANALYZE - that
brings me to the question:
"Total runtime" of the query provided by the EXPLAIN ANALYZE is 0.200ms, but
the result of it comes after sometimes 0.2, sometimes 5 seconds. We use
pgAdmin tool to query the DB - it shows how long the query took to execute.
The question is why the difference of value provided by EXPLAIN ANALYZE and
observed one is so big? I know explain analyze has its overheads, but query
itself takes long to execute. Also we've checked if the internet traffic is
not too high - it appears not even close... Now I have run out of ideas what
to check... Can you give me a hint what else can cause such behavior ?
Thank You in advance.]
Julius Tuskenis
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: julius@nsoft.lt
Subject: Re: query execution time
In-Reply-To: <1e5d6016dca5b8022106577ec316208f@mail.nsoft.lt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox