MIME-Version: 1.0
From: shihao zhong <zhong950419@gmail.com>
Date: Wed, 11 Mar 2026 14:04:52 -0400
Message-ID: 
 <CAGRkXqTuWe6_C06=DM_ez3yPaA=JXpjp43pAHk2+injjhEANSA@mail.gmail.com>
Subject: [PATCH] Add missing stats_reset column to pg_statio_all_sequences
 view
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Content-Type: multipart/mixed; boundary="000000000000a5737c064cc3794e"
Archived-At: 
 <https://www.postgresql.org/message-id/CAGRkXqTuWe6_C06%3DDM_ez3yPaA%3DJXpjp43pAHk2%2BinjjhEANSA%40mail.gmail.com>
Precedence: bulk

--000000000000a5737c064cc3794e
Content-Type: text/plain; charset="UTF-8"

Hi hackers,

Currently, the pg_statio_all_* views have a stats_reset column, but
pg_statio_all_sequences is missing it, as Sami pointed out in [1].

This patch adds the stats_reset column and updates the documentation
to ensure it remains in sync with the other views.

[1] [CAA5RZ0vSjCEAuKXhxacnp0ftrYkf9QRcyPK-AvTi_otFVDWphA@mail.gmail.com]

Thanks,
Shihao

--000000000000a5737c064cc3794e
Content-Type: application/octet-stream; name="pg_statio_all_sequences.patch"
Content-Disposition: attachment; filename="pg_statio_all_sequences.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mmmchi410>
X-Attachment-Id: f_mmmchi410

RnJvbSBlMGIxOGM4Njc0YTE5MTMzYmQ5MTMzYjhmNWE1MjNiZGM5MjgwNTg5IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBzaGloYW8gemhvbmcgPHpob25nOTUwNDE5QGdtYWlsLmNvbT4K
RGF0ZTogV2VkLCAxMSBNYXIgMjAyNiAxNjo1NToyMiArMDAwMApTdWJqZWN0OiBbUEFUQ0hdIEFk
ZCBzdGF0c19yZXNldCBjb2x1bW4gdG8gcGdfc3RhdGlvX2FsbF9zZXF1ZW5jZXMgdmlldwoKVGhp
cyBjb21taXQgYWRkcyB0aGUgc3RhdHNfcmVzZXQgY29sdW1uIHRvIHBnX3N0YXRpb19hbGxfc2Vx
dWVuY2VzLAphbGxvd2luZyB1c2VycyB0byBzZWUgd2hlbiB0aGUgcmVzZXQgd2FzIGxhc3QgcGVy
Zm9ybWVkLiBUaGlzIGJyaW5ncwpjb25zaXN0ZW5jeSB3aXRoIHBnX3N0YXRpb19hbGxfdGFibGVz
IGFuZCBvdGhlciBzdGF0aXN0aWNzIHZpZXdzLgoKSW5jbHVkZXM6Ci0gc3lzdGVtX3ZpZXdzLnNx
bDogVmlldyBkZWZpbml0aW9uIHVwZGF0ZQotIG1vbml0b3Jpbmcuc2dtbDogRG9jdW1lbnRhdGlv
biB1cGRhdGUgYW5kIGluZGVudGF0aW9uIGZpeAotIGNhdHZlcnNpb24uaDogTWFuZGF0b3J5IGNh
dGFsb2cgdmVyc2lvbiBidW1wCi0gUmVncmVzc2lvbiB0ZXN0czogVXBkYXRlZCBydWxlcy5vdXQg
YW5kIHN0YXRzLm91dCwgYW5kIGFkZGVkIHN0YXRzLnNxbCB0ZXN0IGNhc2UKLS0tCiBkb2Mvc3Jj
L3NnbWwvbW9uaXRvcmluZy5zZ21sICAgICAgICAgfCA5ICsrKysrKysrKwogc3JjL2JhY2tlbmQv
Y2F0YWxvZy9zeXN0ZW1fdmlld3Muc3FsIHwgMyArKy0KIHNyYy9pbmNsdWRlL2NhdGFsb2cvY2F0
dmVyc2lvbi5oICAgICB8IDIgKy0KIHNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcnVsZXMub3V0
ICB8IDkgKysrKysrLS0tCiBzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3N0YXRzLm91dCAgfCA4
ICsrKysrKysrCiBzcmMvdGVzdC9yZWdyZXNzL3NxbC9zdGF0cy5zcWwgICAgICAgfCA0ICsrKysK
IDYgZmlsZXMgY2hhbmdlZCwgMzAgaW5zZXJ0aW9ucygrKSwgNSBkZWxldGlvbnMoLSkKCmRpZmYg
LS1naXQgYS9kb2Mvc3JjL3NnbWwvbW9uaXRvcmluZy5zZ21sIGIvZG9jL3NyYy9zZ21sL21vbml0
b3Jpbmcuc2dtbAppbmRleCA3NjNmNjczMWRlZS4uMjIxMDBkMTI5NTUgMTAwNjQ0Ci0tLSBhL2Rv
Yy9zcmMvc2dtbC9tb25pdG9yaW5nLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcu
c2dtbApAQCAtNDkwOCw2ICs0OTA4LDE1IEBAIGRlc2NyaXB0aW9uIHwgV2FpdGluZyBmb3IgYSBu
ZXdseSBpbml0aWFsaXplZCBXQUwgZmlsZSB0byByZWFjaCBkdXJhYmxlIHN0b3JhZ2UKICAgICAg
ICBOdW1iZXIgb2YgYnVmZmVyIGhpdHMgaW4gdGhpcyBzZXF1ZW5jZQogICAgICAgPC9wYXJhPjwv
ZW50cnk+CiAgICAgIDwvcm93PgorCisgICAgIDxyb3c+CisgICAgICA8ZW50cnkgcm9sZT0iY2F0
YWxvZ190YWJsZV9lbnRyeSI+PHBhcmEgcm9sZT0iY29sdW1uX2RlZmluaXRpb24iPgorICAgICAg
IDxzdHJ1Y3RmaWVsZD5zdGF0c19yZXNldDwvc3RydWN0ZmllbGQ+IDx0eXBlPnRpbWVzdGFtcCB3
aXRoIHRpbWUgem9uZTwvdHlwZT4KKyAgICAgIDwvcGFyYT4KKyAgICAgIDxwYXJhPgorICAgICAg
IFRpbWUgYXQgd2hpY2ggdGhlc2Ugc3RhdGlzdGljcyB3ZXJlIGxhc3QgcmVzZXQKKyAgICAgIDwv
cGFyYT48L2VudHJ5PgorICAgICA8L3Jvdz4KICAgICA8L3Rib2R5PgogICAgPC90Z3JvdXA+CiAg
IDwvdGFibGU+CmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC9jYXRhbG9nL3N5c3RlbV92aWV3cy5z
cWwgYi9zcmMvYmFja2VuZC9jYXRhbG9nL3N5c3RlbV92aWV3cy5zcWwKaW5kZXggMzM2MTAzMGQz
NGMuLjBmMWU2MTIxMGNmIDEwMDY0NAotLS0gYS9zcmMvYmFja2VuZC9jYXRhbG9nL3N5c3RlbV92
aWV3cy5zcWwKKysrIGIvc3JjL2JhY2tlbmQvY2F0YWxvZy9zeXN0ZW1fdmlld3Muc3FsCkBAIC04
OTYsNyArODk2LDggQEAgQ1JFQVRFIFZJRVcgcGdfc3RhdGlvX2FsbF9zZXF1ZW5jZXMgQVMKICAg
ICAgICAgICAgIEMucmVsbmFtZSBBUyByZWxuYW1lLAogICAgICAgICAgICAgcGdfc3RhdF9nZXRf
YmxvY2tzX2ZldGNoZWQoQy5vaWQpIC0KICAgICAgICAgICAgICAgICAgICAgcGdfc3RhdF9nZXRf
YmxvY2tzX2hpdChDLm9pZCkgQVMgYmxrc19yZWFkLAotICAgICAgICAgICAgcGdfc3RhdF9nZXRf
YmxvY2tzX2hpdChDLm9pZCkgQVMgYmxrc19oaXQKKyAgICAgICAgICAgIHBnX3N0YXRfZ2V0X2Js
b2Nrc19oaXQoQy5vaWQpIEFTIGJsa3NfaGl0LAorICAgICAgICAgICAgcGdfc3RhdF9nZXRfc3Rh
dF9yZXNldF90aW1lKEMub2lkKSBBUyBzdGF0c19yZXNldAogICAgIEZST00gcGdfY2xhc3MgQwog
ICAgICAgICAgICAgTEVGVCBKT0lOIHBnX25hbWVzcGFjZSBOIE9OIChOLm9pZCA9IEMucmVsbmFt
ZXNwYWNlKQogICAgIFdIRVJFIEMucmVsa2luZCA9ICdTJzsKZGlmZiAtLWdpdCBhL3NyYy9pbmNs
dWRlL2NhdGFsb2cvY2F0dmVyc2lvbi5oIGIvc3JjL2luY2x1ZGUvY2F0YWxvZy9jYXR2ZXJzaW9u
LmgKaW5kZXggOTBmNDZiMDM1MDIuLmZmOTFjZmY4NjZmIDEwMDY0NAotLS0gYS9zcmMvaW5jbHVk
ZS9jYXRhbG9nL2NhdHZlcnNpb24uaAorKysgYi9zcmMvaW5jbHVkZS9jYXRhbG9nL2NhdHZlcnNp
b24uaApAQCAtNTcsNiArNTcsNiBAQAogICovCiAKIC8qCQkJCQkJCXl5eXltbWRkTiAqLwotI2Rl
ZmluZSBDQVRBTE9HX1ZFUlNJT05fTk8JMjAyNjAzMTAxCisjZGVmaW5lIENBVEFMT0dfVkVSU0lP
Tl9OTwkyMDI2MDMxMTEKIAogI2VuZGlmCmRpZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdyZXNzL2V4
cGVjdGVkL3J1bGVzLm91dCBiL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcnVsZXMub3V0Cmlu
ZGV4IDcxZDcyNjIwNDllLi45ZWQwYTE3NTZjMCAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVz
cy9leHBlY3RlZC9ydWxlcy5vdXQKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9ydWxl
cy5vdXQKQEAgLTI0NTEsNyArMjQ1MSw4IEBAIHBnX3N0YXRpb19hbGxfc2VxdWVuY2VzfCBTRUxF
Q1QgYy5vaWQgQVMgcmVsaWQsCiAgICAgbi5uc3BuYW1lIEFTIHNjaGVtYW5hbWUsCiAgICAgYy5y
ZWxuYW1lLAogICAgIChwZ19zdGF0X2dldF9ibG9ja3NfZmV0Y2hlZChjLm9pZCkgLSBwZ19zdGF0
X2dldF9ibG9ja3NfaGl0KGMub2lkKSkgQVMgYmxrc19yZWFkLAotICAgIHBnX3N0YXRfZ2V0X2Js
b2Nrc19oaXQoYy5vaWQpIEFTIGJsa3NfaGl0CisgICAgcGdfc3RhdF9nZXRfYmxvY2tzX2hpdChj
Lm9pZCkgQVMgYmxrc19oaXQsCisgICAgcGdfc3RhdF9nZXRfc3RhdF9yZXNldF90aW1lKGMub2lk
KSBBUyBzdGF0c19yZXNldAogICAgRlJPTSAocGdfY2xhc3MgYwogICAgICBMRUZUIEpPSU4gcGdf
bmFtZXNwYWNlIG4gT04gKChuLm9pZCA9IGMucmVsbmFtZXNwYWNlKSkpCiAgIFdIRVJFIChjLnJl
bGtpbmQgPSAnUyc6OiJjaGFyIik7CkBAIC0yNDkzLDcgKzI0OTQsOCBAQCBwZ19zdGF0aW9fc3lz
X3NlcXVlbmNlc3wgU0VMRUNUIHJlbGlkLAogICAgIHNjaGVtYW5hbWUsCiAgICAgcmVsbmFtZSwK
ICAgICBibGtzX3JlYWQsCi0gICAgYmxrc19oaXQKKyAgICBibGtzX2hpdCwKKyAgICBzdGF0c19y
ZXNldAogICAgRlJPTSBwZ19zdGF0aW9fYWxsX3NlcXVlbmNlcwogICBXSEVSRSAoKHNjaGVtYW5h
bWUgPSBBTlkgKEFSUkFZWydwZ19jYXRhbG9nJzo6bmFtZSwgJ2luZm9ybWF0aW9uX3NjaGVtYSc6
Om5hbWVdKSkgT1IgKHNjaGVtYW5hbWUgfiAnXnBnX3RvYXN0Jzo6dGV4dCkpOwogcGdfc3RhdGlv
X3N5c190YWJsZXN8IFNFTEVDVCByZWxpZCwKQEAgLTI1MjQsNyArMjUyNiw4IEBAIHBnX3N0YXRp
b191c2VyX3NlcXVlbmNlc3wgU0VMRUNUIHJlbGlkLAogICAgIHNjaGVtYW5hbWUsCiAgICAgcmVs
bmFtZSwKICAgICBibGtzX3JlYWQsCi0gICAgYmxrc19oaXQKKyAgICBibGtzX2hpdCwKKyAgICBz
dGF0c19yZXNldAogICAgRlJPTSBwZ19zdGF0aW9fYWxsX3NlcXVlbmNlcwogICBXSEVSRSAoKHNj
aGVtYW5hbWUgPD4gQUxMIChBUlJBWVsncGdfY2F0YWxvZyc6Om5hbWUsICdpbmZvcm1hdGlvbl9z
Y2hlbWEnOjpuYW1lXSkpIEFORCAoc2NoZW1hbmFtZSAhfiAnXnBnX3RvYXN0Jzo6dGV4dCkpOwog
cGdfc3RhdGlvX3VzZXJfdGFibGVzfCBTRUxFQ1QgcmVsaWQsCmRpZmYgLS1naXQgYS9zcmMvdGVz
dC9yZWdyZXNzL2V4cGVjdGVkL3N0YXRzLm91dCBiL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQv
c3RhdHMub3V0CmluZGV4IDBkNjM0YzNhZjQyLi44YjE5NjAyYzUwMyAxMDA2NDQKLS0tIGEvc3Jj
L3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zdGF0cy5vdXQKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9l
eHBlY3RlZC9zdGF0cy5vdXQKQEAgLTE5MjQsNCArMTkyNCwxMiBAQCBTRUxFQ1Qgc3RhdHNfcmVz
ZXQgSVMgTk9UIE5VTEwgQVMgaGFzX3N0YXRzX3Jlc2V0CiAgdAogKDEgcm93KQogCistLSBUZXN0
IHRoYXQgdGhlIHN0YXRzX3Jlc2V0IGNvbHVtbiBpbiBwZ19zdGF0aW9fYWxsX3NlcXVlbmNlcyBp
cyBjb3JyZWN0bHkgbWFpbnRhaW5lZAorU0VMRUNUIHN0YXRzX3Jlc2V0IElTIE5PVCBOVUxMIEFT
IGhhc19zdGF0c19yZXNldAorICBGUk9NIHBnX3N0YXRpb19hbGxfc2VxdWVuY2VzIExJTUlUIDE7
CisgaGFzX3N0YXRzX3Jlc2V0IAorLS0tLS0tLS0tLS0tLS0tLS0KKyB0CisoMSByb3cpCisKIC0t
IEVuZCBvZiBTdGF0cyBUZXN0CmRpZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC9zdGF0
cy5zcWwgYi9zcmMvdGVzdC9yZWdyZXNzL3NxbC9zdGF0cy5zcWwKaW5kZXggZTVmYjkwY2YwYzMu
LjBkMWZhYzk1ZTlmIDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC9zdGF0cy5zcWwK
KysrIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvc3RhdHMuc3FsCkBAIC05NDksNCArOTQ5LDggQEAg
U0VMRUNUIHBnX3N0YXRfcmVzZXQoKTsKIFNFTEVDVCBzdGF0c19yZXNldCBJUyBOT1QgTlVMTCBB
UyBoYXNfc3RhdHNfcmVzZXQKICAgRlJPTSBwZ19zdGF0X2RhdGFiYXNlX2NvbmZsaWN0cyBXSEVS
RSBkYXRuYW1lID0gY3VycmVudF9kYXRhYmFzZSgpOwogCistLSBUZXN0IHRoYXQgdGhlIHN0YXRz
X3Jlc2V0IGNvbHVtbiBpbiBwZ19zdGF0aW9fYWxsX3NlcXVlbmNlcyBpcyBjb3JyZWN0bHkgbWFp
bnRhaW5lZAorU0VMRUNUIHN0YXRzX3Jlc2V0IElTIE5PVCBOVUxMIEFTIGhhc19zdGF0c19yZXNl
dAorICBGUk9NIHBnX3N0YXRpb19hbGxfc2VxdWVuY2VzIExJTUlUIDE7CisKIC0tIEVuZCBvZiBT
dGF0cyBUZXN0Ci0tIAoyLjUzLjAuODgwLmc3M2M0Mjg1Y2FhLWdvb2cKCgo=
--000000000000a5737c064cc3794e--