To Nha Notes | July 19, 2021, 8:50 a.m.
SELECT TABLE_NAME, PARTITION_METHOD, PARTITION_EXPRESSION, COUNT(*) AS PARTITIONS, FORMAT(table_rows, 3) AS Records, FORMAT(ROUND(((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024 / 1024), 2), 2) AS "Size (GiB)" FROM information_schema.partitions WHERE TABLE_SCHEMA='ebdb'AND PARTITION_NAME IS NOT NULL GROUP BY TABLE_NAME, PARTITION_EXPRESSION ORDER BY PARTITION_METHOD DESC, TABLE_NAME;