stats for queries

Поиск
Список
Период
Сортировка
От Lucas Rockwell
Тема stats for queries
Дата
Msg-id Pine.GSO.4.40.0201291546240.8729-100000@socrates.Berkeley.EDU
обсуждение исходный текст
Список pgsql-admin
hi all,

i am very new to this list. i have looked in the docs and have tried to
search the archives and i can not find reference to this:

how do i get psql to give me statistics about how long it took to perform
a query?

for instance, if i do:

select count(table_id) from table;

i want psql to print the time (seconds, milliseconds, or
whatever) it took postgres to get me the results.

can psql do this for me?

many thanks in advance.

-lucas

------------------------
Lucas Rockwell
lr@socrates.berkeley.edu
------------------------


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: problem with pg_restore
Следующее
От: "lonh SENG"
Дата:
Сообщение: SQL Script