| From: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, 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:16:01 |
| Message-ID: | i2z3073cc9b1004261316kb3510531x85ae91d112db1799@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Apr 26, 2010 at 3:03 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> 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.
>
he could see the "actual time" in the very first row of the EXPLAIN
ANALYZE... isn't that a value that is more close to what the OP is
looking for?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2010-04-26 20:18:47 | Re: global temporary tables |
| Previous Message | Tom Lane | 2010-04-26 20:06:44 | Re: global temporary tables |