Re: [ADMIN] Displaying ProcessList to Users

Поиск
Список
Период
Сортировка
От Günce Kaya
Тема Re: [ADMIN] Displaying ProcessList to Users
Дата
Msg-id CAAV2-mWr3fejn=53DbSoSpL5wiw_Zp4vtqP9UsAcN=2dKyoMzg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Displaying ProcessList to Users  ("Gunnar \"Nick\" Bluth" <gunnar.bluth.extern@elster.de>)
Ответы Re: [ADMIN] Displaying ProcessList to Users
Список pgsql-admin
Дерево обсуждения
Hi Gunnar,

When I select pg_stat_activity table, I can see only a row to my user but I have executed lots of queries. I can only see latest executed query to me. 

Is there any way to list users with whole queries that executed before by users?

Regards,

Gunce Kaya

2017-01-05 10:59 GMT+03:00 Gunnar "Nick" Bluth <gunnar.bluth.extern@elster.de>:
Am 05.01.2017 um 08:55 schrieb Günce Kaya:
> Hi All,

Hi Günce,


> I'm curious about can I display or list users who execute which queries
> in databases.
>
> Any help would be appreciated.

Have a look at pg_stat_activity.

Regards,
--
Gunnar "Nick" Bluth
DBA ELSTER

Tel:   +49 911/991-4665
Mobil: +49 172/8853339


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



--
Gunce Kaya

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

Предыдущее
От: "Gunnar \"Nick\" Bluth"
Дата:
Сообщение: Re: [ADMIN] Displaying ProcessList to Users
Следующее
От: "Gunnar \"Nick\" Bluth"
Дата:
Сообщение: Re: [ADMIN] Displaying ProcessList to Users