Re: query that canceled isnt logged

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux