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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
