Does anyone know how to look up the transaction/query 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?

Source link