Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fK3kn-0003Ct-Th for pgsql-performance@arkaria.postgresql.org; Sat, 19 May 2018 15:26:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fK3km-00074Q-2v for pgsql-performance@arkaria.postgresql.org; Sat, 19 May 2018 15:26:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fJm3p-0000T6-Qe for pgsql-performance@lists.postgresql.org; Fri, 18 May 2018 20:33:09 +0000 Received: from vaadcmhout01.cable.comcast.com ([96.114.28.75]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fJm3j-0000TQ-Sg for pgsql-performance@postgresql.org; Fri, 18 May 2018 20:33:07 +0000 X-AuditID: 60721c4b-8b66a7000000a732-d4-5aff387a0569 Received: from VAADCEX43.cable.comcast.com (vaadcmhoutvip.cable.comcast.com [96.115.73.56]) (using TLS with cipher AES256-SHA256 (256/256 bits)) (Client did not present a certificate) by vaadcmhout01.cable.comcast.com (SMTP Gateway) with SMTP id 78.59.42802.A783FFA5; Fri, 18 May 2018 16:32:58 -0400 (EDT) Received: from COPDCEX30.cable.comcast.com (147.191.124.161) by VAADCEX43.cable.comcast.com (147.191.103.220) with Microsoft SMTP Server (TLS) id 15.0.1365.1; Fri, 18 May 2018 16:32:57 -0400 Received: from COPDCEX49.cable.comcast.com (147.191.125.148) by COPDCEX30.cable.comcast.com (147.191.124.161) with Microsoft SMTP Server (TLS) id 15.0.1365.1; Fri, 18 May 2018 14:32:55 -0600 Received: from COPDCEX49.cable.comcast.com ([fe80::3aea:a7ff:fe36:8b5c]) by COPDCEX49.cable.comcast.com ([fe80::3aea:a7ff:fe36:8b5c%15]) with mapi id 15.00.1365.000; Fri, 18 May 2018 14:32:55 -0600 From: "Kotapati, Anil" To: "pgsql-performance@postgresql.org" CC: "Kossi, Edem" , "Yadav, Rahul" , "Mukherjee, Pallavi (Contractor)" Subject: Help with tuning slow query Thread-Topic: Help with tuning slow query Thread-Index: AQHT7udm1cYVYNKazESwZOVWBmjMUA== Date: Fri, 18 May 2018 20:32:55 +0000 Message-ID: <0AA18957-DDD4-413C-AE3A-2D3FD5EF0028@comcast.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [96.114.156.9] Content-Type: multipart/alternative; boundary="_000_0AA18957DDD4413CAE3A2D3FD5EF0028comcastcom_" MIME-Version: 1.0 X-CFilter-Loop: Forward X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFtrPIsWRmVeSWpSXmKPExsWSUOxpoVtl8T/K4Mw/UYvrM88xOzB6XNg3 jT2AMYrLJiU1J7MstUjfLoErY3/TFuaCxdoV++++YWpg/KfZxcjJISFgIrHi1kaWLkYuDiGB 7UwS95/NY4ZwDjFKvDs9kx3O+bToPiuEc5JRonXxZyaQfjYBI4kFDxYxg9giAp4Ss/dvA5vF LDCbUaJ/4WKwhLCAqsSu6c+hirQkzh6YzAJh60lMOLCJFcRmAaq5+Pk3WxcjBwevgJ3EzI1g YUYBMYnvp9aA7WIWEJe49WQ+E8TdAhJL9pxnhrBFJV4+/scKYetInL3+hBHCNpDYunQfC4St IPH+3yk2iDlJEh+WrQebwysgKHFy5hOwGiEBNYk5s95CzRGXOHxkB+sERolZSFbPQtI+C0n7 LKCrmQU0Jdbv0ocoUZSY0v2QHcLWkGidMxfKtpLYdHg2E7KaBYwcqxh5LM30DA1N9Iws9MxN NzGCorVIxnsH47qf7ocYBTgYlXh4DYz+RwmxJpYVV+YCI4ODWUmE12jGvygh3pTEyqrUovz4 otKc1OJDjNIcLErivKd//YoSEkhPLEnNTk0tSC2CyTJxcEo1MBZ55cgt7+NWLHwjlXciJGbK RK03svWL/4ld3+CexLLx2jUf0UMslkxNkzQt0/9c3Xe1TenV3FUGsxdIiLF8bovfPe2Jl3Tv vsYVgfYr2XdNtL1to7BF4gznN7vCpL+qMe+VXl27Yntcors57u7iT+aWs+5ockQ0qapvnHh6 ceb+bct+5SzyuaHEUpyRaKjFXFScCADciKSY0gIAAA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_0AA18957DDD4413CAE3A2D3FD5EF0028comcastcom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SGkgVGVhbSwNCg0KV2UgYXJlIGZhY2luZyBpc3N1ZXMgd2l0aCBvbmUgb2Ygb3VyIHF1ZXJ5LCB3 aGVuIHdlIHVzZSBvcmRlciBieSBjb3VudCBpdCBpcyB0YWtpbmcgbG90IG9mIHRpbWUgdG8gZXhl Y3V0ZSB0aGUgcXVlcnkuIFRvIGJlIHByZWNpc2UgaXQgaXMgdGFraW5nIDkgbWluIHRvIGV4ZWN1 dGUgdGhlIHF1ZXJ5IGZyb20gdGFibGUgd2hpY2ggaGFzIH4yMjAgbWlsbGlvbiByZWNvcmRzLiBJ cyB0aGVyZSBhIHdheSB0byBtYWtlIHRoaXMgcXVlcnkgcnVuIGZhc3RlciBhbmQgZWZmaWNpZW50 bHkgdXNpbmcgb3JkZXIgYnkgY291bnQuIEJlbG93IGlzIHRoZSBxdWVyeSB3aGljaCBJ4oCZbSB0 cnlpbmcgdG8gcnVuDQoNClNlbGVjdCBhY2NvdW50X251bWJlciwgc3VtKGNvdW50X29mX2V2ZW50 KSBhcyAiZXJyb3JfY291bnQiDQpGUk9NIGV2ZW50X2RhaWx5X3N1bW1hcnkNCmdyb3VwIGJ5IGFj Y291bnRfbnVtYmVyLGV2ZW50X2RhdGUscHJvY2Vzc19uYW1lDQpoYXZpbmcgZXZlbnRfZGF0ZSA+ PSAnMjAxOC0wNS0wNycNCmFuZCBwcm9jZXNzX25hbWU9J2V4cDkwZF94cmVlcnJvcicNCm9yZGVy IGJ5IHN1bShjb3VudF9vZl9ldmVudCkgZGVzYw0KbGltaXQgNTAwMA0KDQoNClRoYW5rcywNCkFu aWwNCg== --_000_0AA18957DDD4413CAE3A2D3FD5EF0028comcastcom_ Content-Type: text/html; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6bz0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6b2ZmaWNlIiB4 bWxuczp3PSJ1cm46c2NoZW1hcy1taWNyb3NvZnQtY29tOm9mZmljZTp3b3JkIiB4bWxuczptPSJo dHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL29mZmljZS8yMDA0LzEyL29tbWwiIHhtbG5zPSJo dHRwOi8vd3d3LnczLm9yZy9UUi9SRUMtaHRtbDQwIj4NCjxoZWFkPg0KPG1ldGEgaHR0cC1lcXVp dj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPg0KPG1l dGEgbmFtZT0iR2VuZXJhdG9yIiBjb250ZW50PSJNaWNyb3NvZnQgV29yZCAxNSAoZmlsdGVyZWQg bWVkaXVtKSI+DQo8c3R5bGU+PCEtLQ0KLyogRm9udCBEZWZpbml0aW9ucyAqLw0KQGZvbnQtZmFj ZQ0KCXtmb250LWZhbWlseToiQ2FtYnJpYSBNYXRoIjsNCglwYW5vc2UtMToyIDQgNSAzIDUgNCA2 IDMgMiA0O30NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6Q2FsaWJyaTsNCglwYW5vc2UtMToy IDE1IDUgMiAyIDIgNCAzIDIgNDt9DQovKiBTdHlsZSBEZWZpbml0aW9ucyAqLw0KcC5Nc29Ob3Jt YWwsIGxpLk1zb05vcm1hbCwgZGl2Lk1zb05vcm1hbA0KCXttYXJnaW46MGluOw0KCW1hcmdpbi1i b3R0b206LjAwMDFwdDsNCglmb250LXNpemU6MTIuMHB0Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJp IixzYW5zLXNlcmlmO30NCmE6bGluaywgc3Bhbi5Nc29IeXBlcmxpbmsNCgl7bXNvLXN0eWxlLXBy aW9yaXR5Ojk5Ow0KCWNvbG9yOiMwNTYzQzE7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9 DQphOnZpc2l0ZWQsIHNwYW4uTXNvSHlwZXJsaW5rRm9sbG93ZWQNCgl7bXNvLXN0eWxlLXByaW9y aXR5Ojk5Ow0KCWNvbG9yOiM5NTRGNzI7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQpz cGFuLkVtYWlsU3R5bGUxNw0KCXttc28tc3R5bGUtdHlwZTpwZXJzb25hbC1jb21wb3NlOw0KCWZv bnQtZmFtaWx5OiJDYWxpYnJpIixzYW5zLXNlcmlmOw0KCWNvbG9yOndpbmRvd3RleHQ7fQ0KLk1z b0NocERlZmF1bHQNCgl7bXNvLXN0eWxlLXR5cGU6ZXhwb3J0LW9ubHk7DQoJZm9udC1mYW1pbHk6 IkNhbGlicmkiLHNhbnMtc2VyaWY7fQ0KQHBhZ2UgV29yZFNlY3Rpb24xDQoJe3NpemU6OC41aW4g MTEuMGluOw0KCW1hcmdpbjoxLjBpbiAxLjBpbiAxLjBpbiAxLjBpbjt9DQpkaXYuV29yZFNlY3Rp b24xDQoJe3BhZ2U6V29yZFNlY3Rpb24xO30NCi0tPjwvc3R5bGU+DQo8L2hlYWQ+DQo8Ym9keSBs YW5nPSJFTi1VUyIgbGluaz0iIzA1NjNDMSIgdmxpbms9IiM5NTRGNzIiPg0KPGRpdiBjbGFzcz0i V29yZFNlY3Rpb24xIj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LXNp emU6MTEuMHB0Ij5IaSBUZWFtLDxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29O b3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTEuMHB0Ij48bzpwPiZuYnNwOzwvbzpwPjwv c3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEx LjBwdCI+V2UgYXJlIGZhY2luZyBpc3N1ZXMgd2l0aCBvbmUgb2Ygb3VyIHF1ZXJ5LCB3aGVuIHdl IHVzZSBvcmRlciBieSBjb3VudCBpdCBpcyB0YWtpbmcgbG90IG9mIHRpbWUgdG8gZXhlY3V0ZSB0 aGUgcXVlcnkuIFRvIGJlIHByZWNpc2UgaXQgaXMgdGFraW5nIDkgbWluIHRvIGV4ZWN1dGUgdGhl IHF1ZXJ5IGZyb20gdGFibGUgd2hpY2ggaGFzIH4yMjAgbWlsbGlvbg0KIHJlY29yZHMuIElzIHRo ZXJlIGEgd2F5IHRvIG1ha2UgdGhpcyBxdWVyeSBydW4gZmFzdGVyIGFuZCBlZmZpY2llbnRseSB1 c2luZyBvcmRlciBieSBjb3VudC4gQmVsb3cgaXMgdGhlIHF1ZXJ5IHdoaWNoIEnigJltIHRyeWlu ZyB0byBydW48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3Bh biBzdHlsZT0iZm9udC1zaXplOjExLjBwdCI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0K PHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQiPlNlbGVj dCBhY2NvdW50X251bWJlciwgc3VtKGNvdW50X29mX2V2ZW50KSBhcyAmcXVvdDtlcnJvcl9jb3Vu dCZxdW90OzxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFu IHN0eWxlPSJmb250LXNpemU6MTEuMHB0Ij5GUk9NIGV2ZW50X2RhaWx5X3N1bW1hcnk8bzpwPjwv bzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1z aXplOjExLjBwdCI+Z3JvdXAgYnkgYWNjb3VudF9udW1iZXIsZXZlbnRfZGF0ZSxwcm9jZXNzX25h bWU8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHls ZT0iZm9udC1zaXplOjExLjBwdCI+aGF2aW5nIGV2ZW50X2RhdGUgJmd0Oz0gJzIwMTgtMDUtMDcn PG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9 ImZvbnQtc2l6ZToxMS4wcHQiPmFuZCBwcm9jZXNzX25hbWU9J2V4cDkwZF94cmVlcnJvcic8bzpw PjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9u dC1zaXplOjExLjBwdCI+b3JkZXIgYnkgc3VtKGNvdW50X29mX2V2ZW50KSBkZXNjPG86cD48L286 cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6 ZToxMS4wcHQiPmxpbWl0IDUwMDA8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNv Tm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdCI+PG86cD4mbmJzcDs8L286cD48 L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZTox MS4wcHQiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwi PjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTEuMHB0Ij5UaGFua3MsPG86cD48L286cD48L3NwYW4+ PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQi PkFuaWw8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8L2Rpdj4NCjwvYm9keT4NCjwvaHRtbD4NCg== --_000_0AA18957DDD4413CAE3A2D3FD5EF0028comcastcom_--