check table size

Nervous Nightingale answered on June 15, 2020 Popularity 3/10 Helpfulness 2/10

answer check table size

related check size table

check table size

Comment

SELECT table_name AS "Table Name",
  ROUND(((data_length + index_length) / 1024 / 1024), 2)
  AS "Size in (MB)"
  FROM information_schema.TABLES
  WHERE table_schema = "YOUR_DB_NAME"
  ORDER BY (data_length + index_length) DESC;

Popularity 3/10 Helpfulness 2/10 Language whatever

Source: blog.gtwang.org

Tags: size whatever

Link to this answer
Share Copy Link

Contributed on Sep 12 2022

Nervous Nightingale

0 Answers Avg Quality 2/10

Closely Related Answers

check size table

Comment

-1

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

Popularity 10/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: size

Link to this answer
Share Copy Link

Contributed on Jun 15 2020

Difficult Dove

0 Answers Avg Quality 2/10

check table size

Contents

More Related Answers

check table size

Closely Related Answers

check size table

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.