nbari / pg_exporter / 28193920042

91%

push

github

Release 0.12.0: checkpoint tuning metrics, sqlx 0.9, aarch64

Metrics:
- Add pg_last_checkpoint_age_seconds and pg_wal_bytes_since_last_checkpoint
  (from pg_control_checkpoint(), all supported PostgreSQL versions)
- Expose pg_settings_max_wal_size_bytes and pg_settings_min_wal_size_bytes
- Together these expose the checkpoint_timeout / max_wal_size / storage tradeoff:
  achieved interval, checkpointer liveness, crash-recovery (RTO) volume, and
  whether checkpoints are time- or WAL-driven

Dashboard / docs:
- Add Grafana "Checkpoints" section (4 panels) with live setting overlay lines
- Add checkpoint tuning guide (src/collectors/default/README.md)

Dependencies:
- Upgrade sqlx 0.8 -> 0.9, tower-http 0.6 -> 0.7, OpenTelemetry stack 0.31 -> 0.32,
  tracing-opentelemetry 0.32 -> 0.33, sysinfo 0.38 -> 0.39, plus compatible bumps
- Adapt dynamic SQL to sqlx 0.9 SqlSafeStr via AssertSqlSafe; enable serde derive
- Fix connection-collector test deadlock under sqlx 0.9 Pool::close semantics
- cargo update (astral-tokio-tar 0.6.2 -> 0.6.3)

Release / CI:
- Build and release aarch64 binaries and packages (aarch64-unknown-linux-musl
  with RPM/DEB, aarch64-apple-darwin); set fail-fast: false

Local dev / test tooling:
- 'just test' uses an already-running PostgreSQL instead of requiring a local
  container runtime, so it works inside a toolbox without podman
- Relabel postgres container volumes with :Z on Linux (SELinux hosts), omit on macOS
- Allow server-side pgbench data generation via PGBENCH_INIT_STEPS to avoid
  bulk-COPY stalls over port-forwards; clear leftover pgbench_test connections

Bump version to 0.12.0 and prepare CHANGELOG.

343 of 352 new or added lines in 14 files covered. (97.44%)

11141 of 12352 relevant lines covered (90.2%)

82.95 hits per line