pgtoolkit

PostgreSQL maintenance and administration toolkit

brewmacoslinux

Try with needOr install directly

About

Tools for PostgreSQL maintenance

pgstattuplepgfincorepg_surgerypgwalinspect

Analyze table bloat and dead tuples$ pgstattuple 'tablename'

Check which table pages are in OS cache$ pgfincore -r tablename

Inspect WAL file structure and records$ pgwalinspect 'path/to/wal/file'