# 9.45. SHOW STATS

## Synopsis

```
SHOW STATS FOR table
SHOW STATS FOR ( SELECT * FROM table [ WHERE condition ] )
```

## Description

Returns approximated statistics for the named table or for the results of a (limited) query.

Statistics are returned for each column, along with a summary row.

Column | Description |
---|---|

`column_name` |
The name of the column (`NULL` for the summary row) |

`data_size` |
The total size in bytes of all of the values in the column |

`distinct_values_count` |
The number of distinct values in the column |

`nulls_fractions` |
The portion of the values in the column that are `NULL` |

`row_count` |
The number of rows (only returned for the summary row) |

`low_value` |
The lowest value found in this column (only for some types) |

`high_value` |
The highest value found in this column (only for some types) |