Re: DB size

----- Mensagem original -----
> De: "Magnus Hagander" <magnus@hagander.net>
> Para: "Laurenz Albe" <laurenz.albe@cybertec.at>
> Cc: "Alvaro Herrera" <alvherre@alvh.no-ip.org>, "luis.roberto" <luis.roberto@siscobra.com.br>, "pgsql-general"
> <pgsql-general@lists.postgresql.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