Re: Customizing psql console to show execution times

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Customizing psql console to show execution times
Дата
Msg-id 5902.1187192633@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Customizing psql console to show execution times  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Ответы Re: Customizing psql console to show execution times
Список pgsql-general
"Phoenix Kiula" <phoenix.kiula@gmail.com> writes:
> In some examples posted to this forum, it seems to me that when people
> execute queries in the psql window, they also see "90 ms taken"
> (milliseconds), which denotes the time taken to execute the query.
> Where can I set this option because I'm not seeing it in my psql
> window on both Win XP and Linux. Thanks!

I think you're looking for the \timing command?
http://www.postgresql.org/docs/8.2/static/app-psql.html
(under meta-commands, about halfway down the page)

            regards, tom lane

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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Customizing psql console to show execution times
Следующее
От: Decibel!
Дата:
Сообщение: Re: Permission ALTER PASSWORD