The gp_suboveflowed_backend view allows administrators to identify sessions in which a backend has subtransaction overflows, which can cause query performance degradation in the system, including catalog queries.

column type description
segid integer The id of the segment containing the suboverflowed backend.
pids integer[] A list of the pids of all suboverflowed backends on this segment.

NOTE: As this is not a pg_catalog view, you must run the following command to make this view available:

CREATE EXTENSION gp_subtransaction_overflow;

For more information on handling suboverflowed backends to prevent performance issues, see Checking for and Terminating Overflowed Backends.

Parent topic: System Catalogs Definitions

check-circle-line exclamation-circle-line close-line
Scroll to top icon