RE: Off topic - LLegan mis correos a la lista

1.- Tamaño de la Base de Datos

SELECT datname, pg_size_pretty(pg_database_size(datname))
FROM pg_database
ORDER BY pg_database_size(datname) DESC

2.- Tamaño de las tablas y sus indices

SELECT
schemaname, tablename,
(SELECT pg_total_relation_size(schemaname||'.'||tablename) AS Bytes)/1024/1024 AS MegaBytes_table_plus_all_indexes,
(SELECT pg_relation_size(schemaname||'.'||tablename) AS Bytes)/1024/1024 AS MegaBytes_table_only
FROM pg_tables
ORDER BY MegaBytes_table_plus_all_indexes DESC;

3.- Tamaño de las tablas e indices y su over head

SELECT
schemaname, tablename,
(SELECT pg_total_relation_size(schemaname||'.'||tablename) AS Bytes)/1024/1024 AS MegaBytes_table_plus_all_indexes,
(SELECT pg_relation_size(schemaname||'.'||tablename) AS Bytes)/1024/1024 AS MegaBytes_table_only,
ROUND((
(
(SELECT pg_total_relation_size(schemaname||'.'||tablename))
- (SELECT pg_relation_size(schemaname||'.'||tablename))
)::NUMERIC / (
SELECT pg_total_relation_size(schemaname||'.'||tablename)
)
)*100,2)||'%' AS overhead_all_indexes
FROM pg_tables
where (pg_relation_size(schemaname||'.'||tablename)/1024/1024) > 0
ORDER BY MegaBytes_table_plus_all_indexes DESC;

Saludos

-----Mensaje original-----
De: Gilberto Castillo [mailto:gilberto(dot)castillo(at)etecsa(dot)cu]
Enviado el: miércoles, 28 de enero de 2015 13:08
Para: Mario Soto Cordones
Asunto: RE: [pgsql-es-ayuda] Off topic - LLegan mis correos a la lista

>
> Postgresql 9.2 bajo RHEL 6.x con 32 gb ram y 8 procesadores

¿Cómo sacas el tamaño de la DB?

Saludos,
Gilberto Castillo
La Habana, Cuba

-
Enviado a la lista de correo pgsql-es-ayuda (pgsql-es-ayuda(at)postgresql(dot)org)
Para cambiar tu suscripcin:
http://www.postgresql.org/mailpref/pgsql-es-ayuda