{"repo":"pganalyze/collector","free":true,"listed":false,"github":"https://github.com/pganalyze/collector","clone":"git clone https://github.com/pganalyze/collector.git","description":"pganalyze statistics collector for gathering PostgreSQL metrics and log data","language":"Go","stars":402,"topics":["postgresql","monitoring","database","rds","metrics"],"license":null,"category":"analytics","readme_excerpt":"pganalyze collector =================== This is a Go-based daemon which collects various information about Postgres databases as well as queries run on it. All data is converted to a protocol buffers structure which can then be used as data source for monitoring & graphing systems. Or just as reference on how to pull information out of PostgreSQL. It currently collects information about Schema Tables (including column, constraint and trigger definitions) Indexes Statistics Tables Indexes Database Queries OS CPU Memory Storage Installation ------------ The collector is available in multiple convenient options: APT/YUM packages: https://packages.pganalyze.com/ Docker sidekick service, see details further down in this file Configuration (APT/YUM Packages) -------------------------------- After the package was installed, you can find the configuration in /etc/pganalyze-collector.conf Adjust the values in that file by adding your API key (found in the pganalyze dashboard, use one per database server), and database connection credentials. You can repeat the configuration block with a different [name] if you have multiple servers to monitor. See https://pganalyze.com/docs/install for further details. Setting up a Restricted Monitoring User --------------------------------------- See https://pganalyze.com/docs/install/self managed/01 create monitoring user (or the corresponding instructions for your platform) for details. Example output -------------- To get a feel for the data that ","default_branch":null,"files":null,"tree":[],"storefront":"/r/pganalyze","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/pganalyze/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."}