Sorry, my bad. I did run that query with pg_total_relation_size before but somehow I sent by email the one a query without the total. The result is basically the same: size --------- 100 MB 60 MB 10 MB 9928 kB 5280 kB 5144 kB 3360 kB 2144 kB 1152 kB 2128 kB 544 kB 528 kB 336 kB 336 kB 336 kB 304 kB 296 kB 288 kB 288 kB 101 MB thanks 2013/12/10 bricklen <bricklen@xxxxxxxxx>: > > On Tue, Dec 10, 2013 at 4:43 AM, Luis <luisico@xxxxxxxxx> wrote: >> >> Actually the query I used to get the relations sizes also included >> indexes and even pg_toast. > > > Your query appears to be using "pg_relation_size()", try it again with > "pg_total_relation_size()" to include indexes and toast tables. > > Specifics can be found at: > http://www.postgresql.org/docs/current/static/functions-admin.html -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
