Skip to main content
Version: Next

gp_segment_endpoints

The gp_segment_endpoints view lists the endpoints created in the QE for all active parallel retrieve cursors declared by the current session user. When the Apache Cloudberry superuser accesses this view, it returns a list of all endpoints on the QE created for all parallel retrieve cursors declared by all users.

Endpoints exist only for the duration of the transaction that defines the parallel retrieve cursor, or until the cursor is closed.

columntypereferencesdescription
auth_tokentextThe authentication token for the retrieve session.
databaseidoidThe identifier of the database in which the parallel retrieve cursor was created.
senderpidintegerThe identifier of the process sending the query results.
receiverpidintegerThe process identifier of the retrieve session that is receiving the query results.
statetextThe state of the endpoint; the valid states are:

READY: The endpoint is ready to be retrieved.

ATTACHED: The endpoint is attached to a retrieve connection.

RETRIEVING: A retrieve session is retrieving data from the endpoint at this moment.

FINISHED: The endpoint has been fully retrieved.

RELEASED: Due to an error, the endpoint has been released and the connection closed.
gp_segment_idintegerThe QE's endpoint gp_segment_id.
sessionidintegerThe identifier of the session in which the parallel retrieve cursor was created.
usernametextThe name of the session user (not the current user); you need to initiate the retrieve session as this user.
endpointnametextThe endpoint identifier; you provide this identifier to the RETRIEVE command.
cursornametextThe name of the parallel retrieve cursor.