I will just show you how big of a mess it is to setup pgAudit on production deployments. TLDR: You can get it soon with Rocketgraph.io.
But I am very obsessed with building loggers using Postgres. There are some sneak peaks of my work on Twitter you can find in the above comment. But it's a lot of work to just setup pgAudit on AWS RDS. Like literally takes days. Basically you have to enable pgAudit, for that you need to edit the DBParameterGroup. Then enable cloudwatchlogs and query from cloudwatch console what logs you want to see. It's a mess. But here is a sneak peek of what's cooking at rocketgraph: https://twitter.com/RGraphql/status/1689631592321544192
It's so beautiful that I'm gonna name it "the sexy release".