Postgres Pro
Downloads
Home   >   mailing lists

Re: Finding the size of your biggest relations - Mailing list pgsql-admin

From Artem Tomyuk
Subject Re: Finding the size of your biggest relations
Date
Msg-id CANYYVqKF83n76cD3+SGZkOBWVOytMmVun72a_vm_euYw1CdbjA@mail.gmail.com
Whole thread Raw
In response to Re: Finding the size of your biggest relations  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: Finding the size of your biggest relations
List pgsql-admin
Tree view
Sorry, 
this query

SELECT nspname || '.' || relname AS "relation",   pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size" FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) WHERE nspname NOT IN ('pg_catalog', 'information_schema')   AND C.relkind <> 'i'   AND nspname !~ '^pg_toast' ORDER BY pg_total_relation_size(C.oid) DESC LIMIT 20;


2016-09-23 16:21 GMT+03:00 hubert depesz lubaczewski <depesz@depesz.com>:
On Fri, Sep 23, 2016 at 03:57:52PM +0300, Artem Tomyuk wrote:
> i am running this query to get to 20 biggest tables but getting only
> pg_temp** records like this without size:

What query did you run?

For finding largest tables, I use:

select oid::regclass, pg_table_size(oid) from pg_class where relkind
= 'r' order by 2 desc limit 20;

Best regards,

depesz


pgsql-admin by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Finding the size of your biggest relations
Next
From: "Jan-Peter Seifert"
Date:
Subject: Recommended cluster locale (initdb)?