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 | 
|---|---|---|
| 
 | The name of the column | 
 | 
| 
 | The total size in bytes of all of the values in the column | 
 | 
| 
 | The estimated number of distinct values in the column | 
 | 
| 
 | The portion of the values in the column that are  | 
 | 
| 
 | The estimated number of rows in the table | 
 | 
| 
 | The lowest value found in this column | 
 | 
| 
 | The highest value found in this column | 
 |