1

To calculate replication delay in pgpool, the value is obtained from the view pg_stat_replication.replay_lag.

However, sometimes when executing show pool_nodes, it displays a significantly larger number.

In the pg_stat_replication view, the replay_lag is represented as values like 00:00:00.778134.

How repliation_delay calculated at pgpool? I suspect it is converted into microseconds. I am looking for expert opinion.

node_id  |   hostname   | port | status | lb_weight |  role   | select_cnt  | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+--------------+------+--------+-----------+---------+-------------+-------------------+-------------------+-------------------+------------------------+---------------------
 0       |      db1     | 5678 | up     | 0.200000  | primary | 12401123776 | false             | 0                 |                   |                        | 2023-05-28 00:45:31
 1       |      db2     | 5678 | up     | 0.200000  | standby | 11909003735 | false             | 0                 | streaming         | async                  | 2023-05-28 00:45:31
 2       |      db3     | 5678 | up     | 0.200000  | standby | 11930293446 | true              | 61768             | streaming         | async                  | 2023-05-28 00:45:31
 3       |      db4     | 5678 | up     | 0.200000  | standby | 11829890748 | false             | 776136            | streaming         | async                  | 2023-05-28 00:45:31
 4       |      db5     | 5678 | up     | 0.200000  | standby | 11898267765 | false             | 124128            | streaming         | async                  | 2023-05-28 00:45:31

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.