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 по дате отправления: