Re: pg_stat_statements opening claim is potentially misleading

2018-05-15 Thread legrand legrand
The same should be noted for auto_explain as described here www.postgresql-archive.org/Statements-that-time-out-are-not-considered-here-td6006753.html As you, I was quite confused that cancelled queries where not taken into account, I first consider total_time, and mean_time in a second step (s

Re: trigger audit logon

2018-02-21 Thread legrand legrand
Hi, there is no such trigger in Postgres, but maybe what you are searching is here: https://www.pgaudit.org/ Regards PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-docs-f2165602.html

Re: Statements that time out are not considered here

2018-02-21 Thread legrand legrand
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