Skip to content

Instantly share code, notes, and snippets.

@macdice
Created March 10, 2016 07:18
Show Gist options
  • Save macdice/32620c688b4bc84d4273 to your computer and use it in GitHub Desktop.
Save macdice/32620c688b4bc84d4273 to your computer and use it in GitHub Desktop.
replay_lag
postgres=# select application_name, replay_lag from pg_stat_replication order by application_name;
application_name | replay_lag
------------------+-----------------
node2 | 00:00:00.00323
node3 | 00:00:00.003447
node4 | 00:00:00.003464
node5 | 00:00:00.003607
node6 | 00:00:00.00351
node7 | 00:00:00.003494
node8 | 00:00:00.003403
(7 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment