Statements that time out are not considered here
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/auto-explain.html
Description:
It should be noted that if a statement is cancelled because of the
statement_timeout setting, auto_explain will not log it, even if
statement_timeout is greater than auto_explain.log_min_duration .
0ORPPPPORQE NÃO ME FALA O TREDUZIDO EU RESPONDO TUDO EM UMA SÓ VEz
Em 21/02/2018 2:36 PM, "PG Doc comments form" <noreply@postgresql.org>
escreveu:
Show quoted text
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/auto-explain.html
Description:It should be noted that if a statement is cancelled because of the
statement_timeout setting, auto_explain will not log it, even if
statement_timeout is greater than auto_explain.log_min_duration .
Hi,
It seems that auto_explain works only with finished statements.
I think (to be confirmed) that SQL statements not finished because
timed-out, cancelled, killed, or simply errored are not giving any output.
It would be nice if that could be change, giving a partial explain analyze
as done in
https://github.com/postgrespro/pg_query_state/blob/PGPRO10/runtime_explain.patch
Regards
PAscal
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-docs-f2165602.html