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 EA2B6D1B8D2 for ; Mon, 25 Aug 2003 12:03:34 -0300 (ADT) 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 38234-10 for ; Mon, 25 Aug 2003 12:03:20 -0300 (ADT) Received: from host2.hostseguro.com (unknown [200.198.188.133]) by svr1.postgresql.org (Postfix) with ESMTP id 10858D1B8C8 for ; Mon, 25 Aug 2003 12:03:19 -0300 (ADT) Received: from cpanel by host2.hostseguro.com with local (Exim 4.20) id 19rIsC-0000gC-4D for pgsql-performance@postgresql.org; Mon, 25 Aug 2003 12:03:12 -0300 Received: from 200.203.33.227 ([200.203.33.227]) by sistemica.info (IMP) with HTTP for ; Mon, 25 Aug 2003 12:03:12 -0300 Message-ID: <1061823792.3f4a253015fdc@sistemica.info> Date: Mon, 25 Aug 2003 12:03:12 -0300 From: Rhaoni Chiu Pereira To: PostgreSQL Performance Subject: Query too slow MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="-MOQ1061823792f0203aabba46ce180b1ce3f6ce60d45f" User-Agent: Internet Messaging Program (IMP) 3.2.1 X-Originating-IP: 200.203.33.227 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/322 X-Sequence-Number: 3138 This message is in MIME format. ---MOQ1061823792f0203aabba46ce180b1ce3f6ce60d45f Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Hi List, I have posted a subjetc on the admin list but I thought that it might fit better on this list as follow: Hi List, As I said before, I'm not a DBA " yet" , but I'm learning ... and I already have a PostgreSQL running, so I have to ask some help... I got a SQL as folows : 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||'||'||gsames00.ano_mes , ftprod00.descricao_produto||'||'||gsames00.descricao , 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') <= '200304' 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||'||'||gsames00.ano_mes , ftprod00.descricao_produto||'||'||gsames00.descricao I have created the decode, NVL and DIVIDE functions.... the problem is that the where condition makes this query to slow ( about 4 min ) and the same query in my Oracle database takes less than 40 seconds. I have tried to isolate the problem taking off some fields and I left justa the two first fields in the query ( ftnfco00.estado_cliente , ftcofi00.grupo_faturamento ) and it still taking almost 4 min to return. Does anyone have a hint to give me to make it faster ? Atached goes a explain analyze return os this query. Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122 ---MOQ1061823792f0203aabba46ce180b1ce3f6ce60d45f Content-Type: text/plain; name="explain.sql" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="explain.sql" CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4KCi0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0KIEFnZ3JlZ2F0ZSAgKGNvc3Q9Nzk3MS42 NS4uNzk3MS42OCByb3dzPTEgd2lkdGg9ODMzKSAoYWN0dWFsIHRpbWU9MTUw MTUyOS4xNi4uMTUwODA2Ni4zMiByb3dzPTE3NTUgbG9vcHM9MSkKICAgLT4g IEdyb3VwICAoY29zdD03OTcxLjY1Li43OTcxLjY2IHJvd3M9MSB3aWR0aD04 MzMpIChhY3R1YWwgdGltZT0xNTAxNDk1LjA3Li4xNTAyNTE3Ljk5IHJvd3M9 MjQxMTEgbG9vcHM9MSkKICAgICAgICAgLT4gIFNvcnQgIChjb3N0PTc5NzEu NjUuLjc5NzEuNjUgcm93cz0xIHdpZHRoPTgzMykgKGFjdHVhbCB0aW1lPTE1 MDE0OTUuMDMuLjE1MDE1NjMuODcgcm93cz0yNDExMSBsb29wcz0xKQogICAg ICAgICAgICAgICBTb3J0IEtleTogZnRuZmNvMDAuZXN0YWRvX2NsaWVudGUs IGZ0Y29maTAwLmdydXBvX2ZhdHVyYW1lbnRvLCAoKCgoZnRwcm9kMDAudGlw b19jYWRhc3Rybyk6OnRleHQgfHwgKGZ0cHJvZDAwLmNvZGlnb19wcm9kdXRv KTo6dGV4dCkgfHwgJ3x8Jzo6dGV4dCkgfHwgKGdzYW1lczAwLmFub19tZXMp Ojp0ZXh0KSwgKChmdHByb2QwMC5kZXNjcmljYW9fcHJvZHV0byB8fCAnfHwn OjpjaGFyYWN0ZXIgdmFyeWluZykgfHwgZ3NhbWVzMDAuZGVzY3JpY2FvKQog ICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTc5MTMuMzEu Ljc5NzEuNjQgcm93cz0xIHdpZHRoPTgzMykgKGFjdHVhbCB0aW1lPTEzODIy ODEuMjQuLjE0OTU3NDguNzkgcm93cz0yNDExMWxvb3BzPTEpCiAgICAgICAg ICAgICAgICAgICAgIEpvaW4gRmlsdGVyOiAoImlubmVyIi5lc3RhZG9fc2ln bGEgPSAib3V0ZXIiLmVzdGFkb19jbGllbnRlKQogICAgICAgICAgICAgICAg ICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTc5MTMuMzEuLjc5NjkuOTAg cm93cz0xIHdpZHRoPTgyNykgKGFjdHVhbCB0aW1lPTEzODIyNzEuNDEuLjE0 OTA3MDIuMTEgcm93cz0yNDExMSBsb29wcz0xKQogICAgICAgICAgICAgICAg ICAgICAgICAgICBKb2luIEZpbHRlcjogKCgib3V0ZXIiLmVtcCA9ICJpbm5l ciIuZW1wKSBBTkQgKCJpbm5lciIuZmlsID0gIm91dGVyIi5lbXBmaWwpIEFO RCAoImlubmVyIi5jb2RpZ28gPSAib3V0ZXIiLmJhbmRlaXJhX2NsaWVudGUp KQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3Ag IChjb3N0PTc5MTMuMzEuLjc5NjguODcgcm93cz0xIHdpZHRoPTc5NSkgKGFj dHVhbCB0aW1lPTEzODIxNzkuODAuLjE0ODY0OTIuNjkgcm93cz0yNDExMSBs b29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBKb2lu IEZpbHRlcjogKCgiaW5uZXIiLmVtcCA9ICJvdXRlciIuZW1wKSBBTkQgKCJv dXRlciIuY29kaWdvID0gImlubmVyIi5jbGFfY2F0ZWdvcmlhKUFORCAoIm91 dGVyIi5jb2RpZ28gPSAiaW5uZXIiLmNsYV9tYXJjYSkgQU5EICgib3V0ZXIi LmNvZGlnbyA9ICJpbm5lciIuc2l0dWFjYW8pKQogICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTc5MTMu MzEuLjc5NTQuMzQgcm93cz0zIHdpZHRoPTcwNSkgKGFjdHVhbCB0aW1lPTEz ODE2MzIuNTcuLjE0NjQ2NTEuMzIgcm93cz0yNDExMTAgbG9vcHM9MSkKICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSm9pbiBGaWx0 ZXI6ICgoIm91dGVyIi5lbXAgPSAiaW5uZXIiLmVtcCkgQU5EICgiaW5uZXIi LmZpbCA9ICJvdXRlciIuZW1wZmlsKSkgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTc5MTMu MzEuLjc5NDEuODQgcm93cz0yIHdpZHRoPTY2NSkgKGFjdHVhbCB0aW1lPTEz ODE0NDQuODcuLjE0MDg1MzEuMjkgcm93cz0yNDExMTAgbG9vcHM9MSkKICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSm9p biBGaWx0ZXI6ICgoImlubmVyIi5lbXAgPSAib3V0ZXIiLmVtcCkgQU5EICgi b3V0ZXIiLmZpbCA9ICJpbm5lciIuZW1wZmlsKSBBTkQoIm91dGVyIi5jb2Rp Z29fZ3J1cG9fcmVwID0gImlubmVyIi5jb2RpZ29fZ3J1cG9fcmVwKSkKICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4g IFNlcSBTY2FuIG9uIGZ0Z3JlcDAwICAoY29zdD0wLjAwLi4xLjAxIHJvd3M9 MSB3aWR0aD0zMikgKGFjdHVhbCB0aW1lPTI4Ljk3Li4yOC45NyByb3dzPTEg bG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgLT4gIE1hdGVyaWFsaXplICAoY29zdD03OTQwLjc5Li43OTQw Ljc5IHJvd3M9MiB3aWR0aD02MzMpIChhY3R1YWwgdGltZT0xMzgxNDE1LjUx Li4xMzg1NDQ1LjM5IHJvd3M9MjQxMTEwIGxvb3BzPTEpCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBO ZXN0ZWQgTG9vcCAgKGNvc3Q9NzkxMy4zMS4uNzk0MC43OSByb3dzPTIgd2lk dGg9NjMzKSAoYWN0dWFsIHRpbWU9MTM0ODQwMC45Ni4uMTM3OTA5MC45MyBy b3dzPTI0MTExMCBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBKb2luIEZpbHRlcjog KCgiaW5uZXIiLmVtcCA9ICJvdXRlciIuZW1wKSBBTkQgKCJvdXRlciIuZmls ID0gImlubmVyIi5lbXBmaWwpIEFORCAoIm91dGVyIi5jb2RpZ29fc3VwZXJ2 aXNvciA9ICJpbm5lciIuY29kaWdvX3N1cGVydmlzb3IpKQogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAtPiAgU2VxIFNjYW4gb24gZnRzdXB2MDAgIChjb3N0PTAuMDAuLjEuMDEg cm93cz0xIHdpZHRoPTMyKSAoYWN0dWFsIHRpbWU9MTMuOTIuLjEzLjk0IHJv d3M9MSBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgTWF0ZXJpYWxpemUgIChj b3N0PTc5MzkuNzUuLjc5MzkuNzUgcm93cz0yIHdpZHRoPTYwMSkgKGFjdHVh bCB0aW1lPTEzNDgzODYuODguLjEzNTc4NTMuNzcgcm93cz0yNDExMTAgbG9v cHM9MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29z dD03OTEzLjMxLi43OTM5Ljc1IHJvd3M9MiB3aWR0aD02MDEpIChhY3R1YWwg dGltZT0yMzg1NDguODQuLjEzNDQzMzkuMzMgcm93cz0yNDExMTAgbG9vcHM9 MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgSm9pbiBGaWx0ZXI6ICgoImlu bmVyIi5hbm9fbWVzKTo6dGV4dCA9IHRvX2NoYXIoIm91dGVyIi5kYXRhX2Vt aXNzYW8sICdZWVlZTU0nOjp0ZXh0KSkKICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgLT4gIE1lcmdlIEpvaW4gIChjb3N0PTc5MTMuMzEuLjc5MTMuNDUgcm93 cz0yIHdpZHRoPTU3NikoYWN0dWFsIHRpbWU9MjM4NTI0LjMxLi4yNzU3MjQu NDQgcm93cz0yNDExMTAgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgTWVyZ2UgQ29uZDogKCgib3V0ZXIiLmVtcGZpbCA9ICJpbm5l ciIuZmlsKSBBTkQgKCJvdXRlciIuY29kaWdvX3RpcG9fY2xpZW50ZSA9ICJp bm5lciIuY29kX3RpcG9jbGllbnRlKSBBTkQgKCJvdXRlciIuZW1wID0gImlu bmVyIi5lbXApKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAg U29ydCAgKGNvc3Q9NzkxMS43OS4uNzkxMS44MCByb3dzPTIgd2lkdGg9NTQz KShhY3R1YWwgdGltZT0yMzg1MjMuNDguLjI1NDI4NC4xMyByb3dzPTI0MTEx MCBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICBTb3J0IEtleTogZnRjbGNyMDAuZmlsLCBmdGNsY3IwMC5jb2RpZ29fdGlw b19jbGllbnRlLCBmdG5mcHIwMC5lbXAKICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD03ODUxLjI5 Li43OTExLjc4IHJvd3M9MiB3aWR0aD01NDMpIChhY3R1YWwgdGltZT04MDAw NS41NS4uMTQ0NzU1Ljg0IHJvd3M9MjQxMTEwIGxvb3BzPTEpCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEpvaW4gRmlsdGVy OiAoKCJpbm5lciIuZW1wX2VzdGFkbyA9ICJvdXRlciIuZXN0YWRvX2NsaWVu dGUpIEFORCAoIm91dGVyIi5jb2RpZ28gPSAiaW5uZXIiLmNvZGlnb19ncnVw b19jbGllbnRlKSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD03ODUxLjI5Li43ODUz LjIyIHJvd3M9MTAgd2lkdGg9NDQ5KSAoYWN0dWFsIHRpbWU9Nzk5NjAuNDgu Ljk0MjA2LjE3IHJvd3M9MjQxMTEwIGxvb3BzPTEpCiAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEpvaW4gRmlsdGVy OiAoKCJpbm5lciIuZW1wID0gIm91dGVyIi5lbXApIEFORCAoIm91dGVyIi5m aWwgPSAiaW5uZXIiLmVtcGZpbCkpCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBmdGNs Z3IwMCAgKGNvc3Q9MC4wMC4uMS4wMSByb3dzPTEgd2lkdGg9MzIpIChhY3R1 YWwgdGltZT0xMi4yMS4uMTIuMjEgcm93cz0xIGxvb3BzPTEpICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCi0+ICBN YXRlcmlhbGl6ZSAgKGNvc3Q9Nzg1Mi4wNi4uNzg1Mi4wNiByb3dzPTEwIHdp ZHRoPTQxNykgKGFjdHVhbCB0aW1lPTc5OTQ4LjE2Li44MjA1MS4wMSByb3dz PTI0MTExMCBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAKLT4gIE1lcmdlIEpvaW4gIChj b3N0PTc4NTEuMjkuLjc4NTIuMDYgcm93cz0xMCB3aWR0aD00MTcpIChhY3R1 YWwgdGltZT02NTUzNi4yMi4uNzg1MTUuMzAgcm93cz0yNDExMTAgbG9vcHM9 MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIApNZXJnZSBDb25kOiAoKCJvdXRlciIuZW1wZmls ID0gImlubmVyIi5maWwpIEFORCAoIm91dGVyIi5jb2RfcmVwcmVzID0gImlu bmVyIi5jb2RpZ29fcmVwcikgQU5EICgib3V0ZXIiLmVtcCA9ICJpbm5lciIu ZW1wKSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgCi0+ICBTb3J0ICAoY29zdD03ODQwLjUx Li43ODQwLjU0IHJvd3M9MTAgd2lkdGg9MzY0KSAoYWN0dWFsIHRpbWU9NjQy MDMuMzMuLjY1NTIyLjgwIHJvd3M9MjQxMTEwIGxvb3BzPTEpCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIApTb3J0IEtleTogZnRuZmNvMDAuZW1wZmlsLCBmdG5m Y28wMC5jb2RfcmVwcmVzLCBmdG5mcHIwMC5lbXAKICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgCi0+ICBOZXN0ZWQgTG9vcAogIChjb3N0PTc1NjkuNTEuLjc4NDAu MzUgcm93cz0xMCB3aWR0aD0zNjQpIChhY3R1YWwgdGltZT0yMDk0LjM4Li4z MTQ2OS41MSByb3dzPTI0MTExMCBsb29wcz0xKQogICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAKSm9pbiBGaWx0ZXI6ICgoIm91dGVyIi5lbXAgPSAiaW5u ZXIiLmVtcCkgQU5EICgib3V0ZXIiLmVtcGZpbCA9ICJpbm5lciIuZmlsKSkK ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgCi0+ICBOZXN0ZWQgTG9vcCAg KGNvc3Q9NzU2OS41MS4uNzgzOS4xMCByb3dzPTEgd2lkdGg9MzM3KSAoYWN0 dWFsIHRpbWU9MjA5NC4wMC4uMjE1NjguMDggcm93cz0yNDExMSBsb29wcz0x KSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIApKb2luIEZpbHRlcjogKCgi b3V0ZXIiLmVtcCA9ICJpbm5lciIuZW1wKSBBTkQgKCJvdXRlciIuZW1wZmls ID0gImlubmVyIi5maWwpKQogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIAotPiBOZXN0ZWQgTG9vcCAgKGNvc3Q9NzU2OS41MS4uNzgzOC4wNyBy b3dzPTEgd2lkdGg9MzA1KSAoYWN0dWFsIHRpbWU9MjA4Ni41OS4uMjA0NTYu MjQgcm93cz0yNDExMSBsb29wcz0xKQogICBKb2luIEZpbHRlcjogKCgib3V0 ZXIiLmVtcCA9ICJpbm5lciIuZW1wKSBBTkQgKCJvdXRlciIuZW1wZmlsID0g ImlubmVyIi5maWwpKQogICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTc1Njku NTEuLjc4MzcuMDUgcm93cz0xIHdpZHRoPTI3MykgKGFjdHVhbCB0aW1lPTIw NzguMjEuLjE5MzY4LjQyIHJvd3M9MjQxMTEgbG9vcHM9MSkKICAgICAgICAg LT4gIE1lcmdlIEpvaW4gIChjb3N0PTc1NjkuNTEuLjc1NzIuMDcgcm93cz00 NCB3aWR0aD0xNjEpIChhY3R1YWwgdGltZT0xOTkxLjAwLi4yMjYyLjU0IHJv d3M9NzcxOCBsb29wcz0xKQogICAgICAgICAgICAgICBNZXJnZSBDb25kOiAo KCJvdXRlciIuY29kX2Zpc2NhbCA9ICJpbm5lciIuY29kaWdvX2Zpc2NhbCkg QU5EICgib3V0ZXIiLmVtcGZpbCA9ICJpbm5lciIuZmlsKSBBTkQgKCJvdXRl ciIuZW1wID0gImlubmVyIi5lbXApKQogICAgICAgICAgICAgICAtPiAgU29y dCAgKGNvc3Q9NzUyMC43MS4uNzUyMS40NSByb3dzPTI5NSB3aWR0aD0xMDkp IChhY3R1YWwgdGltZT0xOTU4LjQwLi4xOTk0LjM4IHJvd3M9OTMzOSBsb29w cz0xKQogICAgICAgICAgICAgICAgICAgICBTb3J0IEtleTogZnRuZmNvMDAu Y29kX2Zpc2NhbCwgZnRuZmNvMDAuZW1wZmlsLCBmdG5mY28wMC5lbXAKICAg ICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIGZ0bmZjbzAwICAo Y29zdD0wLjAwLi43NTA4LjYwIHJvd3M9Mjk1IHdpZHRoPTEwOSkgKGFjdHVh bCB0aW1lPTE0LjUwLi4xNTgxLjgxIHJvd3M9OTMzOSBsb29wcz0xKQogICAg ICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6ICgoZW1wID0gOTA5Ojpu dW1lcmljKSBBTkQgKHNpdHVhY2FvX25mID0gJ04nOjpjaGFyYWN0ZXIgdmFy eWluZykgQU5EICh0b19jaGFyKGRhdGFfZW1pc3NhbywgJ1lZWVlNTSc6OnRl eHQpID49ICcyMDAyMDknOjp0ZXh0KSBBTkQgKHRvX2NoYXIoZGF0YV9lbWlz c2FvLCAnWVlZWU1NJzo6dGV4dCkgPD0gJzIwMDMwNCc6OnRleHQpKQogICAg ICAgICAgICAgICAtPiAgU29ydCAgKGNvc3Q9NDguODAuLjQ4Ljk4IHJvd3M9 NzIgd2lkdGg9NTIpIChhY3R1YWwgdGltZT0zMS44Ni4uNDMuNjkgcm93cz03 NzY1IGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAgIFNvcnQgS2V5OiBm dGNvZmkwMC5jb2RpZ29fZmlzY2FsLCBmdGNvZmkwMC5maWwsIGZ0Y29maTAw LmVtcAogICAgICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gZnRj b2ZpMDAgIChjb3N0PTAuMDAuLjQ2LjU4IHJvd3M9NzIgd2lkdGg9NTIpIChh Y3R1YWwgdGltZT03LjYyLi4zMS4wNyByb3dzPTc1IGxvb3BzPTEpCiAgICAg ICAgICAgICAgICAgICAgICAgICAgIEZpbHRlcjogKChncnVwb19mYXR1cmFt ZW50byA+PSAnMDEnOjpjaGFyYWN0ZXIgdmFyeWluZykgQU5EICgoYXR1YWxf ZmF0dXJhID0gJysnOjpjaGFyYWN0ZXIgdmFyeWluZykgT1IgKGF0dWFsX2Zh dHVyYSA9ICctJzo6Y2hhcmFjdGVyIHZhcnlpbmcpIE9SIChuZl9wcm9kZ3Jh dGlzID0gJ1MnOjpjaGFyYWN0ZXIgdmFyeWluZykpKQogICAgICAgICAtPiAg SW5kZXggU2NhbiB1c2luZyBmdG5mcHIwMF9wa2V5IG9uIGZ0bmZwcjAwICAo Y29zdD0wLjAwLi41Ljk1IHJvd3M9MSB3aWR0aD0xMTIpIChhY3R1YWwgdGlt ZT0xLjQxLi4yLjE0IHJvd3M9MyBsb29wcz03NzE4KQogICAgICAgICAgICAg ICBJbmRleCBDb25kOiAoKCJvdXRlciIuZW1wID0gZnRuZnByMDAuZW1wKSBB TkQgKCJvdXRlciIuZmlsID0gZnRuZnByMDAuZmlsKSBBTkQgKGZ0bmZwcjAw LmZpbCA9IDEwMTo6bnVtZXJpYykgQU5EICgib3V0ZXIiLm5vdGFfZmlzY2Fs ID0gZnRuZnByMDAubm90YV9maXNjYWwpIEFORCAoIm91dGVyIi5zZXJpZSA9 IGZ0bmZwcjAwLnNlcmllKSBBTkQgKCJvdXRlciIuZGF0YV9lbWlzc2FvID0g ZnRuZnByMDAuZGF0YV9lbWlzc2FvKSkKICAgLT4gIFNlcSBTY2FuIG9uIGZ0 Y2djYTAwICAoY29zdD0wLjAwLi4xLjAxIHJvd3M9MSB3aWR0aD0zMikgKGFj dHVhbCB0aW1lPTAuMDEuLjAuMDEgcm93cz0xIGxvb3BzPTI0MTExKSAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIAotPiBTZXEgU2NhbiBvbiBm dGNnbWEwMCAgKGNvc3Q9MC4wMC4uMS4wMSByb3dzPTEgd2lkdGg9MzIpIChh Y3R1YWwgdGltZT0wLjAxLi4wLjAxIHJvd3M9MSBsb29wcz0yNDExMSkgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAKLT4gIFNlcSBTY2FuIG9uIGZ0c3By bzAwICAoY29zdD0wLjAwLi4xLjEwIHJvd3M9MTAgd2lkdGg9MjcpIChhY3R1 YWwgdGltZT0wLjAwLi4wLjA0IHJvd3M9MTAgbG9vcHM9MjQxMTEpICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgCi0+ICBTb3J0ICAoY29zdD0xMC43OC4uMTEuMDUgcm93cz0x MDkgd2lkdGg9NTMpIChhY3R1YWwgdGltZT0xMzMyLjU0Li4xNTEwLjY5IHJv d3M9MjQxMTc1IGxvb3BzPTEpICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgClNvcnQg S2V5OiBmdHJlcHIwMC5maWwsIGZ0cmVwcjAwLmNvZGlnb19yZXByLCBmdHJl cHIwMC5lbXAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKLT4gIFNlcSBTY2FuIG9u IGZ0cmVwcjAwICAoY29zdD0wLjAwLi43LjA5IHJvd3M9MTA5IHdpZHRoPTUz KSAoYWN0dWFsIHRpbWU9NDA2LjYzLi4xMzMxLjMzIHJvd3M9MTA5IGxvb3Bz PTEpICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg Ci0+ICBJbmRleCBTY2FuIHVzaW5nIGZ0Y2xjcjAxIG9uIGZ0Y2xjcjAwICAo Y29zdD0wLjAwLi41LjgzIHJvd3M9MSB3aWR0aD05NCkgKGFjdHVhbCB0aW1l PTAuMTMuLjAuMTQgcm93cz0xIGxvb3BzPTI0MTExMCkgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKSW5kZXggQ29u ZDogKChmdGNsY3IwMC5lbXAgPSAib3V0ZXIiLmVtcCkgQU5EIChmdGNsY3Iw MC5maWwgPSAib3V0ZXIiLmVtcGZpbCkgQU5EIChmdGNsY3IwMC50aXBvX2Nh ZGFzdHJvID0gIm91dGVyIi50aXBvX2NhZF9jbGljcmUpIEFORCAoZnRjbGNy MDAuY29kaWdvID0gIm91CnRlciIuY29kX2NsaWVudGUpKQogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAtPiAgU29ydCAgKGNvc3Q9MS41Mi4uMS41 NiByb3dzPTE3IHdpZHRoPTMzKSAoYWN0dWFsIHRpbWU9MC42MS4uMjI1LjQz IHJvd3M9MjQwOTg2IGxvb3BzPTEpICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgClNvcnQgS2V5OiBmdHRjbGkwMC5maWwsIGZ0dGNsaTAw LmNvZF90aXBvY2xpZW50ZSwgZnR0Y2xpMDAuZW1wICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgCi0+ICBTZXEgU2NhbiBvbiBmdHRjbGkw MCAgKGNvc3Q9MC4wMC4uMS4xNyByb3dzPTE3IHdpZHRoPTMzKSAoYWN0dWFs IHRpbWU9MC4xMi4uMC4xNyByb3dzPTE3IGxvb3BzPTEpCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBnc2FtZXMwMCAgKGNvc3Q9 MC4wMC4uNi43MiByb3dzPTM3MiB3aWR0aD0yNSkgKGFjdHVhbCB0aW1lPTAu MDAuLjEuMjggcm93cz0zNzIgbG9vcHM9MjQxMTEwKQogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2lu ZyBmdHJlZGMwMF9wa2V5IG9uIGZ0cmVkYzAwICAoY29zdD0wLjAwLi41Ljgz IHJvd3M9MSB3aWR0aD00MCkgKGFjdHVhbCB0aW1lPTAuMTIuLjAuMTIgcm93 cz0xIGxvb3BzPTI0MTExMCkKICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKChmdHJlZGMwMC5lbXAg PSAib3V0ZXIiLmVtcCkgQU5EIChmdHJlZGMwMC5maWwgPSAib3V0ZXIiLmZp bCkgQU5EIChmCnRyZWRjMDAudGlwb19jb250cmlidWludGUgPSAib3V0ZXIi LnRpcG9fY29udHJpYnVpbnRlKSBBTkQgKGZ0cmVkYzAwLmNvZGlnb19yZWRl ID0gIm91dGVyIi5jb2RpZ29fcmVkZSkpCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGZ0cHJvZDAwX3Br ZXkgb24gZnRwcm9kMDAgIChjb3N0PTAuMDAuLjUuNzQgcm93cz0xIHdpZHRo PTkwKSAoYWN0dWFsIHRpbWU9MC4wNi4uMC4wNiByb3dzPTEgbG9vcHM9MjQx MTEwKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJ bmRleCBDb25kOiAoKGZ0cHJvZDAwLmVtcCA9ICJvdXRlciIuZW1wKSBBTkQg KGZ0cHJvZDAwLmZpbCA9ICJvdXRlciIuZW1wZmlsKSBBTkQgKGZ0cHJvZDAw LnRpcG9fY2FkYXN0cm8gPSAib3V0ZXIiLnRpcG9fY2FkX3Byb21hdCkgQU5E IChmdHByb2QwMC5jb2RpZ29fcHJvZHV0byA9ICJvdXRlciIuY29kX3Byb2R1 dG8pKQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4g b24gZnRiYW5kMDAgIChjb3N0PTAuMDAuLjEuMDEgcm93cz0xIHdpZHRoPTMy KSAoYWN0dWFsIHRpbWU9MC4wMS4uMC4wMSByb3dzPTEgbG9vcHM9MjQxMTEp CiAgICAgICAgICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBnc2VzdGEw MCAgKGNvc3Q9MC4wMC4uMS4zMyByb3dzPTMzIHdpZHRoPTYpIChhY3R1YWwg dGltZT0wLjAxLi4wLjA4IHJvd3M9MzMgbG9vcHM9MjQxMTEpIFRvdGFsIHJ1 bnRpbWU6IDE1MDgyNTkuOTEgbXNlYwooNzQgcm93cykK ---MOQ1061823792f0203aabba46ce180b1ce3f6ce60d45f--