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 1oaCS9-0005dO-VN for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Sep 2022 08:48:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oaCRA-0000Bf-QW for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Sep 2022 08:47:32 +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 1oaCRA-0000BW-BS for pgsql-hackers@lists.postgresql.org; Mon, 19 Sep 2022 08:47:32 +0000 Received: from forward502j.mail.yandex.net ([2a02:6b8:0:801:2::112]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oaCR4-0003Ih-FT for pgsql-hackers@lists.postgresql.org; Mon, 19 Sep 2022 08:47:31 +0000 Received: from myt6-640abdf8240b.qloud-c.yandex.net (myt6-640abdf8240b.qloud-c.yandex.net [IPv6:2a02:6b8:c12:238c:0:640:640a:bdf8]) by forward502j.mail.yandex.net (Yandex) with ESMTP id 2BDE31121AC5; Mon, 19 Sep 2022 11:47:22 +0300 (MSK) Received: from 2a02:6b8:c12:489b:0:640:47ce:0 (2a02:6b8:c12:489b:0:640:47ce:0 [2a02:6b8:c12:489b:0:640:47ce:0]) by myt6-640abdf8240b.qloud-c.yandex.net (mxback/Yandex) with HTTP id Klb2jH6fYCg1-lLfS4t4Q; Mon, 19 Sep 2022 11:47:22 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1663577242; bh=33X9PksK8D5dKwR5RAVu6To9SAMmrBAO92tmwRB/V5s=; h=Message-Id:References:Date:Subject:In-Reply-To:To:From; b=kq2RfW/TE6g17i+VXAS/dgmkbfkT2ocVNUd22NmMK2pvNOl0pXK/Je7jzJewYSqHO sbHlkfzcsFYB4bN+M0MCAlBHzlv3jnTW99ldUWjrgLnwonnuQvNo0JTSpR954SMIWW x9rxcCIuizGcs8JkkEhmWtmHKYuhDydG+ub5DxyI= Authentication-Results: myt6-640abdf8240b.qloud-c.yandex.net; dkim=pass header.i=@yandex.ru Received: by 66ftscwz67pcsni4.myt.yp-c.yandex.net with HTTP; Mon, 19 Sep 2022 11:47:21 +0300 From: =?utf-8?B?0JDQu9C10L3QsCDQoNGL0LHQsNC60LjQvdCw?= Envelope-From: lena-ribackina@yandex.ru To: torikoshia , "pgsql-hackers@lists.postgresql.org" In-Reply-To: <727712bcaa8d449615820c16d15e452e@oss.nttdata.com> References: <20220202.170421.204740592565249296.horikyota.ntt@gmail.com> <3bb7bacbc5ef9e58e2ece0557adac98b@oss.nttdata.com> <03c8dcbb-72d2-d3ad-3ad1-9efe69676529@oss.nttdata.com> <20220208.171852.1699766364147189900.horikyota.ntt@gmail.com> <3e94e9b3-83ef-c328-0c5c-f93aa3224790@oss.nttdata.com> <3d121ed5f81cef588bac836b43f5d1f9@oss.nttdata.com> <379d69c0b3d058997550f88e73ffddd6@oss.nttdata.com> <727712bcaa8d449615820c16d15e452e@oss.nttdata.com> Subject: Re: RFC: Logging plan of the running query MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Mon, 19 Sep 2022 11:47:21 +0300 Message-Id: <598171663576373@mail.yandex.ru> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PGRpdj48ZGl2PkhpLDwvZGl2PjxkaXY+PGRpdj5JJ20gc29ycnksaWYgdGhpcyBtZXNzYWdlIGlz IGR1cGxpY2F0ZWQgcHJldmlvdXMgdGhpcyBvbmUsIGJ1dCBJJ20gbm90IHN1cmUgdGhhdCB0aGUg cHJldmlvdXMgbWVzc2FnZSBpcyBzZW50IGNvcnJlY3RseS4gSSBzZW50IGl0IGZyb20gZW1haWwg YWRkcmVzcyA8YSBocmVmPSJtYWlsdG86YS5yeWJha2luYUBwb3N0Z3Jlc3Byby5ydSIgcmVsPSJu b29wZW5lciBub3JlZmVycmVyIj5hLnJ5YmFraW5hQHBvc3RncmVzcHJvLnJ1PC9hPiBhbmQgSSBj b3VsZG4ndCBzZW5kIHRoaXMgb25lIGVtYWlsIGZyb20gdGhvc2UgYWRkcmVzcy48L2Rpdj48ZGl2 PkkgbGlrZSBpZGVhIHRvIGNyZWF0ZSBwYXRjaCBmb3IgbG9nZ2luZyBxdWVyeSBwbGFuLiBBZnRl ciByZXZpZXdpbmcgdGhpcyBjb2RlIGFuZCBub3RpY2Ugc29tZSBtb21lbnRzIGFuZCBJJ2QgcmF0 aGVyIGFzayB5b3Ugc29tZSBxdWVzdGlvbnMuPC9kaXY+PC9kaXY+PGRpdj48YnIgLz5GaXJzdGx5 LCBJIHN1Z2dlc3Qgc29tZSBlZGl0aW5nIGluIHRoZSBjb21tZW50IG9mIGNvbW1pdC4gSSB0aGlu aywgaXQgaXMgdHVybmVkIG91dCB0aGUgbW9yZSBsYWNvbmljIGFuZCB0aGUgc2FtZSBjbGVhci4g SSB3cm90ZSBpdCBiZWxvdyBzaW5jZSBJIGNhbid0IHRoaW5rIG9mIGFueSBvdGhlciB3YXkgdG8g YWRkIGl0LjxiciAvPjxiciAvPmBgYDxiciAvPkN1cnJlbnRseSwgd2UgaGF2ZSB0byB3YWl0IGZv ciBmaW5pc2hpbmcgb2YgdGhlIHF1ZXJ5IGV4ZWN1dGlvbiB0byBjaGVjayBpdHMgcGxhbi48YnIg Lz5UaGlzIGlzIG5vdCBzbyBjb252ZW5pZW50IGluIGludmVzdGlnYXRpb24gbG9uZy1ydW5uaW5n IHF1ZXJpZXMgb24gcHJvZHVjdGlvbjxiciAvPmVudmlyb25tZW50cyB3aGVyZSB3ZSBjYW5ub3Qg dXNlIGRlYnVnZ2Vycy48YnIgLz48YnIgLz5UbyBpbXByb3ZlIHRoaXMgc2l0dWF0aW9uIHRoZXJl IGlzIHByb3Bvc2VkIHRoZSBwYXRjaCBjb250YWluaW5nIHRoZSBwZ19sb2dfcXVlcnlfcGxhbigp PGJyIC8+ZnVuY3Rpb24gd2hpY2ggcmVxdWVzdCB0byBsb2cgcGxhbiBvZiB0aGUgc3BlY2lmaWVk IGJhY2tlbmQgcHJvY2Vzcy48YnIgLz48YnIgLz5CeSBkZWZhdWx0LCBvbmx5IHN1cGVydXNlcnMg YXJlIGFsbG93ZWQgdG8gcmVxdWVzdCBsb2cgb2YgdGhlIHBsYW4gb3RoZXJ3aXNlPGJyIC8+YWxs b3dpbmcgYW55IHVzZXJzIHRvIGlzc3VlIHRoaXMgcmVxdWVzdCBjb3VsZCBjcmVhdGUgY2F1c2Ug bG90cyBvZiBsb2cgbWVzc2FnZXM8YnIgLz5hbmQgaXQgY2FuIGxlYWQgdG8gZGVuaWFsIG9mIHNl cnZpY2UuPGJyIC8+PGJyIC8+QXQgdGhlIG5leHQgcmVxdWVzdGluZyBDSEVDS19GT1JfSU5URVJS VVBUUygpLCB0aGUgdGFyZ2V0IGJhY2tlbmQgbG9ncyBpdHMgcGxhbiBhdDxiciAvPkxPR19TRVJW RVJfT05MWSBsZXZlbCBhbmQgdGhlcmVmb3JlIHRoaXMgcGxhbiB3aWxsIGFwcGVhciBpbiB0aGUg c2VydmVyIGxvZyBvbmx5LDxiciAvPm5vdCB0byBiZSBzZW50IHRvIHRoZSBjbGllbnQuPGJyIC8+ YGBgPGJyIC8+PGJyIC8+U2Vjb25kbHksIEkgaGF2ZSBxdWVzdGlvbiBhYm91dCBkZWxldGluZyBV U0VfQVNTRVJUX0NIRUNLSU5HIGluIGxvY2suaD88YnIgLz5JdCBzdXBwb3NlZCB0byBoYXZlIGJl ZW4gY2hlY2tlZCBpbiBhbm90aGVyIHBsYWNlZCBvZiB0aGUgY29kZSBieSBtYXRjaGluZyB2YWx1 ZXMuIEkgYW0gd29ycnkgYWJvdXQgc2tpcHBpbmcgZXJyb3JzIGR1ZSB0byB1bnRlc3Rpbmcgd2l0 aCBhc3NlcnQgb3B0aW9uIGluIHRoZSBwbGFjZXMgd2hlcmUgaXQgKEdldExvY2tNZXRob2RMb2Nh bEhhc2gpIHBhcnRpY2lwYXRlcyBhbmQgd2Ugd29uJ3QgYWJsZSB0byBnZXQgY29yZSBmaWxlIGlu IHNlZ2ZhdWx0IGNhc2VzLiBJIG1pZ2h0IG5vdCB1bmRlcnN0YW5kIHNvbWV0aGluZywgdGhlbiBj YW4geW91IHBsZWFzZSBleHBsYWluIHRvIG1lPzxiciAvPjxiciAvPlRoaXJkbHksIEkgaGF2ZSBp bmNvbXByZWhlbnNpb24gb2YgdGhlIHBvaW50IHdoeSBzYXZlX0FjdGl2ZVF1ZXJ5RGVzYyBpcyBk ZWNsYXJlZCBpbiB0aGUgcHF1ZXJ5Lmg/IEkgYW0gc2VlbWVkIHRvIHNhdmVfQWN0aXZlUXVlcnlE ZXNjIHRvIGJlIHVzZWQgaW4gYW4gb25jZSB0aW1lIGluIHRoZSBFeGVjdXRvclJ1biBmdW5jdGlv biBhbmTCoCBpdHMgZGVjbGFyYXRpb24gc3VwZXJmbHVvdXMuIEkgYWRkZWQgaXQgaW4gdGhlIGF0 dGFjaGVkIHBhdGNoLjxiciAvPjxiciAvPkZvdXJ0aGx5LCBpdCBzZWVtcyB0byBtZSB0aGVyZSBh cmUgbm90IGVub3VnaCBleHBsYW5hdG9yeSBjb21tZW50cyBpbiB0aGUgY29kZS4gSSBhbHNvIGFk ZGVkIHRoZW0gaW4gdGhlIGF0dGFjaGVkIHBhdGNoLjxiciAvPjxiciAvPkxhc3RseSwgSSBoYXZl IGluY29tcHJlaGVuc2lvbiBhYm91dCBoYW5kbGluZyBzaWduYWxzIHNpbmNlIGhhdmUgYmVlbiB1 bnVzZWQgaXQgYmVmb3JlLiBDb3VsZCBhbm90aGVyIHNpZ25hbCBkaXNhYmxlZCBjYWxsaW5nIHRo aXMgc2lnbmFsIHRvIGxvZyBxdWVyeSBwbGFuPyBJIG5vdGljZWQgdGhpcyBzaWduYWwgdG8gYmUg Y2hlY2tlZCB0aGUgbGF0ZXN0IGluIHByb2NzaWduYWxfc2lndXNyMV9oYW5kbGVyIGZ1bmN0aW9u LjwvZGl2PjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj4tLcKgPC9kaXY+PGRp dj5SZWdhcmRzLDwvZGl2PjxkaXY+QWxlbmEgUnliYWtpbmE8YnIgLz5Qb3N0Z3JlcyBQcm9mZXNz aW9uYWw8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PjE5 LjA5LjIwMjIsIDExOjAxLCAidG9yaWtvc2hpYSIgJmx0O3Rvcmlrb3NoaWFAb3NzLm50dGRhdGEu Y29tJmd0Ozo8L2Rpdj48YmxvY2txdW90ZT48cD5PbiAyMDIyLTA1LTE2IDE3OjAyLCB0b3Jpa29z aGlhIHdyb3RlOjwvcD48YmxvY2txdW90ZT7CoE9uIDIwMjItMDMtMDkgMTk6MDQsIHRvcmlrb3No aWEgd3JvdGU6PGJsb2NrcXVvdGU+wqBPbiAyMDIyLTAyLTA4IDAxOjEzLCBGdWppaSBNYXNhbyB3 cm90ZTo8YmxvY2txdW90ZT7CoEFib3J0U3ViVHJhbnNhY3Rpb24oKSBzaG91bGQgcmVzZXQgQWN0 aXZlUXVlcnlEZXNjIHRvPGJyIC8+wqBzYXZlX0FjdGl2ZVF1ZXJ5RGVzYyB0aGF0IEV4ZWN1dG9y UnVuKCkgc2V0LCBpbnN0ZWFkIG9mIE5VTEw/PGJyIC8+wqBPdGhlcndpc2UgQWN0aXZlUXVlcnlE ZXNjIG9mIHRvcC1sZXZlbCBzdGF0ZW1lbnQgd2lsbCBiZSB1bmF2YWlsYWJsZTxiciAvPsKgYWZ0 ZXIgc3VidHJhbnNhY3Rpb24gaXMgYWJvcnRlZCBpbiB0aGUgbmVzdGVkIHN0YXRlbWVudHMuPC9i bG9ja3F1b3RlPsKgPGJyIC8+wqBJIG9uY2UgYWdyZWVkIGFib3ZlIHN1Z2dlc3Rpb24gYW5kIG1h ZGUgdjIwIHBhdGNoIG1ha2luZzxiciAvPsKgc2F2ZV9BY3RpdmVRdWVyeURlc2MgYSBnbG9iYWwg dmFyaWFibGUsIGJ1dCBpdCBjYXVzZWQgc2VnZmF1bHQgd2hlbjxiciAvPsKgY2FsbGluZyBwZ19s b2dfcXVlcnlfcGxhbigpIGFmdGVyIEZyZWVRdWVyeURlc2MoKS48YnIgLz7CoDxiciAvPsKgT1RP SCwgZG9pbmcgc29tZSBraW5kIG9mIHJlc2V0IG9mIEFjdGl2ZVF1ZXJ5RGVzYyBzZWVtcyBuZWNl c3Nhcnk8YnIgLz7CoHNpbmNlIGl0IGFsc28gY2F1c2VkIHNlZ2ZhdWx0IHdoZW4gcnVubmluZyBw Z19sb2dfcXVlcnlfcGxhbigpIGR1cmluZzxiciAvPsKgaW5zdGFsbGNoZWNrLjxiciAvPsKgPGJy IC8+wqBUaGVyZSBtYXkgYmUgYSBiZXR0ZXIgd2F5LCBidXQgcmVzZXR0aW5nIEFjdGl2ZVF1ZXJ5 RGVzYyB0byBOVUxMIHNlZW1zPGJyIC8+wqBzYWZlIGFuZCBzaW1wbGUuPGJyIC8+wqBPZiBjb3Vy c2UgaXQgbWFrZXMgcGdfbG9nX3F1ZXJ5X3BsYW4oKSB1c2VsZXNzIGFmdGVyIGEgc3VidHJhbnNh Y3Rpb248YnIgLz7CoGlzIGFib3J0ZWQuPGJyIC8+wqBIb3dldmVyLCBpZiBpdCBkb2VzIG5vdCBv ZnRlbiBoYXBwZW4gdGhhdCBwZW9wbGUgd2FudCB0byBrbm93IHRoZTxiciAvPsKgcnVubmluZyBx dWVyeSdzIHBsYW4gd2hvc2Ugc3VidHJhbnNhY3Rpb24gaXMgYWJvcnRlZCwgcmVzZXR0aW5nPGJy IC8+wqBBY3RpdmVRdWVyeURlc2MgdG8gTlVMTCB3b3VsZCBiZSBhY2NlcHRhYmxlLjxiciAvPsKg PGJyIC8+wqBBdHRhY2hlZCBpcyBhIHBhdGNoIHRoYXQgc2V0cyBBY3RpdmVRdWVyeURlc2MgdG8g TlVMTCB3aGVuIGE8YnIgLz7CoHN1YnRyYW5zYWN0aW9uIGlzIGFib3J0ZWQuPGJyIC8+wqA8YnIg Lz7CoEhvdyBkbyB5b3UgdGhpbms/PC9ibG9ja3F1b3RlPjwvYmxvY2txdW90ZT48cD5BdHRhY2hl ZCBuZXcgcGF0Y2ggdG8gZml4IHBhdGNoIGFwcGx5IGZhaWx1cmVzIGFnYWluLjxiciAvPsKgPC9w Pi0tPGJyIC8+UmVnYXJkcyw8YnIgLz48YnIgLz4tLTxiciAvPkF0c3VzaGkgVG9yaWtvc2hpPGJy IC8+TlRUIERBVEEgQ09SUE9SQVRJT048L2Jsb2NrcXVvdGU+