How to know the sizes of all tables & indexes in a database

From: "Sharma;G(dot)S(dot)" <ghanshyam(at)newgen(dot)co(dot)in>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: How to know the sizes of all tables & indexes in a database
Date: 2006-08-08 15:37:28
Message-ID: 020e01c6bb00$8e385b50$be05a8c0@ng3024
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
Postgres 7.3
Is there any way to know the size taken up by each table and indexes in postgres .
I am having a 53 GB database which contains tables , indexes, functions etc , how i can distribute these 53 GB's in database objects .

Thanks in advance

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jim Nasby 2006-08-08 16:29:28 Re: What's using all my RAM?
Previous Message Sharma;G.S. 2006-08-08 15:28:35 Temporary database Size & Transaction Logs