Cek Ukuran 10 Tabel Terbesar Dalam Database PostgreSQL

Jalankan Query Berikut:

select now(); SELECT n.nspname as "Schema",

  c.relname as "Name",

  pg_catalog.pg_size_pretty(pg_catalog.pg_table_size(c.oid)) as "Size"

FROM pg_catalog.pg_class c

     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace

WHERE c.relkind IN ('r','p','')

      AND n.nspname <> 'pg_catalog'

      AND n.nspname <> 'information_schema'

      AND n.nspname !~ '^pg_toast'

ORDER BY pg_catalog.pg_table_size(c.oid) desc limit 10;