Adsar Logo


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;


Trees for life


Want to get in touch? mail@adsar.co.uk