Hacker News Reader

Comment by simoncion | Hacker News Reader

Is the information provided by

  explain select ...

insufficient?

There's also EXPLAIN ANALYZE which may yield different output than just an EXPLAIN.

Or EXPLAIN (ANALYZE, BUFFERS), which is very useful when you suspect disk IO may be a choke point.

Didn't know about BUFFERS. Thanks!