Re: DB size

----- Mensagem original -----
> De: "Magnus Hagander" <magnus(at)hagander(dot)net>
> Para: "Laurenz Albe" <laurenz(dot)albe(at)cybertec(dot)at>
> Cc: "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org>, "luis.roberto" <luis(dot)roberto(at)siscobra(dot)com(dot)br>, "pgsql-general"
> <pgsql-general(at)lists(dot)postgresql(dot)org>
> Enviadas: Terça-feira, 27 de abril de 2021 4:05:42
> Assunto: Re: DB size

> Yeah, you want to use pg_relation_filenode(oid) rather than looking
> directly at relfilenode.
>
> When compared to the filesystem, it's probably even easier to use
> pg_relation_filepath(oid).
>
> --
> Magnus Hagander
> Me: https://www.hagander.net/
> Work: https://www.redpill-linpro.com/

Thanks all!

Looks like pg_orphaned is what I need! I'll use pg_relation_filepath too to double check.

Luis R. Weck