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 1pQuWc-0008Vr-GW for pgsql-committers@arkaria.postgresql.org; Sat, 11 Feb 2023 18:23:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pQuWa-0003Fd-I4 for pgsql-committers@arkaria.postgresql.org; Sat, 11 Feb 2023 18:23:00 +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 1pQuWa-0003FU-Am for pgsql-committers@lists.postgresql.org; Sat, 11 Feb 2023 18:23:00 +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 1pQuWX-0004rr-Ja for pgsql-committers@lists.postgresql.org; Sat, 11 Feb 2023 18:22:59 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pQuWW-0000tq-Su for pgsql-committers@lists.postgresql.org; Sat, 11 Feb 2023 18:22:56 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pQuWV-000bpI-5x for pgsql-committers@lists.postgresql.org; Sat, 11 Feb 2023 18:22:55 +0000 Content-Type: multipart/mixed; boundary="===============1629423490244319857==" MIME-Version: 1.0 From: Andres Freund To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add pg_stat_io view, providing more detailed IO statistics X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 11 Feb 2023 18:22:55 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1629423490244319857== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIHBnX3N0YXRfaW8gdmlldywgcHJvdmlkaW5nIG1vcmUgZGV0YWlsZWQgSU8gc3RhdGlzdGlj cwoKQnVpbGRzIG9uIDI4ZTYyNmJkZTAwIGFuZCBmMzBkNjJjMmZjNi4gU2VlIHRoZSBmb3JtZXIg Zm9yIG1vdGl2YXRpb24uCgpSb3dzIG9mIHRoZSB2aWV3IHNob3cgSU8gb3BlcmF0aW9ucyBmb3Ig YSBwYXJ0aWN1bGFyIGJhY2tlbmQgdHlwZSwgSU8gdGFyZ2V0Cm9iamVjdCwgSU8gY29udGV4dCBj b21iaW5hdGlvbiAoZS5nLiBhIGNsaWVudCBiYWNrZW5kJ3Mgb3BlcmF0aW9ucyBvbgpwZXJtYW5l bnQgcmVsYXRpb25zIGluIHNoYXJlZCBidWZmZXJzKSBhbmQgZWFjaCBjb2x1bW4gaW4gdGhlIHZp ZXcgaXMgdGhlCnRvdGFsIG51bWJlciBvZiBJTyBPcGVyYXRpb25zIGRvbmUgKGUuZy4gd3JpdGVz KS4gU28gYSBjZWxsIGluIHRoZSB2aWV3IHdvdWxkCmJlLCBmb3IgZXhhbXBsZSwgdGhlIG51bWJl ciBvZiBibG9ja3Mgb2YgcmVsYXRpb24gZGF0YSB3cml0dGVuIGZyb20gc2hhcmVkCmJ1ZmZlcnMg YnkgY2xpZW50IGJhY2tlbmRzIHNpbmNlIHRoZSBsYXN0IHN0YXRzIHJlc2V0LgoKSW4gYW50aWNp cGF0aW9uIG9mIHRyYWNraW5nIFdBTCBJTyBhbmQgbm9uLWJsb2NrLW9yaWVudGVkIElPIChzdWNo IGFzCnRlbXBvcmFyeSBmaWxlIElPKSwgdGhlICJvcF9ieXRlcyIgY29sdW1uIHNwZWNpZmllcyB0 aGUgdW5pdCBvZiB0aGUgInJlYWRzIiwKIndyaXRlcyIsIGFuZCAiZXh0ZW5kcyIgY29sdW1ucyBm b3IgYSBnaXZlbiByb3cuCgpSb3dzIGZvciBjb21iaW5hdGlvbnMgb2YgSU8gb3BlcmF0aW9uLCBi YWNrZW5kIHR5cGUsIHRhcmdldCBvYmplY3QgYW5kIGNvbnRleHQKdGhhdCBuZXZlciBvY2N1ciwg YXJlIG9tbWl0dGVkIGVudGlyZWx5LiBGb3IgZXhhbXBsZSwgY2hlY2twb2ludGVyIHdpbGwgbmV2 ZXIKb3BlcmF0ZSBvbiB0ZW1wb3JhcnkgcmVsYXRpb25zLgoKU2ltaWxhcmx5LCBpZiBhbiBJTyBv cGVyYXRpb24gbmV2ZXIgb2NjdXJzIGZvciBzdWNoIGEgY29tYmluYXRpb24sIHRoZSBJTwpvcGVy YXRpb24ncyBjZWxsIHdpbGwgYmUgbnVsbCwgdG8gZGlzdGluZ3Vpc2ggZnJvbSAwIG9ic2VydmVk IElPCm9wZXJhdGlvbnMuIEZvciBleGFtcGxlLCBiZ3dyaXRlciBzaG91bGQgbm90IHBlcmZvcm0g cmVhZHMuCgpOb3RlIHRoYXQgc29tZSBvZiB0aGUgY2VsbHMgaW4gdGhlIHZpZXcgYXJlIHJlZHVu ZGFudCB3aXRoIGZpZWxkcyBpbgpwZ19zdGF0X2Jnd3JpdGVyIChlLmcuIGJ1ZmZlcnNfYmFja2Vu ZCkuIEZvciBub3csIHRoZXNlIGhhdmUgYmVlbiBrZXB0IGZvcgpiYWNrd2FyZHMgY29tcGF0aWJp bGl0eS4KCkJ1bXBzIGNhdHZlcnNpb24uCgpBdXRob3I6IE1lbGFuaWUgUGxhZ2VtYW4gPG1lbGFu aWVwbGFnZW1hbkBnbWFpbC5jb20+CkF1dGhvcjogU2FtYXkgU2hhcm1hIDxzbWlsaW5nc2FtYXlA Z21haWwuY29tPgpSZXZpZXdlZC1ieTogTWFjaWVrIFNha3JlamRhIDxtLnNha3JlamRhQGdtYWls LmNvbT4KUmV2aWV3ZWQtYnk6IEx1a2FzIEZpdHRsIDxsdWthc0BmaXR0bC5jb20+ClJldmlld2Vk LWJ5OiBBbmRyZXMgRnJldW5kIDxhbmRyZXNAYW5hcmF6ZWwuZGU+ClJldmlld2VkLWJ5OiBKdXN0 aW4gUHJ5emJ5IDxwcnl6YnlAdGVsc2Fzb2Z0LmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0 Z3IuZXMvbS8yMDIwMDEyNDE5NTIyNi5sdGg1Mml5ZHEybjJ1aWxxQGFsYXAzLmFuYXJhemVsLmRl CgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3Rn cmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvYTljNzBiNDZkYmUxNTJlMDk0ZjEzN2Y3ZTZiYTljZDNh NjM4ZWUyNQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KZG9jL3NyYy9zZ21sL21vbml0 b3Jpbmcuc2dtbCAgICAgICAgIHwgMzIxICsrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysr Ky0tCnNyYy9iYWNrZW5kL2NhdGFsb2cvc3lzdGVtX3ZpZXdzLnNxbCB8ICAxNSArKwpzcmMvYmFj a2VuZC91dGlscy9hZHQvcGdzdGF0ZnVuY3MuYyAgfCAxNDEgKysrKysrKysrKysrKysrCnNyYy9p bmNsdWRlL2NhdGFsb2cvY2F0dmVyc2lvbi5oICAgICB8ICAgMiArLQpzcmMvaW5jbHVkZS9jYXRh bG9nL3BnX3Byb2MuZGF0ICAgICAgfCAgIDkgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3J1 bGVzLm91dCAgfCAgMTIgKysKc3JjL3Rvb2xzL3BnaW5kZW50L3R5cGVkZWZzLmxpc3QgICAgIHwg ICAxICsKNyBmaWxlcyBjaGFuZ2VkLCA0ODYgaW5zZXJ0aW9ucygrKSwgMTUgZGVsZXRpb25zKC0p Cgo= --===============1629423490244319857==--