pgsql-bloat-estimation
Space analyzer
Tools to estimate unused space in PostgreSQL indexes and tables
Queries to mesure statistical bloat in indexes and tables for PostgreSQL
519 stars
28 watching
95 forks
last commit: over 2 years ago
Linked from 1 awesome list
mgramin/awesome-db-toolsRelated projects:
| Repository | Description | Stars |
|---|---|---|
 crunchydata/pgnodemx | Provides SQL functions to capture node OS metrics from PostgreSQL | 50 |
 rapidloop/pgmetrics | A tool to collect and display performance metrics from a running PostgreSQL server | 967 |
 alexeyco/pig | A pgx wrapper that simplifies executing and scanning query results in PostgreSQL databases | 16 |
 gleu/pgstats | Collects and displays PostgreSQL statistics for performance monitoring and analysis | 117 |
 arenadotio/pgx | A pure OCaml PostgreSQL client library with support for asynchronous and lightweight operations | 122 |
 hypopg/hypopg | An extension that provides virtual indexes for PostgreSQL to help identify potential performance gains without creating actual indexes. | 1,397 |
 citusdata/pg_shard | Enables horizontal scaling and high availability for PostgreSQL tables by sharding and replicating them. | 1,058 |
 paradedb/pg_analytics | Enables direct querying of data lakes from Postgres without moving data to a cloud data warehouse | 407 |
 spotify/postgresql-metrics | Extracts and provides metrics on PostgreSQL databases | 591 |
 shayonj/pg-osc | Tool for making schema changes in PostgreSQL with minimal locks to achieve zero downtime updates. | 554 |
 tizoc/ppx_pgsql | A syntax extension for embedded SQL queries using PG'OCaml. | 52 |
 pgexperts/pgx_scripts | A collection of scripts and tools for PostgreSQL database analysis and administration | 1,389 |
 dataegret/pg-utils | A collection of PostgreSQL utility scripts providing various DBA tools and query analysis capabilities | 1,053 |
 zabbix-tools/libzbxpgsql | A Zabbix agent module that monitors PostgreSQL servers | 157 |
 darold/pgformatter | Automates formatting and beautification of PostgreSQL SQL queries | 1,711 |