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.