Re: How to get the used time when operate a select query?

Поиск
Список
Период
Сортировка
От Oskar Berggren
Тема Re: How to get the used time when operate a select query?
Дата
Msg-id 3D1AE265.6000502@sgs.o.se
обсуждение исходный текст
Ответ на How to get the used time when operate a select query?  (黄春茂 <huang@tanpopo-tane.com>)
Ответы Re: How to get the used time when operate a select query?  (nconway@klamath.dyndns.org (Neil Conway))
Список pgsql-general
$B2+=ULP wrote:
> How can I  get the time which a select query use?
> thank you!
>
>

If you are using version 7.2 or later, try the command

EXPLAIN ANALYZE <any query>

This will perform the query (even if it is a DELETE FROM <table>!)
and show the actual time.

/Oskar

Ps. You should check what your mail client puts in the from field
of you mail. It is quite unreadable...

--
/----------------------------------------------------------------------\
| Oskar Berggren        beo@sgs.o.se                                   |
| Network and Software Engineer                     SGS Datanätgrupp   |
|                                                   Gothenburg, Sweden |
\----------------------------------------------------------------------/




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

Предыдущее
От: 黄春茂
Дата:
Сообщение: How to get the used time when operate a select query?
Следующее
От: Nadim Bitar
Дата:
Сообщение: Re: Large Objects