oam/knowledge base/postgresql/pganalyze collector.md

pganalyze Collector

Periodically queries configured databases and sends metrics and metadata (as snapshots) to the Pganalyze app.

1. TL;DR
2. Further readings
   1. Sources

TL;DR

Setup

# Generic installation via magic script.
curl 'https://packages.pganalyze.com/collector-install.sh' | bash

# Change the configuration file and reload the collector's settings.
vim '/etc/pganalyze-collector.conf' && pganalyze-collector --test --reload \
&& systemctl status 'pganalyze-collector' && journalctl -xefu 'pganalyze-collector'

Further readings

• PostgreSQL
• Codebase
• Documentation

Sources