Re: query that canceled isnt logged
| От | Mariel Cherkassky |
|---|---|
| Тема | Re: query that canceled isnt logged |
| Дата | |
| Msg-id | CA+t6e1k+hP1tAVn=9u0-TxufrVZKEo2E2wBJ6X5BoCo1yKvm+g@mail.gmail.com обсуждение исходный текст |
| Ответ на | query that canceled isnt logged (Mariel Cherkassky <mariel.cherkassky@gmail.com>) |
| Ответы |
Re: query that canceled isnt logged
|
| Список | 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);
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 по дате отправления: