Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dHCQ4-0006HD-IJ for pgsql-bugs@arkaria.postgresql.org; Sat, 03 Jun 2017 17:00:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dHCQ3-0001jm-TJ for pgsql-bugs@arkaria.postgresql.org; Sat, 03 Jun 2017 17:00:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dHCPM-0000T2-9Z for pgsql-bugs@postgresql.org; Sat, 03 Jun 2017 17:00:12 +0000 Received: from wrigleys.postgresql.org ([204.145.124.246]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dHCPG-0006Hx-4R for pgsql-bugs@postgresql.org; Sat, 03 Jun 2017 17:00:11 +0000 MIME-Version: 1.0 Subject: BUG #14687: pg_xlogdump does only count "main data" for record length and leading to incorrect statistics To: pgsql-bugs@postgresql.org From: chjischj@163.com Date: Sat, 03 Jun 2017 16:59:39 +0000 Message-ID: <20170603165939.1436.58887@wrigleys.postgresql.org> X-Pg-Spam-Score: -1.9 (-) Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDY4NwpMb2dnZWQgYnk6ICAg ICAgICAgIENoZW4gaHVhanVuCkVtYWlsIGFkZHJlc3M6ICAgICAgY2hqaXNj aGpAMTYzLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNS4wCk9wZXJhdGlu ZyBzeXN0ZW06ICAgQUxMCkRlc2NyaXB0aW9uOiAgICAgICAgCgpDdXJyZW50 bHksIHJlY29yZCBsZW5ndGggaW4gcGdfeGxvZ2R1bXAvcGdfd2FsZHVtcCdz IG91dHB1dCBvbmx5IGNvdW50Cmxlbmd0aCBvZiAibWFpbiBkYXRhIiwNClRo aXMgcmVzdWx0cyBpbiBwZ194bG9nZHVtcC9wZ193YWxkdW1wIGNhbiBub3Qg YWNjdXJhdGVseSBjb3VudCB0aGUgc2l6ZSBvZgp0aGUgdmFyaW91cyB0eXBl cyBvZiBXQUwgcmVjb3Jkcy4NCg0KZm9yIGV4YW1wbGUNCg0KICAgIFtwb3N0 Z3Jlc0Bub2RlMSB+XSQgcGdfd2FsZHVtcCAtLXN0YXRzPXJlY29yZApwZzEw ZGF0YS9wZ193YWwvMDAwMDAwMDEwMDAwMDAwMDAwMDAwMDFGDQogICAgVHlw ZSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBO ICAgICAgKCUpICAgICAgICAgClJlY29yZCBzaXplICAgICAgKCUpICAgICAg ICAgICAgIEZQSSBzaXplICAgICAgKCUpICAgICAgICBDb21iaW5lZCBzaXpl ICAgICAKKCUpDQogICAgLS0tLSAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAtICAgICAgLS0tICAgICAgICAgCi0tLS0tLS0t LS0tICAgICAgLS0tICAgICAgICAgICAgIC0tLS0tLS0tICAgICAgLS0tICAg ICAgICAtLS0tLS0tLS0tLS0tICAgICAKLS0tDQogICAgWExPRy9GUEkgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgOTM5ICggMzQuNjgp ICAgICAgICAgICAgICAgCjIyNTM2ICggMjcuMTUpICAgICAgICAgICAgICA2 ODk3NzY0ICggOTkuNzUpICAgICAgICAgICAgICA2OTIwMzAwICggOTguODkp DQogICAgVHJhbnNhY3Rpb24vQ09NTUlUICAgICAgICAgICAgICAgICAgICAg ICAgICAgICA2ICggIDAuMjIpICAgICAgICAgICAgICAgCiAgOTc2ICggIDEu MTgpICAgICAgICAgICAgICAgICAgICAwICggIDAuMDApICAgICAgICAgICAg ICAgICAgOTc2ICggIDAuMDEpDQogICAgU3RvcmFnZS9DUkVBVEUgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAzICggIDAuMTEpICAgICAgICAg ICAgICAgCiAgMTIwICggIDAuMTQpICAgICAgICAgICAgICAgICAgICAwICgg IDAuMDApICAgICAgICAgICAgICAgICAgMTIwICggIDAuMDApDQogICAgU3Rh bmRieS9MT0NLICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICA2 ICggIDAuMjIpICAgICAgICAgICAgICAgCiAgMjQwICggIDAuMjkpICAgICAg ICAgICAgICAgICAgICAwICggIDAuMDApICAgICAgICAgICAgICAgICAgMjQw ICggIDAuMDApDQogICAgU3RhbmRieS9JTlZBTElEQVRJT05TICAgICAgICAg ICAgICAgICAgICAgICAgICAzICggIDAuMTEpICAgICAgICAgICAgICAgCiAg MjY0ICggIDAuMzIpICAgICAgICAgICAgICAgICAgICAwICggIDAuMDApICAg ICAgICAgICAgICAgICAgMjY0ICggIDAuMDApDQogICAgSGVhcDIvVklTSUJM RSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAxICggIDAuMDQp ICAgICAgICAgICAgICAgCiAgIDI5ICggIDAuMDMpICAgICAgICAgICAgICAg ICA4MTkyICggIDAuMTIpICAgICAgICAgICAgICAgICA4MjIxICggIDAuMTIp DQogICAgSGVhcDIvTVVMVElfSU5TRVJUICAgICAgICAgICAgICAgICAgICAg ICAgICAgMTY1ICggIDYuMDkpICAgICAgICAgICAgICAgCjE0NjA2ICggMTcu NjApICAgICAgICAgICAgICAgICAgICAwICggIDAuMDApICAgICAgICAgICAg ICAgIDE0NjA2ICggIDAuMjEpDQogICAgSGVhcDIvTVVMVElfSU5TRVJUK0lO SVQgICAgICAgICAgICAgICAgICAgICAxNDkzICggNTUuMTMpICAgICAgICAg ICAgICAgCjQxODA0ICggNTAuMzcpICAgICAgICAgICAgICAgICAgICAwICgg IDAuMDApICAgICAgICAgICAgICAgIDQxODA0ICggIDAuNjApDQogICAgSGVh cC9JTlNFUlQgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDI5 ICggIDEuMDcpICAgICAgICAgICAgICAgCiAgNzgzICggIDAuOTQpICAgICAg ICAgICAgICAgICAgICAwICggIDAuMDApICAgICAgICAgICAgICAgICAgNzgz ICggIDAuMDEpDQogICAgSGVhcC9JTlBMQUNFICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICA3ICggIDAuMjYpICAgICAgICAgICAgICAgCiAg MTgyICggIDAuMjIpICAgICAgICAgICAgICAgICAgICAwICggIDAuMDApICAg ICAgICAgICAgICAgICAgMTgyICggIDAuMDApDQogICAgQnRyZWUvSU5TRVJU X0xFQUYgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDU2ICggIDIuMDcp ICAgICAgICAgICAgICAgCiAxNDU2ICggIDEuNzUpICAgICAgICAgICAgICAg ICA4ODg4ICggIDAuMTMpICAgICAgICAgICAgICAgIDEwMzQ0ICggIDAuMTUp DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IC0tLS0tLS0tICAgICAgICAgICAgICAgICAgICAgCi0tLS0tLS0tICAgICAg ICAgICAgICAgICAgICAgIC0tLS0tLS0tICAgICAgICAgICAgICAgICAgICAg IC0tLS0tLS0tDQogICAgVG90YWwgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAyNzA4ICAgICAgICAgICAgICAgICAgICAgICAgCjgy OTk2IFsxLjE5JV0gICAgICAgICAgICAgICA2OTE0ODQ0IFs5OC44MSVdICAg ICAgICAgICAgICA2OTk3ODQwIFsxMDAlXQ0KDQpUb3RhbCBDb21iaW5lZCBz aXplIGFib3ZlIGlzIG9ubHkgNjk5Nzg0MCBieXRlLGJ1dCBzaG91bGQgYmUg MTZNQi4NCg0KDQpTbywgSSBtb2RpZmllZCBvbmUgbGluZSBvZiBjb2RlIGlu IHBnX3dhbGR1bXAuYw0KDQpzcmMvYmluL3BnX3dhbGR1bXAvcGdfd2FsZHVt cC5jOjM5MA0KDQogICAgICAgIHJlY19sZW4gPSBYTG9nUmVjR2V0RGF0YUxl bihyZWNvcmQpICsgU2l6ZU9mWExvZ1JlY29yZDsNCg0KICAgICAgICAvKg0K ICAgICAgICAgKiBDYWxjdWxhdGUgdGhlIGFtb3VudCBvZiBGUEkgZGF0YSBp biB0aGUgcmVjb3JkLg0KICAgICAgICAgKg0KICAgICAgICAgKiBYWFg6IFdl IHBlZWsgaW50byB4bG9ncmVhZGVyJ3MgcHJpdmF0ZSBkZWNvZGVkIGJhY2t1 cCBibG9ja3MgZm9yCnRoZQ0KICAgICAgICAgKiBiaW1nX2xlbiBpbmRpY2F0 aW5nIHRoZSBsZW5ndGggb2YgRlBJIGRhdGEuIEl0IGRvZXNuJ3Qgc2VlbSB3 b3J0aAppdCB0bw0KICAgICAgICAgKiBhZGQgYW4gYWNjZXNzb3IgbWFjcm8g Zm9yIHRoaXMuDQogICAgICAgICAqLw0KICAgICAgICBmcGlfbGVuID0gMDsN CiAgICAgICAgZm9yIChibG9ja19pZCA9IDA7IGJsb2NrX2lkIDw9IHJlY29y ZC0+bWF4X2Jsb2NrX2lkOyBibG9ja19pZCsrKQ0KICAgICAgICB7DQogICAg ICAgICAgICAgICAgaWYgKFhMb2dSZWNIYXNCbG9ja0ltYWdlKHJlY29yZCwg YmxvY2tfaWQpKQ0KICAgICAgICAgICAgICAgICAgICAgICAgZnBpX2xlbiAr PSByZWNvcmQtPmJsb2Nrc1tibG9ja19pZF0uYmltZ19sZW47DQogICAgICAg IH0NCj09Pg0KICAgICAgICANCiAgICAgICAgLyoNCiAgICAgICAgICogQ2Fs Y3VsYXRlIHRoZSBhbW91bnQgb2YgRlBJIGRhdGEgaW4gdGhlIHJlY29yZC4N CiAgICAgICAgICoNCiAgICAgICAgICogWFhYOiBXZSBwZWVrIGludG8geGxv Z3JlYWRlcidzIHByaXZhdGUgZGVjb2RlZCBiYWNrdXAgYmxvY2tzIGZvcgp0 aGUNCiAgICAgICAgICogYmltZ19sZW4gaW5kaWNhdGluZyB0aGUgbGVuZ3Ro IG9mIEZQSSBkYXRhLiBJdCBkb2Vzbid0IHNlZW0gd29ydGgKaXQgdG8NCiAg ICAgICAgICogYWRkIGFuIGFjY2Vzc29yIG1hY3JvIGZvciB0aGlzLg0KICAg ICAgICAgKi8NCiAgICAgICAgZnBpX2xlbiA9IDA7DQogICAgICAgIGZvciAo YmxvY2tfaWQgPSAwOyBibG9ja19pZCA8PSByZWNvcmQtPm1heF9ibG9ja19p ZDsgYmxvY2tfaWQrKykNCiAgICAgICAgew0KICAgICAgICAgICAgICAgIGlm IChYTG9nUmVjSGFzQmxvY2tJbWFnZShyZWNvcmQsIGJsb2NrX2lkKSkNCiAg ICAgICAgICAgICAgICAgICAgICAgIGZwaV9sZW4gKz0gcmVjb3JkLT5ibG9j a3NbYmxvY2tfaWRdLmJpbWdfbGVuOw0KICAgICAgICB9DQogICAgICAgIHJl Y19sZW4gPSBYTG9nUmVjR2V0VG90YWxMZW4ocmVjb3JkKSAtIGZwaV9sZW47 DQogICAgICAgIA0KDQphbmQgZ290IG1vcmUgcHJlY2lzZSBvdXRwdXQoY29y cmVjdCBGUEkgcmF0aW8gaXMgNDEuMzclIGluc3RlYWQgb2YgOTguODElKQ0K DQogICAgW3Bvc3RncmVzQG5vZGUxIH5dJCBwZ193YWxkdW1wICAtLXN0YXRz PXJlY29yZApwZzEwZGF0YS9wZ193YWwvMDAwMDAwMDEwMDAwMDAwMDAwMDAw MDFGDQogICAgVHlwZSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICBOICAgICAgKCUpICAgICAgICAgClJlY29yZCBzaXplICAg ICAgKCUpICAgICAgICAgICAgIEZQSSBzaXplICAgICAgKCUpICAgICAgICBD b21iaW5lZCBzaXplICAgICAKKCUpDQogICAgLS0tLSAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtICAgICAgLS0tICAgICAg ICAgCi0tLS0tLS0tLS0tICAgICAgLS0tICAgICAgICAgICAgIC0tLS0tLS0t ICAgICAgLS0tICAgICAgICAtLS0tLS0tLS0tLS0tICAgICAKLS0tDQogICAg WExPRy9GUEkgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg OTM5ICggMzQuNjgpICAgICAgICAgICAgICAgCjQ2MDExICggIDAuNDcpICAg ICAgICAgICAgICA2ODk3NzY0ICggOTkuNzUpICAgICAgICAgICAgICA2OTQz Nzc1ICggNDEuNTQpDQogICAgVHJhbnNhY3Rpb24vQ09NTUlUICAgICAgICAg ICAgICAgICAgICAgICAgICAgICA2ICggIDAuMjIpICAgICAgICAgICAgICAg CiAgOTg4ICggIDAuMDEpICAgICAgICAgICAgICAgICAgICAwICggIDAuMDAp ICAgICAgICAgICAgICAgICAgOTg4ICggIDAuMDEpDQogICAgU3RvcmFnZS9D UkVBVEUgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAzICggIDAu MTEpICAgICAgICAgICAgICAgCiAgMTI2ICggIDAuMDApICAgICAgICAgICAg ICAgICAgICAwICggIDAuMDApICAgICAgICAgICAgICAgICAgMTI2ICggIDAu MDApDQogICAgU3RhbmRieS9MT0NLICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICA2ICggIDAuMjIpICAgICAgICAgICAgICAgCiAgMjUyICgg IDAuMDApICAgICAgICAgICAgICAgICAgICAwICggIDAuMDApICAgICAgICAg ICAgICAgICAgMjUyICggIDAuMDApDQogICAgU3RhbmRieS9JTlZBTElEQVRJ T05TICAgICAgICAgICAgICAgICAgICAgICAgICAzICggIDAuMTEpICAgICAg ICAgICAgICAgCiAgMjcwICggIDAuMDApICAgICAgICAgICAgICAgICAgICAw ICggIDAuMDApICAgICAgICAgICAgICAgICAgMjcwICggIDAuMDApDQogICAg SGVhcDIvVklTSUJMRSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAxICggIDAuMDQpICAgICAgICAgICAgICAgCiAgIDY0ICggIDAuMDApICAg ICAgICAgICAgICAgICA4MTkyICggIDAuMTIpICAgICAgICAgICAgICAgICA4 MjU2ICggIDAuMDUpDQogICAgSGVhcDIvTVVMVElfSU5TRVJUICAgICAgICAg ICAgICAgICAgICAgICAgICAgMTY1ICggIDYuMDkpICAgICAgICAgICAgICAK NTQ3MzI5ICggIDUuNTkpICAgICAgICAgICAgICAgICAgICAwICggIDAuMDAp ICAgICAgICAgICAgICAgNTQ3MzI5ICggCjMuMjcpDQogICAgSGVhcDIvTVVM VElfSU5TRVJUK0lOSVQgICAgICAgICAgICAgICAgICAgICAxNDkzICggNTUu MTMpICAgICAgICAgICAgIAo5MTk0MDMzICggOTMuODIpICAgICAgICAgICAg ICAgICAgICAwICggIDAuMDApICAgICAgICAgICAgICA5MTk0MDMzICgKNTUu MDEpDQogICAgSGVhcC9JTlNFUlQgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIDI5ICggIDEuMDcpICAgICAgICAgICAgICAgCiA1NjU1ICgg IDAuMDYpICAgICAgICAgICAgICAgICAgICAwICggIDAuMDApICAgICAgICAg ICAgICAgICA1NjU1ICggIDAuMDMpDQogICAgSGVhcC9JTlBMQUNFICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICA3ICggIDAuMjYpICAgICAg ICAgICAgICAgCiAxNDkzICggIDAuMDIpICAgICAgICAgICAgICAgICAgICAw ICggIDAuMDApICAgICAgICAgICAgICAgICAxNDkzICggIDAuMDEpDQogICAg QnRyZWUvSU5TRVJUX0xFQUYgICAgICAgICAgICAgICAgICAgICAgICAgICAg IDU2ICggIDIuMDcpICAgICAgICAgICAgICAgCiAzNzIzICggIDAuMDQpICAg ICAgICAgICAgICAgICA4ODg4ICggIDAuMTMpICAgICAgICAgICAgICAgIDEy NjExICggIDAuMDgpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIC0tLS0tLS0tICAgICAgICAgICAgICAgICAgICAgCi0t LS0tLS0tICAgICAgICAgICAgICAgICAgICAgIC0tLS0tLS0tICAgICAgICAg ICAgICAgICAgICAgIC0tLS0tLS0tDQogICAgVG90YWwgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAyNzA4ICAgICAgICAgICAgICAg ICAgICAgIAo5Nzk5OTQ0IFs1OC42MyVdICAgICAgICAgICAgICA2OTE0ODQ0 IFs0MS4zNyVdICAgICAgICAgICAgIDE2NzE0Nzg4IFsxMDAlXQ0KCgoKLS0g ClNlbnQgdmlhIHBnc3FsLWJ1Z3MgbWFpbGluZyBsaXN0IChwZ3NxbC1idWdz QHBvc3RncmVzcWwub3JnKQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJz Y3JpcHRpb246Cmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYv cGdzcWwtYnVncwo=