{"repo":"lesovsky/pgcenter","free":true,"listed":false,"github":"https://github.com/lesovsky/pgcenter","clone":"git clone https://github.com/lesovsky/pgcenter.git","description":"Command-line admin tool for observing and troubleshooting Postgres.","language":"Go","stars":1624,"topics":["postgresql","postgresql-statistics","postgresql-admin"],"license":null,"category":"databases-storage","readme_excerpt":"--- pgCenter is a command-line admin tool for observing and troubleshooting Postgres. - Main goal - Key features - Quick start - Supported statistics - PostgreSQL statistics - System statistics - Install notes - Usage notes - Development, testing and contribution - Thanks --- Main goal Postgres provides various activity statistics about its runtime, such as connections, statements, database operations, replication, resources usage and more. The general purpose of the statistics is to help DBAs to monitor and troubleshoot Postgres. However, these statistics provided in textual form retrieved from SQL functions and views, and Postgres doesn't provide native tools for working with statistics views. pgCenter's main goal is to help Postgres DBA working with statistics and provide a convenient way to observe Postgres in runtime. Key features - Top-like interface that allows you to monitor stats changes as you go. See details here. - Per-process system stats ( Shift+S ): see CPU utilization, IO throughput, and IO wait time per PostgreSQL backend alongside query text — without leaving pgcenter. Instantly identify whether a slow query is CPU-bound or IO-bound. - Configuration management function allows viewing and editing of current configuration files and reloading the service, if needed. - Logfiles functions allow you to quickly check Postgres logs without stopping statistics monitoring. - \"Poor man’s monitoring\" allows you to collect Postgres statistics into files and build reports","default_branch":null,"files":null,"tree":[],"storefront":"/r/lesovsky","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/lesovsky/pgcenter/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."}