From: Richard Broersma Jr <rabroersma@yahoo.com>
To: JM <jerome@gmanmi.tv>
To: pgsql-general@postgresql.org
Cc: Pgsql-Performance \(E-mail\) <pgsql-performance@postgresql.org>
Subject: Re: Need Help
Date: Wed, 27 Dec 2006 18:54:44 -0800 (PST)
Message-ID: <151434.43695.qm@web31810.mail.mud.yahoo.com> (raw)
In-Reply-To: <200612281042.52575.jerome@gmanmi.tv>
--- JM <jerome@gmanmi.tv> wrote:
> how can i get the disk usage for each table? can i do it via SQL?
This function should do what you want:
pg_relation_size(text) or pg_total_relation_size(text)
I found it on the following link:
http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE
Regards,
Richard Broersma Jr.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rabroersma@yahoo.com, jerome@gmanmi.tv, pgsql-general@postgresql.org
Subject: Re: Need Help
In-Reply-To: <151434.43695.qm@web31810.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox