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

SHOW STATS FOR table: Show statistics for a specific table. It provides information about the number of rows, number of nulls, minimum and maximum values, number of distinct values, and average length for each column in the table.

SHOW STATS FOR ( query ): Show statistics for the result of a specific query. It provides the same information as SHOW STATS FOR table, but for the result set of the query instead of a single table.

Any statistics that are not populated or unavailable on the data source are returned as NULL. Any additional statistics collected on the data source other than those listed below are not included in the output of the SHOW STATS command.

The summary row does not correspond to any specific column so the column_name value for the summary row is NULL.

The following table lists the returned columns and what statistics they represent.

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 fixed-precision 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 fixed-precision data types.