----- Mensagem original ----- > De: "Magnus Hagander" <[email protected]> > Para: "Laurenz Albe" <[email protected]> > Cc: "Alvaro Herrera" <[email protected]>, "luis.roberto" > <[email protected]>, "pgsql-general" > <[email protected]> > 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
