Postgresql: How to view the idle session in pg_stat_activity without being a superuser| Postgres Q&A

Published: 20 July 2021
on channel: mynotesoracledba
944
10

In this session, we are going to discuss view the idle session in pg_stat_activity without being a superuser in PostgreSQL.

There is a default role called pg_read_all_stats which help to read all pg_stat_* views and statistics

subscribe to our channel:
-----------------------------------------
https://rebrand.ly/8z3l1y1

For doubts and queries kindly contact us on
-----------------------------------------------------------------------
[email protected]

Follow us:

www.facebook.com/MyNotesOracleDba

#Defaultroles #postgresql #Q&A


Watch video Postgresql: How to view the idle session in pg_stat_activity without being a superuser| Postgres Q&A online without registration, duration hours minute second in high quality. This video was added by user mynotesoracledba 20 July 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 94 once and liked it 1 people.