| Platform | Metrics | Logs | Traces |
|---|---|---|---|
| Linux | ✓ | ✓ | |
| Windows | ✓ | ✓ | |
| macOS | ✓ | ✓ |
This source supports PostgreSQL versions 10.18 and higher.
The monitoring user must be granted SELECT on pg_stat_database.
| Parameter | Type | Default | Description |
|---|---|---|---|
| telemetry_types | telemetrySelector |
["Logs", "Metrics"] |
Choose Telemetry Type. |
| postgresql_log_path | strings |
For CentOS / RHEL: - \"/var/log/postgresql/postgresql_.log\" \nFor SLES: - \"/var/lib/pgsql/data/log/postgresql_.log\" \nFor Debian / Ubuntu: - \"/var/lib/pgsql/_/data/log/postgresql_.log\" |
Path to Postgres log file(s). |
| start_at | enum |
end | Start reading the file from the ‘beginning’ or ’end’. |
| username* | string |
Username used to authenticate. | |
| password* | string |
Password used to authenticate. | |
| endpoint | string |
localhost:5432 | The endpoint of the Postgres server. If transport is set to unix, the endpoint will internally be translated from host:port to /host.s.PGSQL.port. |
| transport | enum |
tcp | The transport protocol used to connect to Postgres. Valid values are tcp, or unix. |
| databases | strings |
The list of databases for which the receiver will attempt to collect statistics. If an empty list is provided, the receiver will attempt to collect statistics for all databases. | |
| collection_interval | int |
60 | Sets how often (seconds) to scrape for metrics. |
| enable_tls | bool |
false | Whether or not to use TLS. |
| enable_tlsinsecure_skip_verify | bool |
false | Enable to skip TLS certificate verification. |
| ca_file | string |
Certificate authority used to validate the database server’s TLS certificate. | |
| cert_file | string |
A TLS certificate used for client authentication, if mutual TLS is enabled. | |
| key_file | string |
A TLS private key used for client authentication, if mutual TLS is enabled. |
