pg_bloat_check
pg_bloat_check copied to clipboard
keithf4
Bloat check script for PostgreSQL
I can use `--debug` just fine if the only option. I can use `--table pgbench_accounts` fine as the only option. Combined, they give an error: ``` $ pg_bloat_check.py --table pgbench_accounts...
PROCEDURES in PG11+ should may allow this to be a built in extension instead of an external script. Can also use similar scheduler that pg_partman is using to not require...
Creating an issue to document some discussions I've had about improving index check speed by using pgstatindex(). empty_pages/deleted_pages account for entire pages that are "bloat" avg_leaf_density provides a % free...
Currently excluding (see https://github.com/keithf4/pg_bloat_check/pull/6).
Got a workaround for this? ``` $ python pg_bloat_check.py -c dbname=my_db_name Traceback (most recent call last): File "pg_bloat_check.py", line 339, in get_bloat(conn, tuple(exclude_schema_list), tuple(include_schema_list), exclude_object_list) File "pg_bloat_check.py", line 200, in...
Could possibly just use table_len instead of doing fancy stuff with relpages. Would avoid the need for analyze if it works.
Since bloat/xid can often be related since bloated tables aren't getting vacuumed as they should, see about adding xid age stats to the data involved. Databases w/ oldest txid's ```...
@keithf4, hi! I have noticed that the output of --rebuild_index flag is a block of commands recreating the index. Since pg v.12 there is an option that enables reindexing concurrently....
@keithf4, hi I have faced with the wrong behavior running script as db's owner. ### Description When executing the bloat analysis script with a database user that owns objects but...
### Description The script encounters a TypeError in the rebuild_index function when processing index rebuilding operations. ### How to reproduce 1. Run the bloat analysis script on a PostgreSQL database....