logging queries and time used

Поиск
Список
Период
Сортировка
От stig erikson
Тема logging queries and time used
Дата
Msg-id cluc5g$2g0o$1@news.hub.org
обсуждение исходный текст
Ответы Re: logging queries and time used  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
Hi.
i would like to log every single query coming in to the database into a
table. i would like the log to include the entire query and execution
time and execution cost, and if possible the user that executed the query.

A trigger is what i was thinking of, but how can i find out the actual
query, the time it took to execute it, etc.?

stig

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

Предыдущее
От: Edmund Bacon
Дата:
Сообщение: Re: adding missing FROM-clause
Следующее
От: GreyGeek
Дата:
Сообщение: Re: PostgreSQL on Windows