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.
Statistics
| 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 the values in the column | NULL in the table summary row. Available for columns of string data types with variable widths. |
distinct_values_count | The estimated number of distinct values in the column | NULL in the table summary row |
nulls_fractions | The portion of the values in the column that are NULL | 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 DATE, integer, floating-point, and exact numeric data types. |
high_value | The highest value found in this column | NULL in the table summary row. Available for columns of DATE, integer, floating-point, and exact numeric data types. |