pgsql监控

1，查看进程
pgsql以多进程方式运行
ps -ef|grep postgres
2，查看进程活动情况
select * from pg_stat_activity;
select * from pg_stat_bgwriter;
select * from pg_stat_archiver;
select * from pg_stat_database;
select * from pg_stat_wal_receiver;
select * from pg_stat_replication;
select * from pg_stat_subscription;
select * from pg_stat_ssl;
select * from pg_stat_database_conflicts;
select * from pg_stat_progress_vacuum;

3，wait event
select pid,backend_type, wait_event_type,wait_event from pg_stat_activity;
wait event type：
LWLock
Lock
BufferPin
Activity
Client
Extension
IPC
Timeout
IO

4，locks
select * from pg_locks

5，查看tuple
pgstattuple returns a relation’s physical length, percentage of “dead” tuples, and other info. This may help users to determine whether vacuum is necessary or not. The argument is the target relation’s name

SELECT * FROM pgstattuple(‘pg_catalog.pg_proc’);