PGXC_GET_TABLE_SKEWNESS
PGXC_GET_TABLE_SKEWNESS displays the data skew on tables in the current database. Only users with the SYSADMIN permission can access this view.
Name | Type | Description |
|---|---|---|
schemaname | name | Schema name of a table |
tablename | name | Table name. |
totalsize | numeric | Total size of the table, in bytes |
avgsize | numeric(1000,0) | Average table size (total table size divided by the number of DNs), which is the ideal size of tables distributed on each DN |
maxratio | numeric(4,3) | Ratio of the maximum table size on a single DN to the total table size |
minratio | numeric(4,3) | Ratio of the minimum table size on a single DN to the total table size |
skewsize | bigint | Table skew rate (the maximum table size on a single DN minus the minimum table size on a single DN) |
skewratio | numeric(4,3) | Table skew rate (skew size divided by total table size) |
skewstddev | numeric(1000,0) | Standard deviation of table distribution (For two tables of the same size, a larger deviation indicates a more severe skew.) |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
