From: | Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com> |
---|---|
To: | Julius T <julius(at)nsoft(dot)lt>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: query execution time |
Date: | 2010-10-05 21:39:36 |
Message-ID: | AANLkTi=O-_Tn3tOxPJhju2EN04RpursxNmzLm_QkPPa6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
I would try reindexing it is not said that it will be the case but
sometimes it may be helpful.
Regards
Luke
2010/10/5, Julius T <julius(at)nsoft(dot)lt>:
> 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
>
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Łukasz Brodziak
II MU Bioinformatyka
From | Date | Subject | |
---|---|---|---|
Next Message | hsienwen chu | 2010-10-06 01:19:00 | Question about the IO on full table scan operation |
Previous Message | Kevin Grittner | 2010-10-05 21:30:24 | Re: query execution time |