Thread: explain analyze buffer

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.

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;

?