News for hackers. Stuff that matters.

A comment on What PostgreSQL has over other open source SQL databases: Part II. Parent comment

Re:What PostgreSQL has over other open source SQL databases:... by simoncion on Saturday October 24, 2015 @09:32PM (#10445592)
Is the information provided by

  explain select ...
insufficient?
[ Parent | on HN ]
Re:What PostgreSQL has over other open source SQL databases:... by brobinson on Saturday October 24, 2015 @11:08PM (#10445805)
There's also EXPLAIN ANALYZE which may yield different output than just an EXPLAIN.
[ Parent | on HN ]
Re:What PostgreSQL has over other open source SQL databases:... by mazelife on Sunday October 25, 2015 @12:55AM (#10446023)
Or EXPLAIN (ANALYZE, BUFFERS), which is very useful when you suspect disk IO may be a choke point.
[ Parent | on HN ]
Re:What PostgreSQL has over other open source SQL databases:... by brobinson on Sunday October 25, 2015 @02:02AM (#10446136)
Didn't know about BUFFERS. Thanks!
[ Parent | on HN ]