Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1siX0o-005mCQ-9K for pgsql-general@arkaria.postgresql.org; Mon, 26 Aug 2024 10:31:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1siX0m-007ykD-Fc for pgsql-general@arkaria.postgresql.org; Mon, 26 Aug 2024 10:31:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1siX0l-007yes-SK for pgsql-general@lists.postgresql.org; Mon, 26 Aug 2024 10:31:48 +0000 Received: from mail-ed1-x52d.google.com ([2a00:1450:4864:20::52d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1siX0j-001VGK-Nw for pgsql-general@lists.postgresql.org; Mon, 26 Aug 2024 10:31:47 +0000 Received: by mail-ed1-x52d.google.com with SMTP id 4fb4d7f45d1cf-5becdf7d36aso4689639a12.1 for ; Mon, 26 Aug 2024 03:31:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1724668304; x=1725273104; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=iT7RR5NLgecwtnTmRI8dGPadc4Bm2WBuH3LaVWEBaEs=; b=JKl7Q2CrMLTK4rpU/ofuTzcNj57Uo01TPXTju12MhyC4S01iEqSQLjkrc6pqdfGG9V DEJKd9F6TihH3Mm4VwfDNAGbbtiZWcYmA4sqMZYMY6WEWyJKDT8e9J70KkVAQ41HHi7I 6sRnFa0/WXV3D60NQddaOFydSHSiEqxfWVhFGI34Y47MQuoeuatuMW1QIehk/noIWEDW gwEuacCFC+tONobAXZ6xgviChYpU6NWLsuo88howdUMRw5CdhM8EU1N6x92FbcA1sAbw rX99yDIXiOAKYBmCQjsmRYwcd5/25hok09LH84aSUcBDdwrzSYnD9CiU5j0E/GtUi4Mb ZDsQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1724668304; x=1725273104; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=iT7RR5NLgecwtnTmRI8dGPadc4Bm2WBuH3LaVWEBaEs=; b=jctmQW+6w8wxQt9Hi0D+PXYcDi5Elf17UtmPcwyp7cuFaJ+o+ZtUJvazWFqYUid9uc kUUWwL/jeDjEqyQmAgevctNPwW937TsQsWlC6U6OOT9+sJlXye3KpZ+zkF2H6kB6ruSm QZRL+RUvh0tsC4NjhHrPzK3vMwkRgGx7w7B0tPdcWfmrPebYUZEfp+eEVBIzlb39EWle AFNkfP+uThA4ILOu92AZ+pbubJ0O+xafbiFUxOhNfYUAXf7oPKAfhJA1qcSDCEdI8nyr 7U61VnrjIgR8/JfD8owwgCl8nDyvO+4Bnb+GHOWW7qLL11tCwvS4Lmu3yL26LgBjxRWb huyA== X-Gm-Message-State: AOJu0YwYILnr+NQmCFKMAiVGowVUtwLCR50O+Ovf3WZ0soKxcTzJtzH/ HPmjeDpz3D5KjZhU3QnktBVMQa6UqURGQ7By9PcOa5jcMOt0qsVYLgIrRCWsmCoVpe38I0yAZGd /gZY086mLKq2/nHNeMtneZeOEFQrS8HRO3xQ= X-Google-Smtp-Source: AGHT+IFX0A2nfzKDxabH0h4lWrO3Yv/oQ68FSfD25YzDt7+g613J66jr376xwF+uqreP4iTlY+kfKk0HLYyMLulZ19A= X-Received: by 2002:a05:6402:34ca:b0:5be:eb9b:b72a with SMTP id 4fb4d7f45d1cf-5c08915b95dmr6326019a12.6.1724668303585; Mon, 26 Aug 2024 03:31:43 -0700 (PDT) MIME-Version: 1.0 From: Siraj G Date: Mon, 26 Aug 2024 16:01:32 +0530 Message-ID: Subject: Problem with a query To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000973a77062093a182" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000973a77062093a182 Content-Type: text/plain; charset="UTF-8" Hello! We have a couple of queries that all of a sudden became rather slow. I took explain analyze from one of the SQLs as bdlow. Can you please check and suggest if anything can be done? '-> Table scan on (actual time=0.019..71.526 rows=38622 loops=1)\n -> Aggregate using temporary table (actual time=33891741.611..33891815.749 rows=38622 loops=1)\n -> Nested loop inner join (cost=155705096.99 rows=0) (actual time=33872496.362..33891210.133 rows=38622 loops=1)\n -> Filter: (SES.IS_SERVER_ID <> (-(1))) (cost=371424.15 rows=1803523) (actual time=0.036..3921.142 rows=3651493 loops=1)\n -> Index scan on SES using IS_SESSION_IDX4 (cost=371424.15 rows=3607044) (actual time=0.034..3600.114 rows=3651493 loops=1)\n -> Index lookup on DST using (IS_SESSION_ID=SES.IS_SESSION_ID) (actual time=0.004..0.004 rows=0 loops=3651493)\n -> Materialize (cost=0.00..0.00 rows=0) (actual time=33886497.639..33886608.008 rows=38622 loops=1)\n -> Table scan on (actual time=0.018..51.715 rows=38622 loops=1)\n -> Aggregate using temporary table (actual time=33872191.430..33872246.080 rows=38622 loops=1)\n -> Nested loop left join (cost=1025850971.42 rows=1242668643) (actual time=910.618..33869299.956 rows=38622 loops=1)\n -> Nested loop left join (cost=124916205.44 rows=1242668643) (actual time=910.606..33868869.982 rows=38622 loops=1)\n -> Nested loop left join (cost=649328.22 rows=949) (actual time=21.155..4387.994 rows=38622 loops=1)\n -> Nested loop left join (cost=648884.46 rows=949) (actual time=21.144..4189.892 rows=38622 loops=1)\n -> Nested loop inner join (cost=648552.34 rows=949) (actual time=21.127..3847.460 rows=38622 loops=1)\n -> Inner hash join (MD.REP_ID = P.IS_REPOSITORY_ID) (cost=0.96 rows=0) (actual time=0.045..0.054 rows=1 loops=1)\n -> Table scan on MD (cost=7.00 rows=2) (actual time=0.007..0.013 rows=2 loops=1)\n -> Hash\n -> Nested loop inner join (cost=0.70 rows=0) (actual time=0.024..0.027 rows=1 loops=1)\n -> Filter: (LU.IS_PROJ_ID is not null) (cost=0.35 rows=1) (actual time=0.010..0.012 rows=1 loops=1)\n -> Table scan on LU (cost=0.35 rows=1) (actual time=0.009..0.011 rows=1 loops=1)\n -> Filter: (P.IS_PROJ_GUID = LU.IS_PROJ_GUID) (cost=0.26 rows=0) (actual time=0.014..0.014 rows=1 loops=1)\n -> Single-row index lookup on P using PRIMARY (IS_PROJ_ID=LU.IS_PROJ_ID) (cost=0.26 rows=1) (actual time=0.012..0.012 rows=1 loops=1)\n -> Filter: ((DS.REPOSITORYID = MD.REP_GUID) and (DS.PROJECTID = LU.IS_PROJ_GUID) and (DS.RECORDTIME >= LU.IS_WIN_BEGIN) and (DS.RECORDTIME < LU.IS_WIN_END)) (cost=11300581.57 rows=18978) (actual time=21.080..3837.717 rows=38622 loops=1)\n -> Index range scan on DS (re-planned for each iteration) (cost=11300581.57 rows=17084027) (actual time=21.071..3653.945 rows=39790 loops=1)\n -> Filter: (MD.REP_ID = U.IS_REPOSITORY_ID) (cost=0.25 rows=1) (actual time=0.008..0.008 rows=1 loops=38622)\n -> Single-row index lookup on U using EM_USER_PK (EM_USER_GUID=DS.USERID, IS_REPOSITORY_ID=MD.REP_ID) (cost=0.25 rows=1) (actual time=0.007..0.007 rows=1 loops=38622)\n -> Single-row index lookup on D using IS_DOC_PK (IS_DOC_GUID=DS.DOCUMENTID, IS_PROJ_ID=LU.IS_PROJ_ID) (cost=0.37 rows=1) (actual time=0.004..0.004 rows=1 loops=38622)\n -> Nested loop inner join (cost=23163414.56 rows=1309557) (actual time=714.186..876.817 rows=1 loops=38622)\n -> Table scan on LU1 (cost=0.01 rows=1) (actual time=0.007..0.011 rows=1 loops=38622)\n -> Filter: ((SS01.PROJECTID = LU1.IS_PROJ_GUID) and (SS01.SCHEDULEID = DS.JOBID) and (SS01.SESSIONID = DS.SESSIONID) and (SS01.RECORDTIME >= LU1.IS_WIN_BEGIN) and (SS01.RECORDTIME < LU1.IS_WIN_END)) (cost=24410.22 rows=1309557) (actual time=714.176..876.804 rows=1 loops=38622)\n -> Index lookup on SS01 using IS_SCHEDULE_STATS_IDX1 (SCHEDULETYPE=1) (cost=24410.22 rows=1309557) (actual time=0.035..522.644 rows=1360349 loops=38622)\n -> Index lookup on S using IS_SCHED_PK (IS_SCHED_GUID=SS01.TRIGGERID) (cost=0.63 rows=1) (actual time=0.009..0.010 rows=1 loops=38622)\n' Regards Siraj --000000000000973a77062093a182 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: base64 PGRpdiBkaXI9Imx0ciI+SGVsbG8hPGJyPjxkaXY+PGJyPjwvZGl2PjxkaXY+V2UgaGF2ZSBhIGNv dXBsZSBvZiBxdWVyaWVzIHRoYXQgYWxsIG9mIGEgc3VkZGVuIGJlY2FtZcKgcmF0aGVyIHNsb3cu IEkgdG9va8KgZXhwbGFpbiBhbmFseXplIGZyb20gb25lIG9mIHRoZSBTUUxzIGFzIGJkbG93LiBD YW4geW91IHBsZWFzZSBjaGVjayBhbmQgc3VnZ2VzdCBpZsKgYW55dGhpbmcgY2FuIGJlIGRvbmU/ PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj4mIzM5Oy0mZ3Q7IFRhYmxlIHNjYW4gb24gJmx0O3Rl bXBvcmFyeSZndDsgwqAoYWN0dWFsIHRpbWU9MC4wMTkuLjcxLjUyNiByb3dzPTM4NjIyIGxvb3Bz PTEpXG4gwqAgwqA8YnI+LSZndDsgQWdncmVnYXRlIHVzaW5nIHRlbXBvcmFyeSB0YWJsZSDCoChh Y3R1YWwgdGltZT0zMzg5MTc0MS42MTEuLjMzODkxODE1Ljc0OSByb3dzPTM4NjIyIGxvb3BzPTEp XG4gwqAgwqAgwqAgwqA8YnI+LSZndDsgTmVzdGVkIGxvb3AgaW5uZXIgam9pbiDCoChjb3N0PTE1 NTcwNTA5Ni45OSByb3dzPTApIChhY3R1YWwgdGltZT0zMzg3MjQ5Ni4zNjIuLjMzODkxMjEwLjEz MyByb3dzPTM4NjIyIGxvb3BzPTEpXG4gwqAgwqAgwqAgwqAgwqAgwqA8YnI+LSZndDsgRmlsdGVy OiAoU0VTLklTX1NFUlZFUl9JRCAmbHQ7Jmd0OyAmbHQ7Y2FjaGUmZ3Q7KC0oMSkpKSDCoChjb3N0 PTM3MTQyNC4xNSByb3dzPTE4MDM1MjMpIChhY3R1YWwgdGltZT0wLjAzNi4uMzkyMS4xNDIgcm93 cz0zNjUxNDkzIGxvb3BzPTEpXG4gwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA8YnI+LSZndDsgSW5k ZXggc2NhbiBvbiBTRVMgdXNpbmcgSVNfU0VTU0lPTl9JRFg0IMKgKGNvc3Q9MzcxNDI0LjE1IHJv d3M9MzYwNzA0NCkgKGFjdHVhbCB0aW1lPTAuMDM0Li4zNjAwLjExNCByb3dzPTM2NTE0OTMgbG9v cHM9MSlcbiDCoCDCoCDCoCDCoCDCoCDCoDxicj4tJmd0OyBJbmRleCBsb29rdXAgb24gRFNUIHVz aW5nICZsdDthdXRvX2tleTAmZ3Q7IChJU19TRVNTSU9OX0lEPVNFUy5JU19TRVNTSU9OX0lEKSDC oChhY3R1YWwgdGltZT0wLjAwNC4uMC4wMDQgcm93cz0wIGxvb3BzPTM2NTE0OTMpXG4gwqAgwqAg wqAgwqAgwqAgwqAgwqAgPGJyPi0mZ3Q7IE1hdGVyaWFsaXplIMKgKGNvc3Q9MC4wMC4uMC4wMCBy b3dzPTApIChhY3R1YWwgdGltZT0zMzg4NjQ5Ny42MzkuLjMzODg2NjA4LjAwOCByb3dzPTM4NjIy IGxvb3BzPTEpXG4gwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA8YnI+LSZndDsgVGFibGUg c2NhbiBvbiAmbHQ7dGVtcG9yYXJ5Jmd0OyDCoChhY3R1YWwgdGltZT0wLjAxOC4uNTEuNzE1IHJv d3M9Mzg2MjIgbG9vcHM9MSlcbiDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDxi cj4tJmd0OyBBZ2dyZWdhdGUgdXNpbmcgdGVtcG9yYXJ5IHRhYmxlIMKgKGFjdHVhbCB0aW1lPTMz ODcyMTkxLjQzMC4uMzM4NzIyNDYuMDgwIHJvd3M9Mzg2MjIgbG9vcHM9MSlcbiDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDxicj4tJmd0OyBOZXN0ZWQgbG9vcCBsZWZ0 IGpvaW4gwqAoY29zdD0xMDI1ODUwOTcxLjQyIHJvd3M9MTI0MjY2ODY0MykgKGFjdHVhbCB0aW1l PTkxMC42MTguLjMzODY5Mjk5Ljk1NiByb3dzPTM4NjIyIGxvb3BzPTEpXG4gwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA8YnI+LSZndDsgTmVzdGVkIGxvb3Ag bGVmdCBqb2luIMKgKGNvc3Q9MTI0OTE2MjA1LjQ0IHJvd3M9MTI0MjY2ODY0MykgKGFjdHVhbCB0 aW1lPTkxMC42MDYuLjMzODY4ODY5Ljk4MiByb3dzPTM4NjIyIGxvb3BzPTEpXG4gwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA8YnI+LSZndDsgTmVz dGVkIGxvb3AgbGVmdCBqb2luIMKgKGNvc3Q9NjQ5MzI4LjIyIHJvd3M9OTQ5KSAoYWN0dWFsIHRp bWU9MjEuMTU1Li40Mzg3Ljk5NCByb3dzPTM4NjIyIGxvb3BzPTEpXG4gwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA8YnI+LSZndDsgTmVz dGVkIGxvb3AgbGVmdCBqb2luIMKgKGNvc3Q9NjQ4ODg0LjQ2IHJvd3M9OTQ5KSAoYWN0dWFsIHRp bWU9MjEuMTQ0Li40MTg5Ljg5MiByb3dzPTM4NjIyIGxvb3BzPTEpXG4gwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgPGJyPi0mZ3Q7 IE5lc3RlZCBsb29wIGlubmVyIGpvaW4gwqAoY29zdD02NDg1NTIuMzQgcm93cz05NDkpIChhY3R1 YWwgdGltZT0yMS4xMjcuLjM4NDcuNDYwIHJvd3M9Mzg2MjIgbG9vcHM9MSlcbiDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoDxicj4tJmd0OyBJbm5lciBoYXNoIGpvaW4gKE1ELlJFUF9JRCA9IFAuSVNfUkVQT1NJVE9S WV9JRCkgwqAoY29zdD0wLjk2IHJvd3M9MCkgKGFjdHVhbCB0aW1lPTAuMDQ1Li4wLjA1NCByb3dz PTEgbG9vcHM9MSlcbiDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDxicj4tJmd0OyBUYWJsZSBzY2FuIG9u IE1EIMKgKGNvc3Q9Ny4wMCByb3dzPTIpIChhY3R1YWwgdGltZT0wLjAwNy4uMC4wMTMgcm93cz0y IGxvb3BzPTEpXG4gwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA8YnI+LSZndDsgSGFzaFxuIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgPGJyPi0mZ3Q7IE5lc3RlZCBsb29wIGlubmVyIGpvaW4gwqAoY29z dD0wLjcwIHJvd3M9MCkgKGFjdHVhbCB0aW1lPTAuMDI0Li4wLjAyNyByb3dzPTEgbG9vcHM9MSlc biDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDxicj4tJmd0OyBGaWx0ZXI6IChMVS5J U19QUk9KX0lEIGlzIG5vdCBudWxsKSDCoChjb3N0PTAuMzUgcm93cz0xKSAoYWN0dWFsIHRpbWU9 MC4wMTAuLjAuMDEyIHJvd3M9MSBsb29wcz0xKVxuIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgPGJyPi0mZ3Q7IFRhYmxlIHNjYW4gb24gTFUgwqAoY29zdD0wLjM1IHJvd3M9 MSkgKGFjdHVhbCB0aW1lPTAuMDA5Li4wLjAxMSByb3dzPTEgbG9vcHM9MSlcbiDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoDxicj4tJmd0OyBGaWx0ZXI6IChQLklTX1BST0pfR1VJRCA9 IExVLklTX1BST0pfR1VJRCkgwqAoY29zdD0wLjI2IHJvd3M9MCkgKGFjdHVhbCB0aW1lPTAuMDE0 Li4wLjAxNCByb3dzPTEgbG9vcHM9MSlcbiDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoDxicj4tJmd0OyBTaW5nbGUtcm93IGluZGV4IGxvb2t1cCBvbiBQIHVzaW5nIFBSSU1B UlkgKElTX1BST0pfSUQ9TFUuSVNfUFJPSl9JRCkgwqAoY29zdD0wLjI2IHJvd3M9MSkgKGFjdHVh bCB0aW1lPTAuMDEyLi4wLjAxMiByb3dzPTEgbG9vcHM9MSlcbiDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDxicj4t Jmd0OyBGaWx0ZXI6ICgoRFMuUkVQT1NJVE9SWUlEID0gTUQuUkVQX0dVSUQpIGFuZCAoRFMuUFJP SkVDVElEID0gTFUuSVNfUFJPSl9HVUlEKSBhbmQgKERTLlJFQ09SRFRJTUUgJmd0Oz0gTFUuSVNf V0lOX0JFR0lOKSBhbmQgKERTLlJFQ09SRFRJTUUgJmx0OyBMVS5JU19XSU5fRU5EKSkgwqAoY29z dD0xMTMwMDU4MS41NyByb3dzPTE4OTc4KSAoYWN0dWFsIHRpbWU9MjEuMDgwLi4zODM3LjcxNyBy b3dzPTM4NjIyIGxvb3BzPTEpXG4gwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA8YnI+LSZndDsgSW5kZXgg cmFuZ2Ugc2NhbiBvbiBEUyAocmUtcGxhbm5lZCBmb3IgZWFjaCBpdGVyYXRpb24pIMKgKGNvc3Q9 MTEzMDA1ODEuNTcgcm93cz0xNzA4NDAyNykgKGFjdHVhbCB0aW1lPTIxLjA3MS4uMzY1My45NDUg cm93cz0zOTc5MCBsb29wcz0xKVxuIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgPGJyPi0mZ3Q7IEZpbHRlcjogKE1ELlJFUF9J RCA9IFUuSVNfUkVQT1NJVE9SWV9JRCkgwqAoY29zdD0wLjI1IHJvd3M9MSkgKGFjdHVhbCB0aW1l PTAuMDA4Li4wLjAwOCByb3dzPTEgbG9vcHM9Mzg2MjIpXG4gwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA8YnI+LSZn dDsgU2luZ2xlLXJvdyBpbmRleCBsb29rdXAgb24gVSB1c2luZyBFTV9VU0VSX1BLIChFTV9VU0VS X0dVSUQ9RFMuVVNFUklELCBJU19SRVBPU0lUT1JZX0lEPU1ELlJFUF9JRCkgwqAoY29zdD0wLjI1 IHJvd3M9MSkgKGFjdHVhbCB0aW1lPTAuMDA3Li4wLjAwNyByb3dzPTEgbG9vcHM9Mzg2MjIpXG4g wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqA8YnI+LSZndDsgU2luZ2xlLXJvdyBpbmRleCBsb29rdXAgb24gRCB1c2luZyBJU19ET0NfUEsg KElTX0RPQ19HVUlEPURTLkRPQ1VNRU5USUQsIElTX1BST0pfSUQ9TFUuSVNfUFJPSl9JRCkgwqAo Y29zdD0wLjM3IHJvd3M9MSkgKGFjdHVhbCB0aW1lPTAuMDA0Li4wLjAwNCByb3dzPTEgbG9vcHM9 Mzg2MjIpXG4gwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqA8YnI+LSZndDsgTmVzdGVkIGxvb3AgaW5uZXIgam9pbiDCoChjb3N0PTIzMTYzNDE0LjU2 IHJvd3M9MTMwOTU1NykgKGFjdHVhbCB0aW1lPTcxNC4xODYuLjg3Ni44MTcgcm93cz0xIGxvb3Bz PTM4NjIyKVxuIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgPGJyPi0mZ3Q7IFRhYmxlIHNjYW4gb24gTFUxIMKgKGNvc3Q9MC4wMSByb3dz PTEpIChhY3R1YWwgdGltZT0wLjAwNy4uMC4wMTEgcm93cz0xIGxvb3BzPTM4NjIyKVxuIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgPGJy Pi0mZ3Q7IEZpbHRlcjogKChTUzAxLlBST0pFQ1RJRCA9IExVMS5JU19QUk9KX0dVSUQpIGFuZCAo U1MwMS5TQ0hFRFVMRUlEID0gRFMuSk9CSUQpIGFuZCAoU1MwMS5TRVNTSU9OSUQgPSBEUy5TRVNT SU9OSUQpIGFuZCAoU1MwMS5SRUNPUkRUSU1FICZndDs9IExVMS5JU19XSU5fQkVHSU4pIGFuZCAo U1MwMS5SRUNPUkRUSU1FICZsdDsgTFUxLklTX1dJTl9FTkQpKSDCoChjb3N0PTI0NDEwLjIyIHJv d3M9MTMwOTU1NykgKGFjdHVhbCB0aW1lPTcxNC4xNzYuLjg3Ni44MDQgcm93cz0xIGxvb3BzPTM4 NjIyKVxuIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgPGJyPi0mZ3Q7IEluZGV4IGxvb2t1cCBvbiBTUzAxIHVzaW5nIElTX1ND SEVEVUxFX1NUQVRTX0lEWDEgKFNDSEVEVUxFVFlQRT0xKSDCoChjb3N0PTI0NDEwLjIyIHJvd3M9 MTMwOTU1NykgKGFjdHVhbCB0aW1lPTAuMDM1Li41MjIuNjQ0IHJvd3M9MTM2MDM0OSBsb29wcz0z ODYyMilcbiDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDxi cj4tJmd0OyBJbmRleCBsb29rdXAgb24gUyB1c2luZyBJU19TQ0hFRF9QSyAoSVNfU0NIRURfR1VJ RD1TUzAxLlRSSUdHRVJJRCkgwqAoY29zdD0wLjYzIHJvd3M9MSkgKGFjdHVhbCB0aW1lPTAuMDA5 Li4wLjAxMCByb3dzPTEgbG9vcHM9Mzg2MjIpXG4mIzM5OzwvZGl2PjxkaXY+PGJyPjwvZGl2Pjxk aXY+UmVnYXJkczwvZGl2PjxkaXY+U2lyYWo8L2Rpdj48L2Rpdj4NCg== --000000000000973a77062093a182--