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