Exporter Enhancement

• Build rpm & deb with nfpm
• Add column.default, replace when metric value is NULL
• Add column.scale, multiply scale factor when metric value is float/int (e.g µs to second)
• Fix /stat endpoint output
• Add docker container vonng/pg_exporter

Metrics Collector

• scale bgwriter & pg_wal time unit to second
• remove pg_class collector and move it to pg_table & pg_inex
• add pg_class metrics to pg_table
• add pg_class metrics to pg_index
• enable pg_table_size by default
• scale pg_query pg_db pg_bgwriter pg_ssl pgbouncer_stat time metrics to second

MD5 (pg_exporter-0.5.0.x86_64.rpm) = f9f3454803bd17d81b94c7c04a21601a
MD5 (pg_exporter_0.5.0_amd64.deb) = 08bd7674a089082cff38fcb55f496390
MD5 (pg_exporter_v0.5.0_darwin-amd64.tar.gz) = c0b5b26222950c66d888dc18cff49231
MD5 (pg_exporter_v0.5.0_linux-amd64.tar.gz) = 9865182fc12387a21775982ca59eef47

• update default collectors
  • omit citus & timescaledb schemas on object monitoring
  • avoid duplicate pg_statio tuples
  • support pgbouncer v1.16
  • bug fix: pg_repl collector overlap on pg 12
• new parameter: -T connect-timeout PG_EXPORTER_CONNECT_TIMEOUT
  this can be useful when monitoring remote postgres instance.
• now pg_exporter.yaml are renamed as pg_exporter.yml in rpm package.

• Add PG 14 support
• Default metrics configuration overhaul. (BUT you can still use old configuration)
• add auto-discovery , include-database and exclude-database option
• Add multiple database monitoring implementation (with auto-discovery = on)

• fix shadow DSN corner case
• fix typo
• fix document

fix default configuration problems (especially for version lower than 13)

• setting primary_conninfo not exists until PG13
• add funcid label to pg_func to avoid func name duplicate label
• fix version string to pg_exporter

• Change default configuration, Support PostgreSQL 13 new metrics (pg_slru, pg_shmem, pg_query13,pg_backup, etc...)
• Add a series new REST API for health / recovery status check
• Add a dummy server with fake pg_up 0 metric which serve before PgExporter is initialized.
• Add sslmode=disable to URL if sslmode is not given
• fix typo and bugs

v0.1.2 Release

* fix pgbouncer_up metrics
* add dynamic configuration reload
* remove 'shard' related logic
* add a 'bulky' mode to default settings

v0.1.1

• Fix the bug that pg_exporter will hang during start-up if any query is failed.

Looks good to me.