On Wed, Sep 12, 2012 at 7:00 PM, Jeff Janes <jeff.janes@xxxxxxxxx> wrote: > Regarding the wiki page on reporting slow queries: > We currently recommend EXPLAIN ANALYZE over just EXPLAIN. Should we > recommend EXPLAIN (ANALYZE, BUFFERS) instead? I know I very often > wish I could see that data. I don't think turning buffer accounting > on adds much cost over a mere ANALYZE. Given the amount of version 8 installs out there the recommendation should be qualified with version >9.0. Otherwise a strong +1 > Also, an additional thing that would be nice for people to report is > whether long running queries are CPU bound or IO bound. Should we add > that recommendation with links to how to do that in a couple OS, say, > Linux and Windows. If so, does anyone know of good links that explain > it for those OS? I don't have any links for OS level monitoring, but with version 9.2 track_io_timing would do the job. Ants Aasma -- Cybertec Schönig & Schönig GmbH Gröhrmühlgasse 26 A-2700 Wiener Neustadt Web: http://www.postgresql-support.de -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance