{"repo":"mfvanek/pg-index-health-sql","free":true,"listed":false,"github":"https://github.com/mfvanek/pg-index-health-sql","clone":"git clone https://github.com/mfvanek/pg-index-health-sql.git","description":"pg-index-health-sql is a collection of SQL queries for analyzing PostgreSQL schemas, detecting issues and promoting best practices.","language":null,"stars":123,"topics":["sql","postgresql","postgres","indexes","hacktoberfest","static-analysis","linter","schema-linter"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"pg-index-health-sql pg-index-health-sql is a collection of SQL queries for analyzing PostgreSQL schemas, detecting issues and promoting best practices. What is this? pg-index-health-sql provides a curated set of raw SQL queries designed to identify common schema issues in PostgreSQL databases — such as redundant indexes, missing primary keys or inefficient table structures. It enables lightweight, database-native analysis without requiring external libraries or frameworks, making it suitable for direct use in psql sessions, scripts, or monitoring dashboards. Supported PostgreSQL versions Support for previous versions of PostgreSQL Compatibility with previous PostgreSQL versions is no longer guaranteed, but it is very likely. We focus only on the currently maintained versions of PostgreSQL. For more information please see PostgreSQL Versioning Policy. Available checks pg-index-health-sql allows you to detect the following problems: 1. Invalid (broken) indexes (sql). 2. Duplicated (completely identical) indexes (sql). 3. Intersected (partially identical) indexes (sql). 4. Unused indexes (sql). 5. Foreign keys without associated indexes (sql). 6. Indexes with null values (sql). 7. Tables with missing indexes (sql). 8. Tables without a primary key (sql). 9. Indexes bloat (sql). 10. Tables bloat (sql). 11. Tables without description (sql). 12. Columns without description (sql). 13. Columns with json type (sql). 14. Columns of serial types that are not primary keys (sql). 15. Funct","default_branch":null,"files":null,"tree":[],"storefront":"/r/mfvanek","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/mfvanek/pg-index-health-sql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}