Re: Discarding the resulting rows

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-hackers(at)postgresql(dot)org, "Murali M(dot) Krishna" <murali1729(at)yahoo(dot)com>
Subject: Re: Discarding the resulting rows
Date: 2010-04-26 20:03:52
Message-ID: l2s603c8f071004261303z98b72425y722156ca64d9e48c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Apr 26, 2010 at 3:36 PM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> "Murali M. Krishna" <murali1729(at)yahoo(dot)com> wrote:
>
>> Basically, I would like to discard the result rows after doing all
>> the work required to execute the query.
>
> I would use EXPLAIN ANALYZE SELECT ...

There's some overhead to that, of course.

....Robert

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-04-26 20:06:44 Re: global temporary tables
Previous Message Robert Haas 2010-04-26 20:02:53 Re: global temporary tables