Also explain(analyze,buffers) is by far my favorite. It shows you the number of pages loaded from disk or cache. Also to note: EXPLAIN just plans the query, EX

Also explain(analyze,buffers) is by far my favorite. It shows you the number of pages loaded from disk or cache. Also to note: EXPLAIN just plans the query, EXPLAIN (ANALYZE) plans and runs the query. Which can take awhile in production.