Hi, On 2019-04-04 16:01:26 -0300, Alvaro Herrera wrote: > Also, if you parse once and bind/execute many times, IMO the statement > should be logged exactly once. I think you could that with the flag I > propose.
I'm not actually sure I buy this. Consider e.g. log analysis for workloads with long-running connections. If most statements are just already prepared statements - pretty common in higher throughput apps - the query will suddenly be either far away in the logfile (thereby requiring pretty expensive analysis to figure out the corresponding statement) or even in a different logfile due to rotation. I'm sympathetic to the desire to reduce log volume, but I'm fearful this would make log analysis much harder. Searching through many gigabytes just to find the query text of the statement being executed over and over doesn't sound great. I think deduplicating the logging between bind and execute has less of that hazard. - Andres