Re: EXPLAIN time difference in real

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