Jeff Janes <jeff.ja...@gmail.com> writes:
> On Tue, Nov 6, 2012 at 10:49 AM, Lists <li...@benjamindsmith.com> wrote:
>> I followed your example, the result is at the bottom. Based on this it would
>> seem that there are 3-4 databases that seem to be the culprit. How could I
>> get more depth/detail on what specifically is the problem?

> If you have installed the contrib modules (oid2name specifically), you
> can use that to get the name of the bloated database:
> oid2name | fgrep 607471

Or, if you didn't install contrib, try

        select datname from pg_database where oid = 607471

> If the name of the database doesn't give you any insight, then look
> for large files in the directory base/607471 that whose names all
> start with the same digits and use oid2name to get the names of the
> relations for those files.

> oid2name -d <name of database>  -o <base name of large files>

For this you can try

        select relname from pg_class where relfilenode = <whatever>

Or let the database do the work:

        select relname, pg_relation_size(oid) from pg_class order by 2 desc;

                        regards, tom lane


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to