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 of 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.