Mysql get table size

SELECT
  TABLE_NAME AS `Table`,
  ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = "bookstore"
ORDER BY
  (DATA_LENGTH + INDEX_LENGTH)
DESC;

Source: chartio.com

Return size of tables in mysql

SELECT 
     table_schema as `Database`, 
     table_name AS `Table`, 
     round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
FROM information_schema.TABLES 
ORDER BY (data_length + index_length) DESC;

Source: stackoverflow.com

Check size table

SELECT pg_size_pretty( pg_total_relation_size('tablename') );
(postgres)

-1

Similar codes

16 votes194 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
13 votes176 views2 answers
Get tables in database sql
SQL
1 vote175 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
0 vote195 views1 answer
Mysql dump with table query
SQL
0 vote149 views2 answers
Postgresql display subquery as json
SQL
0 vote172 views1 answer
Heavy table in mysql
SQL
10 votes196 views6 answers
Sql between
SQL
3 votes170 views2 answers
Update Query in SQL Server
SQL
0 vote230 views1 answer
Drop view sql
SQL
5 votes185 views2 answers
To date oracle
SQL