| From: | Michael Monnerie <lists(dot)michael(dot)monnerie(at)is(dot)it-management(dot)at> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: EXPLAIN time difference in real |
| Date: | 2014-04-26 17:48:19 |
| Message-ID: | 535BF163.9070401@is.it-management.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Am 26.04.2014 16:17, schrieb Jov:
> Maybe your data or index is read from disk for some write heavy load
> time,your sql get 1300ms.when you explain analyze the sql,the data and
> index already in cached in the memory.
>
> you can verify this by restart the server and run the sql from a fresh
> start postgresql.
>
Tried that:
EXPLAIN ANALYZE....
Total runtime: 280.537 ms
EXPLAIN:LOG: duration: 1501.807 ms statement: EXPLAIN ANALYZE VERBOSE
SELECT
So again 1500ms versus 280ms. Why?
--
mit freundlichen Grüssen,
Michael Monnerie, Ing. BSc, Tel: +43 660 415 6531
Protéger.at Internet Services Austria
Web: http://protéger.at und http://proteger.at
Facebook https://facebook.com/protegerat
Mitglied im it-management Netzwerk http://it-management.at
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-04-26 18:27:43 | Re: EXPLAIN time difference in real |
| Previous Message | Jov | 2014-04-26 14:17:26 | Re: EXPLAIN time difference in real |