ioguix pgsql-bloat-estimation issues

ioguix / pgsql-bloat-estimation

Queries to mesure statistical bloat in indexes and tables for PostgreSQL

BSD 2-Clause "Simplified" License

515 stars 94 forks source link

issues

Newest

Newest Most commented Recently updated Oldest Least commented Least recently updated

Big bloat discrepencies compared to pgstattuple

#24 MichaelDBA opened 1 year ago
5
`real_size` in `pgsql-bloat-estimation/btree/btree_bloat.sql`

#23 shangzixie closed 2 years ago
1
Why `IndexTupleData` size is 2

#22 shangzixie closed 2 years ago
5
`table_bloat.sql` might fail with division by zero

#21 pashagolub closed 2 years ago
1
Deduplicated B-tree

#20 pauldraper closed 2 years ago
1
Column says "ratio" but actually reports percentage

#19 pauldraper closed 3 years ago
1
B-tree bloat estimation in PostgreSQL 13

#18 mfvanek closed 3 years ago
1
Ignore table-wide NULL ratio for partial indexes where NULL is excluded

#17 rafbm opened 3 years ago
0
Optimize btree query

#16 bersace closed 11 months ago
4
Toasted text

#15 Krysztophe opened 4 years ago
1
Add the materialized views

#14 tilkow closed 4 years ago
1
replacing JOIN pg_catalog.pg_stats with LEFT JOIN

#13 arteika closed 4 years ago
2
Question : is_na column for jsonb in postgreSQL 9.5

#12 sumodirjo closed 4 years ago
1
Support PostgreSQL 12

#11 ioguix closed 5 years ago
2
Table bloat query failing on PG 12

#10 kmoppel closed 4 years ago
2
Add CTE barrier around core sub-query

#9 julmon closed 4 years ago
3
Avoid negative values for bloat_size

#8 pgiraud closed 5 years ago
1
When fillfactor is 100%, bloat size is a negative value

#7 kayform closed 6 years ago
2
Update table_bloat*.sql to mark tables where some stats are missing as N/A.

#6 tilkow closed 7 years ago
1
exclude table with unavailable stats

#5 ioguix closed 7 years ago
0
Use live_tuples instead of reltuples

#4 ioguix opened 7 years ago
7
bloat_ratio isn't well-documented

#3 jberryman closed 7 years ago
2
Alignement issues

#2 gleu closed 8 years ago
4
Why do you assume 4 tuples per TOAST page?

#1 jberkus closed 8 years ago
4