ADVANCED_ HISTOGRAMS
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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.
Column Name |
Description |
---|---|
|
The name of the database. |
|
The name of the table. |
|
The name of the column. |
|
When there is a histogram on a json_ |
|
The data type of the column. |
|
Internal version number of the histogram format, which may change if the way histograms are stored is changed. |
|
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. |
Last modified: March 8, 2024