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);
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.
