Table sizes

From: luis(dot)roberto(at)siscobra(dot)com(dot)br
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Table sizes
Date: 2020-09-30 12:11:42
Message-ID: 78366091.53791693.1601467902283.JavaMail.zimbra@siscobra.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I'm trying to use this query to get table sizes, however I'm getting a strange error:

select tablename,pg_relation_size(tablename::text)
from pg_tables;

In PG 13:

SQL Error [42P01]: ERROR: relation "sql_implementation_info" does not exist

In PG 12:

SQL Error [42P01]: ERROR: relation "sql_parts" does not exist

Responses

Browse pgsql-general by date

  From Date Subject
Next Message v.brusa@joinsnc.com 2020-09-30 13:27:17 temp table same name real table
Previous Message Devrim Gündüz 2020-09-30 11:48:56 Re: Dependency problem using community repo on Redhat 7