Re: Discarding the resulting rows

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема Re: Discarding the resulting rows
Дата
Msg-id i2z3073cc9b1004261316kb3510531x85ae91d112db1799@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Discarding the resulting rows  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Discarding the resulting rows
Список pgsql-hackers
On Mon, Apr 26, 2010 at 3:03 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Mon, Apr 26, 2010 at 3:36 PM, Kevin Grittner
> <Kevin.Grittner@wicourts.gov> wrote:
>> "Murali M. Krishna" <murali1729@yahoo.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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: global temporary tables
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: global temporary tables