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