PostgreSQL 一键巡检 SQL 合集
一、筛查数据表膨胀
SELECTschemaname,relname AS table_name,n_live_tup AS live_rows,n_dead_tup AS dead_rows,ROUND(n_dead_tup::numeric / NULLIF(n_live_tup + n_dead_tup,0)*100,2) AS dead_tuple_pct,pg_size_pretty(pg_total_relation_size(relid)) AS table_total_s…
2026/8/1 3:50:09