pgsql-bloat-estimation
SQL queries to estimate statistical bloat in PostgreSQL tables and btree indexes.
What is pgsql-bloat-estimation?
pgsql-bloat-estimation is a collection of SQL queries designed to estimate statistical bloat in PostgreSQL tables and btree indexes. It helps database administrators identify unused space caused by alignment padding, fillfactor settings, and actual bloat, enabling better storage management and maintenance planning. The tool provides metrics like extra size, bloat size, and percentages to assess database efficiency.
PostgreSQL database administrators and developers responsible for database performance, storage optimization, and maintenance tasks who need to monitor and reduce bloat.
It offers a lightweight, query-based approach to bloat estimation directly within PostgreSQL, without external dependencies, and includes accuracy flags to filter unreliable stats, making it a trusted tool for informed database upkeep.
Overview
Queries to mesure statistical bloat in indexes and tables for PostgreSQL
Use Cases
Best For
- Monitoring PostgreSQL table and index storage efficiency
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
