SHOW STATS
Synopsis
SHOW STATS FOR table
SHOW STATS FOR ( query )
Description
Returns approximated statistics for the named table or for the results
of a query. Returns NULL for any statistics that are not populated or
unavailable on the data source.
Statistics are returned as a row for each column, plus a summary row for
the table (identifiable by a NULL value for column_name). The
following table lists the returned columns and what statistics they
represent. Any additional statistics collected on the data source, other
than those listed here, are not included.
| Column | Description | Notes |
|---|---|---|
column_name | The name of the column | NULL in the table summary row |
data_size | The total size in bytes of all of the values in the column | NULL in the table summary row. Available for columns of textual types (CHAR, VARCHAR, etc) |
distinct_values_count | The estimated number of distinct values in the column m | NULL in the table summary row |
nulls_fractions | The portion of the values in the column that areNULL | NULL in the table summary row. |
row_count | The estimated number of rows in the table | NULL in column statistic rows |
low_value | The lowest value found in this column | NULL in the table summary row. Available for columns of numeric types (BIGINT, DECIMAL, etc) |
high_value | The highest value found in this column | NULL in the table summary row. Available for columns of numeric types (BIGINT, DECIMAL, etc) |