This is an automated email from the git hooks/post-receive script.
cbaines pushed a commit to branch master
in repository data-service.
The following commit(s) were added to refs/heads/master by this push:
new c05a8e4 COALESCE a couple more pg_stat fields
c05a8e4 is described below
commit c05a8e4e9f0e9c4ea348bcf71672de9c1ee3da46
Author: Christopher Baines <[email protected]>
AuthorDate: Thu Oct 1 22:00:52 2020 +0100
COALESCE a couple more pg_stat fields
As apparently they can be NULL.
---
guix-data-service/metrics.scm | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/guix-data-service/metrics.scm b/guix-data-service/metrics.scm
index d330c88..19dc0d5 100644
--- a/guix-data-service/metrics.scm
+++ b/guix-data-service/metrics.scm
@@ -83,7 +83,7 @@ FROM (
(define query
"
SELECT relname, seq_scan, seq_tup_read,
- idx_scan, idx_tup_fetch,
+ COALESCE(idx_scan, 0), COALESCE(idx_tup_fetch, 0),
n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd,
n_live_tup, n_dead_tup, n_mod_since_analyze,
COALESCE(extract(epoch from last_vacuum), 0),
