freedom=> SELECT relname, reltuples, relpages * 8 / 1024 AS "MB" FROM pg_class ORDER BY relpages DESC; relname | reltuples | MB -----------------------------------+-----------+----- i_docrelc | 60868 | 492 i_docrels | 60868 | 488 full_docread | 16353 | 48 pg_toast_103473 | 23626 | 32 idx_perm | 178001 | 28 pg_toast_16853 | 19210 | 28 docread | 16353 | 20 [...]
Cette commande est pour un block size de 8 Ko. Pour connaître la valeur de votre block size :
# LC_ALL=C pg_controldata /var/lib/pgsql/data/ [...] Database block size: 8192 [...]