pgscv
pgscv copied to clipboard
pgSCV is a multi-purpose monitoring agent and metrics exporter
**Describe the bug** We are using PostgreSQL logical replication (with debezium). And there are multiple logical replication processes per cluster. This is what pg_stat_replication shows: ``` database=# select pid,usename,application_name,client_addr,state from...
**Describe the bug** A lot of messages like "metric value or labels are not collected, skip" in the log. **Steps to reproduce** Add user-defined metrics with "databases" regexp. **Expected behavior**...
when pgscv starts i after small time i get error Dec 16 11:34:25 server pgscv[22893]: {"level":"error","service":"pgscv","time":"2021-12-16T11:34:25+02:00","message":"system/sysinfo collector failed; invalid input, '': wrong number of values"} on prometheus error is Get...
postgres_statements_query_info may be really, really long. this can lead to a problem, that victoria/ptometheus wouldn't scrape any data from exporter because of timeout or metrics length. Anyway, nobody cares about...
See file https://github.com/weaponry/pgscv/blob/master/internal/collector/postgres_archiver.go#L13 Function pg_ls_archive_statusdir only support in PgSQL v12 Would it be great to implement archiver statistics collection for Pg v10 and v11. Thanks!
**Is your feature request related to a problem? Please describe.** We want to collect business metrics from databases. It requires running certain queries on specific databases only **Describe the solution...
**Describe the bug** Running pgscv on host with Patroni, and exporter can not discovery patroni In debug log: {"level":"debug","service":"pgscv","time":"2021-10-22T17:50:32+03:00","message":"auto-discovery: looking up for new services..."} {"level":"debug","service":"pgscv","time":"2021-10-22T17:50:32+03:00","message":"auto-discovery [patroni]: analyzing process with pid...
I'm getting the following error: {"level":"error","service":"pgscv","time":"2021-09-26T08:33:54Z","message":"system/cpu collector failed; collect cpu usage stats failed: invalid input, parse 'cpu 234443201 6 16537547 2863881788 0 0 0 0' failed: wrong number of values;...
**Describe the bug** Having troubles with reading patroni metrics: ``` {"level":"error","service":"pgscv","time":"2021-09-23T16:41:30+03:00","message":"patroni/common collector failed; Get \"http://[]:8008/liveness\": dial tcp: lookup : n$ such host"} ``` **Steps to reproduce** `sudo -u postgres ./pgscv...