pg-monitor-sql:PostrgreSQL 监控查询

时间:2024-08-09 05:20:45
【文件属性】:

文件名称:pg-monitor-sql:PostrgreSQL 监控查询

文件大小:6KB

文件格式:ZIP

更新时间:2024-08-09 05:20:45

pg-monitor-sql PostrgreSQL 监控查询 概述 SELECT d.datname, pg_size_pretty(pg_database_size(d.datname)) as size, numbackends, xact_commit, xact_rollback, blks_read, blks_hit, blks_hit::float / ( blks_hit + blks_read ) * 100.0 as cache_hit_ratio, tup_fetched, tup_returned, tup_inserted, tup_updated, tup_deleted FROM pg_stat_database d RIGHT JOIN pg_database on d.datname = p


【文件预览】:
pg-monitor-sql-master
----README.md(9KB)
----monitor.sql(8KB)

网友评论