{"repo":"awslabs/pg-collector","free":true,"listed":false,"github":"https://github.com/awslabs/pg-collector","clone":"git clone https://github.com/awslabs/pg-collector.git","description":"PG Collector for Postgresql is a sql script that gathers valuable database information and presents it in a consolidated HTML file which provides a convenient way to view and navigate between different sections of the report","language":"HTML","stars":151,"topics":["postgres","postgresql","pg-collector","sql-script","vacuum"],"license":"MIT-0","category":"databases-storage","readme_excerpt":"PG Collector Overview PG Collector for Postgresql is a sql script that gathers valuable database information and presents it in a consolidated HTML file which provides a convenient way to view and navigate between different sections of the report. PG Collector is safe to run on production environments and does not create any database objects to produce the output. With PG Collector an operator gains insights on various aspects of the database, such as: Database size Configuration parameters Installed extensions Vacuum & Statistics Unused Indexes & invalid indexes Users & Roles Info Toast Tables Mapping Database schemas Fragmentation (Bloat) Tablespaces Info Memory setting Tables and Indexes Size and info Transaction ID Replication slots public Schema info Unlogged Tables and more, please check the example reports PG Collector's Automated Database Health check The Observations section has been implemented as an automated database health assessment system designed to identify potential database issues and provide actionable recommendations . The observations section seamlessly integrates with existing PG Collector report sections, providing cross-references to detailed analysis and supporting data. more health checks will be added with each new version . Database Health check list : Example of The Observations section Versioning Policy : Starting from PostgreSQL 13, PG Collector will have a dedicated script for each PostgreSQL major version . each PG Collector major version wil","default_branch":null,"files":null,"tree":[],"storefront":"/r/awslabs","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/awslabs/pg-collector/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."}