Functions / System Information Functions And Operators

pg_get_multixact_stats

Returns statistics about current multixact usage: num_mxids is the total number of multixact IDs currently present in the system, num_members is the total number of multixact member entries currently present in the system, members_size is the storage occupied by num_members in the pg_multixact/members directory, oldest_multixact is the oldest multixact ID still in use.

Reading PG 20devel·documented in 2 of 27 versions, 19 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

Development snapshot. These definitions may change before release.

Signatures & examples

pg_get_multixact_stats () → record ( num_mxids integer, num_members bigint, members_size bigint, oldest_multixact xid )

Returns statistics about current multixact usage: num_mxids is the total number of multixact IDs currently present in the system, num_members is the total number of multixact member entries currently present in the system, members_size is the storage occupied by num_members in the pg_multixact/members directory, oldest_multixact is the oldest multixact ID still in use.

Version history 1

18 → 19 added

Definition snapshot: b7bd9cda · English manual source