PostgreSQL

select a.oid as user_role_id , a.rolname as user_role_name , b.roleid as other_role_id , c.rolname as other_role_name from pg_roles a inner join pg_auth_members b on a.oid=b.member inner join pg_roles c on b.roleid=c.oid where a.rolname = ‘postgres’

Here is the entire list for native on-prem PostgreSQL: https://www.postgresql.org/docs/current/monitoring.html And here are my favorites from that list. PG_STAT_ACTIVITY – shows background activity for a running connection – not service by a connection pooler https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-ACTIVITY-VIEW PG_STAT_REPLICATION – the publication side view shows status of a publications subscribers – lag to them – must be queried …

The Most Important PostgreSQL Monitoring Views Read More »

SELECT pg_size_pretty (pg_relation_size (‘table_1’)) ;

The Best of Series momjian.us/presentations The presentation above addresses requirements open source (mostly free solutions) for PostgreSQL functionality to: – High Availability – No application reconfigure after fail-over/switch – RepMgr (an open source tool for managing PostgreSQL replication and failover) – RPO (recovery point objective / maximum amount of committed data lost) = 0 after …

PostgreSQL optimization – the best of YouTube series Read More »

On-prem? PgBouncer AWS RDS Postgres or AWS RDS Aurora/PostgreSQL? AWS RDS Proxy

https://www.postgresql.org/about/featurematrix/