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

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