----- Mensagem original ----- > De: "Magnus Hagander" <magnus@xxxxxxxxxxxx> > Para: "Laurenz Albe" <laurenz.albe@xxxxxxxxxxx> > Cc: "Alvaro Herrera" <alvherre@xxxxxxxxxxxxxx>, "luis.roberto" <luis.roberto@xxxxxxxxxxxxxxx>, "pgsql-general" > <pgsql-general@xxxxxxxxxxxxxxxxxxxx> > 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
