Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dxV7h-0004kC-8v for pgsql-performance@arkaria.postgresql.org; Thu, 28 Sep 2017 09:28:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dxV7g-0007pL-PG for pgsql-performance@arkaria.postgresql.org; Thu, 28 Sep 2017 09:28:48 +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 1dxV5w-0004kU-MP for pgsql-performance@postgresql.org; Thu, 28 Sep 2017 09:27:00 +0000 Received: from smtppost.atos.net ([193.56.114.166]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dxV5r-0005DB-DE for pgsql-performance@postgresql.org; Thu, 28 Sep 2017 09:27:00 +0000 Received: from mail.fr.worldline.com (edge-smtp-wse04.fr.worldline.com) by smarthost4.atos.net with smtp (TLS: TLSv1/SSLv3,256bits,ECDHE-RSA-AES256-SHA384) id 4b6b_5b59_19f5c4ed_14b9_4a17_9d2c_949243749403; Thu, 28 Sep 2017 11:26:52 +0200 Received: from frspx302.fr01.awl.atosorigin.net (10.24.253.187) by FRSPVMX412.priv.atos.fr (10.24.220.52) with Microsoft SMTP Server (TLS) id 15.0.1210.3; Thu, 28 Sep 2017 11:26:12 +0200 Received: from FRSPX100.fr01.awl.atosorigin.net ([10.24.253.183]) by frspx302.fr01.awl.atosorigin.net ([10.24.253.187]) with mapi; Thu, 28 Sep 2017 11:26:07 +0200 From: Pavy Philippe To: Julien Rouhaud , Subramaniam C CC: "pgsql-performance@postgresql.org" Date: Thu, 28 Sep 2017 11:26:06 +0200 Subject: Re: Slow query in JDBC Thread-Topic: [PERFORM] Slow query in JDBC Thread-Index: AdM4Oy7HvWLeXV8+SJGXnED+TERHpAAAJ+IQ Message-ID: <5F8F324242D0E14B97060D4D32CD0F5C014910CA886C@FRSPX100.fr01.awl.atosorigin.net> References: In-Reply-To: Accept-Language: fr-FR, en-US Content-Language: fr-FR X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: fr-FR, en-US Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 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 aHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy9jdXJyZW50L3N0YXRp Yy9hdXRvLWV4cGxhaW4uaHRtbA0KDQoNCi0tLS0tTWVzc2FnZSBkJ29yaWdp bmUtLS0tLQ0KRGUgOiBwZ3NxbC1wZXJmb3JtYW5jZS1vd25lckBwb3N0Z3Jl c3FsLm9yZyBbbWFpbHRvOnBnc3FsLXBlcmZvcm1hbmNlLW93bmVyQHBvc3Rn cmVzcWwub3JnXSBEZSBsYSBwYXJ0IGRlIEp1bGllbiBSb3VoYXVkDQpFbnZv ecOpIDogamV1ZGkgMjggc2VwdGVtYnJlIDIwMTcgMTE6MjENCsOAIDogU3Vi cmFtYW5pYW0gQw0KQ2MgOiBwZ3NxbC1wZXJmb3JtYW5jZUBwb3N0Z3Jlc3Fs Lm9yZw0KT2JqZXQgOiBSZTogW1BFUkZPUk1dIFNsb3cgcXVlcnkgaW4gSkRC Qw0KDQpPbiBUaHUsIFNlcCAyOCwgMjAxNyBhdCAxMDo1OCBBTSwgU3VicmFt YW5pYW0gQyA8c3VicmFtYW5pYW0zMTc4NEBnbWFpbC5jb20+IHdyb3RlOg0K PiBJIGNvbmZpZ3VyZWQgY3Vyc29yX3R1cGxlX2ZyYWN0aW9uIHRvIDEgYnV0 IHN0aWxsIEkgYW0gZmFjaW5nIHRoZSBzYW1lDQo+IGlzc3VlLg0KDQpDYW4g eW91IHNob3cgZXhwbGFpbiAoYW5hbHl6ZSwgYnVmZmVycykgb2YgdGhlIHF1 ZXJ5IHdoZW4gcnVuIGZyb20gcHNxbCBhbmQgcnVuIGZyb20gYXBwbGljYXRp b24gKHlvdSBjYW4gdXNlIGF1dG9fZXhwbGFpbiBmb3IgdGhhdCBpZiBuZWVk ZWQsIHNlZSBodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzL2N1cnJl bnQvc3RhdGljL2F1dG8tZXhwbGFpbi5odG1sKS4NCg0KDQotLQ0KU2VudCB2 aWEgcGdzcWwtcGVyZm9ybWFuY2UgbWFpbGluZyBsaXN0IChwZ3NxbC1wZXJm b3JtYW5jZUBwb3N0Z3Jlc3FsLm9yZykNClRvIG1ha2UgY2hhbmdlcyB0byB5 b3VyIHN1YnNjcmlwdGlvbjoNCmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcv bWFpbHByZWYvcGdzcWwtcGVyZm9ybWFuY2UNCg0KISEhKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqKioqKioqKioqKg0KIkNlIG1lc3NhZ2UgZXQg bGVzIHBpw6hjZXMgam9pbnRlcyBzb250IGNvbmZpZGVudGllbHMgZXQgcsOp c2VydsOpcyDDoCBsJ3VzYWdlIGV4Y2x1c2lmIGRlIHNlcyBkZXN0aW5hdGFp cmVzLiBJbCBwZXV0IMOpZ2FsZW1lbnQgw6p0cmUgcHJvdMOpZ8OpIHBhciBs ZSBzZWNyZXQgcHJvZmVzc2lvbm5lbC4gU2kgdm91cyByZWNldmV6IGNlIG1l c3NhZ2UgcGFyIGVycmV1ciwgbWVyY2kgZCdlbiBhdmVydGlyIGltbcOpZGlh dGVtZW50IGwnZXhww6lkaXRldXIgZXQgZGUgbGUgZMOpdHJ1aXJlLiBMJ2lu dMOpZ3JpdMOpIGR1IG1lc3NhZ2UgbmUgcG91dmFudCDDqnRyZSBhc3N1csOp ZSBzdXIgSW50ZXJuZXQsIGxhIHJlc3BvbnNhYmlsaXTDqSBkZSBXb3JsZGxp bmUgbmUgcG91cnJhIMOqdHJlIHJlY2hlcmNow6llIHF1YW50IGF1IGNvbnRl bnUgZGUgY2UgbWVzc2FnZS4gQmllbiBxdWUgbGVzIG1laWxsZXVycyBlZmZv cnRzIHNvaWVudCBmYWl0cyBwb3VyIG1haW50ZW5pciBjZXR0ZSB0cmFuc21p c3Npb24gZXhlbXB0ZSBkZSB0b3V0IHZpcnVzLCBsJ2V4cMOpZGl0ZXVyIG5l IGRvbm5lIGF1Y3VuZSBnYXJhbnRpZSDDoCBjZXQgw6lnYXJkIGV0IHNhIHJl c3BvbnNhYmlsaXTDqSBuZSBzYXVyYWl0IMOqdHJlIHJlY2hlcmNow6llIHBv dXIgdG91dCBkb21tYWdlIHLDqXN1bHRhbnQgZCd1biB2aXJ1cyB0cmFuc21p cy4NCg0KVGhpcyBlLW1haWwgYW5kIHRoZSBkb2N1bWVudHMgYXR0YWNoZWQg YXJlIGNvbmZpZGVudGlhbCBhbmQgaW50ZW5kZWQgc29sZWx5IGZvciB0aGUg YWRkcmVzc2VlOyBpdCBtYXkgYWxzbyBiZSBwcml2aWxlZ2VkLiBJZiB5b3Ug cmVjZWl2ZSB0aGlzIGUtbWFpbCBpbiBlcnJvciwgcGxlYXNlIG5vdGlmeSB0 aGUgc2VuZGVyIGltbWVkaWF0ZWx5IGFuZCBkZXN0cm95IGl0LiBBcyBpdHMg aW50ZWdyaXR5IGNhbm5vdCBiZSBzZWN1cmVkIG9uIHRoZSBJbnRlcm5ldCwg dGhlIFdvcmxkbGluZSBsaWFiaWxpdHkgY2Fubm90IGJlIHRyaWdnZXJlZCBm b3IgdGhlIG1lc3NhZ2UgY29udGVudC4gQWx0aG91Z2ggdGhlIHNlbmRlciBl bmRlYXZvdXJzIHRvIG1haW50YWluIGEgY29tcHV0ZXIgdmlydXMtZnJlZSBu ZXR3b3JrLCB0aGUgc2VuZGVyIGRvZXMgbm90IHdhcnJhbnQgdGhhdCB0aGlz IHRyYW5zbWlzc2lvbiBpcyB2aXJ1cy1mcmVlIGFuZCB3aWxsIG5vdCBiZSBs aWFibGUgZm9yIGFueSBkYW1hZ2VzIHJlc3VsdGluZyBmcm9tIGFueSB2aXJ1 cyB0cmFuc21pdHRlZC4hISEiDQoKLS0gClNlbnQgdmlhIHBnc3FsLXBlcmZv cm1hbmNlIG1haWxpbmcgbGlzdCAocGdzcWwtcGVyZm9ybWFuY2VAcG9zdGdy ZXNxbC5vcmcpClRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNjcmlwdGlv bjoKaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1w ZXJmb3JtYW5jZQo=