branch master updated: COALESCE a couple more pg_stat fields

[Christopher Baines]

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 <mail@cbaines.net>
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),