Does anyone know how to look up the transaction that’s associated with an LSN on a CloudSQL Postgres instance?
For example, let’s say I’m trying to find the transaction associated with LSN
842/E62E3F01. On a normal server, I can ssh into the instance, and run
pg_waldump --start=842/E62E3F01 (or
pg_xlogdump on Postgres < 10). But it doesn’t seem possible to ssh into a CloudSQL server. If so, how can I find the query/transaction associated with this LSN on CloudSQL?
I'm open to using Query Insights as well. Specifically, I'm having an issue where I'm trying to monitor transactions larger than 1GB. If there's a way to do this in Query Insights, that would be helpful. I can get the LSN's of these transactions, but not sure how to map them back to the actual transactions themselves.