Neil Conway wrote:
On Tue, 2005-01-25 at 16:49 -0700, Ed L. wrote:

The attached dbsize patch:

        + makes relation_size(relname) include toast tables;
        + adds aggregate_relation_size(relname) to count table data and indices;
        + adds indices_size(relname) to report the size of indices for a 

Hm, these are all implementable as SQL functions, do we need these hard coded too?

create function aggregate_relation_size(oid) returns int8 as $CODE$
select sum(pg_relation_size(indexrelid)) from pg_index where indrelid=$1;
$CODE$ language 'SQL'


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to