vw_table_size

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

relname

name

2147483647

√

null

size_total

int8

19

√

null

size_pretty

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT pg_stat_user_tables.relname,
    pg_total_relation_size(((((pg_stat_user_tables.schemaname)::text || '.'::text) || (pg_stat_user_tables.relname)::text))::regclass) AS size_total,
    pg_size_pretty(pg_total_relation_size(((((pg_stat_user_tables.schemaname)::text || '.'::text) || (pg_stat_user_tables.relname)::text))::regclass)) AS size_pretty
   FROM pg_stat_user_tables
  WHERE (pg_stat_user_tables.schemaname = 'pgq'::name)
  ORDER BY (pg_total_relation_size(((((pg_stat_user_tables.schemaname)::text || '.'::text) || (pg_stat_user_tables.relname)::text))::regclass)) DESC; SELECT pg_stat_user_tables.relname,
    pg_total_relation_size(((((pg_stat_user_tables.schemaname)::text || '.'::text) || (pg_stat_user_tables.relname)::text))::regclass) AS size_total,
    pg_size_pretty(pg_total_relation_size(((((pg_stat_user_tables.schemaname)::text || '.'::text) || (pg_stat_user_tables.relname)::text))::regclass)) AS size_pretty
   FROM pg_stat_user_tables
  WHERE (pg_stat_user_tables.schemaname = 'public'::name)
  ORDER BY (pg_total_relation_size(((((pg_stat_user_tables.schemaname)::text || '.'::text) || (pg_stat_user_tables.relname)::text))::regclass)) DESC; SELECT pretty_sizes.table_name,
    pg_size_pretty(pretty_sizes.table_size) AS table_size,
    pg_size_pretty(pretty_sizes.indexes_size) AS indexes_size,
    pg_size_pretty(pretty_sizes.total_size) AS total_size
   FROM ( SELECT all_tables.table_name,
            pg_table_size((all_tables.table_name)::regclass) AS table_size,
            pg_indexes_size((all_tables.table_name)::regclass) AS indexes_size,
            pg_total_relation_size((all_tables.table_name)::regclass) AS total_size
           FROM ( SELECT (((('"'::text || (tables.table_schema)::text) || '"."'::text) || (tables.table_name)::text) || '"'::text) AS table_name
                   FROM information_schema.tables) all_tables
          ORDER BY (pg_total_relation_size((all_tables.table_name)::regclass)) DESC) pretty_sizes;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views