Visualizing MySQL 8.x Histogram Statistics (beta)

  1. Create a MySQL histogram using this command: ANALYZE TABLE tbl_name UPDATE HISTOGRAM ON col_name WITH N BUCKETS;
  2. Retrieve the histogram statistics using this query and paste it below:
    select histogram from information_schema.column_statistics where schema_name = 'schema' and table_name = 'table' and column_name = 'column';

Data distribution (Value : Frequency)

This chart visualizes the data distribution in the column by presenting the frequency of each distinct value (or range of values).

Data distribution (Value : Cumulative Frequency)

This chart visualizes the cumulative frequency of the column's data (e.g. useful to predict outputs of range filters).