Re: Slow query in JDBC

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Subramaniam C <subramaniam31784(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow query in JDBC
Date: 2017-09-28 09:20:45
Message-ID: CAOBaU_beQv5GoeaZT3Jk382MtsfTfMUmXaN9cS_ocunw4UKqxA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Sep 28, 2017 at 10:58 AM, Subramaniam C
<subramaniam31784(at)gmail(dot)com> wrote:
> I configured cursor_tuple_fraction to 1 but still I am facing the same
> issue.

Can you show explain (analyze, buffers) of the query when run from
psql and run from application (you can use auto_explain for that if
needed, see https://www.postgresql.org/docs/current/static/auto-explain.html)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pavy Philippe 2017-09-28 09:26:06 Re: Slow query in JDBC
Previous Message Subramaniam C 2017-09-28 08:58:24 Re: Slow query in JDBC