Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eExDW-0002XE-D9 for pgsql-performance@arkaria.postgresql.org; Wed, 15 Nov 2017 12:54:58 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1eExDV-0000yB-Qq for pgsql-performance@arkaria.postgresql.org; Wed, 15 Nov 2017 12:54:57 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eExDU-0000y1-Rl for pgsql-performance@postgresql.org; Wed, 15 Nov 2017 12:54:57 +0000 Received: from mail-lf0-x232.google.com ([2a00:1450:4010:c07::232]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1eExDM-0008H4-S2 for pgsql-performance@postgresql.org; Wed, 15 Nov 2017 12:54:55 +0000 Received: by mail-lf0-x232.google.com with SMTP id e143so26103244lfg.12 for ; Wed, 15 Nov 2017 04:54:48 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=WAvOcvgvZAuVhlRej4ipGR7Qsx9ZNY+DkXWNZ0qhzU8=; b=diIkkhwgZd7HuZ4FQe2AXhQGaMZODaTzIwh0oQkfEryGbwXBm3IoIAs/4hQLPl+f9w VEPdvmS1csnpLGmOKPCLJi5N49yGmVUL9uACzkW/Y30m+RPoFd2VMr83ZT7a/ey1hhKr XzWdVzQg+bP9vokLiE4rbQr5wDDps1PVl54H05DWcD147Ba6hiux7JnF/UvwU6jOzAeG aBGWCwBd4+JUIl4loWKVj8inCBdZXOyX9GM+wais9uNLtgg9Au1Y/fudzJJZrwDQ+zbx kVPatFgeUNhfE+cgiD6yvcJGhijQpJ1r9SknAZflkMTI3xmBywIgmoKbbksYkLq4PNBd a0BA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=WAvOcvgvZAuVhlRej4ipGR7Qsx9ZNY+DkXWNZ0qhzU8=; b=Ke3ayp9W2NujI9Sj719x80YRafGfqWm11BLqgeJf9mptnJi+lkqTz1icgGI7OeZ2I8 J36fqZ4jUSmQKyyLyfThXruVQ1RqHEX5PYg3SZ7k2PvJXhUpPh6NdCKquc0ABhhXP1CD xYMnLXgwRkPvIQq7ixVGoSkHWNFLzkh6GQsQtlrA+KYWvLAlTw0aSX+zMXc55wKOHZYi xAwFWMgBD0vldRHiWRoIvfnzQi/2hA9qh0kC5/4AbZTm7q+eJ1cFOSq0SuAw7207T3FW 5gcjaSylaPNsTPvHNBKRZQFRvA9O63rsjttvjiEjnDjywRiVjFgJbOMRA0uftpuOdQ9G YwDA== X-Gm-Message-State: AJaThX5pqN/f9GSfH8doz1ueglecZTdlECiBuEpHo8JdtsjhVGSrXs50 ovXXFtiuvkqDSDQ0dhdSCVanbT4cyADxiiubPe4= X-Google-Smtp-Source: AGs4zMagfE08zFgcJhZFBVajvubgd7HLckG5rxM1ddk7jvzgtGyW9Am6wxQaBhKIEoX7VWp+D9qwW3DEPO6sAFOFFOU= X-Received: by 10.25.165.200 with SMTP id o191mr5271980lfe.92.1510750486302; Wed, 15 Nov 2017 04:54:46 -0800 (PST) MIME-Version: 1.0 Received: by 10.25.21.105 with HTTP; Wed, 15 Nov 2017 04:54:45 -0800 (PST) In-Reply-To: References: From: Samir Magar Date: Wed, 15 Nov 2017 18:24:45 +0530 Message-ID: Subject: Re: query performance issue To: Pavel Stehule , pgsql-performance@postgresql.org Content-Type: multipart/mixed; boundary="001a1141158814ad92055e050239" 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 --001a1141158814ad92055e050239 Content-Type: multipart/alternative; boundary="001a1141158814ad8c055e050237" --001a1141158814ad8c055e050237 Content-Type: text/plain; charset="UTF-8" please find the EXPLAIN ANALYZE output. On Wed, Nov 15, 2017 at 3:13 PM, Pavel Stehule wrote: > Hi > > please send EXPLAIN ANALYZE output. > > Regards > > Pavel > > 2017-11-15 10:33 GMT+01:00 Samir Magar : > >> 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 >> >> >> -- >> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org >> ) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-performance >> >> > --001a1141158814ad8c055e050237 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
please find the=C2=A0EXPL= AIN ANALYZE output.

On Wed, Nov 15, 2017 at 3:13 PM, Pavel Stehule <p= avel.stehule@gmail.com> wrote:
Hi

please send EXPLAIN ANA= LYZE output.

Regards

Pavel

2017-11= -15 10:33 GMT+01:00 Samir Magar <samirmagar8@gmail.com>:=
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
e= ffective_cache_size =3D 12 GB

we are doing the vac= uum/analyze regularly on the database.=C2=A0

attac= hed is the query with its explain plan.

Thanks,
Samir Magar=C2=A0=C2=A0


--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-pe= rformance



--001a1141158814ad8c055e050237-- --001a1141158814ad92055e050239 Content-Type: text/plain; charset="US-ASCII"; name="explain with analyze.txt" Content-Disposition: attachment; filename="explain with analyze.txt" Content-Transfer-Encoding: base64 X-Attachment-Id: f_ja11tulg0 Ikhhc2hBZ2dyZWdhdGUgIChjb3N0PTQ0NTkuNjguLjQ0NTkuNjkgcm93cz0x IHdpZHRoPTI3KSAoYWN0dWFsIHRpbWU9Mjg5MDAzNS40MDMuLjI4OTIxNzMu NjAxIHJvd3M9MzQ4OTg2MSBsb29wcz0xKSINCiIgIEdyb3VwIEtleTogZGxy X3FsZnkuZGxyX3FsZnlfaWQsIG5tcV9yZXEuZ3JhY2VfcHJkLCBubXFfcmVx LmhpZGVfcHJnX2ZsZywgbm1xX3JlcS5udGZ5X2Rscl9mbGcsIGRscl9sb2Mu YWNjdF9udW0sIG5tcV9yZXEubm1xX3JlcV9pZCwgbmV3X21kbC5waV9tZGxf aWQiDQoiICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTMuNTkuLjQ0NTkuNjcg cm93cz0xIHdpZHRoPTI3KSAoYWN0dWFsIHRpbWU9MC4yMjguLjI4NjQ1OTQu MTc3IHJvd3M9MTIzMjEyODkgbG9vcHM9MSkiDQoiICAgICAgICAtPiAgTmVz dGVkIExvb3AgIChjb3N0PTMuMzEuLjQ0NTkuMjkgcm93cz0xIHdpZHRoPTI3 KSAoYWN0dWFsIHRpbWU9MC4yMjEuLjI4MTk5MjcuMjQ5IHJvd3M9MTIzMjEy ODkgbG9vcHM9MSkiDQoiICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3Ag IChjb3N0PTMuMDMuLjQ0NTEuNDUgcm93cz0xIHdpZHRoPTE1KSAoYWN0dWFs IHRpbWU9MC4xNTguLjM2ODE2LjMwNCByb3dzPTEyNjEyOTgzIGxvb3BzPTEp Ig0KIiAgICAgICAgICAgICAgICAgICAgSm9pbiBGaWx0ZXI6IChsZWFkX2xv Yy5kbHJfbG9jX2lkID0gZGxyX2dycF8xLmxlYWRfZGxyX2xvY19pZCkiDQoi ICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTAu NTguLjEzNTguOTQgcm93cz0yNjMgd2lkdGg9MTUpIChhY3R1YWwgdGltZT0w LjA0Ni4uMzYzLjE1MCByb3dzPTUyMjYxIGxvb3BzPTEpIg0KIiAgICAgICAg ICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0wLjI5 Li4xMjI3LjQ2IHJvd3M9MTY5IHdpZHRoPTE1KSAoYWN0dWFsIHRpbWU9MC4w MjQuLjg2LjkwOSByb3dzPTEyMTUxIGxvb3BzPTEpIg0KIiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIGRscl9sb2Mg bGVhZF9sb2MgIChjb3N0PTAuMDAuLjc1Ny44MCByb3dzPTE2OSB3aWR0aD00 KSAoYWN0dWFsIHRpbWU9MC4wMTAuLjMxLjAyOCByb3dzPTEyMTUxIGxvb3Bz PTEpIg0KIiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg RmlsdGVyOiAoYWNjdF9udW0gPSBjb2dfcGFybnRfYWNjdCkiDQoiICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBSb3dzIFJlbW92ZWQg YnkgRmlsdGVyOiAyMTU5MyINCiIgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIC0+ICBJbmRleCBPbmx5IFNjYW4gdXNpbmcgIklEWF8xMDEiIG9u IGRscl9sb2MgY29nX2xlYWQgIChjb3N0PTAuMjkuLjIuNzcgcm93cz0xIHdp ZHRoPTExKSAoYWN0dWFsIHRpbWU9MC4wMDMuLjAuMDA0IHJvd3M9MSBsb29w cz0xMjE1MSkiDQoiICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICBJbmRleCBDb25kOiAoZGxyX2xvY19pZCA9IGxlYWRfbG9jLmRscl9s b2NfaWQpIg0KIiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgSGVhcCBGZXRjaGVzOiAwIg0KIiAgICAgICAgICAgICAgICAgICAgICAg ICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgaWR4XzE0IG9uIHN0Z19hY2ZseF9u bXFfZGxycyAgKGNvc3Q9MC4yOS4uMC42MyByb3dzPTE1IHdpZHRoPTE0KSAo YWN0dWFsIHRpbWU9MC4wMDguLjAuMDE5IHJvd3M9NCBsb29wcz0xMjE1MSki DQoiICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25k OiAocmx0bnBfbGVhZF9hY2N0ID0gY29nX2xlYWQuYWNjdF9udW0pIg0KIiAg ICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0yLjQ1 Li4xMS43NSByb3dzPTEgd2lkdGg9MzMpIChhY3R1YWwgdGltZT0wLjA1OC4u MC42MTUgcm93cz0yNDEgbG9vcHM9NTIyNjEpIg0KIiAgICAgICAgICAgICAg ICAgICAgICAgICAgLT4gIEluZGV4IE9ubHkgU2NhbiB1c2luZyBpZHgzIG9u IGRscl9ncnAgZGxyX2dycF8xICAoY29zdD0wLjI5Li4wLjMyIHJvd3M9MSB3 aWR0aD04KSAoYWN0dWFsIHRpbWU9MC4wMDUuLjAuMDA1IHJvd3M9MSBsb29w cz01MjI2MSkiDQoiICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJ bmRleCBDb25kOiAoKGxlYWRfZGxyX2xvY19pZCA9IGNvZ19sZWFkLmRscl9s b2NfaWQpIEFORCAoZGxyX2dycF90eXAgPSAnQ09HJzo6YnBjaGFyKSkiDQoi ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBIZWFwIEZldGNoZXM6 IDAiDQoiICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExv b3AgIChjb3N0PTIuMTcuLjExLjQyIHJvd3M9MSB3aWR0aD0zNykgKGFjdHVh bCB0aW1lPTAuMDUxLi4wLjUzMCByb3dzPTIzNiBsb29wcz01MzQzNikiDQoi ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBKb2luIEZpbHRlcjog KGRscl9sb2NfMi5hY2N0X251bSA9IGRscl9sb2MuYWNjdF9udW0pIg0KIiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29w ICAoY29zdD0wLjU4Li4wLjc3IHJvd3M9MSB3aWR0aD0xMSkgKGFjdHVhbCB0 aW1lPTAuMDE1Li4wLjAxNiByb3dzPTEgbG9vcHM9NTM0MzYpIg0KIiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IE9u bHkgU2NhbiB1c2luZyBpZHg2IG9uIGRscl9sb2MgZGxyX2xvY18yICAoY29z dD0wLjI5Li4wLjMyIHJvd3M9MSB3aWR0aD0xMSkgKGFjdHVhbCB0aW1lPTAu MDA5Li4wLjAwOSByb3dzPTEgbG9vcHM9NTM0MzYpIg0KIiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDog KChhY2N0X251bSA9IHN0Z19hY2ZseF9ubXFfZGxycy5hY2N0X2lkKSBBTkQg KGlzX2FjdHYgPSAnWSc6OmJwY2hhcikpIg0KIiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgSGVhcCBGZXRjaGVzOiAwIg0K IiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIElu ZGV4IE9ubHkgU2NhbiB1c2luZyBpZHg3IG9uIGRscl9ncnBfZGxyX3hyZWYg ZGxyX2dycF9kbHJfeHJlZl8xICAoY29zdD0wLjI5Li4wLjQzIHJvd3M9MSB3 aWR0aD04KSAoYWN0dWFsIHRpbWU9MC4wMDQuLjAuMDA1IHJvd3M9MSBsb29w cz01MzQwMikiDQoiICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICBJbmRleCBDb25kOiAoKGRscl9sb2NfaWQgPSBkbHJfbG9j XzIuZGxyX2xvY19pZCkgQU5EIChkbHJfZ3JwX2lkID0gZGxyX2dycF8xLmRs cl9ncnBfaWQpKSINCiIgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIEhlYXAgRmV0Y2hlczogMCINCiIgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MS41 OC4uMTAuNjQgcm93cz0xIHdpZHRoPTI2KSAoYWN0dWFsIHRpbWU9MC4wMzYu LjAuNDI1IHJvd3M9MjQzIGxvb3BzPTUxOTg4KSINCiIgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBPbmx5IFNjYW4g dXNpbmcgaWR4MTAgb24gZGxyX2xvYyAgKGNvc3Q9MC4yOS4uMC4zMiByb3dz PTEgd2lkdGg9NykgKGFjdHVhbCB0aW1lPTAuMDA5Li4wLjAwOSByb3dzPTEg bG9vcHM9NTE5ODgpIg0KIiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKChpc19hY3R2ID0gJ1knOjpi cGNoYXIpIEFORCAoYWNjdF9udW0gPSBzdGdfYWNmbHhfbm1xX2RscnMuYWNj dF9pZCkpIg0KIiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgSGVhcCBGZXRjaGVzOiAwIg0KIiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0x LjI5Li4xMC4zMCByb3dzPTEgd2lkdGg9MTkpIChhY3R1YWwgdGltZT0wLjAy Ni4uMC4zNTQgcm93cz0yNDMgbG9vcHM9NTE5ODgpIg0KIiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IE9u bHkgU2NhbiB1c2luZyBpZHg2IG9uIGRscl9sb2MgZGxyX2xvY18xICAoY29z dD0wLjI5Li4wLjM0IHJvd3M9MSB3aWR0aD0xMSkgKGFjdHVhbCB0aW1lPTAu MDA2Li4wLjAwNiByb3dzPTEgbG9vcHM9NTE5ODgpIg0KIiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXgg Q29uZDogKChhY2N0X251bSA9IGRscl9sb2MuYWNjdF9udW0pIEFORCAoaXNf YWN0diA9ICdZJzo6YnBjaGFyKSkiDQoiICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICBIZWFwIEZldGNoZXM6IDAi DQoiICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTEuMDAuLjkuOTUgcm93cz0xIHdp ZHRoPTE2KSAoYWN0dWFsIHRpbWU9MC4wMTkuLjAuMjczIHJvd3M9MjQzIGxv b3BzPTUxOTg4KSINCiIgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBPbmx5IFNjYW4gdXNpbmcg aWR4NyBvbiBkbHJfZ3JwX2Rscl94cmVmICAoY29zdD0wLjI5Li4wLjM1IHJv d3M9MiB3aWR0aD04KSAoYWN0dWFsIHRpbWU9MC4wMDIuLjAuMDAzIHJvd3M9 MiBsb29wcz01MTk4OCkiDQoiICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAoZGxy X2xvY19pZCA9IGRscl9sb2NfMS5kbHJfbG9jX2lkKSINCiIgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IEhlYXAgRmV0Y2hlczogMCINCiIgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNv c3Q9MC43MS4uNC43OSByb3dzPTEgd2lkdGg9MjApIChhY3R1YWwgdGltZT0w LjAxNS4uMC4xMDUgcm93cz0xMjEgbG9vcHM9MTAzOTg3KSINCiIgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGlkeGRnMyBvbiBkbHJfZ3JwICAo Y29zdD0wLjI5Li4wLjMzIHJvd3M9MSB3aWR0aD00KSAoYWN0dWFsIHRpbWU9 MC4wMDUuLjAuMDA2IHJvd3M9MSBsb29wcz0xMDM5ODcpIg0KIiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgSW5kZXggQ29uZDogKGRscl9ncnBfaWQgPSBkbHJfZ3JwX2Rs cl94cmVmLmRscl9ncnBfaWQpIg0KIiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgRmlsdGVy OiAoKGRscl9ncnBfdHlwID0gJ0xPQyc6OmJwY2hhcikgT1IgKGRscl9ncnBf dHlwID0gJ0NPRyc6OmJwY2hhcikpIg0KIiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4 IE9ubHkgU2NhbiB1c2luZyBpZHhkcTcgb24gZGxyX3FsZnkgIChjb3N0PTAu NDMuLjQuNDUgcm93cz0xIHdpZHRoPTE2KSAoYWN0dWFsIHRpbWU9MC4wMDku LjAuMDY2IHJvd3M9MTIxIGxvb3BzPTEwMzk4NykiDQoiICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICBJbmRleCBDb25kOiAoKHFsZnlfZ3JwX2lkID0gZGxyX2dycC5kbHJf Z3JwX2lkKSBBTkQgKHFsZl9mbGcgPSAnTic6OmJwY2hhcikgQU5EIChjb2df Z3JwX2lkID0gZGxyX2dycF9kbHJfeHJlZl8xLmRscl9ncnBfaWQpKSINCiIg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIEhlYXAgRmV0Y2hlczogMCINCiIgICAgICAgICAg ICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIHBfa2V5XzI5IG9uIG5tcV9yZXEg IChjb3N0PTAuMjguLjcuODMgcm93cz0xIHdpZHRoPTE2KSAoYWN0dWFsIHRp bWU9MC4yMTkuLjAuMjIwIHJvd3M9MSBsb29wcz0xMjYxMjk4MykiDQoiICAg ICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAobm1xX3JlcV9pZCA9IGRs cl9xbGZ5Lm5tcV9yZXFfaWQpIg0KIiAgICAgICAgICAgICAgICAgICAgRmls dGVyOiAoKHBnbV9kc2JsX2ZsZyA8PiAnWSc6OmJwY2hhcikgQU5EIChwZ21f c3RhcnRfZHQgPD0gKCdub3cnOjpjc3RyaW5nKTo6ZGF0ZSkgQU5EIChwZ21f ZW5kX2R0ID4gKCdub3cnOjpjc3RyaW5nKTo6ZGF0ZSkgQU5EIChOT1QgKFN1 YlBsYW4gMSkpKSINCiIgICAgICAgICAgICAgICAgICAgIFJvd3MgUmVtb3Zl ZCBieSBGaWx0ZXI6IDAiDQoiICAgICAgICAgICAgICAgICAgICBTdWJQbGFu IDEiDQoiICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBPbmx5IFNj YW4gdXNpbmcgaWR4MTEgb24gZGxyX3FsZnkgZGxyX3FsZnlfMSAgKGNvc3Q9 MC40My4uMTMuOTEgcm93cz0yNzQgd2lkdGg9NCkgKGFjdHVhbCB0aW1lPTAu MDA4Li4wLjE1MyByb3dzPTU3NiBsb29wcz0xMjMyMTI4OSkiDQoiICAgICAg ICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICgobm1xX3JlcV9p ZCA9IG5tcV9yZXEubm1xX3JlcV9pZCkgQU5EIChxbGZfZmxnID0gJ1knOjpi cGNoYXIpKSINCiIgICAgICAgICAgICAgICAgICAgICAgICAgICAgSGVhcCBG ZXRjaGVzOiAwIg0KIiAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgaWR4 MSBvbiBuZXdfbWRsICAoY29zdD0wLjI4Li4wLjM3IHJvd3M9MSB3aWR0aD04 KSAoYWN0dWFsIHRpbWU9MC4wMDIuLjAuMDAzIHJvd3M9MSBsb29wcz0xMjMy MTI4OSkiDQoiICAgICAgICAgICAgICBJbmRleCBDb25kOiAobmV3X21kbF9p ZCA9IG5tcV9yZXEubmV3X21kbF9pZCkiDQoiUGxhbm5pbmcgdGltZTogNjku Nzc0IG1zIg0KIkV4ZWN1dGlvbiB0aW1lOiAyODkyNDQ1LjgyOSBtcyINCg== --001a1141158814ad92055e050239 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 --001a1141158814ad92055e050239--