----- Mensagem original ----- > De: "Magnus Hagander" <mag...@hagander.net> > Para: "Laurenz Albe" <laurenz.a...@cybertec.at> > Cc: "Alvaro Herrera" <alvhe...@alvh.no-ip.org>, "luis.roberto" > <luis.robe...@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
