Show table histograms

It's not that easy to see which tables have histograms associated with them.

To do so, run this query:

SELECT SCHEMA_NAME,TABLE_NAME,COLUMN_NAME,HISTOGRAM->>'$."data-type"' AS 'data-type', JSON_LENGTH(HISTOGRAM->>'$."buckets"') AS 'bucket-count'
FROM INFORMATION_SCHEMA.COLUMN_STATISTICS;

YOU'VE FOUND GREAT DEALS

WELL DONE ✓

adsar · deal runner

Space / ↑ to jump · double jump · Esc to close