Re: 回复：there is a great difference between the query execution time and the log record time

On 02/08/2018 09:38 AM, 邓彪 wrote: i test psql on local and remote server are the same！ the jdbc remote client is display data on web page！ To me that indicates there is overhead in the Java/JDBC/Web stack that causing the statement to take extra time to finish. -- Adrian Klaver adrian.kla.

回复：there is a great difference between the query execution time and the log record time

i test psql on local and remote server are the same！ the jdbc remote client is display data on web page！ | | 邓彪 邮箱：dby...@163.com | 签名由 网易邮箱大师 定制 在2018年02月09日 01:33，Adrian Klaver 写道： On 02/08/2018 09:14 AM, 邓彪 wrote: > the client on the remote server！！！ So when you did the psql test was that

Re: there is a great difference between the query execution time and the log record time

On 02/08/2018 09:14 AM, 邓彪 wrote: the client on the remote server！！！ So when you did the psql test was that local to the server or remote? Also what is the JDBC remote client doing with the data? For example is is feeding a GUI form? 邓彪 邮箱：dby...@163.com

Re: there is a great difference between the query execution time and the log record time

the client on the remote server！！！ | | 邓彪 邮箱：dby...@163.com | 签名由 网易邮箱大师 定制 On 02/09/2018 00:54, Adrian Klaver wrote: On 02/08/2018 08:51 AM, nemo wrote: > Hi,the client is jdbc. Is the client on the server or is it remote? I am not a Java programmer, but for those that are and might be abl

Re: there is a great difference between the query execution time and the log record time

On 02/08/2018 08:51 AM, nemo wrote: Hi,the client is jdbc. Is the client on the server or is it remote? I am not a Java programmer, but for those that are and might be able to help could you provide the code that runs the query? -- Sent from: http://www.postgresql-archive.org/PostgreSQL

Re: there is a great difference between the query execution time and the log record time

Hi,the client is jdbc. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: there is a great difference between the query execution time and the log record time

Hi,from the explain the sql result is only 338 rows! -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: there is a great difference between the query execution time and the log record time

On Thu, Feb 8, 2018 at 5:35 PM, 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 (

Re: there is a great difference between the query execution time and the log record time

On 02/08/2018 08:35 AM, 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. 1. add auto_explain session_preload_libraries = 'au

there is a great difference between the query execution time and the log record time

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. 1. add auto_explain session_preload_libraries = 'auto_explain' auto_explain.log_min_duration = 100 a