swateek/blobs_in_singlestore.md

Created April 17, 2025 08:20

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/swateek/d08a50b38c18a4f83caac8b6f0e836a1.js"></script>
Save swateek/d08a50b38c18a4f83caac8b6f0e836a1 to your computer and use it in GitHub Desktop.

Blobs In Singlestore

Raw

USE information_schema;

DESC MV_DATA_DISK_USAGE;

SELECT * FROM MV_DATA_DISK_USAGE;

SELECT DATABASE_NAME, FORMAT(SUM(`BLOBS_B`) / 1024/1024, 0) MB
FROM MV_DATA_DISK_USAGE
GROUP BY DATABASE_NAME
ORDER BY MB DESC;