gp_workfile_entries
The gp_toolkit.gp_workfile_entries view contains one row for each operator using disk space for workfiles on a segment at the current time.
This view is accessible to all users.
However, non‑superusers only see information for the databases that they have permission to access.
| Column | Type | Description |
|---|---|---|
datname |
name |
Database name |
pid |
integer |
Process ID of the server process |
sess_id |
integer |
Session ID |
command_cnt |
integer |
Command ID of the query |
usename |
name |
Role name |
query |
text |
Current query the process is running |
segid |
integer |
Segment ID |
slice |
integer |
The query plan slice. The portion of the query plan that is being run |
optype |
text |
The query operator type that created the workfile |
size |
bigint |
The size of the workfile in bytes |
numfiles |
integer |
The number of files created |
prefix |
text |
Prefix used when naming a related set of workfiles |