{"repo":"jobinau/pg_gather","free":true,"listed":false,"github":"https://github.com/jobinau/pg_gather","clone":"git clone https://github.com/jobinau/pg_gather.git","description":"Scan PostgreSQL Instance for potential problems. pg_gather is a SQL-only script leveraging the built-in features of psql.","language":"HTML","stars":262,"topics":["postgresql","performance-analysis","postgres","database","scannner"],"license":null,"category":"databases-storage","readme_excerpt":"pg gather Scan and collect the minimal amount of data needed to identify potential problems in your PostgreSQL database, and then generate an analysis report using that data. This project provides two SQL scripts: gather.sql : Gathers performance and configuration data from PostgreSQL databases. gather report.sql : Analyzes the collected data and generates detailed HTML reports. Everything is SQL-only, leveraging the built-in features of psql , the command-line utility for PostgreSQL. Minimum Requirements for Data Collection PostgreSQL Server Versions : 10, 11, 12, 13, 14, 15, 16, 17, and 18. ( Older versions : For PostgreSQL 9.6 and older, please refer to the documentation page.) Minimum PostgreSQL Client ( psql ) Version : 11 Minimum Requirements for Data Analysis Collected data can be analyzed on PostgreSQL 16 or above , which supports the modern analytical functions required for reporting. Highlights 1. Secure and Transparent : Simple, fully auditable code. To ensure full transparency of what is collected, transmitted, and analyzed, we use an SQL-only data collection script that avoids complex control structures, improving readability and auditability. 2. No Executables : No executables need to be deployed on the database host. Using executables in secured environments poses risks. pg gather requires only the standard psql command-line utility. 3. Authentication Agnostic : Any authentication mechanism supported by PostgreSQL works with pg gather . 4. Cross-Platform : Work","default_branch":null,"files":null,"tree":[],"storefront":"/r/jobinau","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/jobinau/pg_gather/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."}