gp_workfile_usage_per_segment
The gp_toolkit.gp_workfile_usage_per_segment view contains one row for each segment.
Each row displays the total amount of disk space used for workfiles on the 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 |
|---|---|---|
segid |
smallint |
Segment ID |
size |
numeric |
The total size of the workfiles in a segment |
numfiles |
bigint |
The number of files created |