On Fri, Oct 8, 2021 at 4:39 PM Bharath Rupireddy <bharath.rupireddyforpostg...@gmail.com> wrote: > > Hi, > > At times, users want to know what are the files (snapshot and mapping > files) that are available under pg_logical directory and also the > spill files that are under pg_replslot directory and how much space > they occupy. >
Why can't you use pg_ls_dir to see the contents of pg_replslot? To know the space taken by spilling, you might want to check pg_stat_replication_slots[1] as that gives information about spill_bytes. [1] - https://www.postgresql.org/docs/devel/monitoring-stats.html#MONITORING-PG-STAT-REPLICATION-SLOTS-VIEW -- With Regards, Amit Kapila.
