public inbox for [email protected]help / color / mirror / Atom feed
Statements that time out are not considered here 3+ messages / 3 participants [nested] [flat]
* Statements that time out are not considered here @ 2018-02-21 18:35 PG Doc comments form <[email protected]> 2018-02-21 18:42 ` Re: Statements that time out are not considered here Salvador Jacinto <[email protected]> 2018-02-21 22:03 ` Re: Statements that time out are not considered here legrand legrand <[email protected]> 0 siblings, 2 replies; 3+ messages in thread From: PG Doc comments form @ 2018-02-21 18:35 UTC (permalink / raw) To: [email protected]; +Cc: [email protected] 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 . ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Statements that time out are not considered here 2018-02-21 18:35 Statements that time out are not considered here PG Doc comments form <[email protected]> @ 2018-02-21 18:42 ` Salvador Jacinto <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Salvador Jacinto @ 2018-02-21 18:42 UTC (permalink / raw) To: [email protected]; [email protected] 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" <[email protected]> escreveu: > 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 . > ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Statements that time out are not considered here 2018-02-21 18:35 Statements that time out are not considered here PG Doc comments form <[email protected]> @ 2018-02-21 22:03 ` legrand legrand <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: legrand legrand @ 2018-02-21 22:03 UTC (permalink / raw) To: pgsql-docs 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2018-02-21 22:03 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2018-02-21 18:35 Statements that time out are not considered here PG Doc comments form <[email protected]> 2018-02-21 18:42 ` Salvador Jacinto <[email protected]> 2018-02-21 22:03 ` legrand legrand <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox