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 1svXhJ-00FpLB-Cj for pgsql-general@arkaria.postgresql.org; Tue, 01 Oct 2024 07:53:30 +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 1svXhH-00CZbi-FC for pgsql-general@arkaria.postgresql.org; Tue, 01 Oct 2024 07:53:27 +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 1svXhG-00CZba-PD for pgsql-general@lists.postgresql.org; Tue, 01 Oct 2024 07:53:27 +0000 Received: from mail-ed1-x531.google.com ([2a00:1450:4864:20::531]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1svXh9-001vKA-M1 for pgsql-general@lists.postgresql.org; Tue, 01 Oct 2024 07:53:25 +0000 Received: by mail-ed1-x531.google.com with SMTP id 4fb4d7f45d1cf-5c896b9b4e0so3067251a12.3 for ; Tue, 01 Oct 2024 00:53:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1727769197; x=1728373997; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=/G8Jj+zrMEWOTUBVZS0UvbKrYKJwcvHR769tTtApEA4=; b=RfbGiZnc8LkbHDiFuFRADV8q3hjIz1VDakBjCx1qcd2Jnb2bzVf4dN37MLAXZQwfYR Q/Xg3NjuwGYb31G+Vo+DEwDVyCQN6iUVRxFM0abAPPqUAP+FzTVzxA5rc8JDddBGRMzo h5+rpiXrl6pUwYDwPLATRF3Q1LrmDiMRq8Ccm3RHJSG4llkj/N+rWR6rPpB57ODk+Nt0 XdEoXax6o90MmoApvE4WMqTa97My+jJiJ6sY8xoafLi5JYEQmlduJ6Ld9ex61y/KyCq4 mfsR+6GMM3hnLTZtQHlxVPU9yd5J/uz2yvUG/dyKvzYahfU0J7vrep57JpvgB2dG4KuU vDmw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1727769197; x=1728373997; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=/G8Jj+zrMEWOTUBVZS0UvbKrYKJwcvHR769tTtApEA4=; b=u6OwdFREObwHI5yzreIyHARqIAulr5ofSngyOL7XGDww/NKzpSTMEGQ7mYNl8OCkv8 fGfMvFfs0YbHndn9a+ClPIiXfCazCAW+IJOkAiiLRy4W6YIrSHGsBlPKXf5KAHOTezoi XZ1UiE5KnYy1hT6JgzcxgxAQuZvSyx1RW8p6V8mydW4/6VMQ5piHIHGBKSG0LaX9VbyA tFU0lcu/lP+h4fjsr3gxvne5TNY9sDDFBtIiEQAF8HTe0JwcU8DP/D8Q4GIR7gvfWEMX Pe6/G1daaoeHBLxEwyIbja+TZV9QopUgOaH16KR7nq6vs1snrfgJlgbF8KEWKsVOYaQq UjUA== X-Gm-Message-State: AOJu0Ywjg3t0u4zm9fv/cndA/67SXVX5xhi8POUkdnXD+EZfCda4X41b tbhzQoXUUbjLs9vdCNLqEGYksVPd9eaVb20EGQUFbE+ayABIQ36ZppFojuw2v7u9wORQ+Q38JCA nrqF81BS8OdX1mOhsbbeQvMB02ytbJOxl X-Google-Smtp-Source: AGHT+IFAqqGXkiExmXxsZo8uPwgL6DaM3QC3eZJ/5e0C+3UtNrnUM6t+MlTD6LANr0p9tnTcEwv4GFxT+yKxOHq9XVE= X-Received: by 2002:a05:6402:210b:b0:5c4:2bd6:68df with SMTP id 4fb4d7f45d1cf-5c8824d371dmr14991093a12.2.1727769196758; Tue, 01 Oct 2024 00:53:16 -0700 (PDT) MIME-Version: 1.0 From: Siraj G Date: Tue, 1 Oct 2024 13:23:05 +0530 Message-ID: Subject: Help with query optimizer To: pgsql-general@lists.postgresql.org Content-Type: multipart/mixed; boundary="0000000000003a225e0623659d3c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003a225e0623659d3c Content-Type: multipart/alternative; boundary="0000000000003a225d0623659d3a" --0000000000003a225d0623659d3a Content-Type: text/plain; charset="UTF-8" Hello Experts! Can you please help with the attached query as it is taking time to execute. The execution plan for the same is below: Thank you! Nested Loop Left Join (cost=8176.99..168603.11 rows=1 width=294) (actual time=3301.886..3303.715 rows=0 loops=1) Join Filter: (conversation.id = "jobReminders"."conversationId") Buffers: shared hit=743696 read=78069 dirtied=16 written=10 I/O Timings: shared read=7224.068 write=0.287 -> Gather (cost=8176.99..168472.90 rows=1 width=246) (actual time=3301.885..3303.711 rows=0 loops=1) Workers Planned: 2 Workers Launched: 2 Buffers: shared hit=743696 read=78069 dirtied=16 written=10 I/O Timings: shared read=7224.068 write=0.287 -> Nested Loop (cost=7176.99..167472.80 rows=1 width=246) (actual time=3286.866..3286.874 rows=0 loops=3) Buffers: shared hit=743696 read=78069 dirtied=16 written=10 I/O Timings: shared read=7224.068 write=0.287 -> Nested Loop (cost=7176.56..61685.83 rows=59320 width=174) (actual time=68.447..1978.593 rows=57917 loops=3) Buffers: shared hit=284214 read=56135 dirtied=11 written=9 I/O Timings: shared read=4546.889 write=0.242 -> Hash Join (cost=7176.13..20450.20 rows=15571 width=142) (actual time=68.196..211.016 rows=17903 loops=3) Hash Cond: (conversation."mailBoxId" = "mailBox".id) Buffers: shared hit=7428 read=11254 dirtied=9 written=3 I/O Timings: shared read=85.214 write=0.085 -> Parallel Hash Join (cost=6944.87..20143.53 rows=26942 width=118) (actual time=67.736..197.476 rows=21937 loops=3) Hash Cond: (conversation."taskId" = task.id ) Buffers: shared hit=6678 read=11254 dirtied=9 written=3 I/O Timings: shared read=85.214 write=0.085 -> Parallel Seq Scan on conversations conversation (cost=0.00..13029.34 rows=64502 width=102) (actual time=0.017..79.191 rows=51677 loops=3) Filter: ((NOT "isCompose") AND ("parentConversationId" IS NULL) AND (id <> '559702f9-55a8-47c7-9b5c-93b29baabf3d'::uuid)) Rows Removed by Filter: 622 Buffers: shared hit=3605 read=8608 dirtied=5 written=3 I/O Timings: shared read=57.862 write=0.085 -> Parallel Hash (cost=6583.67..6583.67 rows=28896 width=16) (actual time=67.046..67.047 rows=22266 loops=3) Buckets: 131072 Batches: 1 Memory Usage: 4224kB Buffers: shared hit=3073 read=2646 dirtied=4 I/O Timings: shared read=27.352 -> Parallel Seq Scan on tasks task (cost=0.00..6583.67 rows=28896 width=16) (actual time=0.015..48.469 rows=22266 loops=3) Filter: (("deletedAt" IS NULL) AND (type = 'MESSAGE'::enum_tasks_type)) Rows Removed by Filter: 32166 Buffers: shared hit=3073 read=2646 dirtied=4 I/O Timings: shared read=27.352 -> Hash (cost=230.80..230.80 rows=37 width=24) (actual time=0.382..0.383 rows=37 loops=3) Buckets: 1024 Batches: 1 Memory Usage: 11kB Buffers: shared hit=690 -> Seq Scan on "mailBoxes" "mailBox" (cost=0.00..230.80 rows=37 width=24) (actual time=0.021..0.367 rows=37 loops=3) Filter: (status = ANY ('{ACTIVE,SYNCING}'::"enum_mailBoxes_status"[])) Rows Removed by Filter: 27 Buffers: shared hit=690 -> Index Scan using idx_message_fk_conversation_id on messages (cost=0.42..2.53 rows=12 width=48) (actual time=0.035..0.096 rows=3 loops=53708) Index Cond: ("conversationId" = conversation.id) Buffers: shared hit=276786 read=44881 dirtied=2 written=6 I/O Timings: shared read=4461.675 write=0.156 -> Index Scan using "mailMessages_pkey" on "mailMessages" "messages->mailMessage" (cost=0.43..1.78 rows=1 width=88) (actual time=0.022..0.022 rows=0 loops=173750) Index Cond: (id = messages."mailMessageId") Filter: (("mailId")::text = '< CAMWt+ZZk_vSuuRU7Wzw76wh4JQLd2i3ZKh7h2+ES4jsjMHsYJQ@mail.gmail.com>'::text) Rows Removed by Filter: 1 Buffers: shared hit=459482 read=21934 dirtied=5 written=1 I/O Timings: shared read=2677.179 write=0.045 -> Seq Scan on "jobReminders" (cost=0.00..129.90 rows=25 width=48) (never executed) Filter: (status = 'PENDING'::"enum_jobReminders_status") Planning: Buffers: shared hit=105 read=1 I/O Timings: shared read=0.010 Planning Time: 2.250 ms Execution Time: 3303.810 ms (61 rows) --0000000000003a225d0623659d3a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: base64 PGRpdiBkaXI9Imx0ciI+SGVsbG8gRXhwZXJ0cyE8ZGl2Pjxicj48L2Rpdj48ZGl2PkNhbiB5b3Ug cGxlYXNlIGhlbHAgd2l0aCB0aGUgYXR0YWNoZWQgcXVlcnkgYXMgaXQgaXMgdGFraW5nIHRpbWUg dG8gZXhlY3V0ZS4gVGhlIGV4ZWN1dGlvbiBwbGFuIGZvciB0aGUgc2FtZSBpcyBiZWxvdzo8L2Rp dj48ZGl2PlRoYW5rIHlvdSE8L2Rpdj48ZGl2Pjxicj48ZGl2Pk5lc3RlZCBMb29wIExlZnQgSm9p biDCoChjb3N0PTgxNzYuOTkuLjE2ODYwMy4xMSByb3dzPTEgd2lkdGg9Mjk0KSAoYWN0dWFsIHRp bWU9MzMwMS44ODYuLjMzMDMuNzE1IHJvd3M9MCBsb29wcz0xKTxicj7CoCDCoEpvaW4gRmlsdGVy OiAoPGEgaHJlZj0iaHR0cDovL2NvbnZlcnNhdGlvbi5pZCI+Y29udmVyc2F0aW9uLmlkPC9hPiA9 ICZxdW90O2pvYlJlbWluZGVycyZxdW90Oy4mcXVvdDtjb252ZXJzYXRpb25JZCZxdW90Oyk8YnI+ wqAgwqBCdWZmZXJzOiBzaGFyZWQgaGl0PTc0MzY5NiByZWFkPTc4MDY5IGRpcnRpZWQ9MTYgd3Jp dHRlbj0xMDxicj7CoCDCoEkvTyBUaW1pbmdzOiBzaGFyZWQgcmVhZD03MjI0LjA2OCB3cml0ZT0w LjI4Nzxicj7CoCDCoC0mZ3Q7IMKgR2F0aGVyIMKgKGNvc3Q9ODE3Ni45OS4uMTY4NDcyLjkwIHJv d3M9MSB3aWR0aD0yNDYpIChhY3R1YWwgdGltZT0zMzAxLjg4NS4uMzMwMy43MTEgcm93cz0wIGxv b3BzPTEpPGJyPsKgIMKgIMKgIMKgIMKgV29ya2VycyBQbGFubmVkOiAyPGJyPsKgIMKgIMKgIMKg IMKgV29ya2VycyBMYXVuY2hlZDogMjxicj7CoCDCoCDCoCDCoCDCoEJ1ZmZlcnM6IHNoYXJlZCBo aXQ9NzQzNjk2IHJlYWQ9NzgwNjkgZGlydGllZD0xNiB3cml0dGVuPTEwPGJyPsKgIMKgIMKgIMKg IMKgSS9PIFRpbWluZ3M6IHNoYXJlZCByZWFkPTcyMjQuMDY4IHdyaXRlPTAuMjg3PGJyPsKgIMKg IMKgIMKgIMKgLSZndDsgwqBOZXN0ZWQgTG9vcCDCoChjb3N0PTcxNzYuOTkuLjE2NzQ3Mi44MCBy b3dzPTEgd2lkdGg9MjQ2KSAoYWN0dWFsIHRpbWU9MzI4Ni44NjYuLjMyODYuODc0IHJvd3M9MCBs b29wcz0zKTxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9NzQz Njk2IHJlYWQ9NzgwNjkgZGlydGllZD0xNiB3cml0dGVuPTEwPGJyPsKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgSS9PIFRpbWluZ3M6IHNoYXJlZCByZWFkPTcyMjQuMDY4IHdyaXRlPTAuMjg3PGJyPsKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgLSZndDsgwqBOZXN0ZWQgTG9vcCDCoChjb3N0PTcxNzYuNTYu LjYxNjg1LjgzIHJvd3M9NTkzMjAgd2lkdGg9MTc0KSAoYWN0dWFsIHRpbWU9NjguNDQ3Li4xOTc4 LjU5MyByb3dzPTU3OTE3IGxvb3BzPTMpPGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgQnVmZmVyczogc2hhcmVkIGhpdD0yODQyMTQgcmVhZD01NjEzNSBkaXJ0aWVkPTExIHdyaXR0 ZW49OTxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoEkvTyBUaW1pbmdzOiBzaGFy ZWQgcmVhZD00NTQ2Ljg4OSB3cml0ZT0wLjI0Mjxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoC0mZ3Q7IMKgSGFzaCBKb2luIMKgKGNvc3Q9NzE3Ni4xMy4uMjA0NTAuMjAgcm93cz0x NTU3MSB3aWR0aD0xNDIpIChhY3R1YWwgdGltZT02OC4xOTYuLjIxMS4wMTYgcm93cz0xNzkwMyBs b29wcz0zKTxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoEhhc2gg Q29uZDogKGNvbnZlcnNhdGlvbi4mcXVvdDttYWlsQm94SWQmcXVvdDsgPSAmcXVvdDttYWlsQm94 JnF1b3Q7LmlkKTxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoEJ1 ZmZlcnM6IHNoYXJlZCBoaXQ9NzQyOCByZWFkPTExMjU0IGRpcnRpZWQ9OSB3cml0dGVuPTM8YnI+ wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqBJL08gVGltaW5nczogc2hh cmVkIHJlYWQ9ODUuMjE0IHdyaXRlPTAuMDg1PGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgLSZndDsgwqBQYXJhbGxlbCBIYXNoIEpvaW4gwqAoY29zdD02OTQ0Ljg3 Li4yMDE0My41MyByb3dzPTI2OTQyIHdpZHRoPTExOCkgKGFjdHVhbCB0aW1lPTY3LjczNi4uMTk3 LjQ3NiByb3dzPTIxOTM3IGxvb3BzPTMpPGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgSGFzaCBDb25kOiAoY29udmVyc2F0aW9uLiZxdW90O3Rhc2tJ ZCZxdW90OyA9IDxhIGhyZWY9Imh0dHA6Ly90YXNrLmlkIj50YXNrLmlkPC9hPik8YnI+wqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqBCdWZmZXJzOiBzaGFy ZWQgaGl0PTY2NzggcmVhZD0xMTI1NCBkaXJ0aWVkPTkgd3JpdHRlbj0zPGJyPsKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgSS9PIFRpbWluZ3M6IHNoYXJl ZCByZWFkPTg1LjIxNCB3cml0ZT0wLjA4NTxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoC0mZ3Q7IMKgUGFyYWxsZWwgU2VxIFNjYW4gb24gY29udmVy c2F0aW9ucyBjb252ZXJzYXRpb24gwqAoY29zdD0wLjAwLi4xMzAyOS4zNCByb3dzPTY0NTAyIHdp ZHRoPTEwMikgKGFjdHVhbCB0aW1lPTAuMDE3Li43OS4xOTEgcm93cz01MTY3NyBsb29wcz0zKTxi cj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoEZpbHRlcjogKChOT1QgJnF1b3Q7aXNDb21wb3NlJnF1b3Q7KSBBTkQgKCZxdW90O3BhcmVu dENvbnZlcnNhdGlvbklkJnF1b3Q7IElTIE5VTEwpIEFORCAoaWQgJmx0OyZndDsgJiMzOTs1NTk3 MDJmOS01NWE4LTQ3YzctOWI1Yy05M2IyOWJhYWJmM2QmIzM5Ozo6dXVpZCkpPGJyPsKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgUm93cyBS ZW1vdmVkIGJ5IEZpbHRlcjogNjIyPGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgQnVmZmVyczogc2hhcmVkIGhpdD0zNjA1IHJlYWQ9 ODYwOCBkaXJ0aWVkPTUgd3JpdHRlbj0zPGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgSS9PIFRpbWluZ3M6IHNoYXJlZCByZWFkPTU3 Ljg2MiB3cml0ZT0wLjA4NTxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoC0mZ3Q7IMKgUGFyYWxsZWwgSGFzaCDCoChjb3N0PTY1ODMuNjcuLjY1ODMu Njcgcm93cz0yODg5NiB3aWR0aD0xNikgKGFjdHVhbCB0aW1lPTY3LjA0Ni4uNjcuMDQ3IHJvd3M9 MjIyNjYgbG9vcHM9Myk8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqBCdWNrZXRzOiAxMzEwNzIgwqBCYXRjaGVzOiAxIMKgTWVtb3J5 IFVzYWdlOiA0MjI0a0I8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqBCdWZmZXJzOiBzaGFyZWQgaGl0PTMwNzMgcmVhZD0yNjQ2IGRp cnRpZWQ9NDxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoEkvTyBUaW1pbmdzOiBzaGFyZWQgcmVhZD0yNy4zNTI8YnI+wqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAtJmd0OyDC oFBhcmFsbGVsIFNlcSBTY2FuIG9uIHRhc2tzIHRhc2sgwqAoY29zdD0wLjAwLi42NTgzLjY3IHJv d3M9Mjg4OTYgd2lkdGg9MTYpIChhY3R1YWwgdGltZT0wLjAxNS4uNDguNDY5IHJvd3M9MjIyNjYg bG9vcHM9Myk8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqBGaWx0ZXI6ICgoJnF1b3Q7ZGVsZXRlZEF0JnF1b3Q7IElT IE5VTEwpIEFORCAodHlwZSA9ICYjMzk7TUVTU0FHRSYjMzk7OjplbnVtX3Rhc2tzX3R5cGUpKTxi cj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6IDMyMTY2PGJyPsKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg QnVmZmVyczogc2hhcmVkIGhpdD0zMDczIHJlYWQ9MjY0NiBkaXJ0aWVkPTQ8YnI+wqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqBJL08gVGltaW5nczogc2hhcmVkIHJlYWQ9MjcuMzUyPGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgLSZndDsgwqBIYXNoIMKgKGNvc3Q9MjMwLjgwLi4yMzAuODAg cm93cz0zNyB3aWR0aD0yNCkgKGFjdHVhbCB0aW1lPTAuMzgyLi4wLjM4MyByb3dzPTM3IGxvb3Bz PTMpPGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg QnVja2V0czogMTAyNCDCoEJhdGNoZXM6IDEgwqBNZW1vcnkgVXNhZ2U6IDExa0I8YnI+wqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqBCdWZmZXJzOiBzaGFy ZWQgaGl0PTY5MDxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoC0mZ3Q7IMKgU2VxIFNjYW4gb24gJnF1b3Q7bWFpbEJveGVzJnF1b3Q7ICZxdW90O21h aWxCb3gmcXVvdDsgwqAoY29zdD0wLjAwLi4yMzAuODAgcm93cz0zNyB3aWR0aD0yNCkgKGFjdHVh bCB0aW1lPTAuMDIxLi4wLjM2NyByb3dzPTM3IGxvb3BzPTMpPGJyPsKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgRmlsdGVyOiAoc3RhdHVz ID0gQU5ZICgmIzM5O3tBQ1RJVkUsU1lOQ0lOR30mIzM5Ozo6JnF1b3Q7ZW51bV9tYWlsQm94ZXNf c3RhdHVzJnF1b3Q7W10pKTxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6IDI3PGJyPsKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgQnVm ZmVyczogc2hhcmVkIGhpdD02OTA8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAt Jmd0OyDCoEluZGV4IFNjYW4gdXNpbmcgaWR4X21lc3NhZ2VfZmtfY29udmVyc2F0aW9uX2lkIG9u IG1lc3NhZ2VzIMKgKGNvc3Q9MC40Mi4uMi41MyByb3dzPTEyIHdpZHRoPTQ4KSAoYWN0dWFsIHRp bWU9MC4wMzUuLjAuMDk2IHJvd3M9MyBsb29wcz01MzcwOCk8YnI+wqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqBJbmRleCBDb25kOiAoJnF1b3Q7Y29udmVyc2F0aW9uSWQm cXVvdDsgPSA8YSBocmVmPSJodHRwOi8vY29udmVyc2F0aW9uLmlkIj5jb252ZXJzYXRpb24uaWQ8 L2E+KTxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoEJ1ZmZlcnM6 IHNoYXJlZCBoaXQ9Mjc2Nzg2IHJlYWQ9NDQ4ODEgZGlydGllZD0yIHdyaXR0ZW49Njxicj7CoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoEkvTyBUaW1pbmdzOiBzaGFyZWQg cmVhZD00NDYxLjY3NSB3cml0ZT0wLjE1Njxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoC0mZ3Q7 IMKgSW5kZXggU2NhbiB1c2luZyAmcXVvdDttYWlsTWVzc2FnZXNfcGtleSZxdW90OyBvbiAmcXVv dDttYWlsTWVzc2FnZXMmcXVvdDsgJnF1b3Q7bWVzc2FnZXMtJmd0O21haWxNZXNzYWdlJnF1b3Q7 IMKgKGNvc3Q9MC40My4uMS43OCByb3dzPTEgd2lkdGg9ODgpIChhY3R1YWwgdGltZT0wLjAyMi4u MC4wMjIgcm93cz0wIGxvb3BzPTE3Mzc1MCk8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqBJbmRleCBDb25kOiAoaWQgPSBtZXNzYWdlcy4mcXVvdDttYWlsTWVzc2FnZUlkJnF1b3Q7 KTxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoEZpbHRlcjogKCgmcXVvdDttYWls SWQmcXVvdDspOjp0ZXh0ID0gJiMzOTsmbHQ7PGEgaHJlZj0ibWFpbHRvOkNBTVd0JTJCWlprX3ZT dXVSVTdXenc3NndoNEpRTGQyaTNaS2g3aDIlMkJFUzRqc2pNSHNZSlFAbWFpbC5nbWFpbC5jb20i PkNBTVd0K1paa192U3V1UlU3V3p3NzZ3aDRKUUxkMmkzWktoN2gyK0VTNGpzak1Ic1lKUUBtYWls LmdtYWlsLmNvbTwvYT4mZ3Q7JiMzOTs6OnRleHQpPGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgUm93cyBSZW1vdmVkIGJ5IEZpbHRlcjogMTxicj7CoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9NDU5NDgyIHJlYWQ9MjE5MzQgZGlydGll ZD01IHdyaXR0ZW49MTxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoEkvTyBUaW1p bmdzOiBzaGFyZWQgcmVhZD0yNjc3LjE3OSB3cml0ZT0wLjA0NTxicj7CoCDCoC0mZ3Q7IMKgU2Vx IFNjYW4gb24gJnF1b3Q7am9iUmVtaW5kZXJzJnF1b3Q7IMKgKGNvc3Q9MC4wMC4uMTI5LjkwIHJv d3M9MjUgd2lkdGg9NDgpIChuZXZlciBleGVjdXRlZCk8YnI+wqAgwqAgwqAgwqAgwqBGaWx0ZXI6 IChzdGF0dXMgPSAmIzM5O1BFTkRJTkcmIzM5Ozo6JnF1b3Q7ZW51bV9qb2JSZW1pbmRlcnNfc3Rh dHVzJnF1b3Q7KTxicj7CoFBsYW5uaW5nOjxicj7CoCDCoEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9MTA1 IHJlYWQ9MTxicj7CoCDCoEkvTyBUaW1pbmdzOiBzaGFyZWQgcmVhZD0wLjAxMDxicj7CoFBsYW5u aW5nIFRpbWU6IDIuMjUwIG1zPGJyPsKgRXhlY3V0aW9uIFRpbWU6IDMzMDMuODEwIG1zPGJyPig2 MSByb3dzKTxicj48L2Rpdj48L2Rpdj48L2Rpdj4NCg== --0000000000003a225d0623659d3a-- --0000000000003a225e0623659d3c Content-Type: application/octet-stream; name=query1 Content-Disposition: attachment; filename=query1 Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_m1q55qy20 U0VMRUNUICJjb252ZXJzYXRpb24iLiJpZCIsICJjb252ZXJzYXRpb24iLiJtYWlsQm94SWQiLCAi Y29udmVyc2F0aW9uIi4iY3JlYXRlZEZyb20iLA0KICAgICAgICJjb252ZXJzYXRpb24iLiJ0YXNr SWQiLCAiY29udmVyc2F0aW9uIi4ic3RhdHVzIiwNCiAgICAgICAiY29udmVyc2F0aW9uIi4iY29u dmVyc2F0aW9uVHlwZSIsImNvbnZlcnNhdGlvbiIuInRpY2tldElkIiwNCiAgICAgICAiY29udmVy c2F0aW9uIi4iaXNEcmFmdCIsICJjb252ZXJzYXRpb24iLiJsYXN0U3VtbWFyeVVwZGF0ZWRBdCIs DQogICAgICAgImNvbnZlcnNhdGlvbiIuImlzQ29tcG9zZSIsICJjb252ZXJzYXRpb24iLiJwYXJl bnRDb252ZXJzYXRpb25JZCIsDQogICAgICAgIm1lc3NhZ2VzIi4iaWQiIEFTICJtZXNzYWdlcy5p ZCIsICJtZXNzYWdlcy0+bWFpbE1lc3NhZ2UiLiJpZCIgQVMgIm1lc3NhZ2VzLm1haWxNZXNzYWdl LmlkIiwNCiAgICAgICAibWVzc2FnZXMtPm1haWxNZXNzYWdlIi4ibWFpbElkIiBBUyAibWVzc2Fn ZXMubWFpbE1lc3NhZ2UubWFpbElkIiwgInRhc2siLiJpZCIgQVMgInRhc2suaWQiLA0KICAgICAg ICJqb2JSZW1pbmRlcnMiLiJpZCIgQVMgImpvYlJlbWluZGVycy5pZCIsICJqb2JSZW1pbmRlcnMi LiJ0YXNrSWQiIEFTICJqb2JSZW1pbmRlcnMudGFza0lkIiwNCiAgICAgICAiam9iUmVtaW5kZXJz Ii4iY29udmVyc2F0aW9uSWQiIEFTICJqb2JSZW1pbmRlcnMuY29udmVyc2F0aW9uSWQiLA0KICAg ICAgICJtYWlsQm94Ii4iaWQiIEFTICJtYWlsQm94LmlkIiwNCiAgICAgICAibWFpbEJveCIuInBy b3ZpZGVyIiBBUyAibWFpbEJveC5wcm92aWRlciIsDQogICAgICAgIm1haWxCb3giLiJzdGF0dXMi IEFTICJtYWlsQm94LnN0YXR1cyINCkZST00gImNvbnZlcnNhdGlvbnMiIEFTICJjb252ZXJzYXRp b24iDQogICAgSU5ORVIgSk9JTiAibWVzc2FnZXMiIEFTICJtZXNzYWdlcyINCiAgICAgICAgT04g ImNvbnZlcnNhdGlvbiIuImlkIiA9ICJtZXNzYWdlcyIuImNvbnZlcnNhdGlvbklkIg0KICAgIElO TkVSIEpPSU4gIm1haWxNZXNzYWdlcyIgQVMgIm1lc3NhZ2VzLT5tYWlsTWVzc2FnZSINCiAgICAg ICAgT04gIm1lc3NhZ2VzIi4ibWFpbE1lc3NhZ2VJZCIgPSAibWVzc2FnZXMtPm1haWxNZXNzYWdl Ii4iaWQiDQogICAgICAgICAgIEFORCAibWVzc2FnZXMtPm1haWxNZXNzYWdlIi4ibWFpbElkIiBJ TiAoICc8Q0FNV3QrWlprX3ZTdXVSVTdXenc3NndoNEpRTGQyaTNaS2g3aDIrRVM0anNqTUhzWUpR QG1haWwuZ21haWwuY29tPicgKQ0KICAgIElOTkVSIEpPSU4gInRhc2tzIiBBUyAidGFzayINCiAg ICAgICAgT04gImNvbnZlcnNhdGlvbiIuInRhc2tJZCIgPSAidGFzayIuImlkIg0KICAgICAgICAg ICBBTkQgKA0KICAgICAgICAgICAgICAgICAgICJ0YXNrIi4iZGVsZXRlZEF0IiBJUyBOVUxMDQog ICAgICAgICAgICAgICAgICAgQU5EICJ0YXNrIi4idHlwZSIgPSAnTUVTU0FHRScNCiAgICAgICAg ICAgICAgICkNCiAgICBMRUZUIE9VVEVSIEpPSU4gImpvYlJlbWluZGVycyIgQVMgImpvYlJlbWlu ZGVycyINCiAgICAgICAgT04gImNvbnZlcnNhdGlvbiIuImlkIiA9ICJqb2JSZW1pbmRlcnMiLiJj b252ZXJzYXRpb25JZCINCiAgICAgICAgICAgQU5EICJqb2JSZW1pbmRlcnMiLiJzdGF0dXMiIElO ICggJ1BFTkRJTkcnICkNCiAgICBJTk5FUiBKT0lOICJtYWlsQm94ZXMiIEFTICJtYWlsQm94Ig0K ICAgICAgICBPTiAiY29udmVyc2F0aW9uIi4ibWFpbEJveElkIiA9ICJtYWlsQm94Ii4iaWQiDQog ICAgICAgICAgIEFORCAibWFpbEJveCIuInN0YXR1cyIgSU4gKCAnQUNUSVZFJywgJ1NZTkNJTkcn ICkNCldIRVJFICJjb252ZXJzYXRpb24iLiJpc0NvbXBvc2UiID0gZmFsc2UNCiAgICAgIEFORCAi Y29udmVyc2F0aW9uIi4icGFyZW50Q29udmVyc2F0aW9uSWQiIElTIE5VTEwNCiAgICAgIEFORCAi Y29udmVyc2F0aW9uIi4iaWQiIE5PVCBJTiAoICc1NTk3MDJmOS01NWE4LTQ3YzctOWI1Yy05M2Iy OWJhYWJmM2QnICk7 --0000000000003a225e0623659d3c--