ADVANCED_HISTOGRAMS
This view contains information about histograms that have been collected by automatic statistics or using ANALYZE
.
For more information about this command and which columns SingleStore collects histograms on, see Statistics and Sampling Tasks.
Each histogram provides information about the distribution of data in a column, and consists of several buckets - the groups/intervals among which data points are divided. Each histogram bucket is displayed as a row in this view.
Column Name | Description |
---|---|
| The name of the database. |
| The name of the table. |
| The name of the column. |
| The datatype of the column. |
| Internal version number of the histogram format, which may change if the way histograms are stored is changed. Its current value is 100. |
| The number of buckets in the histogram. |
| The index for a given bucket within its histogram. |
| The minimum value in a given bucket. |
| The maximum value in a given bucket. |
| The number of distinct data values that are in a given bucket. |
| The number of rows in a given bucket. |
| The cumulative number of distinct data values in this column, up to the current bucket index. |
| The cumulative number of rows in this column, up to the current bucket index. |