14.43. SHOW STATS
SHOW STATS FOR table SHOW STATS FOR ( SELECT * FROM table [ WHERE condition ] )
Returns approximated statistics for the named table or for the results of a (limited) query.
Statistics are returned for each column, along with a summary row.
(column_name will be
NULL for the summary row).
|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)|