Postgres Pro
Downloads
Home   >   mailing lists

Table sizes - Mailing list pgsql-general

From luis.roberto@siscobra.com.br
Subject Table sizes
Date
Msg-id 78366091.53791693.1601467902283.JavaMail.zimbra@siscobra.com.br
Whole thread Raw
Responses Re: Table sizes  ("Ireneusz Pluta/wp.pl" <ipluta@wp.pl>)
Re: Table sizes  (Charles Clavadetscher <clavadetscher@swisspug.org>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: Dependency problem using community repo on Redhat 7
Next
From: "v.brusa@joinsnc.com"
Date:
Subject: temp table same name real table