]> git.openstreetmap.org Git - chef.git/blob - cookbooks/munin/files/default/plugins/postgres_replication
enable munin plugins for nominatim
[chef.git] / cookbooks / munin / files / default / plugins / postgres_replication
1 #!/usr/bin/perl
2
3 use strict;
4 use warnings;
5
6 use Munin::Plugin::Pgsql;
7
8 my $pg = Munin::Plugin::Pgsql->new(
9     title     => 'PostgreSQL replication delay',
10     info      => 'Replication delay',
11     vlabel    => 'Seconds',
12     basequery =>
13         "SELECT
14            CASE
15              WHEN pg_last_xlog_receive_location() = pg_last_xlog_replay_location() THEN 0::int
16              ELSE (extract(epoch FROM now()) - extract(epoch FROM pg_last_xact_replay_timestamp()))::int
17            END AS delay",
18     pivotquery => 1,
19     configquery =>
20         "VALUES ('delay','Replication delay')"
21 );
22
23 $pg->Process();