From user-return-11165-apmail-drill-user-archive=drill.apache.org@drill.apache.org Tue Jun 2 05:26:20 2020 Return-Path: X-Original-To: apmail-drill-user-archive@www.apache.org Delivered-To: apmail-drill-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by minotaur.apache.org (Postfix) with SMTP id B613019547 for ; Tue, 2 Jun 2020 05:26:19 +0000 (UTC) Received: (qmail 45899 invoked by uid 500); 2 Jun 2020 05:26:18 -0000 Delivered-To: apmail-drill-user-archive@drill.apache.org Received: (qmail 45844 invoked by uid 500); 2 Jun 2020 05:26:17 -0000 Mailing-List: contact user-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@drill.apache.org Delivered-To: mailing list user@drill.apache.org Received: (qmail 45826 invoked by uid 99); 2 Jun 2020 05:26:16 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Jun 2020 05:26:16 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 1396C1A421A for ; Tue, 2 Jun 2020 05:26:16 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.313 X-Spam-Level: X-Spam-Status: No, score=0.313 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=0.2, KAM_DMARC_STATUS=0.01, RCVD_IN_MSPIKE_H4=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001, URI_HEX=0.1] autolearn=disabled Received: from mx1-ec2-va.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id GBuij59k_I9D for ; Tue, 2 Jun 2020 05:26:12 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=158.42.249.11; helo=smtpsalv.upv.es; envelope-from=msole@iti.es; receiver= Received: from smtpsalv.upv.es (smtpsalv.cc.upv.es [158.42.249.11]) by mx1-ec2-va.apache.org (ASF Mail Server at mx1-ec2-va.apache.org) with ESMTPS id DD0B2BB8CA for ; Tue, 2 Jun 2020 05:26:10 +0000 (UTC) Received: from smtpx.upv.es (smtpxv.cc.upv.es [158.42.249.46]) by smtpsalv.upv.es (8.14.7/8.14.7) with ESMTP id 0525Q23S021566 (version=TLSv1/SSLv3 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NO) for ; Tue, 2 Jun 2020 07:26:03 +0200 Received: from smtp.upv.es (smtpv.cc.upv.es [158.42.249.16]) by smtpx.upv.es (8.14.7/8.14.7) with ESMTP id 0525Q2aG011377 for ; Tue, 2 Jun 2020 07:26:02 +0200 Received: from AGENDA2.upvnet.upv.es (agenda2.cc.upv.es [158.42.250.83]) by smtp.upv.es (8.14.7/8.14.7) with ESMTP id 0525Q2kY022142 (version=TLSv1/SSLv3 cipher=ECDHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Tue, 2 Jun 2020 07:26:02 +0200 Received: from AGENDA4.upvnet.upv.es (158.42.250.61) by AGENDA2.upvnet.upv.es (158.42.250.83) with Microsoft SMTP Server (TLS) id 14.3.487.0; Tue, 2 Jun 2020 07:26:02 +0200 Received: from AGENDA3.upvnet.upv.es ([fe80::85a8:9bc7:4edf:d512]) by AGENDA4.upvnet.upv.es ([fe80::f577:23d0:30ec:69ae%13]) with mapi id 14.03.0487.000; Tue, 2 Jun 2020 07:26:02 +0200 From: Marc Sole Fonte To: "user@drill.apache.org" Subject: Re: Excesive Execution Time querying RDBMS Thread-Topic: Excesive Execution Time querying RDBMS Thread-Index: AQHWKd2EUIlArfW5DUWTTiGm3BOanKindQoAgAAQvACAESf+gIAMGZMA Date: Tue, 2 Jun 2020 05:26:02 +0000 Message-ID: References: <3fa13856029b1c8229fe78327490eedf2bd3ebce.camel@iti.es> <8ef3ef5c321698dfbce940e27e71fc391a1cdda8.camel@iti.es> <66acb79d06606734bb0387f663d1c501309bfd6a.camel@iti.es> In-Reply-To: <66acb79d06606734bb0387f663d1c501309bfd6a.camel@iti.es> Accept-Language: es-ES, en-US Content-Language: es-ES X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [80.31.46.139] Content-Type: multipart/alternative; boundary="_000_a6635e1fc00d30a86c8e92aed11f2d6969101ba5camelities_" MIME-Version: 1.0 --_000_a6635e1fc00d30a86c8e92aed11f2d6969101ba5camelities_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SGVsbG8sDQoNCkkgYW0gdXBkYXRpbmcgdGhpcyBhcyBJIGhhdmUgc3RpbGwgbm90IHJlY2VpdmVk IGFueSBhbnN3ZXIuIEkgaG9wZSB5b3UgY2FuIGhlbHAgbWUuDQoNClRoYW5rIHlvdSB2ZXJ5IG11 Y2gsDQpNYXJjDQoNCk9uIE1vbiwgMjAyMC0wNS0yNSBhdCAxNDozOSArMDIwMCwgTWFyYyBTb2zD qSB3cm90ZToNCkhlbGxvLA0KDQpTbyB3ZSBmaW5hbGx5IHVwZGF0ZWQgdG8gMS4xNy4wIGFuZCBp dCBpbXByb3ZlZCBhIGxvdCBvdXIgdGltZXMgYnV0IGEgbmV3IHByb2JsZW0gYXBwZWFyZWQuIEl0 IGxvb2tzIGxpa2UgaXQgaXMgcmVsYXRlZCB0byBsaW1pdHMuDQoNCklmIHdlIGV4ZWN1dGUgYSBz aW1wbGUgcXVlcnkgaXQgbm93IHRha2VzIGEgbG90IG9mIGxlc3MgdGltZS4gSXQgaXMgYWNjZXB0 YWJsZSBhbmQgaXQgaXMgbm90IGEgcHJvYmxlbSBhbnltb3JlLiBIb3dldmVyLCBpZiB5b3UgdXNl IGEgbGltaXQgaW4gdGhhdCBxdWVyeSAoKzQpIGl0IHN0YXJ0cyB0byB0YWtlIGEgbG90IG9mIGV4 ZWN1dGlvbiB0aW1lLiBJdCBpcyBqdXN0IHRoYXQgd2VpcmQuIEl0IGxvb2tzIGxpa2UgaWYgd2Ug dXNlIGJpZyBsaW1pdHMgKGxpa2UgMTAwMDApIHRoZW4gdGltZXMgYXJlIGFjY2VwdGFibGUgYWdh aW4uIEhlcmUgaXMgYSB0YWJsZToNCg0KVGltZSAgICBVc2VyICAgIFF1ZXJ5ICAgU3RhdGUgICBE dXJhdGlvbiAgICAgICAgRm9yZW1hbg0KMDUvMjUvMjAyMCAxMToxNjo1MCAgICAgYW5vbnltb3Vz ICAgICAgIFNFTEVDVCAqIEZST00gZGJfc2NvdHRfY2VudHJpYS5wdWJsaWMuY2VudHJpYV9yYXcg TElNSVQgMTAwMDA8aHR0cHM6Ly9wcm9kLTItNC1kcmlsbC1hcGktMTU4OTk3NzAwOTgwNi5pdGlw cm9kLnNsYXA1My5pdGkuZXMvcHJvZmlsZXMvMjEzNDU2ZGQtMDdiNi1mYTAxLWUyYmQtMzg2Y2Y1 YTFiYzRjPiAgICAgU3VjY2VlZGVkICAgICAgIDEuOTkwIHNlYyAgICAgICA2NjY5YTU1MjM2ZGYN CjA1LzI1LzIwMjAgMTE6MTU6MzEgICAgIGFub255bW91cyAgICAgICBTRUxFQ1QgKiBGUk9NIGRi X3Njb3R0X2NlbnRyaWEucHVibGljLmNlbnRyaWFfcmF3IExJTUlUIDQ8aHR0cHM6Ly9wcm9kLTIt NC1kcmlsbC1hcGktMTU4OTk3NzAwOTgwNi5pdGlwcm9kLnNsYXA1My5pdGkuZXMvcHJvZmlsZXMv MjEzNDU3MmMtMTJmNy0zNjQ0LTgzOTEtY2RlNmViZDQzOGM2PiBTdWNjZWVkZWQgICAgICAgMjku OTk5IHNlYyAgICAgIDY2NjlhNTUyMzZkZg0KMDUvMjUvMjAyMCAxMToxNToyMiAgICAgYW5vbnlt b3VzICAgICAgIFNFTEVDVCAqIEZST00gZGJfc2NvdHRfY2VudHJpYS5wdWJsaWMuY2VudHJpYV9y YXcgTElNSVQgMzxodHRwczovL3Byb2QtMi00LWRyaWxsLWFwaS0xNTg5OTc3MDA5ODA2Lml0aXBy b2Quc2xhcDUzLml0aS5lcy9wcm9maWxlcy8yMTM0NTczNS0xMTIyLWU2NTMtZDIzMi02YjFlMzkw M2VhYjU+IFN1Y2NlZWRlZCAgICAgICAxLjMzMiBzZWMgICAgICAgNjY2OWE1NTIzNmRmDQowNS8y NS8yMDIwIDExOjE0OjQxICAgICBhbm9ueW1vdXMgICAgICAgU0VMRUNUICogRlJPTSBkYl9zY290 dF9jZW50cmlhLnB1YmxpYy5jZW50cmlhX3JhdyBMSU1JVCA0PGh0dHBzOi8vcHJvZC0yLTQtZHJp bGwtYXBpLTE1ODk5NzcwMDk4MDYuaXRpcHJvZC5zbGFwNTMuaXRpLmVzL3Byb2ZpbGVzLzIxMzQ1 NzVkLTg4N2ItMTIwMi0xYTEzLTFlYjhjZjNlNmE4ZT4gU3VjY2VlZGVkICAgICAgIDI5LjYxMiBz ZWMgICAgICA2NjY5YTU1MjM2ZGYNCjA1LzI1LzIwMjAgMTE6MTM6NTAgICAgIGFub255bW91cyAg ICAgICBTRUxFQ1QgKiBGUk9NIGRiX3Njb3R0X2NlbnRyaWEucHVibGljLmNlbnRyaWFfcmF3IExJ TUlUIDU8aHR0cHM6Ly9wcm9kLTItNC1kcmlsbC1hcGktMTU4OTk3NzAwOTgwNi5pdGlwcm9kLnNs YXA1My5pdGkuZXMvcHJvZmlsZXMvMjEzNDU3OTAtZjRiYi00YTUxLTE0YjUtYzY1MDM1N2I1YTdm PiBTdWNjZWVkZWQgICAgICAgMzAuNDQ2IHNlYyAgICAgIDY2NjlhNTUyMzZkZg0KMDUvMjUvMjAy MCAxMToxMjo1OCAgICAgYW5vbnltb3VzICAgICAgIFNFTEVDVCAqIEZST00gZGJfc2NvdHRfY2Vu dHJpYS5wdWJsaWMuY2VudHJpYV9yYXcgTElNSVQgNzxodHRwczovL3Byb2QtMi00LWRyaWxsLWFw aS0xNTg5OTc3MDA5ODA2Lml0aXByb2Quc2xhcDUzLml0aS5lcy9wcm9maWxlcy8yMTM0NTdjNS03 ZDNmLTQ4MDctZjg5YS0xNmE4MWVkODBlMTc+IFN1Y2NlZWRlZCAgICAgICAzMC4zNDMgc2VjICAg ICAgNjY2OWE1NTIzNmRmDQowNS8yNS8yMDIwIDExOjEyOjQzICAgICBhbm9ueW1vdXMgICAgICAg U0VMRUNUICogRlJPTSBkYl9zY290dF9jZW50cmlhLnB1YmxpYy5jZW50cmlhX3JhdyBMSU1JVCAz PGh0dHBzOi8vcHJvZC0yLTQtZHJpbGwtYXBpLTE1ODk5NzcwMDk4MDYuaXRpcHJvZC5zbGFwNTMu aXRpLmVzL3Byb2ZpbGVzLzIxMzQ1N2QzLWM0NGQtOWM5Zi1kZjY1LTg0NTc0MzZiNzIxYT4gU3Vj Y2VlZGVkICAgICAgIDAuNTE5IHNlYyAgICAgICA2NjY5YTU1MjM2ZGYNCjA1LzI1LzIwMjAgMTE6 MTI6MjMgICAgIGFub255bW91cyAgICAgICBTRUxFQ1QgKiBGUk9NIGRiX3Njb3R0X2NlbnRyaWEu cHVibGljLmNlbnRyaWFfcmF3IExJTUlUIDI8aHR0cHM6Ly9wcm9kLTItNC1kcmlsbC1hcGktMTU4 OTk3NzAwOTgwNi5pdGlwcm9kLnNsYXA1My5pdGkuZXMvcHJvZmlsZXMvMjEzNDU3ZTctZDcxMy03 ZTk4LWM4MjgtNmFhOWQ3NjVlMWFlPiBTdWNjZWVkZWQgICAgICAgMC41Mjcgc2VjICAgICAgIDY2 NjlhNTUyMzZkZg0KMDUvMjUvMjAyMCAxMToxMTo1NSAgICAgYW5vbnltb3VzICAgICAgIFNFTEVD VCAqIEZST00gZGJfc2NvdHRfY2VudHJpYS5wdWJsaWMuY2VudHJpYV9yYXcgTElNSVQgMTxodHRw czovL3Byb2QtMi00LWRyaWxsLWFwaS0xNTg5OTc3MDA5ODA2Lml0aXByb2Quc2xhcDUzLml0aS5l cy9wcm9maWxlcy8yMTM0NTgwMy1jMzgxLWUxODgtZDRhNS01NjEyNjNlZTI3YzA+IFN1Y2NlZWRl ZCAgICAgICAwLjYyMiBzZWMgICAgICAgNjY2OWE1NTIzNmRmDQowNS8yNS8yMDIwIDExOjExOjEw ICAgICBhbm9ueW1vdXMgICAgICAgU0VMRUNUICogRlJPTSBkYl9zY290dF9jZW50cmlhLnB1Ymxp Yy5jZW50cmlhX3JhdyBMSU1JVCAxMDxodHRwczovL3Byb2QtMi00LWRyaWxsLWFwaS0xNTg5OTc3 MDA5ODA2Lml0aXByb2Quc2xhcDUzLml0aS5lcy9wcm9maWxlcy8yMTM0NTgzMC04MDdlLTJmYmYt Mjk2Ny0wMzliYjczY2FiZGQ+ICAgICAgICBTdWNjZWVkZWQgICAgICAgMzIuMTExIHNlYyAgICAg IDY2NjlhNTUyMzZkZg0KDQpJdCBqdXN0IGRvZXMgbm90IG1ha2Ugc2Vuc2UgZm9yIHVzLiBXaGVu IGR1cmF0aW9uIGlzIGJpZyB3ZSBhcmUgdGFsa2luZyBhYm91dCBleGVjdXRpb24gdGltZS4gRGF0 YWJhc2Ugd29ya3MgY29ycmVjdGx5IGlmIGFjY2VkZXNlZCBmcm9tIHdpdGhvdXQgbWFraW5nIHVz ZSBvZiBEcmlsbC4NCg0KQW55IGlkZWEgYWJvdXQgaG93IHRvIHNvbHZlIGl0Pw0KDQpUaGFuayB5 b3UgYWdhaW4sDQpNYXJjDQoNCk9uIFRodSwgMjAyMC0wNS0xNCBhdCAxNDozOSArMDAwMCwgTWFy YyBTb2xlIEZvbnRlIHdyb3RlOg0KSGVsbG8sDQoNClN0aWxsIHVuYWJsZSB0byBhbnN3ZXIgdG8g eW91ciBhc253ZXJzLiBJIHRoaW5rIEkgYWxyZWFkeSBmaXhlZCBpdCBmb3IgdGhlIGZvbGxvd2lu ZyBvbmVzLg0KDQpJIGFtIGdvaW5nIHRvIHRyeSB0byB1c2UgMS4xNy4wLCBpdCBpcyBub3QgZXhh Y3RseSBlYXN5IGZvciB1cywgYXMgaXQgaXMgcGFydCBvZiBhIGJpZ2dlciBwcm9qZWN0LCBidXQg SSBjYW4gdHJ5Lg0KDQpBbnl0aGluZyBlbHNlIEkgY2FuIGhhdmUgaW4gbWluZCB0byBjaGVjaz8g SSBoYXZlIHNlZW4gdGhlcmUgYXJlIGEgbG90IG9mIHR1bm5pbmcgb3B0aW9ucy4NCg0KVGhhbmsg eW91LA0KTWFyYw0KDQpPbiBUaHUsIDIwMjAtMDUtMTQgYXQgMTU6MzkgKzAyMDAsIE1hcmMgU29s w6kgd3JvdGU6DQpIZWxsbywNCg0KSSBoYXZlIHNlZW4gYW4gYW5zd2VyIGJ1dCBJIGFtIG5vdCBh YmxlIHRvIGFuc3dlciBpdCBkaXJlY3RseS4gVGhlIERyaWxsIHZlcnNpb24gSSBhbSB1c2luZyBp cyAxLjE2LjAuDQoNClRoZSB0cmFuc2NyaXB0IGZvciB0aGUgaW1hZ2VzIGlzIG1vcmUgb3IgbGVz cyB0aGUgZm9sbG93aW5nIG9uZToNCg0KUGxhbm5pbmcgUXVldWVkIEV4ZWN1dGlvbiBUb3RhbA0K MC4yMTkgc2VjIDAuMDcwIHNlYyAxNS4xNjYgc2VjIDE1LjQ1NSBzZWMNCjAuMTg2IHNlYyAwLjAz NiBzZWMgMTYuOTQ0IHNlYyAxNy4xNjYgc2VjDQoNCklmIHlvdSBuZWVkIG1vcmUgZGF0YSwgZmVl bCBmcmVlIHRvIGFzayBmb3IgaXQuIFRoYW5rIHlvdSBmb3IgeW91ciBoZWxwLg0KDQpNYXJjDQoN Cg0KT24gVGh1LCAyMDIwLTA1LTE0IGF0IDEyOjUwICswMjAwLCBNYXJjIFNvbMOpIHdyb3RlOg0K SGVsbG8sDQoNCkZpcnN0IG9mIGFsbCwgSSBob3BlIHlvdSBhbmQgeW91ciBmYW1pbGllcyBhcmUg YWxsIHNhZmUgYW5kIGhlYWx0aHkuIEFsc28sIHRoYW5rIHlvdSBpbiBhZHZhbmNlIGZvciB5b3Vy IHN1cHBvcnQuDQoNCkkgaGF2ZSBhIHByb2JsZW0gd2l0aCBBcGFjaGUgRHJpbGwgY29uZWN0ZWQg dG8gQ29ja3JvYWNoREIgKFBvc3RncmVTUUwpIHVzaW5nIHRoZSBSREJNUyBTdG9yYWdlIFBsdWdp bi4gSXQgd29ya3MsIGJ1dCBpdCBpcyBleHRyZW1lbHkgc2xvdy4gTXkgZXhwZXJpZW5jZSB3aXRo IERyaWxsIGhhcyBzaG93ZWQgbWUgYSBsb3Qgb2Ygc2NlbmFyaW9zIHdoZXJlIHRoZSBmaXJzdCBx dWVyeSBpcyBzbG93LCBkdWUgdG8gcGxhbmlmaWNhdGlvbiwgYnV0IHRoZSBuZXh0IG9uZXMgYXJl IGFjY2VwdGFibGUsIGFzc3VtaW5nIHRoZSB0aW1lIGNvbnN1bWVkIGJ5IHRoZSBtYW4gaW4gdGhl IG1pZGRsZS4gSG93ZXZlciwgdGhpcyBkb2VzIG5vdCBzZWVtIG5vcm1hbCBhdCBhbGwuDQoNClJ1 bm5pbmcgYSBzbWFsbCBhbmQgc2ltcGxlIHF1ZXJ5IGxpa2UgdGhpcyBvbmU6IFNFTEVDVCAqIEZS T00gZGJfc2NvdHRfY2VudHJpYS5wdWJsaWMuY2VudHJpYV9yYXcgTElNSVQgMSwgZXhlY3V0aW9u IHRpbWVzIGFyZSBjb21wbGV0ZWx5IG92ZXIgdGhlIGxpbWl0LiBJdCB0YWtlcyBhYm91dCAxNSBz ZWNvbmRzIG9mIEV4ZWN1dGlvbiBUaW1lLiBCb3RoIEFwYWNoZSBEcmlsbCBhbmQgdGhlIGRhdGFi YXNlIGFyZSBpbiB0aGUgc2FtZSBuZXR3b3JrLCBhbmQgYSBxdWVyeSBmcm9tIHRlcm1pbmFsIGZy b20gdGhlIHNhbWUgdGFrZXMgb25seSBzb21lIG1pbGxpc2Vjb25kcy4gV2hlcmUgaXMgdGhlIHBy b2JsZW0/IFdoYXQgY2FuIEkgZG8gdG8gaW1wcm92ZSB0aGF0IHRpbWU/DQoNCkhlcmUgYXJlIHNv bWUgcGljdHVyZXMgd2l0aCBleGFtcGxlczoNCg0KW2NpZDo5N2ViMmVhMDk3NzM1MGNjM2NhODU4 M2RiMDMxYzJkYTljMzMyYzMyLmNhbWVsQGl0aS5lc10NCg0KW2NpZDo3NWQ0NjYyNmI0OTYxYWFj ZTc3ZjEzNjMyNTM5MWE4ZmI3MDAyZDA0LmNhbWVsQGl0aS5lc10NCg0KVGhhbmsgeW91IHZlcnkg bXVjaCBmb3IgeW91ciBoZWxwLCBJIGhvcGUgeW91IGNhbiBoZWxwIG1lLg0KDQpNYXJjDQo= --_000_a6635e1fc00d30a86c8e92aed11f2d6969101ba5camelities_--