On Thu, Feb 8, 2018 at 5:35 PM, dby...@163.com <dby...@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.

Reply via email to