Hi guys, does anybody knows the query to show the information showed in the image?
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
WHERE DATABASE_NAME = '**YOUR DATABASE NAME**'
GROUP BY STORAGE_TYPE