{"repo":"NikolayS/postgres_dba","free":true,"listed":false,"github":"https://github.com/NikolayS/postgres_dba","clone":"git clone https://github.com/NikolayS/postgres_dba.git","description":"The missing set of useful tools for Postgres DBAs and all engineers","language":"PLpgSQL","stars":1284,"topics":["postgres-dba","postgresql","dba","postgres","psql","postgres-server"],"license":"BSD-3-Clause","category":"databases-storage","readme_excerpt":"🐘 postgres dba 34 diagnostic reports for PostgreSQL, right inside psql . No agents, no daemons, no external dependencies — just SQL. Bloat estimation, index health, lock trees, vacuum monitoring, query analysis, corruption checks, buffer cache inspection, and more. Type :dba and go. Quick Start Connect to any Postgres server via psql and type :dba . Requires psql 10+. The server can be any version. For best results, use the latest psql client. Reports General (0–3) ID Report ---- -------- 0 Node info: primary/replica, replication lag, database size, temp files, WAL, replication slots 1 Database sizes and stats 2 Table and index sizes, row counts 3 Load profile Activity & Locks ID Report ---- -------- a1 Current connections grouped by database, user, state l1 Lock trees (lightweight) l2 Lock trees with wait times (PG14+ pg locks.waitstart ) Bloat ID Report ---- -------- b1 Table bloat estimation b2 B-tree index bloat estimation b3 Table bloat via pgstattuple (expensive) b4 B-tree index bloat via pgstattuple (expensive) b5 Tables without stats (bloat can't be estimated) Corruption Checks ( amcheck ) ID Lock Report ---- ------ -------- c1 AccessShareLock Quick index check: btree + GIN (PG18+). Safe for production. c2 AccessShareLock Indexes + heap/TOAST (PG14+). Safe but reads all data. c3 ⚠️ ShareLock B-tree parent check — detects glibc/collation corruption. Use on clones. c4 ⚠️⚠️ ShareLock Full: heapallindexed + parent + heap. Proves every tuple is indexed. Memory ID Report -","default_branch":null,"files":null,"tree":[],"storefront":"/r/NikolayS","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/NikolayS/postgres_dba/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}