Finding current SQL activity

Поиск
Список
Период
Сортировка
От Thusitha Kodikara
Тема Finding current SQL activity
Дата
Msg-id 20061018080606.90849.qmail@web56608.mail.re3.yahoo.com
обсуждение исходный текст
Ответы Re: Finding current SQL activity  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-admin
Hi,

I would like to find the current (and very recent) SQL statements.  I went through 'pg_stat_activity'. But it showed only the current statement I was issuing. Going through the defintion of 'pg_stat_activity' I came across pg_stat_get_backend_activity(), and I thought if I could get the source of this function I would be able to further. But I can't see the definition of this function.

Am I on the right direction, or is there an easier way? I would appreciate if someone can give some suggestions.

Thanks in advance.

-Thusitha

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Missing Earth Distance Functions Under Debian
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Finding current SQL activity