Lists: | pgsql-general |
---|
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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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;
?