10.47. SHOW STATS
- Synopsis
- Description

10.47. 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 `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)