Postgres Pro
Downloads
Home   >   mailing lists

Re: Difference in the size of database size and relations - Mailing list pgsql-admin

From bricklen
Subject Re: Difference in the size of database size and relations
Date
Msg-id CAGrpgQ_fr_4m48fSP5rB=aKUFgMPHrvVC-zv8=1z_3qh791ncg@mail.gmail.com
Whole thread Raw
In response to Re: Difference in the size of database size and relations  (Luis <luisico@gmail.com>)
Responses Re: Difference in the size of database size and relations  (Luis <luisico@gmail.com>)
List pgsql-admin
Tree view

On Tue, Dec 10, 2013 at 4:43 AM, Luis <luisico@gmail.com> 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

pgsql-admin by date:

Previous
From: Luis
Date:
Subject: Re: Difference in the size of database size and relations
Next
From: Luis
Date:
Subject: Re: Difference in the size of database size and relations