Show table size by its storage type

SingleStore Tools
1

Hi guys, does anybody knows the query to show the information showed in the image?

49
Screen Shot 2019-08-13 at 17.29.49.png2348×778 75.8 KB

2

Hi @diemontufar,

You can find everything inside TABLE_STATISTICS table in the information_schema database inside MemSQL Studio, and you can use:

SELECT TABLE_NAME, STORAGE_TYPE FROM TABLE_STATISTICS;

For showing table size by its storage type you can use:
SELECT SUM(MEMORY_USE), STORAGE_TYPE
FROM TABLE_STATISTICS
WHERE DATABASE_NAME = '**YOUR DATABASE NAME**'
GROUP BY STORAGE_TYPE