Re: query that canceled isnt logged - Mailing list pgsql-performance

From Mariel Cherkassky
Subject Re: query that canceled isnt logged
Date
Msg-id CA+t6e1k+hP1tAVn=9u0-TxufrVZKEo2E2wBJ6X5BoCo1yKvm+g@mail.gmail.com
Whole thread Raw
In response to query that canceled isnt logged  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Responses Re: query that canceled isnt logged  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: query that canceled isnt logged
Next
From: Mariel Cherkassky
Date:
Subject: Re: query that canceled isnt logged