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@xxxxxxxxx>:
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Gunce Kaya
