PostgreSQL监控调优

1.监控

-- 查询会话
SELECT query, count(0) FROM pg_stat_activity GROUP BY query HAVING count(*) > 1

-- 查询具体select语句
SELECT * FROM pg_stat_activity 
WHERE datname = '' and query like '%%'
posted @ 2024-12-12 09:21  lwx_R  阅读(13)  评论(0)    收藏  举报