Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jiO6y-0006Gq-Ep for pgsql-bugs@arkaria.postgresql.org; Mon, 08 Jun 2020 20:11:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jiO6x-0005Wv-Ej for pgsql-bugs@arkaria.postgresql.org; Mon, 08 Jun 2020 20:11:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jiN6v-0005Q7-QR for pgsql-bugs@lists.postgresql.org; Mon, 08 Jun 2020 19:07:05 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jiN6s-0001rP-CW for pgsql-bugs@lists.postgresql.org; Mon, 08 Jun 2020 19:07:05 +0000 Content-Type: multipart/mixed; boundary="===============0298510234795029909==" MIME-Version: 1.0 Subject: BUG #16487: EXPLAIN produces JSON with duplicate "Workers" arrays To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: felix@felixge.de Reply-To: felix@felixge.de, pgsql-bugs@lists.postgresql.org Date: Mon, 08 Jun 2020 19:06:48 +0000 Message-ID: <16487-c253609c5d095ff1@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============0298510234795029909== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjQ4NwpMb2dnZWQgYnk6ICAgICAgICAgIEZlbGl4IEdlaXNlbmTDtnJm ZXIKRW1haWwgYWRkcmVzczogICAgICBmZWxpeEBmZWxpeGdlLmRlClBvc3RncmVTUUwgdmVyc2lv bjogMTIuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIEFueQpEZXNjcmlwdGlvbjogICAgICAgIAoKSGkg YWxsLA0KDQpJIGJlbGlldmUgSSBmb3VuZCBhIGJ1ZyB0aGF0IGNhdXNlcyBFWFBMQUlOIHRvIHBy b2R1Y2UgSlNPTiB3aXRoDQpkdXBsaWNhdGUgIldvcmtlcnMiIGFycmF5cyB3aGVuIHRoZSBmb2xs b3dpbmcgY29uZGl0aW9ucyBhcmUgbWV0Og0KDQotIFRoZSBvcHRpb25zIEFOQUxZWkUsIFZFUkJP U0UgYW5kIEZPUk1BVCBKU09OIGFyZSB1c2VkIHRvZ2V0aGVyLg0KLSBUaGVyZSBpcyBhIFNvcnQg bm9kZSBpbiB0aGUgcGxhbiB0aGF0IGlzIGV4ZWN1dGVkIGluIHBhcmFsbGVsLg0KDQpCZWxvdyBp cyBhbiBleGFtcGxlIHRoYXQgc2hvdWxkIHJlcHJvZHVjZSB0aGUgaXNzdWUgaW4gYWxsIHZlcnNp b24gb2YNClBvc3RncmVTUUwgPj0gMTAuIEkgdGVzdGVkIHdpdGggMTIuMSBhbmQgMTEuNi4NCg0K LS0gQ3JlYXRlIGEgc2FtcGxlIHRhYmxlIGFuZCBudWRnZSB0aGUgcGxhbm5lciB0byB1c2UgYSBw YXJhbGxlbCBwbGFuDQpDUkVBVEUgVEFCTEUgZm9vIEFTDQpTRUxFQ1QgKiBGUk9NIGdlbmVyYXRl X3NlcmllcygxLCAxMDAwMCkgdmFsOw0KU0VUIHBhcmFsbGVsX3NldHVwX2Nvc3QgPSAwOw0KU0VU IHBhcmFsbGVsX3R1cGxlX2Nvc3QgPSAwOw0KU0VUIG1pbl9wYXJhbGxlbF90YWJsZV9zY2FuX3Np emU9MDsNCi0tIFJ1biB0aGUgYWN0dWFsIHF1ZXJ5IHRoYXQgY2F1c2VzIHRoZSBpbnZhbGlkIEpT T04gb3V0cHV0DQpFWFBMQUlOIChBTkFMWVpFLCBWRVJCT1NFLCBGT1JNQVQgSlNPTikNClNFTEVD VCAqIEZST00gZm9vIE9SREVSIEJZIHZhbDsNCg0KQmVsb3cgaXMgdGhlIHJlbGV2YW50IHN1YnNl dCBvZiB0aGUgSlNPTiBwcm9kdWNlZCBieSB0aGUgcXVlcnkgYWJvdmUuDQpOb3RlIHRoZSBkdXBs aWNhdGUgIldvcmtlcnMiIGFycmF5czoNCg0Kew0KICAiTm9kZSBUeXBlIjogIlNvcnQiLA0KICAi V29ya2VycyI6IFsNCiAgICB7DQogICAgICAiV29ya2VyIE51bWJlciI6IDAsDQogICAgICAiU29y dCBNZXRob2QiOiAicXVpY2tzb3J0IiwNCiAgICAgICJTb3J0IFNwYWNlIFVzZWQiOiAyNSwNCiAg ICAgICJTb3J0IFNwYWNlIFR5cGUiOiAiTWVtb3J5Ig0KICAgIH0sDQogICAgew0KICAgICAgIldv cmtlciBOdW1iZXIiOiAxLA0KICAgICAgIlNvcnQgTWV0aG9kIjogInF1aWNrc29ydCIsDQogICAg ICAiU29ydCBTcGFjZSBVc2VkIjogMjUsDQogICAgICAiU29ydCBTcGFjZSBUeXBlIjogIk1lbW9y eSINCiAgICB9DQogIF0sDQogICJXb3JrZXJzIjogWw0KICAgIHsNCiAgICAgICJXb3JrZXIgTnVt YmVyIjogMCwNCiAgICAgICJBY3R1YWwgU3RhcnR1cCBUaW1lIjogMC4yMzAsDQogICAgICAiQWN0 dWFsIFRvdGFsIFRpbWUiOiAwLjIzMCwNCiAgICAgICJBY3R1YWwgUm93cyI6IDAsDQogICAgICAi QWN0dWFsIExvb3BzIjogMQ0KICAgIH0sDQogICAgew0KICAgICAgIldvcmtlciBOdW1iZXIiOiAx LA0KICAgICAgIkFjdHVhbCBTdGFydHVwIFRpbWUiOiAwLjIzMSwNCiAgICAgICJBY3R1YWwgVG90 YWwgVGltZSI6IDAuMjMxLA0KICAgICAgIkFjdHVhbCBSb3dzIjogMCwNCiAgICAgICJBY3R1YWwg TG9vcHMiOiAxDQogICAgfQ0KICBdDQp9DQoNCkFjY29yZGluZyB0byBSRkMgODI1OSwgSSB0aGlu ayB0aGlzIGlzIHRlY2huaWNhbGx5IHN0aWxsIHZhbGlkIEpTT046DQoNCj4gV2hlbiB0aGUgbmFt ZXMgd2l0aGluIGFuIG9iamVjdCBhcmUgbm90IHVuaXF1ZSwgdGhlIGJlaGF2aW9yIG9mDQo+IHNv ZnR3YXJlIHRoYXQgcmVjZWl2ZXMgc3VjaCBhbiBvYmplY3QgaXMgdW5wcmVkaWN0YWJsZS4NCg0K SG93ZXZlciwgSSdtIHN0aWxsIHJlcG9ydGluZyB0aGlzIGFzIGEgYnVnIHNpbmNlIEkgYXNzdW1l IHRoYXQgdGhlDQpGT1JNQVQgSlNPTiBvcHRpb24gaXMgaW50ZW5kZWQgdG8gaGF2ZSBnb29kIGlu dGVyb3BlcmFiaWxpdHkgd2l0aCBvdGhlcg0Kc29mdHdhcmUuDQoNCkkndmUgYWxzbyBoYWQgYSBs b29rIGluIHRoZSBjb2RlLCBhbmQgYmVsaWV2ZSB0aGUgaXNzdWUgd2FzIGludHJvZHVjZWQNCmlu dG8gYmFja2VuZC9jb21tYW5kcy9leHBsYWluLmMgaW4gYmYxMWU3ZS4NCg0KSWYgc29tZWJvZHkg aXMgd2lsbGluZyB0byBndWlkZSBtZSBhIGxpdHRsZSwgSSdkIGFsc28gYmUgaW50ZXJlc3RlZCBp bg0KYXR0ZW1wdGluZyB0byBjcmVhdGUgYSBwYXRjaCB0byBmaXggdGhpcy4gSSBoYXZlbid0IGNv bnRyaWJ1dGVkIHRvDQpQb3N0Z3JlU1FMIGJlZm9yZSBhbmQgdGhpcyBzZWVtcyBsaWtlIGEgbmlj ZSBvcHBvcnR1bml0eS4NCg0KQ2hlZXJzDQpGZWxpeAoK --===============0298510234795029909==--