DataGrip - How to learn any table size in DataGrip?

Question

Simple question is that I want to learn table size in DataGrip.Is there any shortcut or a simple way ..

Answer 1

This query is a solution:

SELECT table_name,
(data_length + index_length) / power(1024, 2) AS tablesize_mb
FROM    information_schema.tables
WHERE   1=1
AND table_name IN ('actor', 'category', 'film', 'film_actor', 'film_category', 'language')

Answer 2

There is now a quick way to do this from the UI.

1. Right click the table of interest

2. Select Quick documentation

3. Scroll down to rows field