finding and monitoring old WAL archives

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.