Pg Index Health Sql Versions Save

pg-index-health-sql is a set of sql-queries for analyzing and maintaining indexes and tables health in Postgresql databases.

v.0.11.0

2 weeks ago

What's Changed

Add dependabot schedule day by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/29
Bump actions/checkout from 3 to 4 by @dependabot in https://github.com/mfvanek/pg-index-health-sql/pull/30
Indexes with boolean values by @Evreke in https://github.com/mfvanek/pg-index-health-sql/pull/31
Query to check not valid constraints by @BLoHny in https://github.com/mfvanek/pg-index-health-sql/pull/34
Query to find B-tree indexes on array columns by @mfaulther in https://github.com/mfvanek/pg-index-health-sql/pull/35
Add ordering to check_not_valid_constraints.sql by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/37
Add index_size to the query results by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/38
Remove tokei badges by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/39
Added index_size to btree_indexes_on_array_columns.sql by @mfaulther in https://github.com/mfvanek/pg-index-health-sql/pull/40
Update README.md by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/41

New Contributors

@dependabot made their first contribution in https://github.com/mfvanek/pg-index-health-sql/pull/30
@Evreke made their first contribution in https://github.com/mfvanek/pg-index-health-sql/pull/31
@BLoHny made their first contribution in https://github.com/mfvanek/pg-index-health-sql/pull/34
@mfaulther made their first contribution in https://github.com/mfvanek/pg-index-health-sql/pull/35

Full Changelog: https://github.com/mfvanek/pg-index-health-sql/compare/v.0.10.3...v.0.11.0

v.0.10.3

4 months ago

What's Changed

Update сopyright by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/28

Full Changelog: https://github.com/mfvanek/pg-index-health-sql/compare/v.0.9.5...v.0.10.3

v.0.9.5

7 months ago

What's Changed

Copyright and query update by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/24
Added dependabot.yml by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/26
Added support for PostgreSQL 16 by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/27

Full Changelog: https://github.com/mfvanek/pg-index-health-sql/compare/v.0.8.0...v.0.9.5

v.0.8.0

1 year ago

What's Changed

Added tokei badges by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/23

Full Changelog: https://github.com/mfvanek/pg-index-health-sql/compare/v.0.7.0...v.0.8.0

v.0.7.0

1 year ago

What's Changed

Excluded materialized views from check on primary key existence by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/3
Added a short description into each sql script. by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/5
Added query to find the slowest queries by total execution time. by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/6
Wrong detection of Duplicated indexes with different collation by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/7
Updated copyright by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/9
Objects without description by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/10
Added query to find columns of json type. Use jsonb instead. by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/11
Updated README.md by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/12
Added super-linter by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/14
Do not use serial types for non primary key columns by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/13
Changed to 'left join' of 'pg_constraint' by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/16
Fixed wrong detection for columns with multiple constraints by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/17
Added query to find functions and procedures that don't have a description by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/18
Updated README.md by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/19
Added support for PostgreSQL 15 by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/20
Upgraded action by @mfvanek in https://github.com/mfvanek/pg-index-health-sql/pull/21

New Contributors

@mfvanek made their first contribution in https://github.com/mfvanek/pg-index-health-sql/pull/3

Full Changelog: https://github.com/mfvanek/pg-index-health-sql/commits/v.0.7.0