This is a discussion on Re: [GENERAL] Need Help within the Pgsql Performance forums, part of the PostgreSQL category; --> --- JM <jerome@gmanmi.tv> wrote: > how can i get the disk usage for each table? can i do it ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| --- 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/i...S-ADMIN-DBSIZE Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate |