SHOW STATS

Synopsis

SHOW STATS FOR table
SHOW STATS FOR ( SELECT * FROM table [ WHERE condition ] )

Description

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 Description

column_name The name of the column (NULL for the summary row) 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 NULL 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)