PG_GTT_ATTACHED_PIDS
PG_GTT_ATTACHED_PIDS checks which sessions are using global temporary tables by calling the pg_get_attached_pid function.
| 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 |