Thread: Need Help

how can i get the disk usage for each table? can i do it via SQL?



Thanks,

Mailing-Lists

--- 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.