SELECT n.nspname AS schemaname, c.relname AS tablename, C.reltuples::int AS
Registros, pg_size_pretty(pg_relation_size(n.nspname ||'.'||c.relname)) as
Tamanho
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_tablespace t ON t.oid = c.reltablespace
WHERE c.relkind = 'r'::"char"
-AND n.nspname = 'acc'
AND nspname NOT IN
('dbateste','information_schema','pg_catalog','pg_temp_1','pg_toast','postgres','publico','public')
ORDER BY n.nspname
----- Original Message -----
From: paulo matadr
To: pgbr_LISTA
Sent: Monday, June 01, 2009 10:41 AM
Subject: [pgbr-geral] listar tabelas pelo tamanho
Pessoal, alguem tem ai uma query pronta pra listar por tamanho (com indice)
as tabelas do banco.
agradeço desde ja
------------------------------------------------------------------------------
Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10 -
Celebridades - Música - Esportes
------------------------------------------------------------------------------
_______________________________________________
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
_______________________________________________
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
