Hello Justin, On 27.02.2019 21:06, Justin Pryzby wrote:
I'm attaching a v2 patch which avoids repeated logging of PREPARE, rather than making such logs conditional on log_error_verbosity=VERBOSE, since log_error_verbosity is documented to control whether these are output: DETAIL/HINT/QUERY/CONTEXT/SQLSTATE.
I looked the patch. I got interesting result with different parameters.
With log_statement='all' and log_min_duration_statement='0' I get: =# execute test_ins(3); LOG: statement: execute test_ins(3); LOG: duration: 17.283 ms But with log_statement='none' and log_min_duration_statement='0' I get: =# execute test_ins(3); LOG: duration: 8.439 ms statement: execute test_ins(3); DETAIL: prepare: prepare test_ins (int) as insert into test values ($1); Is it intended? In the second result I got the query details. -- Arthur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company
