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