PostgreSQL - Cancelling statement due to conflict with recovery
Running queries on a standby replica node may cause queries to error out with a message 'Cancelling statement due to conflict with recovery'.
SQL - Postgres Long running queries
Quick snippet to discover queries that have been running for over 1 minute on Postgres
Kill a running query - Postgres
Often we notice long running queries in idle or idle in transaction state.