gp_skew_idle_fractions
The gp_toolkit.gp_skew_idle_fractions view shows data distribution skew by calculating the percentage of the system that is idle during a table scan, which is an indicator of processing data skew.
This view is accessible to all users.
However, non‑superusers will only be able to see tables that they have permission to access.
| Column | Description |
|---|---|
sifoid |
Object ID of the table |
sifnamespace |
Namespace where the table is defined |
sifrelname |
Table name |
siffraction |
Percentage of the system that is idle during a table scan, which is an indicator of uneven data distribution or query processing skew. For example, a value of 0.02 indicates 2% skew. Tables that have more than 10% skew should have their distribution policies evaluated |