explain analyze buffer <query>

On Wed, Apr 27, 2011 at 20:45, SUBHAM ROY <subham.iem@gmail.com> wrote:

I am using postgres 8.4.8.
EXPLAIN (ANALYZE,BUFFERS) is not working. So is there any patch available
for it? If so, kindly specify from where to get it and how to install it.

This functionality is new in PostgreSQL 9.0. You need to upgrade to get it.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

On 04/27/2011 12:45 PM, SUBHAM ROY wrote:

I am using postgres 8.4.8.
|EXPLAIN (ANALYZE,BUFFERS)| is not working. So is there any patch
available for it? If so, kindly specify from where to get it and how to
install it.

--
Thank You,
Subham Roy,
CSE IIT Bombay.

Have you tried just plain

explain analyse select-something;

?