X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id ED95DD1B8A9 for ; Fri, 29 Aug 2003 21:00:22 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 58878-10 for ; Fri, 29 Aug 2003 17:59:51 -0300 (ADT) Received: from host2.hostseguro.com (unknown [200.198.188.133]) by svr1.postgresql.org (Postfix) with ESMTP id 863CED1B8EE for ; Fri, 29 Aug 2003 17:59:47 -0300 (ADT) Received: from cpanel by host2.hostseguro.com with local (Exim 4.20) id 19sqL1-0008EW-Np for pgsql-performance@postgresql.org; Fri, 29 Aug 2003 17:59:19 -0300 Received: from 200.180.189.138 ([200.180.189.138]) by sistemica.info (IMP) with HTTP for ; Fri, 29 Aug 2003 17:59:19 -0300 Message-ID: <1062190759.3f4fbea7aae8c@sistemica.info> Date: Fri, 29 Aug 2003 17:59:19 -0300 From: Rhaoni Chiu Pereira To: PostgreSQL Performance Subject: SQL performance problems MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="-MOQ10621907597c83580e1a1a0b1ef30a4fe538606e93" User-Agent: Internet Messaging Program (IMP) 3.2.1 X-Originating-IP: 200.180.189.138 X-MailScanner-Information: Verificado pelo McAfee VirusScan / Scanned by McAfee VirusScan X-MailScanner: Nao infectado / Found to be clean X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - host2.hostseguro.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [32001 32001] / [47 12] X-AntiAbuse: Sender Address Domain - sistemica.info X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/512 X-Sequence-Number: 3328 This message is in MIME format. ---MOQ10621907597c83580e1a1a0b1ef30a4fe538606e93 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Hi List, I still have performance problems with this sql: SELECT /*+ */ ftnfco00.estado_cliente , ftcofi00.grupo_faturamento , SUM( DECODE( ftcofi00.atual_fatura, '-', -(NVL(ftnfpr00.qtde_duzias,0)), '+', NVL(ftnfpr00.qtde_duzias,0), 0) ) , SUM( DECODE( ftcofi00.atual_fatura, '-', -(NVL(ftnfpr00.vlr_liquido,0)), '+', NVL(ftnfpr00.vlr_liquido,0), 0) ) , ftprod00.tipo_cadastro||ftprod00.codigo_produto , ftprod00.descricao_produto , DIVIDE( SUM( DECODE( ftcofi00.atual_fatura, '-', -(NVL(ftnfpr00.vlr_liquido,0)), '+', NVL(ftnfpr00.vlr_liquido,0), 0)*ftnfpr00.margem_comercial ), SUM( DECODE( ftcofi00.atual_fatura, '-', -(NVL(ftnfpr00.vlr_liquido,0)), '+', NVL(ftnfpr00.vlr_liquido,0), 0)) ) , SUM( DECODE( ftcofi00.nf_prodgratis, 'S', NVL(ftnfpr00.qtde_duzias,0), 0 ) ) , SUM( DECODE( ftcofi00.nf_prodgratis, 'S', NVL(ftnfpr00.vlr_liquido,0), 0 ) ) FROM ftprod00 , ftnfco00 , ftcgma00 , ftcgca00 , ftspro00 , ftclcr00 , gsames00 , ftcofi00 , ftrepr00 , gsesta00 , ftsupv00 , ftgrep00 , ftclgr00 , ftband00 , fttcli00 , ftredc00 , ftnfpr00 WHERE ftnfco00.emp = 909 AND ftnfpr00.fil IN ('101') AND ftnfco00.situacao_nf = 'N' AND TO_CHAR(ftnfco00.data_emissao,'YYYYMM') >= '200208' AND TO_CHAR(ftnfco00.data_emissao,'YYYYMM') <= '200303' AND ftcofi00.grupo_faturamento >= '01' AND (ftcofi00.atual_fatura IN ('+','-') OR ftcofi00.nf_prodgratis = 'S') AND ftcgma00.emp = ftprod00.emp AND ftcgma00.fil = ftprod00.fil AND ftcgma00.codigo = ftprod00.cla_marca AND ftcgca00.emp = ftprod00.emp AND ftcgca00.fil = ftprod00.fil AND ftcgca00.codigo = ftprod00.cla_categoria AND ftspro00.emp = ftprod00.emp AND ftspro00.fil = ftprod00.fil AND ftspro00.codigo = ftprod00.situacao AND ftclcr00.emp = ftnfco00.emp AND ftclcr00.fil = ftnfco00.empfil AND ftclcr00.tipo_cadastro = ftnfco00.tipo_cad_clicre AND ftclcr00.codigo = ftnfco00.cod_cliente AND gsames00.ano_mes = TO_CHAR(ftnfco00.data_emissao,'YYYYMM') AND ftcofi00.emp = ftnfco00.emp AND ftcofi00.fil = ftnfco00.empfil AND ftcofi00.codigo_fiscal = ftnfco00.cod_fiscal AND ftrepr00.emp = ftnfco00.emp AND ftrepr00.fil = ftnfco00.empfil AND ftrepr00.codigo_repr = ftnfco00.cod_repres AND gsesta00.estado_sigla = ftnfco00.estado_cliente AND ftsupv00.emp = ftrepr00.emp AND ftsupv00.fil = ftrepr00.fil AND ftsupv00.codigo_supervisor = ftrepr00.codigo_supervisor AND ftgrep00.emp = ftrepr00.emp AND ftgrep00.fil = ftrepr00.fil AND ftgrep00.codigo_grupo_rep = ftrepr00.codigo_grupo_rep AND ftclgr00.emp = ftclcr00.emp AND ftclgr00.fil = ftclcr00.fil AND ftclgr00.codigo = ftclcr00.codigo_grupo_cliente AND ftband00.emp = ftclcr00.emp AND ftband00.fil = ftclcr00.fil AND ftband00.codigo = ftclcr00.bandeira_cliente AND fttcli00.emp = ftclcr00.emp AND fttcli00.fil = ftclcr00.fil AND fttcli00.cod_tipocliente = ftclcr00.codigo_tipo_cliente AND ftredc00.emp = ftclcr00.emp AND ftredc00.fil = ftclcr00.fil AND ftredc00.tipo_contribuinte = ftclcr00.tipo_contribuinte AND ftredc00.codigo_rede = ftclcr00.codigo_rede AND gsesta00.estado_sigla = ftclcr00.emp_estado AND ftnfco00.emp = ftnfpr00.emp AND ftnfco00.fil = ftnfpr00.fil AND ftnfco00.nota_fiscal = ftnfpr00.nota_fiscal AND ftnfco00.serie = ftnfpr00.serie AND ftnfco00.data_emissao = ftnfpr00.data_emissao AND ftprod00.emp = ftnfpr00.emp AND ftprod00.fil = ftnfpr00.empfil AND ftprod00.tipo_cadastro = ftnfpr00.tipo_cad_promat AND ftprod00.codigo_produto= ftnfpr00.cod_produto GROUP BY ftnfco00.estado_cliente , ftcofi00.grupo_faturamento , ftprod00.tipo_cadastro||ftprod00.codigo_produto , ftprod00.descricao_produto I have created some oracle function in the database 'cuz I want the same alication to use both Oracle or PostgreSQL without changing any source. atached follow tha explain analyze for this query and my postgresql.conf. I still searching a way to make it faster. I've tried to change a lot of variables values like sort_mem, effective_cache_size, fsync, ... I change the machine box from a Pentium III 1Ghz with 256 RAM to a P4 1.7 with 512 RAM DDR. I don't know what else to do ! Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122 ---MOQ10621907597c83580e1a1a0b1ef30a4fe538606e93 Content-Type: application/octet-stream; name="postgresql.conf" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="postgresql.conf" IwojIFBvc3RncmVTUUwgY29uZmlndXJhdGlvbiBmaWxlCiMgLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0KIwojIFRoaXMgZmlsZSBjb25zaXN0cyBv ZiBsaW5lcyBvZiB0aGUgZm9ybToKIwojICAgbmFtZSA9IHZhbHVlCiMKIyAo VGhlICc9JyBpcyBvcHRpb25hbC4pIFdoaXRlIHNwYWNlIG1heSBiZSB1c2Vk LiBDb21tZW50cyBhcmUgaW50cm9kdWNlZAojIHdpdGggJyMnIGFueXdoZXJl IG9uIGEgbGluZS4gVGhlIGNvbXBsZXRlIGxpc3Qgb2Ygb3B0aW9uIG5hbWVz IGFuZAojIGFsbG93ZWQgdmFsdWVzIGNhbiBiZSBmb3VuZCBpbiB0aGUgUG9z dGdyZVNRTCBkb2N1bWVudGF0aW9uLiBUaGUKIyBjb21tZW50ZWQtb3V0IHNl dHRpbmdzIHNob3duIGluIHRoaXMgZmlsZSByZXByZXNlbnQgdGhlIGRlZmF1 bHQgdmFsdWVzLgojCiMgQW55IG9wdGlvbiBjYW4gYWxzbyBiZSBnaXZlbiBh cyBhIGNvbW1hbmQgbGluZSBzd2l0Y2ggdG8gdGhlCiMgcG9zdG1hc3Rlciwg ZS5nLiAncG9zdG1hc3RlciAtYyBsb2dfY29ubmVjdGlvbnM9b24nLiBTb21l IG9wdGlvbnMKIyBjYW4gYmUgY2hhbmdlZCBhdCBydW4tdGltZSB3aXRoIHRo ZSAnU0VUJyBTUUwgY29tbWFuZC4KIwojIFRoaXMgZmlsZSBpcyByZWFkIG9u IHBvc3RtYXN0ZXIgc3RhcnR1cCBhbmQgd2hlbiB0aGUgcG9zdG1hc3Rlcgoj IHJlY2VpdmVzIGEgU0lHSFVQLiBJZiB5b3UgZWRpdCB0aGUgZmlsZSBvbiBh IHJ1bm5pbmcgc3lzdGVtLCB5b3UgaGF2ZSAKIyB0byBTSUdIVVAgdGhlIHBv c3RtYXN0ZXIgZm9yIHRoZSBjaGFuZ2VzIHRvIHRha2UgZWZmZWN0LCBvciB1 c2UgCiMgInBnX2N0bCByZWxvYWQiLgoKCiM9PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT0KCgojCiMJQ29ubmVjdGlvbiBQYXJhbWV0ZXJzCiMKdGNwaXBf c29ja2V0ID0gdHJ1ZQojc3NsID0gZmFsc2UKCm1heF9jb25uZWN0aW9ucyA9 IDMyCiNzdXBlcnVzZXJfcmVzZXJ2ZWRfY29ubmVjdGlvbnMgPSAyCgpwb3J0 ID0gNTQzMiAKI2hvc3RuYW1lX2xvb2t1cCA9IGZhbHNlCiNzaG93X3NvdXJj ZV9wb3J0ID0gZmFsc2UKCiN1bml4X3NvY2tldF9kaXJlY3RvcnkgPSAnJwoj dW5peF9zb2NrZXRfZ3JvdXAgPSAnJwojdW5peF9zb2NrZXRfcGVybWlzc2lv bnMgPSAwNzc3CSMgb2N0YWwKCiN2aXJ0dWFsX2hvc3QgPSAnJwoKI2tyYl9z ZXJ2ZXJfa2V5ZmlsZSA9ICcnCgoKIwojCVNoYXJlZCBNZW1vcnkgU2l6ZQoj CnNoYXJlZF9idWZmZXJzID0gODAwMAkJIyBtaW4gbWF4X2Nvbm5lY3Rpb25z KjIgb3IgMTYsIDhLQiBlYWNoCiNtYXhfZnNtX3JlbGF0aW9ucyA9IDEwMDAJ IyBtaW4gMTAsIGZzbSBpcyBmcmVlIHNwYWNlIG1hcCwgfjQwIGJ5dGVzCiNt YXhfZnNtX3BhZ2VzID0gMTAwMDAJCSMgbWluIDEwMDAsIGZzbSBpcyBmcmVl IHNwYWNlIG1hcCwgfjYgYnl0ZXMKI21heF9sb2Nrc19wZXJfdHJhbnNhY3Rp b24gPSA2NAkjIG1pbiAxMAojd2FsX2J1ZmZlcnMgPSA4CQkjIG1pbiA0LCB0 eXBpY2FsbHkgOEtCIGVhY2gKCiMKIwlOb24tc2hhcmVkIE1lbW9yeSBTaXpl cwojCnNvcnRfbWVtID0gODAwMCAgCQkjIG1pbiA2NCwgc2l6ZSBpbiBLQgoj dmFjdXVtX21lbSA9IDgxOTIJCSMgbWluIDEwMjQsIHNpemUgaW4gS0IKCgoj CiMJV3JpdGUtYWhlYWQgbG9nIChXQUwpCiMKY2hlY2twb2ludF9zZWdtZW50 cyA9IDkgCSMgaW4gbG9nZmlsZSBzZWdtZW50cywgbWluIDEsIDE2TUIgZWFj aAojY2hlY2twb2ludF90aW1lb3V0ID0gMzAwCSMgcmFuZ2UgMzAtMzYwMCwg aW4gc2Vjb25kcwojCiNjb21taXRfZGVsYXkgPSAwCQkjIHJhbmdlIDAtMTAw MDAwLCBpbiBtaWNyb3NlY29uZHMKI2NvbW1pdF9zaWJsaW5ncyA9IDUJCSMg cmFuZ2UgMS0xMDAwCiMKI2ZzeW5jID0gZmFsc2UKI3dhbF9zeW5jX21ldGhv ZCA9IGZzeW5jCSMgdGhlIGRlZmF1bHQgdmFyaWVzIGFjcm9zcyBwbGF0Zm9y bXM6CiMJCQkJIyBmc3luYywgZmRhdGFzeW5jLCBvcGVuX3N5bmMsIG9yIG9w ZW5fZGF0YXN5bmMKI3dhbF9kZWJ1ZyA9IDAJCQkjIHJhbmdlIDAtMTYKCgoj CiMJT3B0aW1pemVyIFBhcmFtZXRlcnMKIwplbmFibGVfc2Vxc2NhbiA9IGZh bHNlCmVuYWJsZV9pbmRleHNjYW4gPSB0cnVlCmVuYWJsZV90aWRzY2FuID0g dHJ1ZQplbmFibGVfc29ydCA9IHRydWUKZW5hYmxlX25lc3Rsb29wID0gdHJ1 ZQplbmFibGVfbWVyZ2Vqb2luID0gdHJ1ZQplbmFibGVfaGFzaGpvaW4gPSB0 cnVlCgplZmZlY3RpdmVfY2FjaGVfc2l6ZSA9IDE2MDAwCSMgdHlwaWNhbGx5 IDhLQiBlYWNoCiNyYW5kb21fcGFnZV9jb3N0ID0gNAkJIyB1bml0cyBhcmUg b25lIHNlcXVlbnRpYWwgcGFnZSBmZXRjaCBjb3N0CiNjcHVfdHVwbGVfY29z dCA9IDAuMDEJCSMgKHNhbWUpCiNjcHVfaW5kZXhfdHVwbGVfY29zdCA9IDAu MDAxCSMgKHNhbWUpCiNjcHVfb3BlcmF0b3JfY29zdCA9IDAuMDAyNQkjIChz YW1lKQoKZGVmYXVsdF9zdGF0aXN0aWNzX3RhcmdldCA9IDc1MAkjIHJhbmdl IDEtMTAwMAoKIwojCUdFUU8gT3B0aW1pemVyIFBhcmFtZXRlcnMKIwojZ2Vx byA9IHRydWUKI2dlcW9fc2VsZWN0aW9uX2JpYXMgPSAyLjAJIyByYW5nZSAx LjUtMi4wCiNnZXFvX3RocmVzaG9sZCA9IDExCiNnZXFvX3Bvb2xfc2l6ZSA9 IDAJCSMgZGVmYXVsdCBiYXNlZCBvbiB0YWJsZXMgaW4gc3RhdGVtZW50LCAK CQkJCSMgcmFuZ2UgMTI4LTEwMjQKI2dlcW9fZWZmb3J0ID0gMQojZ2Vxb19n ZW5lcmF0aW9ucyA9IDAKI2dlcW9fcmFuZG9tX3NlZWQgPSAtMQkJIyBhdXRv LWNvbXB1dGUgc2VlZAoKCiMKIwlNZXNzYWdlIGRpc3BsYXkKIwojc2VydmVy X21pbl9tZXNzYWdlcyA9IG5vdGljZQkjIFZhbHVlcywgaW4gb3JkZXIgb2Yg ZGVjcmVhc2luZyBkZXRhaWw6CgkJCQkjICAgZGVidWc1LCBkZWJ1ZzQsIGRl YnVnMywgZGVidWcyLCBkZWJ1ZzEsCgkJCQkjICAgaW5mbywgbm90aWNlLCB3 YXJuaW5nLCBlcnJvciwgbG9nLCBmYXRhbCwKCQkJCSMgICBwYW5pYwojY2xp ZW50X21pbl9tZXNzYWdlcyA9IG5vdGljZQkjIFZhbHVlcywgaW4gb3JkZXIg b2YgZGVjcmVhc2luZyBkZXRhaWw6CgkJCQkjICAgZGVidWc1LCBkZWJ1ZzQs IGRlYnVnMywgZGVidWcyLCBkZWJ1ZzEsCgkJCQkjICAgbG9nLCBpbmZvLCBu b3RpY2UsIHdhcm5pbmcsIGVycm9yCiNzaWxlbnRfbW9kZSA9IGZhbHNlCgoj bG9nX2Nvbm5lY3Rpb25zID0gZmFsc2UKI2xvZ19waWQgPSBmYWxzZQojbG9n X3N0YXRlbWVudCA9IGZhbHNlCiNsb2dfZHVyYXRpb24gPSBmYWxzZQpsb2df dGltZXN0YW1wID0gdHJ1ZQoKI2xvZ19taW5fZXJyb3Jfc3RhdGVtZW50ID0g ZXJyb3IgIyBWYWx1ZXMgaW4gb3JkZXIgb2YgaW5jcmVhc2luZyBzZXZlcml0 eToKCQkJCSAjICAgZGVidWc1LCBkZWJ1ZzQsIGRlYnVnMywgZGVidWcyLCBk ZWJ1ZzEsCgkJCQkgIyAgIGluZm8sIG5vdGljZSwgd2FybmluZywgZXJyb3Is IHBhbmljKG9mZikKCiNkZWJ1Z19wcmludF9wYXJzZSA9IGZhbHNlCiNkZWJ1 Z19wcmludF9yZXdyaXR0ZW4gPSBmYWxzZQojZGVidWdfcHJpbnRfcGxhbiA9 IGZhbHNlCiNkZWJ1Z19wcmV0dHlfcHJpbnQgPSBmYWxzZQoKI2V4cGxhaW5f cHJldHR5X3ByaW50ID0gdHJ1ZQoKIyByZXF1aXJlcyBVU0VfQVNTRVJUX0NI RUNLSU5HCiNkZWJ1Z19hc3NlcnRpb25zID0gdHJ1ZQoKCiMKIwlTeXNsb2cK Iwojc3lzbG9nID0gMAkJCSMgcmFuZ2UgMC0yCiNzeXNsb2dfZmFjaWxpdHkg PSAnTE9DQUwwJwojc3lzbG9nX2lkZW50ID0gJ3Bvc3RncmVzJwoKCiMKIwlT dGF0aXN0aWNzCiMKI3Nob3dfcGFyc2VyX3N0YXRzID0gZmFsc2UKI3Nob3df cGxhbm5lcl9zdGF0cyA9IGZhbHNlCiNzaG93X2V4ZWN1dG9yX3N0YXRzID0g ZmFsc2UKI3Nob3dfc3RhdGVtZW50X3N0YXRzID0gZmFsc2UKCiMgcmVxdWly ZXMgQlRSRUVfQlVJTERfU1RBVFMKI3Nob3dfYnRyZWVfYnVpbGRfc3RhdHMg PSBmYWxzZQoKCiMKIwlBY2Nlc3Mgc3RhdGlzdGljcyBjb2xsZWN0aW9uCiMK I3N0YXRzX3N0YXJ0X2NvbGxlY3RvciA9IHRydWUKI3N0YXRzX3Jlc2V0X29u X3NlcnZlcl9zdGFydCA9IHRydWUKI3N0YXRzX2NvbW1hbmRfc3RyaW5nID0g ZmFsc2UKI3N0YXRzX3Jvd19sZXZlbCA9IGZhbHNlCiNzdGF0c19ibG9ja19s ZXZlbCA9IGZhbHNlCgoKIwojCUxvY2sgVHJhY2luZwojCiN0cmFjZV9ub3Rp ZnkgPSBmYWxzZQoKIyByZXF1aXJlcyBMT0NLX0RFQlVHCiN0cmFjZV9sb2Nr cyA9IGZhbHNlCiN0cmFjZV91c2VybG9ja3MgPSBmYWxzZQojdHJhY2VfbHds b2NrcyA9IGZhbHNlCiNkZWJ1Z19kZWFkbG9ja3MgPSBmYWxzZQojdHJhY2Vf bG9ja19vaWRtaW4gPSAxNjM4NAojdHJhY2VfbG9ja190YWJsZSA9IDAKCgoj CiMJTWlzYwojCiNhdXRvY29tbWl0ID0gdHJ1ZQojZHluYW1pY19saWJyYXJ5 X3BhdGggPSAnJGxpYmRpcicKc2VhcmNoX3BhdGggPSAndmVuZGFzJwojZGF0 ZXN0eWxlID0gJ2lzbywgdXMnCiN0aW1lem9uZSA9IHVua25vd24JCSMgYWN0 dWFsbHksIGRlZmF1bHRzIHRvIFRaIGVudmlyb25tZW50IHNldHRpbmcKI2F1 c3RyYWxpYW5fdGltZXpvbmVzID0gZmFsc2UKI2NsaWVudF9lbmNvZGluZyA9 IHNxbF9hc2NpaQkjIGFjdHVhbGx5LCBkZWZhdWx0cyB0byBkYXRhYmFzZSBl bmNvZGluZwojYXV0aGVudGljYXRpb25fdGltZW91dCA9IDYwCSMgMS02MDAs IGluIHNlY29uZHMKI2RlYWRsb2NrX3RpbWVvdXQgPSAxMDAwCSMgaW4gbWls bGlzZWNvbmRzCiNkZWZhdWx0X3RyYW5zYWN0aW9uX2lzb2xhdGlvbiA9ICdy ZWFkIGNvbW1pdHRlZCcKI21heF9leHByX2RlcHRoID0gMTAwMDAJCSMgbWlu IDEwCiNtYXhfZmlsZXNfcGVyX3Byb2Nlc3MgPSAxMDAwCSMgbWluIDI1CiNw YXNzd29yZF9lbmNyeXB0aW9uID0gdHJ1ZQojc3FsX2luaGVyaXRhbmNlID0g dHJ1ZQojdHJhbnNmb3JtX251bGxfZXF1YWxzID0gZmFsc2UKI3N0YXRlbWVu dF90aW1lb3V0ID0gMAkJIyAwIGlzIGRpc2FibGVkLCBpbiBtaWxsaXNlY29u ZHMKI2RiX3VzZXJfbmFtZXNwYWNlID0gZmFsc2UKIAoKCiMKIwlMb2NhbGUg c2V0dGluZ3MKIwojIChpbml0aWFsaXplZCBieSBpbml0ZGIgLS0gbWF5IGJl IGNoYW5nZWQpCkxDX01FU1NBR0VTID0gJ2VuX1VTLlVURi04JwpMQ19NT05F VEFSWSA9ICdlbl9VUy5VVEYtOCcKTENfTlVNRVJJQyA9ICdlbl9VUy5VVEYt OCcKTENfVElNRSA9ICdlbl9VUy5VVEYtOCcK ---MOQ10621907597c83580e1a1a0b1ef30a4fe538606e93 Content-Type: application/octet-stream; name="explain2.sql" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="explain2.sql" ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAotLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tCiBBZ2dyZWdhdGUgIChjb3N0PTEwMDAyNjMy OC45OC4uMTAwMDI2MzI5LjAxIHJvd3M9MSB3aWR0aD04MTgpIChhY3R1YWwg dGltZT0xMDYwOTIuNDguLjExMjIzOC44MCByb3dzPTM3NiBsb29wcz0xKQog ICAtPiAgR3JvdXAgIChjb3N0PTEwMDAyNjMyOC45OC4uMTAwMDI2MzI4Ljk5 IHJvd3M9MSB3aWR0aD04MTgpIChhY3R1YWwgdGltZT0xMDYwNTAuMDYuLjEw NjY2MS44MiByb3dzPTI0MjI2IGxvb3BzPTEpCiAgICAgICAgIC0+ICBTb3J0 ICAoY29zdD0xMDAwMjYzMjguOTguLjEwMDAyNjMyOC45OCByb3dzPTEgd2lk dGg9ODE4KSAoYWN0dWFsIHRpbWU9MTA2MDUwLjAzLi4xMDYwOTQuOTkgcm93 cz0yNDIyNiBsb29wcz0xKQogICAgICAgICAgICAgICBTb3J0IEtleTogZnRu ZmNvMDAuZXN0YWRvX2NsaWVudGUsIGZ0Y29maTAwLmdydXBvX2ZhdHVyYW1l bnRvLCAoKGZ0cHJvZDAwLnRpcG9fY2FkYXN0cm8pOjp0ZXh0IHx8IChmdHBy b2QwMC5jb2RpZ29fcHJvZHV0byk6OnRleHQpLCBmdHByb2QwMC5kZXNjcmlj YW9fcHJvZHV0bwogICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChj b3N0PTEwMDAyNTczNS41MS4uMTAwMDI2MzI4Ljk3IHJvd3M9MSB3aWR0aD04 MTgpIChhY3R1YWwgdGltZT05NDk3OS43Mi4uMTA0MDMzLjc4IHJvd3M9MjQy MjYgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgSm9pbiBGaWx0ZXI6 ICgoImlubmVyIi5maWwgPSAib3V0ZXIiLmZpbCkgQU5EICgiaW5uZXIiLmVt cCA9ICJvdXRlciIuZW1wKSkKICAgICAgICAgICAgICAgICAgICAgLT4gIE5l c3RlZCBMb29wICAoY29zdD0xMDAwMjU3MzUuNTEuLjEwMDAyNjMyNC40NSBy b3dzPTEgd2lkdGg9NzkxKSAoYWN0dWFsIHRpbWU9OTQ5NzEuMDAuLjEwMjQ2 OS4yNiByb3dzPTI0MjI2IGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAg ICAgICAgIEpvaW4gRmlsdGVyOiAoKCJpbm5lciIuZW1wID0gIm91dGVyIi5l bXApIEFORCAoImlubmVyIi5maWwgPSAib3V0ZXIiLmVtcGZpbCkgQU5EICgi aW5uZXIiLmNvZGlnb19zdXBlcnZpc29yID0gIm91dGVyIi5jb2RpZ29fc3Vw ZXJ2aXNvcikpCiAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBOZXN0 ZWQgTG9vcCAgKGNvc3Q9MTAwMDI1NzM1LjUxLi4xMDAwMjYzMTkuNzYgcm93 cz0xIHdpZHRoPTc1OSkgKGFjdHVhbCB0aW1lPTk0OTYyLjM2Li45OTk5MS43 NCByb3dzPTI0MjI2IGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIEpvaW4gRmlsdGVyOiAoImlubmVyIi5lc3RhZG9fc2lnbGEg PSAib3V0ZXIiLmVzdGFkb19jbGllbnRlKQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTEwMDAyNTcz NS41MS4uMTAwMDI2MzE2LjE5IHJvd3M9MSB3aWR0aD03NTMpIChhY3R1YWwg dGltZT05NDk0Ni40My4uOTcxNTcuOTYgcm93cz0yNDIyNiBsb29wcz0xKQog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBKb2luIEZp bHRlcjogKCgiaW5uZXIiLmZpbCA9ICJvdXRlciIuZmlsKSBBTkQgKCJpbm5l ciIuZW1wID0gIm91dGVyIi5lbXApIEFORCAoIm91dGVyIi5jb2RpZ28gPSAi aW5uZXIiLmNsYV9tYXJjYSkpCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGZ0Y2dtYTAwX3Br ZXkgb24gZnRjZ21hMDAgIChjb3N0PTAuMDAuLjQuNjggcm93cz0xIHdpZHRo PTMyKSAoYWN0dWFsIHRpbWU9NC4wMC4uNC4wMSByb3dzPTEgbG9vcHM9MSkK ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE1h dGVyaWFsaXplICAoY29zdD0xMDAwMjYzMTEuNTAuLjEwMDAyNjMxMS41MCBy b3dzPTEgd2lkdGg9NzIxKSAoYWN0dWFsIHRpbWU9OTQ5NDIuMjkuLjk1MTAz LjA2IHJvd3M9MjQyMjYgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29z dD0xMDAwMjU3MzUuNTEuLjEwMDAyNjMxMS41MCByb3dzPTEgd2lkdGg9NzIx KSAoYWN0dWFsIHRpbWU9ODM1NzIuNDIuLjk0NjQ0LjUxIHJvd3M9MjQyMjYg bG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgSm9pbiBGaWx0ZXI6ICgoIm91dGVyIi5lbXAgPSAi aW5uZXIiLmVtcCkgQU5EICgib3V0ZXIiLmZpbCA9ICJpbm5lciIuZmlsKSBB TkQgKCJvdXRlciIuY29kaWdvID0gImlubmVyIi5jbGFfY2F0ZWdvcmlhKSkK ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0xMDAwMjU3MzUuNTEuLjEw MDAyNjMwNS43MyByb3dzPTEgd2lkdGg9NjMxKSAoYWN0dWFsIHRpbWU9ODM1 NjUuNDUuLjkxMzkyLjc0IHJvd3M9MjQyMjYgbG9vcHM9MSkKICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgSm9pbiBGaWx0ZXI6ICgoImlubmVyIi5lbXAgPSAib3V0ZXIiLmVtcCkg QU5EICgib3V0ZXIiLmNvZGlnb19ncnVwb19yZXAgPSAiaW5uZXIiLmNvZGln b19ncnVwb19yZXApKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChj b3N0PTEwMDAyNTczNS41MS4uMTAwMDI2MzAwLjMwIHJvd3M9MSB3aWR0aD01 NzgpIChhY3R1YWwgdGltZT04MzU1OC4xMi4uODg4MTcuNTMgcm93cz0yNDIy NiBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICBKb2luIEZpbHRlcjogKCgi aW5uZXIiLmVtcCA9ICJvdXRlciIuZW1wKSBBTkQgKCJpbm5lciIuZmlsID0g Im91dGVyIi5lbXBmaWwpKQogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVk IExvb3AgIChjb3N0PTEwMDAyNTczNS41MS4uMTAwMDI2Mjk1Ljc5IHJvd3M9 MSB3aWR0aD01NDUpIChhY3R1YWwgdGltZT04MzU1MS44OC4uODY1OTcuMjEg cm93cz0yNDIyNiBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBK b2luIEZpbHRlcjogKCgiaW5uZXIiLmVtcCA9ICJvdXRlciIuZW1wKSBBTkQg KCJpbm5lciIuZmlsID0gIm91dGVyIi5lbXBmaWwpIEFORCAoImlubmVyIi5j b2RpZ28gPSAib3V0ZXIiLmJhbmRlaXJhX2NsaWVudGUpKQogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTEwMDAyNTcz NS41MS4uMTAwMDI2MjkxLjA5IHJvd3M9MSB3aWR0aD01MTMpIChhY3R1YWwg dGltZT04MzUzOS45Mi4uODQ5MTAuNjggcm93cz0yNDIyNiBsb29wcz0xKQog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICBKb2luIEZpbHRlcjogKCgi b3V0ZXIiLmVtcCA9ICJpbm5lciIuZW1wKSBBTkQgKCJvdXRlciIuZmlsID0g ImlubmVyIi5lbXBmaWwpKQogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAtPiAgSW5kZXggU2NhbiB1c2luZyBmdGdyZXAwMF9wa2V5IG9uIGZ0Z3Jl cDAwICAoY29zdD0wLjAwLi40LjY4IHJvd3M9MSB3aWR0aD0zMikgKGFjdHVh bCB0aW1lPTYuOTAuLjYuOTEgcm93cz0xIGxvb3BzPTEpCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIC0+ICBNYXRlcmlhbGl6ZSAgKGNvc3Q9MTAw MDI2Mjg2LjQwLi4xMDAwMjYyODYuNDAgcm93cz0xIHdpZHRoPTQ4MSkgKGFj dHVhbCB0aW1lPTgzNTMyLjkzLi44MzY4NC42MCByb3dzPTI0MjI2IGxvb3Bz PTEpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBO ZXN0ZWQgTG9vcCAgKGNvc3Q9MTAwMDI1NzM1LjUxLi4xMDAwMjYyODYuNDAg cm93cz0xIHdpZHRoPTQ4MSkgKGFjdHVhbCB0aW1lPTI0ODcuMjEuLjgzMjgw LjUwIHJvd3M9MjQyMjYgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgSm9pbiBGaWx0ZXI6ICgoImlubmVyIi5h bm9fbWVzKTo6dGV4dCA9IHRvX2NoYXIoIm91dGVyIi5kYXRhX2VtaXNzYW8s ICdZWVlZTU0nOjp0ZXh0KSkKICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0yNTczNS41 MS4uMjYyNzQuMTAgcm93cz0xIHdpZHRoPTQ3MSkgKGFjdHVhbCB0aW1lPTI0 ODUuNzYuLjgyNjYuMDQgcm93cz0yNDIyNiBsb29wcz0xKQogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBKb2luIEZp bHRlcjogKCgiaW5uZXIiLmVtcGZpbCA9ICJvdXRlciIuZmlsKSBBTkQgKCJp bm5lciIuZW1wID0gIm91dGVyIi5lbXApKQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3Ag IChjb3N0PTI1NzM1LjUxLi4yNjIxMy42NyByb3dzPTEwIHdpZHRoPTM1OSkg KGFjdHVhbCB0aW1lPTI0NDkuMDMuLjM2NTYuMDAgcm93cz03NzA1IGxvb3Bz PTEpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIEpvaW4gRmlsdGVyOiAoKCJpbm5lciIuZW1wID0gIm91 dGVyIi5lbXApIEFORCAoImlubmVyIi5maWwgPSAib3V0ZXIiLmVtcGZpbCkp CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MjU3MzUuNTEuLjI2 MTU2LjMxIHJvd3M9MTAgd2lkdGg9MzE5KSAoYWN0dWFsIHRpbWU9MjQxMC4w Mi4uMjY2NC42OCByb3dzPTc3MDUgbG9vcHM9MSkKICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg Sm9pbiBGaWx0ZXI6ICgoIm91dGVyIi5lbXAgPSAiaW5uZXIiLmVtcCkgQU5E ICgib3V0ZXIiLmZpbCA9ICJpbm5lciIuZW1wZmlsKSBBTkQgKCJvdXRlciIu Y29kaWdvID0gImlubmVyIi5jb2RpZ29fZ3J1cG9fY2xpZW50ZSkpCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGZ0Y2xncjAwX3BrZXkg b24gZnRjbGdyMDAgIChjb3N0PTAuMDAuLjQuNjggcm93cz0xIHdpZHRoPTMy KSAoYWN0dWFsIHRpbWU9OS4yMC4uOS4yMSByb3dzPTEgbG9vcHM9MSkKICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgLT4gIE1hdGVyaWFsaXplICAoY29zdD0yNjE1MS40Ni4u MjYxNTEuNDYgcm93cz0xMCB3aWR0aD0yODcpIChhY3R1YWwgdGltZT0yNDAw Ljc1Li4yNDE1LjgwIHJvd3M9NzcwNSBsb29wcz0xKQogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTI1NzM1LjUxLi4yNjE1 MS40NiByb3dzPTEwIHdpZHRoPTI4NykgKGFjdHVhbCB0aW1lPTEzNDkuODku LjIzNjkuMjQgcm93cz03NzA1IGxvb3BzPTEpCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIEpvaW4gRmlsdGVyOiAoKCJpbm5lciIuZW1wID0gIm91dGVy Ii5lbXApIEFORCAoImlubmVyIi5lbXBfZXN0YWRvID0gIm91dGVyIi5lc3Rh ZG9fY2xpZW50ZSkpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBN ZXJnZSBKb2luICAoY29zdD0yNTczNS41MS4uMjU4OTIuNjUgcm93cz00NCB3 aWR0aD0xOTMpIChhY3R1YWwgdGltZT0xMzIyLjM2Li4xNDUyLjk0IHJvd3M9 NzcwNSBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICBNZXJnZSBDb25kOiAoKCJvdXRlciIuZW1wID0gImlubmVyIi5lbXApIEFO RCAoIm91dGVyIi5maWwgPSAiaW5uZXIiLmVtcGZpbCkgQU5EICgib3V0ZXIi LmNvZGlnb19maXNjYWwgPSAiaW5uZXIiLmNvZF9maXNjYWwpKQogICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2lu ZyBmdGNvZmkwMF9wa2V5IG9uIGZ0Y29maTAwICAoY29zdD0wLjAwLi4xNTIu NzMgcm93cz03MiB3aWR0aD01MikgKGFjdHVhbCB0aW1lPTIxLjYwLi4yNy40 NiByb3dzPTY0IGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIEZpbHRlcjogKChncnVwb19mYXR1cmFtZW50byA+PSAn MDEnOjpjaGFyYWN0ZXIgdmFyeWluZykgQU5EICgoYXR1YWxfZmF0dXJhID0g JysnOjpjaGFyYWN0ZXIgdmFyeWluZykgT1IgKGF0dWFsX2ZhdHVyYSA9ICct Jzo6Y2hhcmFjdGVyIHZhcnlpbmcpIE9SIChuZl9wcm9kZ3JhdGlzID0gJ1Mn OjpjaGFyYWN0ZXIgdmFyeWluZykpKQogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAtPiAgU29ydCAgKGNvc3Q9MjU3MzUuNTEuLjI1NzM2LjI1 IHJvd3M9Mjk0IHdpZHRoPTE0MSkgKGFjdHVhbCB0aW1lPTEyOTguMjIuLjEz MTAuNDQgcm93cz05NDUzIGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIFNvcnQgS2V5OiBmdG5mY28wMC5lbXAsIGZ0 bmZjbzAwLmVtcGZpbCwgZnRuZmNvMDAuY29kX2Zpc2NhbAogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3Ag IChjb3N0PTAuMDAuLjI1NzIzLjQ2IHJvd3M9Mjk0IHdpZHRoPTE0MSkgKGFj dHVhbCB0aW1lPTY1Mi42Mi4uMTA4NS4wOCByb3dzPTk0NTMgbG9vcHM9MSkK ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg Sm9pbiBGaWx0ZXI6ICgiaW5uZXIiLmVtcCA9ICJvdXRlciIuZW1wKQogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAg SW5kZXggU2NhbiB1c2luZyBmdGNnY2EwMF9wa2V5IG9uIGZ0Y2djYTAwICAo Y29zdD0wLjAwLi40LjY4IHJvd3M9MSB3aWR0aD0zMikgKGFjdHVhbCB0aW1l PTIzLjc4Li4yMy43OSByb3dzPTEgbG9vcHM9MSkKICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4g dXNpbmcgZnRuZmNvMDIgb24gZnRuZmNvMDAgIChjb3N0PTAuMDAuLjI1NzE1 LjExIHJvd3M9Mjk0IHdpZHRoPTEwOSkgKGFjdHVhbCB0aW1lPTYyOC44MC4u OTczLjY5IHJvd3M9OTQ1MyBsb29wcz0xKQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6ICgoZW1w ID0gOTA5OjpudW1lcmljKSBBTkQgKHNpdHVhY2FvX25mID0gJ04nOjpjaGFy YWN0ZXIgdmFyeWluZykgQU5EICh0b19jaGFyKGRhdGFfZW1pc3NhbywgJ1lZ WVlNTSc6OnRleHQpID49ICcyMDAyMDgnOjp0ZXh0KSBBTkQgKHRvX2NoYXIo ZGF0YV9lbWlzc2FvLCAnWVlZWU1NJzo6dGV4dCkgPD0gJzIwMDMwMyc6OnRl eHQpKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2Nh biB1c2luZyBmdGNsY3IwMF9wa2V5IG9uIGZ0Y2xjcjAwICAoY29zdD0wLjAw Li41LjgzIHJvd3M9MSB3aWR0aD05NCkgKGFjdHVhbCB0aW1lPTAuMDkuLjAu MDkgcm93cz0xIGxvb3BzPTc3MDUpCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIEluZGV4IENvbmQ6ICgoZnRjbGNyMDAuZW1wID0gIm91dGVy Ii5lbXApIEFORCAoZnRjbGNyMDAuZmlsID0gIm91dGVyIi5lbXBmaWwpIEFO RCAoZnRjbGNyMDAudGlwb19jYWRhc3RybyA9ICJvdXRlciIudGlwb19jYWRf Y2xpY3JlKSBBTkQgKGZ0Y2xjcjAwLmNvZGlnbyA9ICJvdXRlciIuY29kX2Ns aWVudGUpKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBmdHJlZGMw MF9wa2V5IG9uIGZ0cmVkYzAwICAoY29zdD0wLjAwLi41LjgzIHJvd3M9MSB3 aWR0aD00MCkgKGFjdHVhbCB0aW1lPTAuMDkuLjAuMDkgcm93cz0xIGxvb3Bz PTc3MDUpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICgoZnRyZWRjMDAu ZW1wID0gIm91dGVyIi5lbXApIEFORCAoZnRyZWRjMDAuZmlsID0gIm91dGVy Ii5maWwpIEFORCAoZnRyZWRjMDAudGlwb19jb250cmlidWludGUgPSAib3V0 ZXIiLnRpcG9fY29udHJpYnVpbnRlKSBBTkQgKGZ0cmVkYzAwLmNvZGlnb19y ZWRlID0gIm91dGVyIi5jb2RpZ29fcmVkZSkpCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2Fu IHVzaW5nIGZ0bmZwcjAwX3BrZXkgb24gZnRuZnByMDAgIChjb3N0PTAuMDAu LjUuOTUgcm93cz0xIHdpZHRoPTExMikgKGFjdHVhbCB0aW1lPTAuMjIuLjAu NDggcm93cz0zIGxvb3BzPTc3MDUpCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICgo Im91dGVyIi5lbXAgPSBmdG5mcHIwMC5lbXApIEFORCAoIm91dGVyIi5maWwg PSBmdG5mcHIwMC5maWwpIEFORCAoZnRuZnByMDAuZmlsID0gMTAxOjpudW1l cmljKSBBTkQgKCJvdXRlciIubm90YV9maXNjYWwgPSBmdG5mcHIwMC5ub3Rh X2Zpc2NhbCkgQU5EICgib3V0ZXIiLnNlcmllID0gZnRuZnByMDAuc2VyaWUp IEFORCAoIm91dGVyIi5kYXRhX2VtaXNzYW8gPSBmdG5mcHIwMC5kYXRhX2Vt aXNzYW8pKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAtPiAgU2VxIFNjYW4gb24gZ3NhbWVzMDAgIChjb3N0PTEwMDAwMDAw MC4wMC4uMTAwMDAwMDA2LjcyIHJvd3M9MzcyIHdpZHRoPTEwKSAoYWN0dWFs IHRpbWU9MC4wMS4uMC44OCByb3dzPTM3MiBsb29wcz0yNDIyNikKICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgZnRiYW5k MDBfcGtleSBvbiBmdGJhbmQwMCAgKGNvc3Q9MC4wMC4uNC42OCByb3dzPTEg d2lkdGg9MzIpIChhY3R1YWwgdGltZT0wLjAxLi4wLjAyIHJvd3M9MSBsb29w cz0yNDIyNikKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNp bmcgZnR0Y2xpMDBfcGtleSBvbiBmdHRjbGkwMCAgKGNvc3Q9MC4wMC4uNC41 MCByb3dzPTEgd2lkdGg9MzMpIChhY3R1YWwgdGltZT0wLjAzLi4wLjAzIHJv d3M9MSBsb29wcz0yNDIyNikKICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5k ZXggQ29uZDogKChmdHRjbGkwMC5lbXAgPSAib3V0ZXIiLmVtcCkgQU5EIChm dHRjbGkwMC5maWwgPSAib3V0ZXIiLmZpbCkgQU5EIChmdHRjbGkwMC5jb2Rf dGlwb2NsaWVudGUgPSAib3V0ZXIiLmNvZGlnb190aXBvX2NsaWVudGUpKQog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBmdHJlcHIwMF9wa2V5 IG9uIGZ0cmVwcjAwICAoY29zdD0wLjAwLi41LjQxIHJvd3M9MSB3aWR0aD01 MykgKGFjdHVhbCB0aW1lPTAuMDQuLjAuMDQgcm93cz0xIGxvb3BzPTI0MjI2 KQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAoKGZ0cmVwcjAwLmVt cCA9ICJvdXRlciIuZW1wKSBBTkQgKGZ0cmVwcjAwLmZpbCA9ICJvdXRlciIu ZW1wZmlsKSBBTkQgKGZ0cmVwcjAwLmNvZGlnb19yZXByID0gIm91dGVyIi5j b2RfcmVwcmVzKSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgZnRwcm9k MDBfcGtleSBvbiBmdHByb2QwMCAgKGNvc3Q9MC4wMC4uNS43NCByb3dzPTEg d2lkdGg9OTApIChhY3R1YWwgdGltZT0wLjA2Li4wLjA2IHJvd3M9MSBsb29w cz0yNDIyNikKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKChmdHByb2QwMC5l bXAgPSAib3V0ZXIiLmVtcCkgQU5EIChmdHByb2QwMC5maWwgPSAib3V0ZXIi LmVtcGZpbCkgQU5EIChmdHByb2QwMC50aXBvX2NhZGFzdHJvID0gIm91dGVy Ii50aXBvX2NhZF9wcm9tYXQpIEFORCAoZnRwcm9kMDAuY29kaWdvX3Byb2R1 dG8gPSAib3V0ZXIiLmNvZF9wcm9kdXRvKSkKICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgZ3Nlc3RhMDBf cGtleSBvbiBnc2VzdGEwMCAgKGNvc3Q9MC4wMC4uMy41NSByb3dzPTEgd2lk dGg9NikgKGFjdHVhbCB0aW1lPTAuMDMuLjAuMDMgcm93cz0xIGxvb3BzPTI0 MjI2KQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJ bmRleCBDb25kOiAoZ3Nlc3RhMDAuZXN0YWRvX3NpZ2xhID0gIm91dGVyIi5l bXBfZXN0YWRvKQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSW5k ZXggU2NhbiB1c2luZyBmdHN1cHYwMF9wa2V5IG9uIGZ0c3VwdjAwICAoY29z dD0wLjAwLi40LjY4IHJvd3M9MSB3aWR0aD0zMikgKGFjdHVhbCB0aW1lPTAu MDEuLjAuMDIgcm93cz0xIGxvb3BzPTI0MjI2KQogICAgICAgICAgICAgICAg ICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBmdHNwcm8wMF9wa2V5IG9uIGZ0 c3BybzAwICAoY29zdD0wLjAwLi40LjUwIHJvd3M9MSB3aWR0aD0yNykgKGFj dHVhbCB0aW1lPTAuMDMuLjAuMDMgcm93cz0xIGxvb3BzPTI0MjI2KQogICAg ICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAoKGZ0c3BybzAw LmVtcCA9ICJvdXRlciIuZW1wKSBBTkQgKGZ0c3BybzAwLmZpbCA9ICJvdXRl ciIuZmlsKSBBTkQgKGZ0c3BybzAwLmNvZGlnbyA9ICJvdXRlciIuc2l0dWFj YW8pKQogVG90YWwgcnVudGltZTogMTEyMjg3LjEwIG1zZWMKKDY5IHJvd3Mp Cgo= ---MOQ10621907597c83580e1a1a0b1ef30a4fe538606e93--