What do you mean by live queries ? If I'll try to run the following query and cancel it manually(ctrl+c) : select pg_sleep(10) I will see in the logs the following messages :
2019-12-08 17:16:34 IST postgres 30797 LOG: statement: select pg_sleep(10); 2019-12-08 17:16:36 IST postgres 30797 ERROR: canceling statement due to user request 2019-12-08 17:16:36 IST postgres 30797 STATEMENT: select pg_sleep(10); The first message indicates that I run this query (logged because I set log_statements to all) and the two next messages appear because I canceled the query. When it happens to my application I dont see the first message that indicates that I run it and thats what I'm trying to understand. >
