On Thu, Feb 8, 2018 at 5:35 PM, dbyzaa(at)163(dot)com <dbyzaa(at)163(dot)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.