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.
||integer||The id of the segment containing the suboverflowed backend.|
||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