pg-index-health-sql

pg-index-health-sql copied to clipboard

Add documentation for - https://github.com/mfvanek/pg-index-health-sql/blob/master/sql/indexes_with_boolean.sql - https://github.com/mfvanek/pg-index-health-sql/blob/master/sql/check_not_valid_constraints.sql

mfvanek

See also another queries [table_bloat.txt](https://github.com/mfvanek/pg-index-health-sql/files/14341911/table_bloat.txt) [index_bloat.txt](https://github.com/mfvanek/pg-index-health-sql/files/14341912/index_bloat.txt)

mfvanek

Query to check sequence overflow sql

3

relate : https://github.com/mfvanek/pg-index-health/issues/363

BLoHny

Compare current "B-tree indexes on array columns" with query by Kirill Borovikov

1

Need to compare [current version of sql query](https://github.com/mfvanek/pg-index-health-sql/blob/master/sql/btree_indexes_on_array_columns.sql) with version by Kirill Borovikov from https://habr.com/ru/companies/tensor/articles/488104/ ```sql WITH sch AS ( SELECT 'public'::text sch -- schema ) , def AS (...

mfvanek