Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dxV26-0004OR-Qm for pgsql-performance@arkaria.postgresql.org; Thu, 28 Sep 2017 09:23:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dxV26-0004Xu-CE for pgsql-performance@arkaria.postgresql.org; Thu, 28 Sep 2017 09:23:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dxV0J-0000xN-VG for pgsql-performance@postgresql.org; Thu, 28 Sep 2017 09:21:12 +0000 Received: from mail-it0-x22a.google.com ([2607:f8b0:4001:c0b::22a]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dxV0G-00055p-3a for pgsql-performance@postgresql.org; Thu, 28 Sep 2017 09:21:11 +0000 Received: by mail-it0-x22a.google.com with SMTP id y138so491593itc.5 for ; Thu, 28 Sep 2017 02:21:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=jDDMkftQ8vW86UrnkrYOzfr5ydwtxz5OeMY0Z0UIibA=; b=D11Z2/e6M7p34l6SnPuMCkDyk3dOwd+4FWXg/uztt9oK8xFFMQ7swzHiZar8LRPGyB o4ccqLLalHP/gmVNKTXDAUwXl2Yqx7SzDgqAGX199HlMGO/MeCcOxKyPXYMdjWCnQlRB lqEw2AO5gP7a5xunhEXZYanWY7aewBSTH+OrE+/abwj7a7M+2w0f21wDLpJhVRhxl601 9SJhV/3Txyjm3bYbLLfpruAl71Cg5PH62Xi0kMMoKhmrxkph9IKSog/mYGkqfQi/XMUL aXzFEgoj16u7W3PQC78Ie4OH0vhE4iw7A2iHnmdQUDVEgICdsX7j3SNosK1AfGr3a7JF w9HQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=jDDMkftQ8vW86UrnkrYOzfr5ydwtxz5OeMY0Z0UIibA=; b=KR10fWPBMl4R6eZCdQ0kqyInKqrhwAAdE/ZRyMzspzyvUrKHAt+NN/17hX0+UnbT5F NC+bG3HxF4poM2naVV6nUiXMDxrQ/r2yk7SW/4P+q0ummVx9w3oAgZ+DLO013eCQ31Bh AWfUMsQ99k1DZLHDNLYzHhxB44at1RpB4nzK556f2KB8nFIgYaHIR+6VlR7OxQTBx6Js GsiEKCFZc+RAjLIioEb/PElQWJrYfamK8CS2HZfS48GlPWPpDmMYCFIZvCBNAbOwaZan ZLaIKaHyWrTrPSGqo9qyjLcDZf2W6atpPi1pWqUNbIaMRBVl1Gacq1xFgFoOWRNsK6jR ZZGQ== X-Gm-Message-State: AMCzsaU/JUe2XV3FH4E30Mp7ryp6L7v3Mbd9jFLs+o7FoS7jxki92PBP t0FIw3CYvqI3J4DLwZMDmOuwQOhMUGmDf/SzBs8= X-Google-Smtp-Source: AOwi7QD7+jduQYB2PuV/yXVJv5k8aoJAK0z8CbYC+v6QKa5Xobr5I9Bkbul4oO2sqbOXnN2nIr9rHVCuAJmUEKOs3Vk= X-Received: by 10.36.74.9 with SMTP id k9mr549387itb.145.1506590466113; Thu, 28 Sep 2017 02:21:06 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.162.205 with HTTP; Thu, 28 Sep 2017 02:20:45 -0700 (PDT) In-Reply-To: References: From: Julien Rouhaud Date: Thu, 28 Sep 2017 11:20:45 +0200 Message-ID: Subject: Re: Slow query in JDBC To: Subramaniam C Cc: pgsql-performance@postgresql.org Content-Type: text/plain; charset="UTF-8" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On Thu, Sep 28, 2017 at 10:58 AM, Subramaniam C 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). -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance