Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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
