PostgreSQL DBA Toolkit

A shell-based interactive tool for PostgreSQL developers and DBAs to monitor, maintain, and analyze PostgreSQL databases.

Features

• Vacuum, Analyze, Reindex Tables
• Monitor slow queries, blocking, dead tuples
• View table sizes, cache hit ratio, autovacuum stats
• Show PostgreSQL config paths, tablespace usage
• and more...

Requirements

• PostgreSQL client (psql)
• Bash Shell (Linux)

Usage

chmod +x pg_dba_tool.sh
./pg_dba_tool.sh