PG_GTT_ATTACHED_PIDS

PG_GTT_ATTACHED_PIDS is used to check which sessions are using global temporary tables by calling the pg_gtt_attached_pid() function.

**Table 1** PG_GTT_ATTACHED_PIDS columns
Name	Type	Description
schemaname	name	Schema name.
tablename	name	Name of a global temporary table.
relid	oid	OID of a global temporary table.
pids	bigint[]	Thread PID list.
sessionids	bigint[]	Session ID list.

Parent topic: System Views

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.