Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YXqK7-0001la-1w for pgsql-performance@arkaria.postgresql.org; Tue, 17 Mar 2015 12:10:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YXqK5-0003uQ-Vq for pgsql-performance@arkaria.postgresql.org; Tue, 17 Mar 2015 12:10:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YXqK4-0003tv-QY for pgsql-performance@postgresql.org; Tue, 17 Mar 2015 12:10:12 +0000 Received: from mail-oi0-x22b.google.com ([2607:f8b0:4003:c06::22b]) by magus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YXqJw-0006LW-K4 for pgsql-performance@postgresql.org; Tue, 17 Mar 2015 12:10:11 +0000 Received: by oibu204 with SMTP id u204so6141492oib.0 for ; Tue, 17 Mar 2015 05:10:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zetainteractive.com; s=google; h=reply-to:from:references:in-reply-to:mime-version:thread-index:date :message-id:subject:to:cc:content-type; bh=gWXRbAFLN3QGguzTd/V6IZKmtK+oFBXIIO2i5aSmKmU=; b=c9jTamzIMMjOAZjrqnKCkQVZmafOeamg2VXLnNf56Kb/+51vJkOqjjewpgobeVEI+4 2EPz/p443cOaQtfG2sn17ExNzf9PkV3Z7BWdlX5WKMNj+0oIttSVmcVKCterrhLBL6Ev pDzmgEW4t789Z1eh0s1Soxc8ITooZ+JdjVta4= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:reply-to:from:references:in-reply-to :mime-version:thread-index:date:message-id:subject:to:cc :content-type; bh=gWXRbAFLN3QGguzTd/V6IZKmtK+oFBXIIO2i5aSmKmU=; b=CC/i4QHb7xP7X6HlygJOiKvzrFS4/CaiZyQWYUWu1FCNHda3avnvFibwWJvDEJGbc1 +JhyyYlMVx+HVIjtS+l1qPsVgFjJX3uePtmoFDxZudp97y6jroomFCruvhMncdWilZ+Z TlNfB3N0vhObNZk7hxTijou2ysWxQKQZRWr4ODRLl0K1HRJQrgy4ZVkfXHGiaJ7nYYOu H2jXqZzZ7juBqGT1MWVk64wzTBabMr0uENN3BllPZIPf6yrjs60sG0Ny3GPbABjf85qF q62KSAtDDMkfZpnvvPt9KzGRMM9jxxvO4DlE1MvA3PGAOTBRH9GZoovNSuBohop2wtiE QjBg== X-Gm-Message-State: ALoCoQmaj/fFewNIy3PyAqKaVv5fh3By2+E/cwPINSQLlhc3gkriQ7HTfXrDZ+EcB1NgCzrhSU8p X-Received: by 10.182.42.133 with SMTP id o5mr52454125obl.36.1426594202650; Tue, 17 Mar 2015 05:10:02 -0700 (PDT) Reply-To: From: Vivekanand Joshi References: <84a6fe4be04c3ef0a714851977860ac8@mail.gmail.com> <160b8780d89add7f23c4eb9c3debb99d@mail.gmail.com> <55034A48.4040409@2ndquadrant.com> <849e75d9463938372dd4c516f5c5d89c@mail.gmail.com> <55037CEA.5050906@2ndquadrant.com> <55073272.20209@BlueTreble.com> <55074424.9050506@2ndquadrant.com> <55076FFB.9090105@BlueTreble.com> c5231342781287ff8cbc9ac1f20ff036@mail.gmail.com <61a7a27428e588411e8ac1817043205c@mail.gmail.com> <550813CD.7040605@2ndquadrant.com> d6a86358c5e8d7ffe923ff307c3e8c7e@mail.gmail.com In-Reply-To: d6a86358c5e8d7ffe923ff307c3e8c7e@mail.gmail.com MIME-Version: 1.0 X-Mailer: Microsoft Outlook 15.0 thread-index: AQGXPdRf3VxuG24kJ8WwflsQcHnAgQJFdAGLAd7f+TAB3+I8LgHxOMQ4AZdEQFACZq94KAEoF2rjAunz58UBLhBnRQIZ3EmNAZo17EoBofTzdgDeIilzApfZn0sB7x5cEJyzYK/wgAAFHgA= Date: Tue, 17 Mar 2015 17:40:01 +0530 Message-ID: Subject: Re: Performance issues To: vjoshi@zetainteractive.com, Tomas Vondra , Jim Nasby , Scott Marlowe , Varadharajan Mukundan Cc: pgsql-performance@postgresql.org Content-Type: multipart/mixed; boundary=001a11c2df7cb0524f05117ad83c X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --001a11c2df7cb0524f05117ad83c Content-Type: text/plain; charset=UTF-8 Attaching explain analyze file as well. Vivek -----Original Message----- From: Vivekanand Joshi [mailto:vjoshi@zetainteractive.com] Sent: Tuesday, March 17, 2015 5:36 PM To: 'Tomas Vondra'; 'Jim Nasby'; 'Scott Marlowe'; 'Varadharajan Mukundan' Cc: 'pgsql-performance@postgresql.org' Subject: RE: [PERFORM] Performance issues Hi Tomas, This is what I am getting, EXPLAIN ANALYZE SELECT * FROM s_f_promotion_history WHERE (send_dt >= '2014-03-13 00:00:00'); QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------- Seq Scan on s_f_promotion_history (cost=0.00..283333.66 rows=1 width=74) (actual time=711.023..1136.393 rows=1338 loops=1) Filter: ((send_dt >= '2014-03-13 00:00:00'::timestamp without time zone) AND (send_dt <= '2015-03-14 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 9998662 Total runtime: 1170.682 ms CREATE INDEX idx_pr_history ON S_F_PROMOTION_HISTORY(touchpoint_execution_id, send_dt); After Creating Index: QUERY PLAN ----------------------------------------------------------------------------------------------------------------------------------------------------- Index Scan using idx_pr_history on s_f_promotion_history (cost=0.43..254028.45 rows=1 width=74) (actual time=375.796..604.587 rows=1338 loops=1) Index Cond: ((send_dt >= '2014-03-13 00:00:00'::timestamp without time zone) AND (send_dt <= '2015-03-14 00:00:00'::timestamp without time zone)) Total runtime: 604.733 ms The query I gave you is the smallest query, it is using two views and both the views I have changed by using subqueries instead of CTEs. When I join these two views, it is not getting completed at all. Explain analyze plan for view s_v_f_promotion_history_email: http://explain.depesz.com/s/ure Explain analyze plan for view s_v_d_campaign_hierarchy : http://explain.depesz.com/s/WxI Regards, Vivek -----Original Message----- From: Tomas Vondra [mailto:tomas.vondra@2ndquadrant.com] Sent: Tuesday, March 17, 2015 5:15 PM To: vjoshi@zetainteractive.com; Jim Nasby; Scott Marlowe; Varadharajan Mukundan Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Performance issues On 17.3.2015 12:07, Vivekanand Joshi wrote: > EXPLAIN ANALYZE didn't give result even after three hours. In that case the only thing you can do is 'slice' the query into smaller parts (representing subtrees of the plan), and analyze those first. Look for misestimates (significant differences between estimated and actual row counts, and very expensive parts). We can't do that, because we don't have your data or queries, and without the explain analyze it's difficult to give advices. -- Tomas Vondra http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services --001a11c2df7cb0524f05117ad83c Content-Type: text/plain; charset=US-ASCII; name="Explain.sql" Content-Disposition: attachment; filename="Explain.sql" Content-Transfer-Encoding: base64 X-Attachment-Id: 5bd90c646677158c_0.1 c192X2ZfcHJvbW90aW9uX2hpc3RvcnlfZW1haWwNCg0KSGFzaCBMZWZ0IEpv aW4gIChjb3N0PTM0Njc5LjkwLi4zNzM5Ni4zNyByb3dzPTExNjQ0IHdpZHRo PTE0OCkgKGFjdHVhbCB0aW1lPTYwOS40NzIuLjkwNzAuNjc1IHJvd3M9NDU1 OTI4OSBsb29wcz0xKQ0KICAgSGFzaCBDb25kOiAoKGJhc2UucHJvbW9faGlz dF9pZCA9IGVtYWlsLnByb21vX2hpc3RfaWQpIEFORCAoYmFzZS5hdWRpZW5j ZV9tZW1iZXJfaWQgPSBlbWFpbC5hdWRpZW5jZV9tZW1iZXJfaWQpKQ0KICAg LT4gIE5lc3RlZCBMb29wICAoY29zdD0zMjc4Mi42Mi4uMzUwMDQuMjEgcm93 cz0xMTY0NCB3aWR0aD03NCkgKGFjdHVhbCB0aW1lPTU2Ny40NDEuLjQwOTYu OTY5IHJvd3M9NDU1OTI4OSBsb29wcz0xKQ0KICAgICAgICAgSm9pbiBGaWx0 ZXI6IChzX2ZfdG91Y2hwb2ludF9leGVjdXRpb25fc3RhdHVzX2hpc3Rvcnku dG91Y2hwb2ludF9leGVjdXRpb25faWQgPSBiYXNlLnRvdWNocG9pbnRfZXhl Y3V0aW9uX2lkKQ0KICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0z Mjc4Mi4xOS4uMzQ1MDQuMTYgcm93cz0xIHdpZHRoPTE2KSAoYWN0dWFsIHRp bWU9MzM3LjQ4NC4uODg0LjQzOCByb3dzPTQ2NDU0IGxvb3BzPTEpDQogICAg ICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTMyNzgxLjkwLi4z NDUwMy44MyByb3dzPTEgd2lkdGg9MjQpIChhY3R1YWwgdGltZT0zMzcuNDYy Li42ODIuOTQzIHJvd3M9NzE4OTIgbG9vcHM9MSkNCiAgICAgICAgICAgICAg ICAgICAgIC0+ICBVbmlxdWUgIChjb3N0PTMyNzgxLjYxLi4zNDQ5NS41MCBy b3dzPTEgd2lkdGg9OCkgKGFjdHVhbCB0aW1lPTMzNy40MjguLjQ3OC42MTkg cm93cz03NjA4OCBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAg ICAgLT4gIE1lcmdlIEpvaW4gIChjb3N0PTMyNzgxLjYxLi4zNDQ5NS41MCBy b3dzPTEgd2lkdGg9OCkgKGFjdHVhbCB0aW1lPTMzNy40MjcuLjQ1NC4yNDkg cm93cz03NzA5MCBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgTWVyZ2UgQ29uZDogKChzX2ZfdG91Y2hwb2ludF9leGVjdXRp b25fc3RhdHVzX2hpc3RvcnkudG91Y2hwb2ludF9leGVjdXRpb25faWQgPSBz X2ZfdG91Y2hwb2ludF9leGVjdXRpb25fc3RhdHVzX2hpc3RvcnlfMS50b3Vj aHBvaW50X2V4DQplY3V0aW9uX2lkKSBBTkQgKHNfZl90b3VjaHBvaW50X2V4 ZWN1dGlvbl9zdGF0dXNfaGlzdG9yeS5jcmVhdGlvbl9kdCA9IChtYXgoc19m X3RvdWNocG9pbnRfZXhlY3V0aW9uX3N0YXR1c19oaXN0b3J5XzEuY3JlYXRp b25fZHQpKSkpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAt PiAgU29ydCAgKGNvc3Q9MTk2OTcuODcuLjIwMDk4LjE0IHJvd3M9MTYwMTA3 IHdpZHRoPTE2KSAoYWN0dWFsIHRpbWU9MTMyLjkzOC4uMTU1LjMyNSByb3dz PTE2MDg5OCBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgU29ydCBLZXk6IHNfZl90b3VjaHBvaW50X2V4ZWN1dGlv bl9zdGF0dXNfaGlzdG9yeS50b3VjaHBvaW50X2V4ZWN1dGlvbl9pZCwgc19m X3RvdWNocG9pbnRfZXhlY3V0aW9uX3N0YXR1c19oaXN0b3J5LmNyZWF0aW9u X2R0DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBT b3J0IE1ldGhvZDogcXVpY2tzb3J0ICBNZW1vcnk6IDEzNjg3a0INCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBTZXEgU2Nh biBvbiBzX2ZfdG91Y2hwb2ludF9leGVjdXRpb25fc3RhdHVzX2hpc3Rvcnkg IChjb3N0PTAuMDAuLjU4NTcuNjggcm93cz0xNjAxMDcgd2lkdGg9MTYpIChh Y3R1YWwgdGltZT0wLjAxMi4uNjAuNDIxIHJvdw0Kcz0xNjA4OTggbG9vcHM9 MSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIEZpbHRlcjogKHRvdWNocG9pbnRfZXhlY3V0aW9uX3N0YXR1c190eXBl X2lkID0gQU5ZICgnezMsNCw2fSc6OmludGVnZXJbXSkpDQogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBSb3dzIFJlbW92 ZWQgYnkgRmlsdGVyOiAxMzAyMDYNCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIC0+ICBTb3J0ICAoY29zdD0xMzA4My43NC4uMTMyNTQuNzYg cm93cz02ODQxMCB3aWR0aD0xNikgKGFjdHVhbCB0aW1lPTIwNC40NzYuLjIy Ny40ODMgcm93cz03NzQ1NiBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgU29ydCBLZXk6IHNfZl90b3VjaHBvaW50 X2V4ZWN1dGlvbl9zdGF0dXNfaGlzdG9yeV8xLnRvdWNocG9pbnRfZXhlY3V0 aW9uX2lkLCAobWF4KHNfZl90b3VjaHBvaW50X2V4ZWN1dGlvbl9zdGF0dXNf aGlzdG9yeV8xLmNyZWF0DQppb25fZHQpKQ0KICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgU29ydCBNZXRob2Q6IHF1aWNrc29ydCAg TWVtb3J5OiA2NjU2a0INCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIC0+ICBIYXNoQWdncmVnYXRlICAoY29zdD02MjIxLjU2Li42 OTA1LjY2IHJvd3M9Njg0MTAgd2lkdGg9MTYpIChhY3R1YWwgdGltZT0xNDAu OTkyLi4xNjkuNDI2IHJvd3M9NzY0NTQgbG9vcHM9MSkNCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBTZXEgU2Nh biBvbiBzX2ZfdG91Y2hwb2ludF9leGVjdXRpb25fc3RhdHVzX2hpc3Rvcnkg c19mX3RvdWNocG9pbnRfZXhlY3V0aW9uX3N0YXR1c19oaXN0b3J5XzEgIChj b3N0PTAuMDAuLjQ3NjYuMDQgcm93cw0KPTI5MTEwNCB3aWR0aD0xNikgKGFj dHVhbCB0aW1lPTAuMDEzLi4zOS44NTEgcm93cz0yOTExMDQgbG9vcHM9MSkN CiAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGlk eF9zX2RfdG91Y2hwb2ludF9leGVjdXRpb25faWQgb24gc19kX3RvdWNocG9p bnRfZXhlY3V0aW9uIHRwZSAgKGNvc3Q9MC4yOS4uOC4zMSByb3dzPTEgd2lk dGg9MTYpIChhY3R1YWwgdGltZT0wLjAwMi4uMC4wMDIgcg0Kb3dzPTEgbG9v cHM9NzYwODgpDQogICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBD b25kOiAodG91Y2hwb2ludF9leGVjdXRpb25faWQgPSBzX2ZfdG91Y2hwb2lu dF9leGVjdXRpb25fc3RhdHVzX2hpc3RvcnkudG91Y2hwb2ludF9leGVjdXRp b25faWQpDQogICAgICAgICAgICAgICAtPiAgSW5kZXggT25seSBTY2FuIHVz aW5nIHNfZF90b3VjaHBvaW50X3BrZXkgb24gc19kX3RvdWNocG9pbnQgdHAg IChjb3N0PTAuMjkuLjAuMzIgcm93cz0xIHdpZHRoPTgpIChhY3R1YWwgdGlt ZT0wLjAwMi4uMC4wMDIgcm93cz0xIGxvb3BzPTcxODkyKQ0KICAgICAgICAg ICAgICAgICAgICAgSW5kZXggQ29uZDogKCh0b3VjaHBvaW50X2lkID0gdHBl LnRvdWNocG9pbnRfaWQpIEFORCAoY2hhbm5lbF90eXBlX2lkID0gMSkpDQog ICAgICAgICAgICAgICAgICAgICBIZWFwIEZldGNoZXM6IDQ2NDU0DQogICAg ICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBpZHhfcHJfaGlzdG9yeSBvbiBz X2ZfcHJvbW90aW9uX2hpc3RvcnkgYmFzZSAgKGNvc3Q9MC40My4uMzExLjUy IHJvd3M9MTUwODMgd2lkdGg9NzQpIChhY3R1YWwgdGltZT0wLjAwMi4uMC4w MzMgcm93cz05OCBsb29wcz00NjQ1NCkNCiAgICAgICAgICAgICAgIEluZGV4 IENvbmQ6ICh0b3VjaHBvaW50X2V4ZWN1dGlvbl9pZCA9IHRwZS50b3VjaHBv aW50X2V4ZWN1dGlvbl9pZCkNCiAgIC0+ICBIYXNoICAoY29zdD0xMTkyLjcx Li4xMTkyLjcxIHJvd3M9NDY5NzEgd2lkdGg9OTApIChhY3R1YWwgdGltZT00 MS45NzguLjQxLjk3OCByb3dzPTQ2OTcxIGxvb3BzPTEpDQogICAgICAgICBC dWNrZXRzOiA4MTkyICBCYXRjaGVzOiAxICBNZW1vcnkgVXNhZ2U6IDQ3NzVr Qg0KICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHNfZl9wcm9tb3Rpb25faGlz dG9yeV9lbWFpbCBlbWFpbCAgKGNvc3Q9MC4wMC4uMTE5Mi43MSByb3dzPTQ2 OTcxIHdpZHRoPTkwKSAoYWN0dWFsIHRpbWU9MC4wMTAuLjE5LjYyMCByb3dz PTQ2OTcxIGxvb3BzPTEpDQoJCSANCgkJIA0KCQkgDQpzX3ZfZF9jYW1wYWln bl9oaWVyYXJjaHkNCg0KTmVzdGVkIExvb3AgTGVmdCBKb2luICAoY29zdD0x ODQ4NS4wNy4uMjAzNjYuNDQgcm93cz0xIHdpZHRoPTg5NCkgKGFjdHVhbCB0 aW1lPTI2NTYuNDUxLi40MDQxLjk1MiByb3dzPTQ1MzYwIGxvb3BzPTEpDQog ICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTE4NDg0Ljk0Li4yMDM2Ni4yOSBy b3dzPTEgd2lkdGg9Nzc2KSAoYWN0dWFsIHRpbWU9MjQ0NS40ODcuLjM3NDEu MDQ5IHJvd3M9NDUzNjAgbG9vcHM9MSkNCiAgICAgICAgIC0+ICBOZXN0ZWQg TG9vcCBMZWZ0IEpvaW4gIChjb3N0PTE4NDg0LjgxLi4yMDM2Ni4xMiByb3dz PTEgd2lkdGg9NjU4KSAoYWN0dWFsIHRpbWU9MjQ0NS40NzEuLjM2NDguMDA3 IHJvd3M9NDg5MjYgbG9vcHM9MSkNCiAgICAgICAgICAgICAgIC0+ICBIYXNo IEpvaW4gIChjb3N0PTE4NDg0LjY4Li4yMDM2NS45NiByb3dzPTEgd2lkdGg9 MzQwKSAoYWN0dWFsIHRpbWU9MjI2Ny45OTcuLjMzNTkuMTQ4IHJvd3M9NDg5 MjYgbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAgICAgIEhhc2ggQ29uZDog KChzX2ZfdG91Y2hwb2ludF9leGVjdXRpb25fc3RhdHVzX2hpc3RvcnlfMS50 b3VjaHBvaW50X2V4ZWN1dGlvbl9pZCA9IHNfZl90b3VjaHBvaW50X2V4ZWN1 dGlvbl9zdGF0dXNfaGlzdG9yeS50b3VjaHBvaW50X2V4ZWN1dGlvbl9pZCkg QQ0KTkQgKChtYXgoc19mX3RvdWNocG9pbnRfZXhlY3V0aW9uX3N0YXR1c19o aXN0b3J5XzEuY3JlYXRpb25fZHQpKSA9IHNfZl90b3VjaHBvaW50X2V4ZWN1 dGlvbl9zdGF0dXNfaGlzdG9yeS5jcmVhdGlvbl9kdCkpDQogICAgICAgICAg ICAgICAgICAgICAtPiAgSGFzaEFnZ3JlZ2F0ZSAgKGNvc3Q9NjIyMS41Ni4u NjkwNS42NiByb3dzPTY4NDEwIHdpZHRoPTE2KSAoYWN0dWFsIHRpbWU9MTQw LjA3OS4uMTgxLjQ2NSByb3dzPTc2NDU0IGxvb3BzPTEpDQogICAgICAgICAg ICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gc19mX3RvdWNocG9p bnRfZXhlY3V0aW9uX3N0YXR1c19oaXN0b3J5IHNfZl90b3VjaHBvaW50X2V4 ZWN1dGlvbl9zdGF0dXNfaGlzdG9yeV8xICAoY29zdD0wLjAwLi40NzY2LjA0 IHJvd3M9MjkxMTA0IHdpZHRoPTE2KQ0KKGFjdHVhbCB0aW1lPTAuMDEwLi4z OC44OTQgcm93cz0yOTExMDQgbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAg ICAgIC0+ICBIYXNoICAoY29zdD0xMjI2My4wOS4uMTIyNjMuMDkgcm93cz0y IHdpZHRoPTM1NikgKGFjdHVhbCB0aW1lPTIxMjcuODY5Li4yMTI3Ljg2OSBy b3dzPTEzMTQyNyBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAg ICAgQnVja2V0czogMTAyNCAgQmF0Y2hlczogMSAgTWVtb3J5IFVzYWdlOiAz Nzk5MGtCDQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSGFzaCBK b2luICAoY29zdD02MjU5LjcyLi4xMjI2My4wOSByb3dzPTIgd2lkdGg9MzU2 KSAoYWN0dWFsIHRpbWU9MTM1Ny42NTIuLjE5OTAuMTc3IHJvd3M9MTMxNDI3 IGxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBI YXNoIENvbmQ6IChzX2ZfdG91Y2hwb2ludF9leGVjdXRpb25fc3RhdHVzX2hp c3RvcnkudG91Y2hwb2ludF9leGVjdXRpb25faWQgPSB0cF9leGVjLnRvdWNo cG9pbnRfZXhlY3V0aW9uX2lkKQ0KICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHNfZl90b3VjaHBvaW50X2V4ZWN1 dGlvbl9zdGF0dXNfaGlzdG9yeSAgKGNvc3Q9MC4wMC4uNTQ5My44MCByb3dz PTEzNTg3OCB3aWR0aD0xNikgKGFjdHVhbCB0aW1lPTAuMDExLi41Mi45MzIg cm93cz0xMzYyDQo4MCBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgRmlsdGVyOiAodG91Y2hwb2ludF9leGVjdXRp b25fc3RhdHVzX3R5cGVfaWQgPSBBTlkgKCd7Myw0fSc6OmludGVnZXJbXSkp DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBSb3dz IFJlbW92ZWQgYnkgRmlsdGVyOiAxNTQ4MjQNCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIC0+ICBIYXNoICAoY29zdD02MjU5LjcxLi42MjU5 LjcxIHJvd3M9MSB3aWR0aD0zNDApIChhY3R1YWwgdGltZT0xMzU3LjYwNS4u MTM1Ny42MDUgcm93cz03MjQyNyBsb29wcz0xKQ0KICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgQnVja2V0czogMTAyNCAgQmF0Y2hl czogMSAgTWVtb3J5IFVzYWdlOiAxOTUxMGtCDQogICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgTGVmdCBK b2luICAoY29zdD0xOTU1LjQwLi42MjU5LjcxIHJvd3M9MSB3aWR0aD0zNDAp IChhY3R1YWwgdGltZT0xNTguNzc5Li4xMjY5LjkzOCByb3dzPTcyNDI3IGxv b3BzPTEpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAtPiAgTmVzdGVkIExvb3AgTGVmdCBKb2luICAoY29zdD0xOTU1 LjI3Li42MjU5LjU1IHJvd3M9MSB3aWR0aD0yMjIpIChhY3R1YWwgdGltZT0z MS44MzYuLjk5OC4yOTcgcm93cz03MjQyNyBsb29wcz0xKQ0KICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4g IE5lc3RlZCBMb29wICAoY29zdD0xOTU0Ljk5Li42MjU5LjI0IHJvd3M9MSB3 aWR0aD0xOTcpIChhY3R1YWwgdGltZT0zMS44MjYuLjgyOS4yNzggcm93cz03 MjQyNyBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAo Y29zdD0xOTU0LjcxLi42MjU4LjkyIHJvd3M9MSB3aWR0aD0xNzMpIChhY3R1 YWwgdGltZT0zMS44MTYuLjYzNi4xMjIgcm93cz03MjQyNyBsb29wcz0xKQ0K ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgSm9pbiBGaWx0ZXI6IChjYW1wX2V4ZWMuY2Ft cGFpZ25faWQgPSB3YXZlLmNhbXBhaWduX2lkKQ0KICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgUm93cyBSZW1vdmVkIGJ5IEpvaW4gRmlsdGVyOiAyNDMNCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MTk1NC40Mi4uNjI1 NC42NyByb3dzPTEzIHdpZHRoPTE2NykgKGFjdHVhbCB0aW1lPTMxLjgwNC4u NDM1LjQ2MSByb3dzPTcyNjcwIGxvb3BzPQ0KMSkNCiAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIC0+ICBIYXNoIEpvaW4gIChjb3N0PTE5NTQuMTMuLjYyNDku Njcgcm93cz0xMyB3aWR0aD0xMDgpIChhY3R1YWwgdGltZT0zMS43NzcuLjIx MC4zNDYgcm93cz03MjY3MCBsbw0Kb3BzPTEpDQogICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBIYXNoIENvbmQ6ICgodHBfZXhlYy50b3VjaHBvaW50 X2lkID0gdHAudG91Y2hwb2ludF9pZCkgQU5EICh3YXZlX2V4ZWMud2F2ZV9p ZCA9IHRwLndhdmVfaWQpKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgLT4gIEhhc2ggSm9pbiAgKGNvc3Q9MTU3Ni44My4uNDU5NS41MSByb3dz PTcyOTU2IHdpZHRoPTkwKSAoYWN0dWFsIHRpbWU9MjUuOTg0Li4xNDEuNTY0 IHJvd3M9DQo3Mjk1NiBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgSGFzaCBDb25kOiAodHBfZXhlYy53YXZlX2V4ZWN1 dGlvbl9pZCA9IHdhdmVfZXhlYy53YXZlX2V4ZWN1dGlvbl9pZCkNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBv biBzX2RfdG91Y2hwb2ludF9leGVjdXRpb24gdHBfZXhlYyAgKGNvc3Q9MC4w MC4uMTU1OS41NiByb3dzPTcyOTU2IHdpZHRoPQ0KNDIpIChhY3R1YWwgdGlt ZT0wLjAwNS4uMTQuOTQ1IHJvd3M9NzI5NTYgbG9vcHM9MSkNCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBIYXNoICAoY29zdD0x MDAxLjM3Li4xMDAxLjM3IHJvd3M9NDYwMzcgd2lkdGg9NTYpIChhY3R1YWwg dGltZT0yNS45MjIuLjI1LjkyMiByb3dzPQ0KNDYwMzcgbG9vcHM9MSkNCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEJ1Y2tl dHM6IDgxOTIgIEJhdGNoZXM6IDEgIE1lbW9yeSBVc2FnZTogNDEwNGtCDQog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAg U2VxIFNjYW4gb24gc19kX3dhdmVfZXhlY3V0aW9uIHdhdmVfZXhlYyAgKGNv c3Q9MC4wMC4uMTAwMS4zNyByb3dzPTQ2MDM3IHdpZHQNCmg9NTYpIChhY3R1 YWwgdGltZT0wLjAwNy4uMTAuNDI0IHJvd3M9NDYwMzcgbG9vcHM9MSkNCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBIYXNoICAoY29zdD0y MTIuNzIuLjIxMi43MiByb3dzPTEwOTcyIHdpZHRoPTI2KSAoYWN0dWFsIHRp bWU9NS43NzMuLjUuNzczIHJvd3M9MTA5NzIgbG9vcA0Kcz0xKQ0KICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgQnVja2V0czogMjA0OCAg QmF0Y2hlczogMSAgTWVtb3J5IFVzYWdlOiA2NDVrQg0KICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHNfZF90 b3VjaHBvaW50IHRwICAoY29zdD0wLjAwLi4yMTIuNzIgcm93cz0xMDk3MiB3 aWR0aD0yNikgKGFjdHVhbCB0aW1lDQo9MC4wMDcuLjIuMzUwIHJvd3M9MTA5 NzIgbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRl eCBTY2FuIHVzaW5nIHNfZF9jYW1wYWlnbl9leGVjdXRpb25faWR4IG9uIHNf ZF9jYW1wYWlnbl9leGVjdXRpb24gY2FtcF9leGVjICAoY29zdD0wLjI5Li4w Lg0KMzcgcm93cz0xIHdpZHRoPTY3KSAoYWN0dWFsIHRpbWU9MC4wMDIuLjAu MDAyIHJvd3M9MSBsb29wcz03MjY3MCkNCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIEluZGV4IENvbmQ6IChjYW1wYWlnbl9leGVjdXRpb25faWQg PSB3YXZlX2V4ZWMuY2FtcGFpZ25fZXhlY3V0aW9uX2lkKQ0KICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgc19kX3dhdmVfcGtleSBv biBzX2Rfd2F2ZSB3YXZlICAoY29zdD0wLjI5Li4wLjMxIHJvd3M9MSB3aWR0 aD0yMikgKGFjdHVhbCB0aW1lPTAuMDAyDQouLjAuMDAyIHJvd3M9MSBsb29w cz03MjY3MCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6 ICh3YXZlX2lkID0gd2F2ZV9leGVjLndhdmVfaWQpDQogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAt PiAgSW5kZXggU2NhbiB1c2luZyBzX2RfY2FtcGFpZ25fcGtleSBvbiBzX2Rf Y2FtcGFpZ24gY2FtcCAgKGNvc3Q9MC4yOS4uMC4zMiByb3dzPTEgd2lkdGg9 NDApIChhY3R1YWwgdGltZT0wLjANCjAyLi4wLjAwMiByb3dzPTEgbG9vcHM9 NzI0MjcpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAoY2FtcGFp Z25faWQgPSBjYW1wX2V4ZWMuY2FtcGFpZ25faWQpDQogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSW5k ZXggU2NhbiB1c2luZyBzX2RfY29udGVudF9wa2V5IG9uIHNfZF9jb250ZW50 IGNvbnRlbnQgIChjb3N0PTAuMjguLjAuMzAgcm93cz0xIHdpZHRoPTMzKSAo YWN0dWFsIHRpbWU9MC4wMDEuLjANCi4wMDIgcm93cz0xIGxvb3BzPTcyNDI3 KQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKHRwX2V4ZWMuY29udGVudF9p ZCA9IGNvbnRlbnRfaWQpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBzX2RfbWVz c2FnZV90eXBlX3BrZXkgb24gc19kX21lc3NhZ2VfdHlwZSBtZXNzYWdlX3R5 cGUgIChjb3N0PTAuMTMuLjAuMTUgcm93cz0xIHdpZHRoPTEyMCkgKGFjdHVh bCB0aW0NCmU9MC4wMDMuLjAuMDAzIHJvd3M9MSBsb29wcz03MjQyNykNCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIEluZGV4IENvbmQ6ICh0cF9leGVjLm1lc3NhZ2VfdHlwZV9pZCA9IG1l c3NhZ2VfdHlwZV9pZCkNCiAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2Fu IHVzaW5nIHNfZF9ncm91cF9wa2V5IG9uIHNfZF9ncm91cCBncnVwICAoY29z dD0wLjEzLi4wLjE1IHJvd3M9MSB3aWR0aD0zMjApIChhY3R1YWwgdGltZT0w LjAwNS4uMC4wMDUgcm93cz0xIGxvb3BzPTQ4OTI2KQ0KICAgICAgICAgICAg ICAgICAgICAgSW5kZXggQ29uZDogKGNhbXBfZXhlYy5ncm91cF9pZCA9IGdy b3VwX2lkKQ0KICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgZF9jaGFu bmVsX3BrIG9uIHNfZF9jaGFubmVsX3R5cGUgY2hhbm5lbCAgKGNvc3Q9MC4x My4uMC4xNSByb3dzPTEgd2lkdGg9MTIwKSAoYWN0dWFsIHRpbWU9MC4wMDEu LjAuMDAxIHJvd3M9MSBsb29wcz00ODkyNikNCiAgICAgICAgICAgICAgIElu ZGV4IENvbmQ6IChjaGFubmVsX3R5cGVfaWQgPSB0cC5jaGFubmVsX3R5cGVf aWQpDQogICAtPiAgSW5kZXggU2NhbiB1c2luZyBzX2RfY2F0ZWdvcnlfcGtl eSBvbiBzX2RfY2F0ZWdvcnkgIkNBVEVHT1JZIiAgKGNvc3Q9MC4xMy4uMC4x NSByb3dzPTEgd2lkdGg9MTIwKSAoYWN0dWFsIHRpbWU9MC4wMDYuLjAuMDA2 IHJvd3M9MSBsb29wcz00NTM2MCkNCiAgICAgICAgIEluZGV4IENvbmQ6IChj YW1wLmNhdGVnb3J5X2lkID0gY2F0ZWdvcnlfaWQp --001a11c2df7cb0524f05117ad83c Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance --001a11c2df7cb0524f05117ad83c--