gp_skew_coefficients
The gp_toolkit.gp_skew_coefficients view shows data distribution skew by calculating the coefficient of variation (CV) for the data stored on each segment.
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 |
|---|---|
skcoid |
The object ID of the table |
skcnamespace |
The namespace where the table is defined |
skcrelname |
The table name |
skccoeff |
The coefficient of variation (CV) is calculated as the standard deviation divided by the average. It takes into account both the average and variability around the average of a data series. The lower the value, the better. Higher values indicate greater data skew |