DBA效率翻倍的postgres_dba必备神器

git clone https://github.com/NikolayS/postgres_dba.git
cd postgres_dba
bash -c "echo \"\\set dba '\\\\\\\\i $(pwd)/start.psql'\" >> ~/.psqlrc"

[postgres@mdw ~]$ psql
psql (17.5)
Type "help" for help.

postgres=# :dba
Menu:
   0 – Node and current database information: primary/replica, lag, database size, temporary files, etc.
   1 – Databases: size, stats
   2 – Tables: table/index/TOAST size, number of rows
   3 – Load profile
  a1 – Current activity: count of current connections grouped by database, username, state
  b1 – Table bloat (estimated)
  b2 – B-tree index bloat (estimated)
  b3 – Table bloat (requires pgstattuple; expensive)
  b4 – B-tree indexes bloat (requires pgstattuple; expensive)
  b5 – Tables and columns without stats (so bloat cannot be estimated)
  c1 – Corruption: quick index check — btree + GIN (PG18+). Safe for production, fast.
  c2 – Corruption: indexes + heap/TOAST check. Safe for production but reads all data.
  c3 – Corruption: B-tree parent check — detects glibc/collation corruption (ShareLock, use on clones)
  c4 – Corruption: FULL check — heapallindexed + parent + heap (SLOW + ShareLock, use on clones)
  e1 – Extensions installed in current database
  i1 – Unused and rarely used indexes
  i2 – Redundant indexes
  i3 – Foreign keys with missing or bad indexes
  i4 – Invalid indexes
  i5 – Cleanup unused and redundant indexes – DO & UNDO migration DDL
  l1 – Lock trees (lightweight)
  l2 – Lock trees, detailed (based on pg_blocking_pids())
  m1 – Buffer cache contents (requires pg_buffercache; expensive on large shared_buffers)
  p1 – Index (re)creation progress (CREATE INDEX / REINDEX)
  r1 – Create user with random password (interactive)
  r2 – Alter user with random password (interactive)
  s1 – Slowest queries, by total time (requires pg_stat_statements)
  s2 – Slowest queries report (requires pg_stat_statements)
  s3 – Workload profile by query type (requires pg_stat_statements)
  t1 – Postgres parameters tuning
  t2 – Objects with custom storage parameters
  v1 – Vacuum: running operations (detailed progress)
  v2 – Vacuum: autovacuum queue and pending tables
  x1 – [EXP] Alignment padding: how many bytes can be saved if columns are reordered?
   q – Quit

Type your choice and press <Enter>: