Skip site navigation (1) Skip section navigation (2)

Re: explain analyze buffer <query>

From: SUBHAM ROY <subham(dot)iem(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: explain analyze buffer <query>
Date: 2011-04-27 18:45:40
Message-ID: BANLkTi=muBputhqgJw8B=EbHBsgPF25E7A@mail.gmail.com (view raw) 
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.
From: Magnus Hagander <magnus(at)hagander(dot)net>
To: SUBHAM ROY <subham(dot)iem(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: explain analyze buffer <query>
Date: 2011-04-27 18:56:39
Message-ID: BANLkTi=+bhc8k2gDUKCkqTHBzd3c7-gWdA@mail.gmail.com (view raw) 
On Wed, Apr 27, 2011 at 20:45, SUBHAM ROY <subham(dot)iem(at)gmail(dot)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/
From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: explain analyze buffer <query>
Date: 2011-04-27 19:21:31
Message-ID: 4DB86CBB.1020601@gmail.com (view raw) 

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;

?

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group