Functions / System Administration Functions

pg_wal_lsn_diff

Calculates the difference in bytes (lsn1 - lsn2) between two write-ahead log locations.

Reading PG 18current·documented in 11 of 27 versions, 10 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

pg_wal_lsn_diff ( lsn1 pg_lsn, lsn2 pg_lsn ) → numeric

Calculates the difference in bytes (lsn1 - lsn2) between two write-ahead log locations. This can be used with pg_stat_replication or some of the functions shown in Table 9.97 to get the replication lag.

Version history 9

19 → 20 changed
18 → 19 changed
17 → 18 changed
16 → 17 changed
15 → 16 changed
14 → 15 changed
13 → 14 changed
12 → 13 changed
9.6 → 10 added

Definition snapshot: b7bd9cda · English manual source