View Recommendations
DBCC provides recommendations for table optimization, focusing on identifying tables with high bloat ratios or data skew. On the Recommendations page, you can detect potential storage and performance issues by checking the Bloat Ratio and Skew Rate of tables.
Access the page
To access the Recommendations page, you need to:
Access the DBCC dashboard in your browser via
http://<cluster_node_IP>:8080/.Click Recommendations in the left navigation menu to enter the page.
Note
Table bloat and skew data are collected periodically by the system in the background. The page displays the results from the most recent collection. To enable and configure the scan table task, see Configure scan table task.
The top of the tab displays details about the last collection task:
Scanned Tables: The number of tables covered in this collection.
Start Time: The start time of the last collection task.
Duration: The duration of the collection task.
Status: The status of the collection task.
View bloat ratio
The Bloat Ratio tab helps you identify tables that might need maintenance (such as VACUUM) to reclaim space.
In the search area, you can filter tables by Database, Schema, or Relation Name. Click Query to search.
The fields in the Bloat Ratio list are described as follows:
Field name |
Description |
|---|---|
Schema |
The schema to which the table belongs. |
Relation Name |
The name of the table. |
Include Partitions |
Indicates whether the table contains partitions. |
User |
The owner of the table. |
Size |
The storage size of the table. |
Est. Rows |
The estimated number of rows in the table. |
Bloat Ratio |
The estimated percentage of bloated space (dead tuples) in the table. |
Last Vacuumed |
The time when the table was last vacuumed. |
View skew rate
The Skew Rate tab helps you identify tables with uneven data distribution across segments, which can impact query performance.
In the search area, you can filter tables by Database, Schema, or Relation Name. Click Query to search.
The fields in the Skew Rate list are described as follows:
Field name |
Description |
|---|---|
Schema |
The schema to which the table belongs. |
Relation Name |
The name of the table. |
Include Partitions |
Indicates whether the table contains partitions. |
User |
The owner of the table. |
Size |
The storage size of the table. |
Est. Rows |
The estimated number of rows in the table. |
Skew Coefficient |
A coefficient indicating the degree of data skew. A higher value usually indicates clearer skew. |
Distributed By |
The distribution key columns of the table. |