Mariel Cherkassky writes:
> 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 E
that is the first thing I did but it isnt logged even when this parameter
is set, I guess because it is canceled before it finishes to run - which is
weird..
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
Mariel Cherkassky 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 won
