The crunchy-collect container provides real time metrics about the PostgreSQL database via an API. These metrics are scraped and stored by a Prometheus time-series database and are then graphed and visualized through the open source data visualizer Grafana.
The crunchy-collect container uses pgMonitor for advanced metric collection.
It is required that the
crunchy-postgres container has the
variable to create the appropriate user (
ccp_monitoring) to collect metrics.
Custom queries to collect metrics can be specified by the user. By mounting a queries.yml file to /conf on the container, additional metrics can be specified for the API to collect. For an example of a queries.yml file, see here
The crunchy-collect Docker image contains the following packages (versions vary depending on PostgreSQL version):
- PostgreSQL (11.1, 10.6, 9.6.11 and 9.5.15)
- CentOS7 - publicly available
- RHEL7 - customers only
- PostgreSQL Exporter
- Node Exporter
|DATA_SOURCE_NAME||None||The URL for the PostgreSQL server’s data source name. This is required to be in the form of
|DISABLE_NODE_EXPORTER||false||Set this to true to disable node exporter in the collect container.|
|CRUNCHY_DEBUG||FALSE||Set this to true to enable debugging in logs. Note: this mode can reveal secrets in logs.|