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).

No Warranty: This tool and page are provided "as-is" and without any warranties, whether express or implied. We do not warrant the accuracy, completeness, or reliability of any input or output this tool generates, and we disclaim all warranties.
No Privacy Guarantee: Your use of the Tool may involve the submission of data or information. We make no representations or guarantees regarding the privacy or security of any data or information you provide. You are solely responsible for the security and protection of your data and information.
No Liability: In no event shall we be liable for any direct, indirect, incidental, special, consequential, or punitive damages, or any loss of profits or revenues, whether incurred directly or indirectly, arising out of your use of the Tool.
No Endorsement: The Tool may generate content or output based on the data or information you provide. We do not endorse, guarantee the accuracy of, or take responsibility for the content or output generated by the Tool.
Use at Your Own Risk: Your use of the Tool is at your own risk. You assume all responsibility and risk associated with the use of the Tool and any consequences resulting from its use.
No Guarantee of Availability: We reserve the right to modify, suspend, or discontinue the Tool at any time without notice. We are not responsible for any inconvenience or loss resulting from the unavailability of the Tool.
By using the Tool, you acknowledge that you have read and understood these terms and conditions and agree to be bound by them. If you do not agree with these terms and conditions, please do not use the Tool.