EXPLAIN ANALYZE

oscon=> explain analyze select * from pg_proc order by oid;
                                      QUERY PLAN                                      
--------------------------------------------------------------------------------------
Sort  (C=151.57..155.30 R=1492 W=315) (actual time=181.82..184.05 rows=1495 loops=1)
 Sort Key: oid
  ->  Seq Scan on pg_proc  (C=0.00..72.92 R=1492 W=315) (actual time=11.25..83.81 rows=1495 loops=1)
Total runtime: 224.23 msec

• Actually runs the query and gets accurate information about each step
   
• Time is in milliseconds, NOT related to the EXPLAIN "cost"
   
• Abbreviations: "actual time" = AT, "rows" = R, "loops" = L
   
• Also gives a total running time: a nice quick summary tool
   
• Loops is how many times that operator is run - multiply both times and the rows by the number of lops for the actual numbers

Previous: EXPLAIN: cost         [Table of Contents]         Next: EXPLAIN plan Operators