访问postgres数据库，监控postgres性能

访问数据库：

 ./psql -Upostgres -dDBname

查看当前进程数：

SELECT count(*) FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s;

查询正在进行的sql操作：

SELECT * FROM pg_stat_activity;

 

 SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,
pg_stat_get_backend_activity(s.backendid) AS current_query
FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s ;

 

退出数据库：\q

 

查看postgres进程：

$ ps auxww | grep ^postgres