More than 5 years have passed since last update.

テーブルのコラムサイズを調べる

PostgreSQL

Posted at 2015-07-07

size.sql

select
    sum(pg_column_size(the_text_column)) as total_size,
    avg(pg_column_size(the_text_column)) as average_size,
    sum(pg_column_size(the_text_column)) * 100.0 / pg_relation_size('t') as percentage
from t;

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up