RE: [pgsql-es-ayuda] Off topic - LLegan mis correos a la lista

Wed, 28 Jan 2015 08:19:31 -0800 

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.casti...@etecsa.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@postgresql.org)
Para cambiar tu suscripci�n:
http://www.postgresql.org/mailpref/pgsql-es-ayuda

Responder a