{"repo":"SalmonSung/pg-hotspots-cli","free":true,"listed":false,"github":"https://github.com/SalmonSung/pg-hotspots-cli","clone":"git clone https://github.com/SalmonSung/pg-hotspots-cli.git","description":"PostgreSQL Hotspots is a diagnostic cli tool built for high-pressure “database down” situations...All reports are written into an interactive html file + txt file so the result can be shared and used with customers easily Besides, metrics have been mapped into a diagnosis-ready format for rapid trouble-shooting.","language":"HTML","stars":147,"topics":["database","database-management","monitoring-tool","performance-analysis","postgresql","google-cloud-monitoring","google-cloud-sql","google"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Postgres on fire? Start here. A diagnostic tool built for high-pressure “database down” situations... Analyzes database behavior without connecting to the database itself Build on Google Cloud Monitoring Key Features Emergency-Ready Diagnostics: The tool pulls metrics from Google Cloud Monitoring, not from PostgreSQL system views. This means it continues to work when the database is hung, locked, or under extreme load. Zero-Impact Observation: Unlike pg stat statements or active SQL polling, PostgreSQL Hotspots adds no load to your production database. All analysis is performed out-of-band, ensuring diagnostics never make an ongoing incident worse. Interactive Visual Correlation: generates rich, interactive reports into a .html file: - database activity history - most expensive SQL statements - lock waits and contention and more... The Metrics have been mapped into a diagnosis-ready format for rapid trouble-shooting b Compare Mode: Displayed multiple figures in a row for better comparison Use Case You can find some cases that have been solved with PostgreSQL Hotspots here: - When High CPU Is Normal — Until It Isn’t: A PostgreSQL Incident Analysis Safety & Security Security is a core design principle of this project. PostgreSQL Hotspots is intentionally non-intrusive and strictly follows the principle of least privilege. IAM-Based Authentication: The tool uses your existing Google Cloud environment via gcloud auth application-default login . It relies on your local Application","default_branch":null,"files":null,"tree":[],"storefront":"/r/SalmonSung","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/SalmonSung/pg-hotspots-cli/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."}