Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eEu6e-0005i4-Pr for pgsql-performance@arkaria.postgresql.org; Wed, 15 Nov 2017 09:35:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1eEu6e-0005xy-BY for pgsql-performance@arkaria.postgresql.org; Wed, 15 Nov 2017 09:35: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.84_2) (envelope-from ) id 1eEu4m-0001kk-VW for pgsql-performance@postgresql.org; Wed, 15 Nov 2017 09:33:45 +0000 Received: from mail-lf0-x22b.google.com ([2a00:1450:4010:c07::22b]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1eEu4j-0000dA-IE for pgsql-performance@postgresql.org; Wed, 15 Nov 2017 09:33:44 +0000 Received: by mail-lf0-x22b.google.com with SMTP id 73so11132168lfu.10 for ; Wed, 15 Nov 2017 01:33:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=lijjy/Q2WolNGVcDPtMsTt9zuwEmt9xOxYw8uecq2j0=; b=UBkmIHcCEjQ3lkYUlVX5jZVpouJYhAuzMRVRZjrTumKjdYcxjx/GCbvKed5E8W0SAv JdypDEruD3sdQXc0bd3CaPpXuy/kaP5t8AyNhlzi9Yd47Yhi8yu6wwQs+AHZkoMmUyHf eHSC07eD/1sbcFlhKE2Bc2PF2ExrmViBOPNk4kO5zyp4rSnssd60275UB8j8LIY1WVvE 4tbFNwWRK1DBmkBgRxngSzsBLfFFnn4FZSStYb7ZsePtpVBZbPhawxsw9To9MyrJElog mQsupceTsGRWc+g0lv/f9VAors46Qd4CHa4MV6CUftkEAcPFfcEK7qO43R6cyh9BtGY1 0SFw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=lijjy/Q2WolNGVcDPtMsTt9zuwEmt9xOxYw8uecq2j0=; b=Z9BKz1H1RoO7y2kxB6ka62FLEaiRNqYNhxa+z5aQdGimEssJqU6Mh4VKkyi1XOA4bA NVSBZaCgCm3lkAx7bVOCJwxdxCMBFdoblLP9t98Tcq/LcoU0L3AqviWS2Od7VsvHF81M jDXpQV3p9tTYZ7nLfTWatdKdZHr9lKYnY+xRYEsbQiYCZVyw4AoOhuAoKSQIrcjrVsw3 jaFVfUCV1/ZdiOXxM7XXrM7hxIPenmu2EGXy8P4Z0rmsSw8d6Y1yor08Oc9+sy41xacW rnjIT4Iu9DsnVQgOxBS/hKsarp8iNC9ob2DHQeXRd1OK7b8EZkC8ePaMqOMRCvf6uROX SynQ== X-Gm-Message-State: AJaThX6gtlgtlKMndBW4mk56hp3SAmleg7AfYcngHW6cv0jMxrcqgD1g 5U/Wvs614fWpIkrKk0gIyG6gcGSq+lk3UbW6O7g= X-Google-Smtp-Source: AGs4zMbPSE19yeVRBRASASb1Ajhe83b7BphM+qRda48VkJG9sf//2t/vQjvVAiW/GZAwvKeIUDQ/9H3boxgKn7tSNUk= X-Received: by 10.25.165.200 with SMTP id o191mr5075200lfe.92.1510738420329; Wed, 15 Nov 2017 01:33:40 -0800 (PST) MIME-Version: 1.0 Received: by 10.25.21.105 with HTTP; Wed, 15 Nov 2017 01:33:39 -0800 (PST) From: Samir Magar Date: Wed, 15 Nov 2017 15:03:39 +0530 Message-ID: Subject: query performance issue To: pgsql-performance@postgresql.org Content-Type: multipart/mixed; boundary="001a11411588e48597055e023246" 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 --001a11411588e48597055e023246 Content-Type: multipart/alternative; boundary="001a11411588e48594055e023244" --001a11411588e48594055e023244 Content-Type: text/plain; charset="UTF-8" Hello, I am having performance issues with one of the query. The query is taking 39 min to fetch 3.5 mil records. I want to reduce that time to 15 mins. could you please suggest something to its performance? server configuration: CPUs = 4 memory = 16 GM shared_buffers = 3 GB work_mem = 100MB effective_cache_size = 12 GB we are doing the vacuum/analyze regularly on the database. attached is the query with its explain plan. Thanks, Samir Magar --001a11411588e48594055e023244 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello,
I am having performance issues with one of the = query.
The query is taking 39 min to fetch 3.5 mil records.
=

I want to reduce that time to 15 mins.=C2=A0
= could you please suggest something to its performance?

=
server configuration:
=C2=A0CPUs =3D 4
memory =3D = 16 GM
shared_buffers =3D 3 GB
work_mem =3D 100MB
<= div>effective_cache_size =3D 12 GB

we are doing th= e vacuum/analyze regularly on the database.=C2=A0

= attached is the query with its explain plan.

Thank= s,
Samir Magar=C2=A0=C2=A0
--001a11411588e48594055e023244-- --001a11411588e48597055e023246 Content-Type: text/plain; charset="US-ASCII"; name="query with access plan.txt" Content-Disposition: attachment; filename="query with access plan.txt" Content-Transfer-Encoding: base64 X-Attachment-Id: f_ja0ukd5o0 cXVlcnk6DQoNClNFTEVDVCANCkRJU1RJTkNUDQpETFJfUUxGWS5ETFJfUUxG WV9JRCBhcyBETFJfUUxGWV9JRCwgTk1RX1JFUS5HUkFDRV9QUkQgYXMgR1JB Q0VfUFJELCBOTVFfUkVRLkhJREVfUFJHX0ZMRyBhcyBISURFX1BSR19GTEcs IE5NUV9SRVEuTlRGWV9ETFJfRkxHIGFzIE5URllfRExSX0ZMRywgRExSX0xP Qy5BQ0NUX05VTSBhcyBBQ0NUX05VTSwgTk1RX1JFUS5OTVFfUkVRX0lEIGFz IE5NUV9SRVFfSUQsIE5FV19NREwuUElfTURMX0lEIGFzIFBJX01ETF9JRCAN Cg0KIA0KRlJPTSAgICAgdGVzdC5ETFJfUUxGWSBJTk5FUiBKT0lOIA0KKFNF TEVDVCBETFJfR1JQLkRMUl9HUlBfSUQgQVMgTE9DX0dSUF9JRCxMRUFEX0RM Ul9MT0NfSUQsRExSX0xPQy5BQ0NUX05VTSBBUyBMT0NfQUNDVF9OVU0gRlJP TSB0ZXN0LkRMUl9HUlAsIHRlc3QuRExSX0dSUF9ETFJfWFJFRiwgdGVzdC5E TFJfTE9DIFdIRVJFIERMUl9HUlAuRExSX0dSUF9JRD1ETFJfR1JQX0RMUl9Y UkVGLkRMUl9HUlBfSUQgQU5EIERMUl9HUlBfRExSX1hSRUYuRExSX0xPQ19J RD1ETFJfTE9DLkRMUl9MT0NfSUQgQU5EIChETFJfR1JQLkRMUl9HUlBfVFlQ PSdMT0MnIE9SIERMUl9HUlAuRExSX0dSUF9UWVA9J0NPRycpIEFORCBETFJf TE9DLklTX0FDVFY9J1knICkgTE9DX0dSUA0KT04gRExSX1FMRlkuUUxGWV9H UlBfSUQ9TE9DX0dSUC5MT0NfR1JQX0lEDQpJTk5FUiBKT0lOIChTRUxFQ1Qg RExSX0dSUC5ETFJfR1JQX0lEIEFTIENPR19HUlBfSUQsTEVBRF9ETFJfTE9D X0lELERMUl9MT0MuQUNDVF9OVU0gQVMgQ09HX0FDQ1RfTlVNIEZST00gdGVz dC5ETFJfR1JQLHRlc3QuRExSX0dSUF9ETFJfWFJFRix0ZXN0LkRMUl9MT0Mg V0hFUkUgRExSX0dSUC5ETFJfR1JQX0lEPURMUl9HUlBfRExSX1hSRUYuRExS X0dSUF9JRCBBTkQgRExSX0dSUF9ETFJfWFJFRi5ETFJfTE9DX0lEPURMUl9M T0MuRExSX0xPQ19JRCBBTkQgRExSX0dSUC5ETFJfR1JQX1RZUD0nQ09HJyBB TkQgRExSX0xPQy5JU19BQ1RWPSdZJyApIENPR19HUlANCk9OIERMUl9RTEZZ LkNPR19HUlBfSUQ9Q09HX0dSUC5DT0dfR1JQX0lEDQpJTk5FUiBKT0lOIHRl c3QuRExSX0xPQw0KT04gRExSX0xPQy5BQ0NUX05VTT1MT0NfR1JQLkxPQ19B Q0NUX05VTQ0KQU5EICAgICAgRExSX0xPQy5BQ0NUX05VTT1DT0dfR1JQLkNP R19BQ0NUX05VTQ0KSU5ORVIgSk9JTiB0ZXN0LkRMUl9MT0MgTEVBRF9MT0MN Ck9OIExFQURfTE9DLkRMUl9MT0NfSUQ9Q09HX0dSUC5MRUFEX0RMUl9MT0Nf SUQNCkFORCAgICAgIExFQURfTE9DLkFDQ1RfTlVNPUxFQURfTE9DLkNPR19Q QVJOVF9BQ0NUDQpJTk5FUiBKT0lOIHRlc3QuRExSX0xPQyBDT0dfTEVBRA0K T04gQ09HX0xFQUQuRExSX0xPQ19JRD1DT0dfR1JQLkxFQURfRExSX0xPQ19J RA0KSU5ORVIgSk9JTiB0ZXN0Lk5NUV9SRVENCk9OIERMUl9RTEZZLk5NUV9S RVFfSUQ9Tk1RX1JFUS5OTVFfUkVRX0lEDQpJTk5FUiBKT0lOIHRlc3QuTkVX X01ETA0KT04gTk1RX1JFUS5ORVdfTURMX0lEID0gTkVXX01ETC5ORVdfTURM X0lEDQpJTk5FUiBKT0lOIHRlc3QuU1RHX0FDRkxYX05NUV9ETFJTDQpPTiBD T0dfTEVBRC5BQ0NUX05VTT1TVEdfQUNGTFhfTk1RX0RMUlMuUkxUTlBfTEVB RF9BQ0NUDQpBTkQgICAgICBTVEdfQUNGTFhfTk1RX0RMUlMuQUNDVF9JRD1E TFJfTE9DLkFDQ1RfTlVNDQoNCldIRVJFIA0KIERMUl9MT0MuSVNfQUNUVj0n WScNCkFORCAgICAgIERMUl9RTEZZLlFMRl9GTEc9J04nDQpBTkQgICAgICBO TVFfUkVRLlBHTV9EU0JMX0ZMRyAhPSAnWScNCkFORCAgICAgIChOTVFfUkVR LlBHTV9TVEFSVF9EVCA8PSBDVVJSRU5UX0RBVEUNCiAgICAgQU5EIE5NUV9S RVEuUEdNX0VORF9EVCA+IENVUlJFTlRfREFURSkNCiAgICAgDQpBTkQgICAg ICAgRExSX1FMRlkuRExSX1FMRllfSUQgTk9UIElOIChTRUxFQ1QgRExSX1FM RlkuRExSX1FMRllfSUQgRlJPTSB0ZXN0LkRMUl9RTEZZIFdIRVJFIFFMRl9G TEc9J1knIEFORCBETFJfUUxGWS5OTVFfUkVRX0lEPU5NUV9SRVEuTk1RX1JF UV9JRCk7DQoNCg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoN CmFjY2VzcyBwbGFuDQoNCg0KDQoNCiJIYXNoQWdncmVnYXRlICAoY29zdD00 NTM4LjMzLi40NTM4LjM0IHJvd3M9MSB3aWR0aD0yNykiDQoiICBHcm91cCBL ZXk6IGRscl9xbGZ5LmRscl9xbGZ5X2lkLCBubXFfcmVxLmdyYWNlX3ByZCwg bm1xX3JlcS5oaWRlX3ByZ19mbGcsIG5tcV9yZXEubnRmeV9kbHJfZmxnLCBk bHJfbG9jLmFjY3RfbnVtLCBubXFfcmVxLm5tcV9yZXFfaWQsIG5ld19tZGwu cGlfbWRsX2lkIg0KIiAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0zLjU5Li40 NTM4LjMxIHJvd3M9MSB3aWR0aD0yNykiDQoiICAgICAgICAtPiAgTmVzdGVk IExvb3AgIChjb3N0PTMuMzEuLjQ1MzcuOTQgcm93cz0xIHdpZHRoPTI3KSIN CiIgICAgICAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9My4wMy4u NDUzMC4xNiByb3dzPTEgd2lkdGg9MTUpIg0KIiAgICAgICAgICAgICAgICAg ICAgSm9pbiBGaWx0ZXI6IChsZWFkX2xvYy5kbHJfbG9jX2lkID0gZGxyX2dy cF8xLmxlYWRfZGxyX2xvY19pZCkiDQoiICAgICAgICAgICAgICAgICAgICAt PiAgTmVzdGVkIExvb3AgIChjb3N0PTAuNTguLjE0MzguMjcgcm93cz0yNjMg d2lkdGg9MTUpIg0KIiAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE5l c3RlZCBMb29wICAoY29zdD0wLjI5Li4xMzA2Ljc4IHJvd3M9MTY5IHdpZHRo PTE1KSINCiIgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBT ZXEgU2NhbiBvbiBkbHJfbG9jIGxlYWRfbG9jICAoY29zdD0wLjAwLi43NTcu MTIgcm93cz0xNjkgd2lkdGg9NCkiDQoiICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICBGaWx0ZXI6IChhY2N0X251bSA9IGNvZ19wYXJu dF9hY2N0KSINCiIgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ ICBJbmRleCBPbmx5IFNjYW4gdXNpbmcgIklEWF8xMDEiIG9uIGRscl9sb2Mg Y29nX2xlYWQgIChjb3N0PTAuMjkuLjMuMjQgcm93cz0xIHdpZHRoPTExKSIN CiIgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4 IENvbmQ6IChkbHJfbG9jX2lkID0gbGVhZF9sb2MuZGxyX2xvY19pZCkiDQoi ICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2lu ZyBpZHhfMTQgb24gc3RnX2FjZmx4X25tcV9kbHJzICAoY29zdD0wLjI5Li4w LjYzIHJvd3M9MTUgd2lkdGg9MTQpIg0KIiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgSW5kZXggQ29uZDogKHJsdG5wX2xlYWRfYWNjdCA9IGNv Z19sZWFkLmFjY3RfbnVtKSINCiIgICAgICAgICAgICAgICAgICAgIC0+ICBO ZXN0ZWQgTG9vcCAgKGNvc3Q9Mi40NS4uMTEuNzQgcm93cz0xIHdpZHRoPTMz KSINCiIgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBPbmx5 IFNjYW4gdXNpbmcgaWR4MyBvbiBkbHJfZ3JwIGRscl9ncnBfMSAgKGNvc3Q9 MC4yOS4uMC4zMiByb3dzPTEgd2lkdGg9OCkiDQoiICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAoKGxlYWRfZGxyX2xvY19p ZCA9IGNvZ19sZWFkLmRscl9sb2NfaWQpIEFORCAoZGxyX2dycF90eXAgPSAn Q09HJzo6YnBjaGFyKSkiDQoiICAgICAgICAgICAgICAgICAgICAgICAgICAt PiAgTmVzdGVkIExvb3AgIChjb3N0PTIuMTcuLjExLjQxIHJvd3M9MSB3aWR0 aD0zNykiDQoiICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBKb2lu IEZpbHRlcjogKGRscl9sb2NfMi5hY2N0X251bSA9IGRscl9sb2MuYWNjdF9u dW0pIg0KIiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE5l c3RlZCBMb29wICAoY29zdD0wLjU4Li4wLjc3IHJvd3M9MSB3aWR0aD0xMSki DQoiICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAg SW5kZXggT25seSBTY2FuIHVzaW5nIGlkeDYgb24gZGxyX2xvYyBkbHJfbG9j XzIgIChjb3N0PTAuMjkuLjAuMzIgcm93cz0xIHdpZHRoPTExKSINCiIgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4 IENvbmQ6ICgoYWNjdF9udW0gPSBzdGdfYWNmbHhfbm1xX2RscnMuYWNjdF9p ZCkgQU5EIChpc19hY3R2ID0gJ1knOjpicGNoYXIpKSINCiIgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBPbmx5IFNj YW4gdXNpbmcgaWR4NyBvbiBkbHJfZ3JwX2Rscl94cmVmIGRscl9ncnBfZGxy X3hyZWZfMSAgKGNvc3Q9MC4yOS4uMC40NCByb3dzPTEgd2lkdGg9OCkiDQoi ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJ bmRleCBDb25kOiAoKGRscl9sb2NfaWQgPSBkbHJfbG9jXzIuZGxyX2xvY19p ZCkgQU5EIChkbHJfZ3JwX2lkID0gZGxyX2dycF8xLmRscl9ncnBfaWQpKSIN CiIgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBOZXN0ZWQg TG9vcCAgKGNvc3Q9MS41OC4uMTAuNjMgcm93cz0xIHdpZHRoPTI2KSINCiIg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRl eCBPbmx5IFNjYW4gdXNpbmcgaWR4XzEwMiBvbiBkbHJfbG9jICAoY29zdD0w LjI5Li4wLjMyIHJvd3M9MSB3aWR0aD03KSINCiIgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICgoYWNj dF9udW0gPSBzdGdfYWNmbHhfbm1xX2RscnMuYWNjdF9pZCkgQU5EIChpc19h Y3R2ID0gJ1knOjpicGNoYXIpKSINCiIgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MS4yOS4u MTAuMzAgcm93cz0xIHdpZHRoPTE5KSINCiIgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBPbmx5IFNjYW4g dXNpbmcgaWR4NiBvbiBkbHJfbG9jIGRscl9sb2NfMSAgKGNvc3Q9MC4yOS4u MC4zNCByb3dzPTEgd2lkdGg9MTEpIg0KIiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKChh Y2N0X251bSA9IGRscl9sb2MuYWNjdF9udW0pIEFORCAoaXNfYWN0diA9ICdZ Jzo6YnBjaGFyKSkiDQoiICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTEuMDAuLjku OTUgcm93cz0xIHdpZHRoPTE2KSINCiIgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBPbmx5IFNj YW4gdXNpbmcgaWR4NyBvbiBkbHJfZ3JwX2Rscl94cmVmICAoY29zdD0wLjI5 Li4wLjM1IHJvd3M9MiB3aWR0aD04KSINCiIgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENv bmQ6IChkbHJfbG9jX2lkID0gZGxyX2xvY18xLmRscl9sb2NfaWQpIg0KIiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0wLjcxLi40Ljc5IHJvd3M9MSB3 aWR0aD0yMCkiDQoiICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBp ZHhkZzMgb24gZGxyX2dycCAgKGNvc3Q9MC4yOS4uMC4zMyByb3dzPTEgd2lk dGg9NCkiDQoiICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAoZGxyX2dy cF9pZCA9IGRscl9ncnBfZGxyX3hyZWYuZGxyX2dycF9pZCkiDQoiICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICBGaWx0ZXI6ICgoZGxyX2dycF90eXAgPSAnTE9DJzo6YnBj aGFyKSBPUiAoZGxyX2dycF90eXAgPSAnQ09HJzo6YnBjaGFyKSkiDQoiICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAtPiAgSW5kZXggT25seSBTY2FuIHVzaW5nIGlkeGRxNyBvbiBk bHJfcWxmeSAgKGNvc3Q9MC40My4uNC40NSByb3dzPTEgd2lkdGg9MTYpIg0K IiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKChxbGZ5X2dycF9pZCA9 IGRscl9ncnAuZGxyX2dycF9pZCkgQU5EIChxbGZfZmxnID0gJ04nOjpicGNo YXIpIEFORCAoY29nX2dycF9pZCA9IGRscl9ncnBfZGxyX3hyZWZfMS5kbHJf Z3JwX2lkKSkiDQoiICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2lu ZyBwX2tleV8yOSBvbiBubXFfcmVxICAoY29zdD0wLjI4Li43Ljc3IHJvd3M9 MSB3aWR0aD0xNikiDQoiICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25k OiAobm1xX3JlcV9pZCA9IGRscl9xbGZ5Lm5tcV9yZXFfaWQpIg0KIiAgICAg ICAgICAgICAgICAgICAgRmlsdGVyOiAoKHBnbV9kc2JsX2ZsZyA8PiAnWSc6 OmJwY2hhcikgQU5EIChwZ21fc3RhcnRfZHQgPD0gKCdub3cnOjpjc3RyaW5n KTo6ZGF0ZSkgQU5EIChwZ21fZW5kX2R0ID4gKCdub3cnOjpjc3RyaW5nKTo6 ZGF0ZSkgQU5EIChOT1QgKFN1YlBsYW4gMSkpKSINCiIgICAgICAgICAgICAg ICAgICAgIFN1YlBsYW4gMSINCiIgICAgICAgICAgICAgICAgICAgICAgLT4g IEluZGV4IE9ubHkgU2NhbiB1c2luZyBpZHgxMSBvbiBkbHJfcWxmeSBkbHJf cWxmeV8xICAoY29zdD0wLjQzLi4xMy44MSByb3dzPTI2OSB3aWR0aD00KSIN CiIgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKChu bXFfcmVxX2lkID0gbm1xX3JlcS5ubXFfcmVxX2lkKSBBTkQgKHFsZl9mbGcg PSAnWSc6OmJwY2hhcikpIg0KIiAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNp bmcgaWR4MSBvbiBuZXdfbWRsICAoY29zdD0wLjI4Li4wLjM3IHJvd3M9MSB3 aWR0aD04KSINCiIgICAgICAgICAgICAgIEluZGV4IENvbmQ6IChuZXdfbWRs X2lkID0gbm1xX3JlcS5uZXdfbWRsX2lkKSINCg0KDQoNCg0KDQo= --001a11411588e48597055e023246 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 --001a11411588e48597055e023246--