Merge ~stub/charm-telegraf:pgarchiver into ~telegraf-charmers/charm-telegraf:master

[Stuart Bishop]

pg_stat_archiver PostgreSQL metrics

pg_stat_archiver provides non-streaming WAL shipping metrics

[🤖 Canonical IS Merge Bot (canonical-is-mergebot)]

This merge proposal is being monitored by mergebot. Change the status to Approved to merge.

[Joel Sing (jsing)]

LGTM

review: Approve (+1)

[🤖 Canonical IS Merge Bot (canonical-is-mergebot)]

Change successfully merged at revision c6b6f6880852914d18d5af1cbb8112e634b80712

diff --git a/templates/postgresql.tmpl b/templates/postgresql.tmpl
index db721d5..2eee7f8 100644
--- a/templates/postgresql.tmpl
+++ b/templates/postgresql.tmpl
@@ -132,6 +132,19 @@
       pg_xlog_location_diff(pg_current_xlog_insert_location(), replay_location)::integer AS lag_bytes
     FROM pg_stat_replication"""
 {% endif %}
+
+[[inputs.postgresql_extensible.query]]
+  withdbname=false
+  tagvalue=""
+  version=904
+  sqlquery="""
+    SELECT
+      archived_count AS archive_archived_count,
+      EXTRACT(EPOCH FROM last_archived_time) AS archive_last_archived_time,
+      failed_count AS archive_failed_count,
+      EXTRACT(EPOCH FROM last_failed_time) AS archive_last_failed_time
+      FROM pg_stat_archiver"""
+
 {% endif %}