Skip to content

Instantly share code, notes, and snippets.

@codfish

codfish/get_table_sizes.sql

Last active August 29, 2015 14:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save codfish/ae94686a5aee0173f3af to your computer and use it in GitHub Desktop.
Save codfish/ae94686a5aee0173f3af to your computer and use it in GitHub Desktop.
Download ZIP
Here is a super simple SQL query to determine the size of all tables in a given database. References: http://goo.gl/7jFF5y, http://goo.gl/cBZKWW
Raw
get_table_sizes.sql
-- only thing you need to supply is the database name in the WHERE statement
SELECT TABLE_NAME AS "Table",
round(((data_length + index_length) / 1024 / 1024), 2) AS Size_in_MB
FROM information_schema.TABLES
WHERE table_schema = '%%database%%'
ORDER BY Size_in_MB DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment