I am able to download logs from RDS having queries in the format
2022-09-18 00:00:02 UTC:<host><region>.compute.amazonaws.com(10000):user@db:[20000]:LOG: duration: 0.768 ms statement: Possibly multi line query>
I was suggested to use pgreplay, two things
(1) I want to provide a fixed user for all queries.
(2) The query format above is not compatible.
Is there something can be done or better to write a custom script? Or any alternative tool you would suggest?