| From: | "Ireneusz Pluta/wp(dot)pl" <ipluta(at)wp(dot)pl> |
|---|---|
| To: | luis(dot)roberto(at)siscobra(dot)com(dot)br, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Table sizes |
| Date: | 2020-09-30 13:41:38 |
| Message-ID: | ac5663d1-933d-c453-6c8e-1e92185d7fdc@wp.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
W dniu 2020-09-30 o 14:11, luis(dot)roberto(at)siscobra(dot)com(dot)br pisze:
> 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
>
You need to use full tablenames, using schemaname of pg_tables too.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charles Clavadetscher | 2020-09-30 13:46:39 | Re: Table sizes |
| Previous Message | Wiltsch,Sigrid | 2020-09-30 13:32:41 | Problem close curser after rollback |