Warehouse User Guide > Warehouse and Database Management > Monitor Warehouses > Warehouse Monitoring Services > Table Data Skew
Was this helpful?
Table Data Skew
tableDataSkew -w <count> -c <count>
Displays counts of database tables with data skew. The warning (-w) and critical (-c) thresholds are applied to the table skew percentage; if that percentage is higher than the critical threshold, a critical alert is raised. If the percentage is higher than the warning threshold, a warning alert is raised. For more information, see Service Statuses.
1 critical tables and 0 warning tables
The detail section displays individual table data skew details:
Detail
Description
Partitions
Partition count for the specific table
Total Blocks
Sum of data blocks for all partitions
Partition Blocks
• Min – Block count for smallest partition
• Median – Partition median block count
• Max – Block count for largest partition
Data Skew
Data skew percentage
Table
Table name using <owner>.<table> notation
                Total                Partition Blocks          Data
Partitions      Blocks         Min       Median         Max    Skew  Table
 
     8           6,275           0          227       2,683  342.2%  actian.lineitem
Data Skew is calculated as partition blocks max / partition blocks average.
Last modified date: 10/30/2024