Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 8/28/19 5:36 AM, francis picabia wrote:
>> I had no clue the database was the issue because I
>> had the minimal
>> log_duration = on
>> log_line_prefix = '<%t>'
>> With those settings all queries seen were roughly 1ms
>>
>> I need this log to show the true time it takes to get a result back.
> I'm having a hard time believing autovacuum was involved in this, given
> you say the queries took only 1ms on average.
Also: the time logged by log_duration IS the time it took, so far as the
server can tell.
Perhaps there's monstrous network delays involved, but what I'm suspicious
of is inefficient client-side processing.
regards, tom lane