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 1pgkAX-00019F-RF for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Mar 2023 10:33:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pgkAW-0002tA-Km for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Mar 2023 10:33:40 +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 1pghOk-0003gx-Ui for pgsql-bugs@lists.postgresql.org; Mon, 27 Mar 2023 07:36:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pghOf-0007oH-1t for pgsql-bugs@lists.postgresql.org; Mon, 27 Mar 2023 07:36:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=TmlyRMgz2EP2kX5ea/7SmyDrail0cZKpHcbJN0cBkZI=; b=E51fqArW6C/Qo70EIahMsxqCkG Nd23vd1T+O1MhvtGQheR96txbZo8WF+o6toPsiJ+XJqCjf/IwXSrjcWFYD303NWxIq8t7WkaePC9e IkadIIzgnjdhD608E5iBPxtdNWIlnIpbc5H9yKrK/L3jCVxgP2fH9zFwHkcV87DNvtyKKWYyOPqzR NrsOO5+/zEcuC0ZE54OwdU5z47XUHDfPq5Q5mzWmQ0PNrhUCx+3wZGWAQAudOLvMKh3M2jLODQoU0 Q7++KnfknMbxJFYp4WSN/oZXH7lgPYX78dy6iALRKWkS/GtVr50581dwI+PEBgbPmEh65LyMd/nGT fcJqaGBw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pghOd-0003Ok-NT for pgsql-bugs@lists.postgresql.org; Mon, 27 Mar 2023 07:36:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pghOa-001rDd-Rq for pgsql-bugs@lists.postgresql.org; Mon, 27 Mar 2023 07:36:02 +0000 Content-Type: multipart/mixed; boundary="===============3107954939147168741==" MIME-Version: 1.0 Subject: BUG #17870: Analyze on remote postgresql_fdw table never finish To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: maxim.boguk@gmail.com Reply-To: maxim.boguk@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 27 Mar 2023 07:35:39 +0000 Message-ID: <17870-2949e79d1b0a32e5@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3107954939147168741== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzg3MApMb2dnZWQgYnk6ICAgICAgICAgIE1heGltIEJvZ3VrCkVtYWls IGFkZHJlc3M6ICAgICAgbWF4aW0uYm9ndWtAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTMuOQpPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSwN Cg0KSSBmb3VuZCBzdHJhbmdlIHNpdHVhdGlvbiB3aGVuIEkgdHJ5IHRvIHBvcHVsYXRlIGxvY2Fs IHN0YXRpc3RpYyBmcm9tIHJlbW90ZQpwb3N0Z2VzcWxfZmR3IHRhYmxlOg0KYW5hbHl6ZSB2ZXJi b3NlIGNvbGRfcmVwbGljYV9mZHcuaW50ZXJ2aWV3X3Jldmlld19pbmZvX2FyY2hpdmU7DQotIG5l dmVyIGVuZHMsDQoNCkxvY2FsIGFuZCByZW1vdGUgREIgaW4gdGhlIHNhbWUgZGF0YWNlbnRlciB3 aXRoIG1vcmUgdG90YWwgYmFuZHdpZHRoIDIwR2JwcwphbmQgbGF0ZW5jeSB1bmRlciAwLjFtcyAo Ym90aCB0ZXN0ZWQvdmVyaWZpZWQpLCBzbyBubyBuZXR3b3JrIGlzc3Vlcy4NCg0KV2hhdCBJIHNl ZSBvbiBsb2NhbCBzaWRlIHdpdGggc2V0IGNsaWVudF9taW5fbWVzc2FnZXMgdG8gZGVidWc1OzoN CmhoX2RhdGE9IyBhbmFseXplIHZlcmJvc2UgY29sZF9yZXBsaWNhX2Zkdy5pbnRlcnZpZXdfcmV2 aWV3X2luZm9fYXJjaGl2ZTsNCkRFQlVHOiAgZGlzY2FyZGluZyBjb25uZWN0aW9uIDB4NTYzNjU2 OTgxOTAwDQpERUJVRzogIHNpbnZhbCBjYXRjaHVwIGNvbXBsZXRlLCBjbGVhbmluZyBxdWV1ZQ0K REVCVUc6ICBTdGFydFRyYW5zYWN0aW9uKDEpIG5hbWU6IHVubmFtZWQ7IGJsb2NrU3RhdGU6IERF RkFVTFQ7IHN0YXRlOgpJTlBST0dSRVNTLCB4aWQvc3ViaWQvY2lkOiAwLzEvMA0KREVCVUc6ICBD b21taXRUcmFuc2FjdGlvbigxKSBuYW1lOiB1bm5hbWVkOyBibG9ja1N0YXRlOiBTVEFSVEVEOyBz dGF0ZToKSU5QUk9HUkVTUywgeGlkL3N1YmlkL2NpZDogMC8xLzANCkRFQlVHOiAgU3RhcnRUcmFu c2FjdGlvbigxKSBuYW1lOiB1bm5hbWVkOyBibG9ja1N0YXRlOiBERUZBVUxUOyBzdGF0ZToKSU5Q Uk9HUkVTUywgeGlkL3N1YmlkL2NpZDogMC8xLzANCkRFQlVHOiAgbmV3IHBvc3RncmVzX2ZkdyBj b25uZWN0aW9uIDB4NTYzNjU2OThmYzQwIGZvciBzZXJ2ZXIgImNvbGRfcmVwbGljYSIKKHVzZXIg bWFwcGluZyBvaWQgMjYzOTk2NjA3LCB1c2VyaWQgMTApDQpERUJVRzogIHN0YXJ0aW5nIHJlbW90 ZSB0cmFuc2FjdGlvbiBvbiBjb25uZWN0aW9uIDB4NTYzNjU2OThmYzQwDQpJTkZPOiAgYW5hbHl6 aW5nICJjb2xkX3JlcGxpY2FfZmR3LmludGVydmlld19yZXZpZXdfaW5mb19hcmNoaXZlIg0KYW5k ICBzdGF5cyB0aGVyZSBmb3IgaG91cnMuLi4NCg0KV2hhdCBJIHNlZSBvbiB0aGUgcmVtb3ZlIGRh dGFiYXNlIHdpdGggbG9nX21pbl9kdXJhdGlvbl9zdGF0ZW1lbnQgc2V0IHRvIDAKdG8gRkRXIHVz ZXI6DQoyMDIzLTAzLTI3IDEwOjExOjI0Ljc2MyBVVEMgNjM2MTMwCm5lZ290aWF0aW9uX2NoYXRf YXJjaGl2ZV9yby5mZHdAbmVnb3RpYXRpb25fY2hhdF9hcmNoaXZlIGZyb20gW2xvY2FsXQpbdnhp ZDozOS8wIHR4aWQ6MF0gW1NFVF0gTE9HOiAgZHVyYXRpb246IDAuMDg2IG1zICBzdGF0ZW1lbnQ6 IFNFVAphcHBsaWNhdGlvbl9uYW1lPSdwb3N0Z3Jlc19mZHcnOw0KMjAyMy0wMy0yNyAxMDoxMToy NC43NjMgVVRDIDYzNjEzMApuZWdvdGlhdGlvbl9jaGF0X2FyY2hpdmVfcm8uZmR3QG5lZ290aWF0 aW9uX2NoYXRfYXJjaGl2ZSBmcm9tIFtsb2NhbF0KW3Z4aWQ6MzkvMCB0eGlkOjBdIFtTRVRdIExP RzogIGR1cmF0aW9uOiAwLjAyOSBtcyAgc3RhdGVtZW50OiBTRVQKc2VhcmNoX3BhdGggPSBwZ19j YXRhbG9nDQoyMDIzLTAzLTI3IDEwOjExOjI0Ljc2NCBVVEMgNjM2MTMwCm5lZ290aWF0aW9uX2No YXRfYXJjaGl2ZV9yby5mZHdAbmVnb3RpYXRpb25fY2hhdF9hcmNoaXZlIGZyb20gW2xvY2FsXQpb dnhpZDozOS8wIHR4aWQ6MF0gW1NFVF0gTE9HOiAgZHVyYXRpb246IDAuMTY2IG1zICBzdGF0ZW1l bnQ6IFNFVCB0aW1lem9uZSA9CidVVEMnDQoyMDIzLTAzLTI3IDEwOjExOjI0Ljc2NCBVVEMgNjM2 MTMwCm5lZ290aWF0aW9uX2NoYXRfYXJjaGl2ZV9yby5mZHdAbmVnb3RpYXRpb25fY2hhdF9hcmNo aXZlIGZyb20gW2xvY2FsXQpbdnhpZDozOS8wIHR4aWQ6MF0gW1NFVF0gTE9HOiAgZHVyYXRpb246 IDAuMDIzIG1zICBzdGF0ZW1lbnQ6IFNFVCBkYXRlc3R5bGUKPSBJU08NCjIwMjMtMDMtMjcgMTA6 MTE6MjQuNzY1IFVUQyA2MzYxMzAKbmVnb3RpYXRpb25fY2hhdF9hcmNoaXZlX3JvLmZkd0BuZWdv dGlhdGlvbl9jaGF0X2FyY2hpdmUgZnJvbSBbbG9jYWxdClt2eGlkOjM5LzAgdHhpZDowXSBbU0VU XSBMT0c6ICBkdXJhdGlvbjogMC4wMzIgbXMgIHN0YXRlbWVudDogU0VUCmludGVydmFsc3R5bGUg PSBwb3N0Z3Jlcw0KMjAyMy0wMy0yNyAxMDoxMToyNC43NjUgVVRDIDYzNjEzMApuZWdvdGlhdGlv bl9jaGF0X2FyY2hpdmVfcm8uZmR3QG5lZ290aWF0aW9uX2NoYXRfYXJjaGl2ZSBmcm9tIFtsb2Nh bF0KW3Z4aWQ6MzkvMCB0eGlkOjBdIFtTRVRdIExPRzogIGR1cmF0aW9uOiAwLjAzMiBtcyAgc3Rh dGVtZW50OiBTRVQKZXh0cmFfZmxvYXRfZGlnaXRzID0gMw0KMjAyMy0wMy0yNyAxMDoxMToyNC43 NjYgVVRDIDYzNjEzMApuZWdvdGlhdGlvbl9jaGF0X2FyY2hpdmVfcm8uZmR3QG5lZ290aWF0aW9u X2NoYXRfYXJjaGl2ZSBmcm9tIFtsb2NhbF0KW3Z4aWQ6MzkvMzU2ODAyNjcyIHR4aWQ6MF0gW1NU QVJUIFRSQU5TQUNUSU9OXSBMT0c6ICBkdXJhdGlvbjogMC4wMjEgbXMgCnN0YXRlbWVudDogU1RB UlQgVFJBTlNBQ1RJT04gSVNPTEFUSU9OIExFVkVMIFJFUEVBVEFCTEUgUkVBRA0KMjAyMy0wMy0y NyAxMDoxMToyNC43NjcgVVRDIDYzNjEzMApuZWdvdGlhdGlvbl9jaGF0X2FyY2hpdmVfcm8uZmR3 QG5lZ290aWF0aW9uX2NoYXRfYXJjaGl2ZSBmcm9tIFtsb2NhbF0KW3Z4aWQ6MzkvMzU2ODAyNjcy IHR4aWQ6MF0gW1NFTEVDVF0gTE9HOiAgZHVyYXRpb246IDAuNDQ2IG1zICBzdGF0ZW1lbnQ6ClNF TEVDVApwZ19jYXRhbG9nLnBnX3JlbGF0aW9uX3NpemUoJ3B1YmxpYy5pbnRlcnZpZXdfcmV2aWV3 X2luZm9fYXJjaGl2ZSc6OnBnX2NhdGFsb2cucmVnY2xhc3MpCi8gODE5Mg0KMjAyMy0wMy0yNyAx MDoxMToyNC44NjEgVVRDIDYzNjEzMApuZWdvdGlhdGlvbl9jaGF0X2FyY2hpdmVfcm8uZmR3QG5l Z290aWF0aW9uX2NoYXRfYXJjaGl2ZSBmcm9tIFtsb2NhbF0KW3Z4aWQ6MzkvMzU2ODAyNjcyIHR4 aWQ6MF0gW0RFQ0xBUkUgQ1VSU09SXSBMT0c6ICBkdXJhdGlvbjogOTIuOTQyIG1zIApzdGF0ZW1l bnQ6IERFQ0xBUkUgYzEgQ1VSU09SIEZPUiBTRUxFQ1QgdG9waWNfaWQsIHJldmlld19pZCwKbW92 ZV90b19pbnZpdGF0aW9uX3N0YXRlX3RpbWUsIG5vX2ludGVydmlld19yZXBseV90aW1lLApyZXZp ZXdfc3VnZ2VzdGlvbl9jaGF0X21lc3NhZ2VfY3JlYXRpb25fdGltZSBGUk9NCnB1YmxpYy5pbnRl cnZpZXdfcmV2aWV3X2luZm9fYXJjaGl2ZQ0KMjAyMy0wMy0yNyAxMDoxMToyOC4yNjggVVRDIDYz NjEzMApuZWdvdGlhdGlvbl9jaGF0X2FyY2hpdmVfcm8uZmR3QG5lZ290aWF0aW9uX2NoYXRfYXJj aGl2ZSBmcm9tIFtsb2NhbF0KW3Z4aWQ6MzkvMzU2ODAyNjcyIHR4aWQ6MF0gW0ZFVENIXSBMT0c6 ICBkdXJhdGlvbjogMzQwNi40NjIgbXMgIHN0YXRlbWVudDoKRkVUQ0ggMTAwIEZST00gYzENCjIw MjMtMDMtMjcgMTA6MTE6MjguMjY5IFVUQyA2MzYxMzAKbmVnb3RpYXRpb25fY2hhdF9hcmNoaXZl X3JvLmZkd0BuZWdvdGlhdGlvbl9jaGF0X2FyY2hpdmUgZnJvbSBbbG9jYWxdClt2eGlkOjM5LzM1 NjgwMjY3MiB0eGlkOjBdIFtGRVRDSF0gTE9HOiAgZHVyYXRpb246IDAuMDk0IG1zICBzdGF0ZW1l bnQ6CkZFVENIIDEwMCBGUk9NIGMxDQoNCmFuZCB0aGVuIGNvbnRpbnVlIGZldGNoIGZvcmV2ZXIs IG9uIHRoZSBsYXN0IGF0dGVtcHQgaXQgZmV0Y2hlZCBmcm9tIGN1cnNvcgpvdmVyIDVNIHRpbWVz IGJlZm9yZSBJIGNhbmNlbGVkIGFuYWx5emUgc3RhdGVtZW50Lg0KDQpwdWJsaWMuaW50ZXJ2aWV3 X3Jldmlld19pbmZvX2FyY2hpdmUgLSBodWdlIG5hdGl2ZSBwYXJ0aXRpb25lZCBieSByYW5nZQp0 YWJsZSB3aXRoIDEwMCBwYXJ0aXRpb25zIGFuZCAyVEIrIHNpemUuDQoNCklzIGl0IGV4cGVjdGVk IHRoYXQgdGhlIGFuYWx5emUgb2YgZm9yZWlnbiB0YWJsZSB3aWxsIGZldGNoIHdob2xlIHRhYmxl IHRvCmxvY2FsIHNpemUgKHF1aXRlIGEgdGFzayBmb3IgMlRCIHRhYmxlKT8NCg0KUFM6IEkgZG9u J3Qgd2FudCBlbmFibGUgYSByZW1vdGUgZXN0aW1hdGVzIGJlY2F1c2UgaXQgYWRkcyBodWdlIHBs YW5uaW5nCm92ZXJoZWFkICh3aXRoIHJlbW90ZV9lc3RpbWF0ZSAndHJ1ZScpOg0KIEZvcmVpZ24g U2NhbiBvbiBjb2xkX3JlcGxpY2FfZmR3LmludGVydmlld19yZXZpZXdfaW5mb19hcmNoaXZlIAoo Y29zdD0xNC4xMC4uMTQuMTQgcm93cz0xIHdpZHRoPTQwKSAoYWN0dWFsIHRpbWU9My45NjYuLjQu NjgxIHJvd3M9MQpsb29wcz0xKQ0KICAgT3V0cHV0OiB0b3BpY19pZCwgcmV2aWV3X2lkLCBtb3Zl X3RvX2ludml0YXRpb25fc3RhdGVfdGltZSwKbm9faW50ZXJ2aWV3X3JlcGx5X3RpbWUsIHJldmll d19zdWdnZXN0aW9uX2NoYXRfbWVzc2FnZV9jcmVhdGlvbl90aW1lDQogICBSZW1vdGUgU1FMOiBT RUxFQ1QgdG9waWNfaWQsIHJldmlld19pZCwgbW92ZV90b19pbnZpdGF0aW9uX3N0YXRlX3RpbWUs Cm5vX2ludGVydmlld19yZXBseV90aW1lLCByZXZpZXdfc3VnZ2VzdGlvbl9jaGF0X21lc3NhZ2Vf Y3JlYXRpb25fdGltZSBGUk9NCnB1YmxpYy5pbnRlcnZpZXdfcmV2aWV3X2luZm9fYXJjaGl2ZSBP UkRFUiBCWSB0b3BpY19pZCBBU0MgTlVMTFMgTEFTVCBMSU1JVAoxOjpiaWdpbnQNCiBQbGFubmlu ZyBUaW1lOiAxMy42NDYgbXMNCiBFeGVjdXRpb24gVGltZTogNS4zNDcgbXMKCg== --===============3107954939147168741==--