| From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
|---|---|
| To: | JM <jerome(at)gmanmi(dot)tv>, pgsql-general(at)postgresql(dot)org |
| Cc: | "Pgsql-Performance \(E-mail\)" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Need Help |
| Date: | 2006-12-28 02:54:44 |
| Message-ID: | 151434.43695.qm@web31810.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
--- JM <jerome(at)gmanmi(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 马庆 | 2006-12-28 03:04:10 | 答复: [GENERAL] Need Help |
| Previous Message | JM | 2006-12-28 02:42:52 | Need Help |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guy Rouillier | 2006-12-28 05:46:49 | High update activity, PostgreSQL vs BigDBMS |
| Previous Message | JM | 2006-12-28 02:42:52 | Need Help |