We are trying to debug some of the problems we are having on our production database server. One thing we would like to enable is
pg_stat_statements, but we are holding off on restarting the service. In the meantime, we had the idea that we could enable
pg_stat_statements and restart the hot standby. The thinking here was that we could at least see all of the writes that were issued in production, just on a time delay. However, this doesn't seem to be the case.
Is there a way to view the updates that are issued by the WAL logs on the hot standby?
EDIT: or by streaming replication?