This should help you get the disk usage for a table: select pg_size_pretty(pg_relation_size('tablename'));
--------------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 12/28/06, 马庆 <[EMAIL PROTECTED]> wrote:
Maybe U can't get the disk usage info, but you can try command "explain" -----邮件原件----- 发件人: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] 代表 JM 发送时间: 2006年12月28日 10:43 MARK 收件人: pgsql-general@postgresql.org 抄送: Pgsql-Performance (E-mail) 主题: [GENERAL] Need Help how can i get the disk usage for each table? can i do it via SQL? Thanks, Mailing-Lists ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match