Re: Monitor what command is executing at the backend

Поиск
Список
Период
Сортировка
От George Pavlov
Тема Re: Monitor what command is executing at the backend
Дата
Msg-id 8C5B026B51B6854CBE88121DBF097A869869D1@ehost010-33.exch010.intermedia.net
обсуждение исходный текст
Ответ на Monitor what command is executing at the backend  ("Karthikeyan Sundaram" <skarthi98@hotmail.com>)
Ответы Re: Monitor what command is executing at the backend  ("Karthikeyan Sundaram" <skarthi98@hotmail.com>)
Список pgsql-sql
>    Is there a way to see from the log files on what sql statement is
> currently by which user?  In other words, I want to monitor
> the DB activity.

for a current snapshot you don't need the logs, try:

  select * from pg_stat_activity;

(command string needs to be enabled for your database.)

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

Предыдущее
От: "Karthikeyan Sundaram"
Дата:
Сообщение: Monitor what command is executing at the backend
Следующее
От: "Karthikeyan Sundaram"
Дата:
Сообщение: Re: Monitor what command is executing at the backend