Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx> writes: > ... > Therefore, my theory was that the validation query is taking more than 2 > seconds. I decided to log all the statements(log_statements=all) that are > running in order to see for how long the validation query is running in the > db (log_min_duration_statement wont be helpful here because the query is > canceled and I wont be able to see its duration..). > The weird thing is that I dont see before that error any log message that > indicate that the query was running. I hoped to see the following msg in > the db log : > 2019-12-08 00:04:55 IST DB 2695 LOG: *execute *<unnamed>: select 1 as test > but I dont see any execute msg of this query , I just see the ERROR msg : > 2019-12-08 00:04:56 IST DB 10035 ERROR: canceling statement due to user > request > 2019-12-08 00:04:56 IST DB 10035 STATEMENT: select 1 as test Hm. Perhaps you should *also* turn on log_min_duration_statement = 0, so that the parse and bind phases log something. Maybe one of them is taking a long time (hard to see why...) regards, tom lane
