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 1mn4X9-0005WB-Rj for pgsql-docs@arkaria.postgresql.org; Tue, 16 Nov 2021 19:54:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mn4X8-0008G6-FA for pgsql-docs@arkaria.postgresql.org; Tue, 16 Nov 2021 19:54:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mmuum-0000vc-H1 for pgsql-docs@lists.postgresql.org; Tue, 16 Nov 2021 09:38:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mmuuk-0006We-BN for pgsql-docs@lists.postgresql.org; Tue, 16 Nov 2021 09:38:07 +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=ovPodaTUc54adYTaBOfbchDt7Uuz4C7h5H4ioxMNz60=; b=CTPyU++vnEzJt5CTKfDXuHB6Fz pHrDHiKr0ja9YRyfIvKpBTggVwFB0Yh7FD4Jh/shKp6pM3lc2+o14/y4emDUStgsz4SjZCWsEYihZ U5D02D7q1gDH2I0QIONuN5PiePsRsFW9P9zN6UoW9a2p5U9df9NQnAfctjSJ20kWocyJP9DKzd76F yhyo3DtNegmT0FsrqtvmrjCwQdT9TDc+Bywmqtoeql4U5uLW3UBznftXicEsEFslN8gc0iXFfILka 1xclgZxMOqyau1sQUNsxf2XBlA5KcHOmR6i+QRdmKDbBG985rFbX62NDWCGCabp9BWBY/sxkoupOB /7nJQXFQ==; 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 1mmuui-0003n6-T6 for pgsql-docs@lists.postgresql.org; Tue, 16 Nov 2021 09:38:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mmuug-00022r-Jc for pgsql-docs@lists.postgresql.org; Tue, 16 Nov 2021 09:38:02 +0000 Content-Type: multipart/mixed; boundary="===============5530668038956808723==" MIME-Version: 1.0 Subject: "actual time" in QUERY PLAN for parallel operation when loops is bigger than 1 To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: tanghy.fnst@fujitsu.com Reply-To: tanghy.fnst@fujitsu.com, pgsql-docs@lists.postgresql.org Date: Tue, 16 Nov 2021 09:37:21 +0000 Message-ID: <163705544128.11069.9460699508957759732@wrigleys.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 --===============5530668038956808723== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xNC91c2lu Zy1leHBsYWluLmh0bWwKRGVzY3JpcHRpb246CgpodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9k b2NzLzE0L3VzaW5nLWV4cGxhaW4uaHRtbA0KVGhlIGRvYyBzYXlzDQoidGhlIGxvb3BzIHZhbHVl IHJlcG9ydHMgdGhlIHRvdGFsIG51bWJlciBvZiBleGVjdXRpb25zIG9mIHRoZSBub2RlLCBhbmQg dGhlCmFjdHVhbCB0aW1lIGFuZCByb3dzIHZhbHVlcyBzaG93biBhcmUgYXZlcmFnZXMgcGVyLWV4 ZWN1dGlvbi4gVGhpcyBpcyBkb25lCnRvIG1ha2UgdGhlIG51bWJlcnMgY29tcGFyYWJsZSB3aXRo IHRoZSB3YXkgdGhhdCB0aGUgY29zdCBlc3RpbWF0ZXMgYXJlCnNob3duLiINCg0KQnV0IEkgZm91 bmQgZm9yIHBhcmFsbGVsIG9wZXJhdGlvbiwgdGhlIGFib3ZlIGRlc2NyaXB0aW9uIG1heWJlIG5v dApjb3JyZWN0Lg0KDQpGb3IgZXhhbXBsZSANCnBvc3RncmVzPSMgY3JlYXRlIHRhYmxlIGMoaWQg aW50KTsNCkNSRUFURSBUQUJMRQ0KcG9zdGdyZXM9IyBpbnNlcnQgaW50byBjIHNlbGVjdCBnZW5l cmF0ZV9zZXJpZXMoMSwxMDAwMDAwKTsNCklOU0VSVCAwIDEwMDAwMDANCnBvc3RncmVzPSMgZXhw bGFpbiBhbmFseXplIHNlbGVjdCBjb3VudCgqKSBmcm9tIGM7DQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTg0KLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLQ0KIEZpbmFsaXplIEFnZ3JlZ2F0ZSAgKGNvc3Q9MTA2MzMuNTUuLjEw NjMzLjU2IHJvd3M9MSB3aWR0aD04KSAoYWN0dWFsCnRpbWU9MjkwLjQ2MC4uMjkwLjUwOCByb3dz PTEgbG9vcHM9MSkNCiAgIC0+ICBHYXRoZXIgIChjb3N0PTEwNjMzLjMzLi4xMDYzMy41NCByb3dz PTIgd2lkdGg9OCkgKGFjdHVhbAp0aW1lPTI4OS42MDUuLjI5MC40ODQgcm93cz0zIGxvb3BzPTEp DQogICAgICAgICBXb3JrZXJzIFBsYW5uZWQ6IDINCiAgICAgICAgIFdvcmtlcnMgTGF1bmNoZWQ6 IDINCiAgICAgICAgIC0+ICBQYXJ0aWFsIEFnZ3JlZ2F0ZSAgKGNvc3Q9OTYzMy4zMy4uOTYzMy4z NCByb3dzPTEgd2lkdGg9OCkKKGFjdHVhbCB0aW1lPTE4OC4zMzYuLjE4OC4zMzcgcm93cz0xIGxv b3BzPTMpDQogICAgICAgICAgICAgICAtPiAgUGFyYWxsZWwgU2VxIFNjYW4gb24gYyAgKGNvc3Q9 MC4wMC4uODU5MS42NyByb3dzPTQxNjY2Nwp3aWR0aD0wKSAoYWN0dWFsIHRpbWU9MC4wMzAuLjE0 MC4wMzYgcm93cz0zMzMzMzMgbG9vcHM9MykNCiBQbGFubmluZyBUaW1lOiAwLjMzMSBtcw0KIEV4 ZWN1dGlvbiBUaW1lOiAyOTAuNjA3IG1zDQooOCByb3dzKQ0KDQpwb3N0Z3Jlcz0jIA0KDQpBY2Nv cmRpbmcgdG8gUEctZG9jLCB0aGUgIlBhcmFsbGVsIFNlcSBTY2FuIiBub2RlIGNvc3QgMTQwLjAz NiozPTQyMG1zLCBidXQKdGhlIHRvdGFsIGNvc3QgZm9yIHRoaXMgU1FMIGlzIG9ubHkgMjkwbXMu DQpJcyB0aGUgb3V0cHV0IG9mIHRoaXMgZXhwbGFpbiBjb3JyZWN0Pwo= --===============5530668038956808723==--