文件名称: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)