Re: EXPLAIN time difference in real

Michael Monnerie <lists.michael.monnerie@xxxxxxxxxxxxxxxxxxx> · Sat, 26 Apr 2014 19:48:19 +0200



    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