SHOW STATS#
Synopsis#
SHOW STATS FOR table
SHOW STATS FOR ( SELECT * FROM table [ WHERE condition ] )
SHOW STATS FOR ( SELECT col1, col2,... colN FROM table [ WHERE condition ] )
Description#
Returns approximated statistics for the named table or for the results of a (limited) query.
Statistics are returned for the specified columns, along with a summary row.
(column_name will be NULL for the summary row).
Column |
Description |
|---|---|
column_name |
The name of the column |
data_size |
The total size in bytes of all of the values in the column |
distinct_values_count |
The number of distinct values in the column |
nulls_fractions |
The portion of the values in the column that are |
row_count |
The number of rows (only returned for the summary row) |
low_value |
The lowest value found in this column (only for some types) |
high_value |
The highest value found in this column (only for some types) |