SHOW STATS

Synopsis

  1. SHOW STATS FOR table
  2. SHOW STATS FOR ( SELECT * FROM table [ WHERE condition ] )
  3. 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)