gp_suboverflowed_backend
The gp_suboverflowed_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.
NOTE
Execute the following command to make this view available:
CREATE EXTENSION gp_subtransaction_overflow;| 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 |