Postgres Pro
Downloads
Home   >   mailing lists

Re: there is a great difference between the query execution time andthe log record time - Mailing list pgsql-general

From Francisco Olarte
Subject Re: there is a great difference between the query execution time andthe log record time
Date
Msg-id CA+bJJbxuFFMsiuhEYW9HjwD6Ei7+r=xVn2afBoJA2ykwqt1atw@mail.gmail.com
Whole thread Raw
In response to there is a great difference between the query execution time and the log record time  ("dbyzaa@163.com" <dbyzaa@163.com>)
Responses Re: there is a great difference between the query execution timeand the log record time  (nemo <dbyzaa@163.com>)
List pgsql-general
Tree view 
On Thu, Feb 8, 2018 at 5:35 PM, dbyzaa@163.com <dbyzaa@163.com> wrote:
> Hi,everybody recently, I found some slow SQL runtime as long as 4 seconds in
> postgres log. However, when I was executing on PSQL client, it takes only
> 3.6 milliseconds, I did the following things.
....

You are not doing the same thing ( explain discards all data in the
server ) and your query has a lot of columns. I'm not sure if it does
affect, but are you sure you are not gettin more time for transmitting
the actual result data?

Francisco Olarte.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: there is a great difference between the query execution time andthe log record time
Next
From: nemo
Date:
Subject: Re: there is a great difference between the query execution timeand the log record time