Re: DB size

----- Mensagem original -----
> De: "Josef Šimánek" <josef.simanek@gmail.com>
> Para: "luis.roberto" <luis.roberto@siscobra.com.br>
> Cc: "pgsql-general" <pgsql-general@lists.postgresql.org>
> Enviadas: Segunda-feira, 26 de abril de 2021 17:40:05
> Assunto: Re: DB size

> Do you have any indexes in mydb database?


Yes, I do. I believe pg_total_relation_size accounts for these. These are the results for my biggest table:

SELECT pg_table_size('my_table'),
       pg_size_pretty(pg_table_size('my_table')) AS tb_pretty,
       pg_indexes_size('my_table'),
       pg_size_pretty(pg_indexes_size('my_table')) AS idx_pretty,
       pg_total_relation_size('my_table'),
       pg_size_pretty(pg_total_relation_size('my_table')) AS total_pretty

pg_table_size|tb_pretty|pg_indexes_size|idx_pretty|pg_total_relation_size|total_pretty|
-------------+---------+---------------+----------+----------------------+------------+
  82016485376|76 GB    |    88119033856|82 GB     |          170135519232|158 GB      |


Luis R. Weck