finding and monitoring old WAL archives

[asli cokay <aslicokay@xxxxxxxxx>]

Hi everyone ,

I want to ask that let's say if I have 1 day old wal files I want to figure out and monitor that with prometheus. 

I can find the WAL files in this way  find <path to wal> -ctime +x(day)

I wonder if I want to figure out the files with sql command is there any way to figure out ?

Thanks in advance.