From 1da44136718f65e2fb02ef2249c98395b69cf9da Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Tue, 13 Aug 2013 11:33:06 +0100 Subject: [PATCH] Fix tracking of postgres replication delay --- cookbooks/munin/files/default/plugins/postgres_replication | 7 +------ 1 file changed, 1 insertion(+), 6 deletions(-) diff --git a/cookbooks/munin/files/default/plugins/postgres_replication b/cookbooks/munin/files/default/plugins/postgres_replication index a41af7d3b..4a04d0b0e 100755 --- a/cookbooks/munin/files/default/plugins/postgres_replication +++ b/cookbooks/munin/files/default/plugins/postgres_replication @@ -9,12 +9,7 @@ my $pg = Munin::Plugin::Pgsql->new( title => 'PostgreSQL replication delay', info => 'Replication delay', vlabel => 'Seconds', - basequery => - "SELECT - CASE - WHEN pg_last_xlog_receive_location() = pg_last_xlog_replay_location() THEN 0::int - ELSE (extract(epoch FROM now()) - extract(epoch FROM pg_last_xact_replay_timestamp()))::int - END AS delay", + basequery => "SELECT (extract(epoch FROM now()) - extract(epoch FROM pg_last_xact_replay_timestamp()))::int AS delay", pivotquery => 1, configquery => "VALUES ('delay','Replication delay')" -- 2.39.5