{"id":22549,"date":"2023-02-14T10:26:25","date_gmt":"2023-02-14T09:26:25","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=22549"},"modified":"2023-02-14T10:26:25","modified_gmt":"2023-02-14T09:26:25","slug":"postgresql-16-more-i-o-statistics","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-more-i-o-statistics\/","title":{"rendered":"PostgreSQL 16: More I\/O statistics"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">PostgreSQL is already tracking various kinds of statistics which can help in identifying bottlenecks. Some of these statistics are available in the the pg_statio_* catalog views:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; highlight: [1]; title: ; notranslate\" title=\"\">\npostgres=# select viewname from pg_views where viewname like &#039;%statio%&#039;;\n         viewname         \n--------------------------\n pg_statio_all_sequences\n pg_statio_all_tables\n pg_statio_sys_tables\n pg_statio_user_tables\n pg_statio_all_indexes\n pg_statio_sys_indexes\n pg_statio_user_indexes\n pg_statio_sys_sequences\n pg_statio_user_sequences\n(9 rows)\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Other views providing I\/O related statistics are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.postgresql.org\/docs\/current\/monitoring-stats.html#MONITORING-PG-STAT-BGWRITER-VIEW\" target=\"_blank\" rel=\"noreferrer noopener\">pg_stat_bgwriter<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.postgresql.org\/docs\/current\/monitoring-stats.html#MONITORING-PG-STAT-WAL-VIEW\" target=\"_blank\" rel=\"noreferrer noopener\">pg_stat_wal<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.postgresql.org\/docs\/current\/monitoring-stats.html#MONITORING-PG-STAT-DATABASE-VIEW\" target=\"_blank\" rel=\"noreferrer noopener\">pg_stat_database<\/a><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">That&#8217;s what you have up to PostgreSQL 15. The next major version, which will be PostgreSQL 16, will come with more detailed I\/O statistics. The new catalog view which provides this, is called pg_stat_io:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; highlight: [1,7]; title: ; notranslate\" title=\"\">\npostgres=# select version();\n                                               version                                                \n------------------------------------------------------------------------------------------------------\n PostgreSQL 16devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit\n(1 row)\n\npostgres=# \\d pg_stat_io\n                       View &quot;pg_catalog.pg_stat_io&quot;\n    Column    |           Type           | Collation | Nullable | Default \n--------------+--------------------------+-----------+----------+---------\n backend_type | text                     |           |          | \n io_object    | text                     |           |          | \n io_context   | text                     |           |          | \n reads        | bigint                   |           |          | \n writes       | bigint                   |           |          | \n extends      | bigint                   |           |          | \n op_bytes     | bigint                   |           |          | \n evictions    | bigint                   |           |          | \n reuses       | bigint                   |           |          | \n fsyncs       | bigint                   |           |          | \n stats_reset  | timestamp with time zone |           |          | \n\npostgres=# \n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">As my instance was newly created the numbers in there are not very huge:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; highlight: [1]; title: ; notranslate\" title=\"\">\npostgres=# select * from pg_stat_io;\n    backend_type     |   io_object   | io_context | reads | writes | extends | op_bytes | evictions | reuses | fsyncs |          stats_reset          \n---------------------+---------------+------------+-------+--------+---------+----------+-----------+--------+--------+-------------------------------\n autovacuum launcher | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n autovacuum launcher | relation      | normal     |     2 |      0 |         |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n autovacuum worker   | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n autovacuum worker   | relation      | normal     |   324 |      0 |      11 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n autovacuum worker   | relation      | vacuum     |   144 |      0 |       0 |     8192 |         0 |    108 |        | 2023-02-13 16:00:04.736157+01\n client backend      | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n client backend      | relation      | bulkwrite  |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n client backend      | relation      | normal     |   455 |      0 |       1 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n client backend      | relation      | vacuum     |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n client backend      | temp relation | normal     |     0 |      0 |       0 |     8192 |         0 |        |        | 2023-02-13 16:00:04.736157+01\n background worker   | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n background worker   | relation      | bulkwrite  |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n background worker   | relation      | normal     |     0 |      0 |       0 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n background worker   | relation      | vacuum     |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n background worker   | temp relation | normal     |     0 |      0 |       0 |     8192 |         0 |        |        | 2023-02-13 16:00:04.736157+01\n background writer   | relation      | normal     |       |      0 |         |     8192 |           |        |      0 | 2023-02-13 16:00:04.736157+01\n checkpointer        | relation      | normal     |       |     67 |         |     8192 |           |        |     29 | 2023-02-13 16:00:04.736157+01\n standalone backend  | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n standalone backend  | relation      | bulkwrite  |     0 |      0 |       8 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n standalone backend  | relation      | normal     |   689 |   1007 |     493 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n standalone backend  | relation      | vacuum     |    10 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n startup             | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n startup             | relation      | bulkwrite  |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n startup             | relation      | normal     |     0 |      0 |       0 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n startup             | relation      | vacuum     |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n walsender           | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n walsender           | relation      | bulkwrite  |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n walsender           | relation      | normal     |     0 |      0 |       0 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n walsender           | relation      | vacuum     |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n walsender           | temp relation | normal     |     0 |      0 |       0 |     8192 |         0 |        |        | 2023-02-13 16:00:04.736157+01\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">What you see is one row per backend type, context and object. Running a small pgbench load will increase those numbers. Doing a manual checkpoint right after also increases the fsync operations of the checkpointer:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; highlight: [1,9,44,46]; title: ; notranslate\" title=\"\">\npostgres=# \\! pgbench -i -s 10 postgres\ndropping old tables...\ncreating tables...\ngenerating data (client-side)...\n1000000 of 1000000 tuples (100%) done (elapsed 2.76 s, remaining 0.00 s)\nvacuuming...\ncreating primary keys...\ndone in 3.85 s (drop tables 0.00 s, create tables 0.03 s, client-side generate 2.83 s, vacuum 0.14 s, primary keys 0.84 s).\npostgres=# select * from pg_stat_io;\n    backend_type     |   io_object   | io_context | reads | writes | extends | op_bytes | evictions | reuses | fsyncs |          stats_reset          \n---------------------+---------------+------------+-------+--------+---------+----------+-----------+--------+--------+-------------------------------\n autovacuum launcher | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n autovacuum launcher | relation      | normal     |     2 |      0 |         |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n autovacuum worker   | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n autovacuum worker   | relation      | normal     |   324 |      0 |      11 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n autovacuum worker   | relation      | vacuum     |   144 |      0 |       0 |     8192 |         0 |    108 |        | 2023-02-13 16:00:04.736157+01\n client backend      | relation      | bulkread   |  7568 |      0 |         |     8192 |         0 |   7536 |        | 2023-02-13 16:00:04.736157+01\n client backend      | relation      | bulkwrite  |     0 |  14346 |   16394 |     8192 |         0 |  14346 |        | 2023-02-13 16:00:04.736157+01\n client backend      | relation      | normal     |   533 |      0 |       6 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n client backend      | relation      | vacuum     | 14346 |      0 |       0 |     8192 |         0 |  14314 |        | 2023-02-13 16:00:04.736157+01\n client backend      | temp relation | normal     |     0 |      0 |       0 |     8192 |         0 |        |        | 2023-02-13 16:00:04.736157+01\n background worker   | relation      | bulkread   |  6746 |      0 |         |     8192 |         0 |   6714 |        | 2023-02-13 16:00:04.736157+01\n background worker   | relation      | bulkwrite  |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n background worker   | relation      | normal     |     5 |      0 |       0 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n background worker   | relation      | vacuum     |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n background worker   | temp relation | normal     |     0 |      0 |       0 |     8192 |         0 |        |        | 2023-02-13 16:00:04.736157+01\n background writer   | relation      | normal     |       |      0 |         |     8192 |           |        |      0 | 2023-02-13 16:00:04.736157+01\n checkpointer        | relation      | normal     |       |     67 |         |     8192 |           |        |     29 | 2023-02-13 16:00:04.736157+01\n standalone backend  | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n standalone backend  | relation      | bulkwrite  |     0 |      0 |       8 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n standalone backend  | relation      | normal     |   689 |   1007 |     493 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n standalone backend  | relation      | vacuum     |    10 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n startup             | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n startup             | relation      | bulkwrite  |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n startup             | relation      | normal     |     0 |      0 |       0 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n startup             | relation      | vacuum     |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n walsender           | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n walsender           | relation      | bulkwrite  |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n walsender           | relation      | normal     |     0 |      0 |       0 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n walsender           | relation      | vacuum     |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n walsender           | temp relation | normal     |     0 |      0 |       0 |     8192 |         0 |        |        | 2023-02-13 16:00:04.736157+01\n(30 rows)\n\npostgres=# checkpoint;\nCHECKPOINT\npostgres=# select * from pg_stat_io;\n    backend_type     |   io_object   | io_context | reads | writes | extends | op_bytes | evictions | reuses | fsyncs |          stats_reset          \n---------------------+---------------+------------+-------+--------+---------+----------+-----------+--------+--------+-------------------------------\n autovacuum launcher | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n autovacuum launcher | relation      | normal     |     2 |      0 |         |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n autovacuum worker   | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n autovacuum worker   | relation      | normal     |   324 |      0 |      11 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n autovacuum worker   | relation      | vacuum     |   144 |      0 |       0 |     8192 |         0 |    108 |        | 2023-02-13 16:00:04.736157+01\n client backend      | relation      | bulkread   |  7568 |      0 |         |     8192 |         0 |   7536 |        | 2023-02-13 16:00:04.736157+01\n client backend      | relation      | bulkwrite  |     0 |  14346 |   16394 |     8192 |         0 |  14346 |        | 2023-02-13 16:00:04.736157+01\n client backend      | relation      | normal     |   533 |      0 |       6 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n client backend      | relation      | vacuum     | 14346 |      0 |       0 |     8192 |         0 |  14314 |        | 2023-02-13 16:00:04.736157+01\n client backend      | temp relation | normal     |     0 |      0 |       0 |     8192 |         0 |        |        | 2023-02-13 16:00:04.736157+01\n background worker   | relation      | bulkread   |  6746 |      0 |         |     8192 |         0 |   6714 |        | 2023-02-13 16:00:04.736157+01\n background worker   | relation      | bulkwrite  |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n background worker   | relation      | normal     |     5 |      0 |       0 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n background worker   | relation      | vacuum     |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n background worker   | temp relation | normal     |     0 |      0 |       0 |     8192 |         0 |        |        | 2023-02-13 16:00:04.736157+01\n background writer   | relation      | normal     |       |      0 |         |     8192 |           |        |      0 | 2023-02-13 16:00:04.736157+01\n checkpointer        | relation      | normal     |       |   2174 |         |     8192 |           |        |     70 | 2023-02-13 16:00:04.736157+01\n standalone backend  | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n standalone backend  | relation      | bulkwrite  |     0 |      0 |       8 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n standalone backend  | relation      | normal     |   689 |   1007 |     493 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n standalone backend  | relation      | vacuum     |    10 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n startup             | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n startup             | relation      | bulkwrite  |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n startup             | relation      | normal     |     0 |      0 |       0 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n startup             | relation      | vacuum     |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n walsender           | relation      | bulkread   |     0 |      0 |         |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n walsender           | relation      | bulkwrite  |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n walsender           | relation      | normal     |     0 |      0 |       0 |     8192 |         0 |        |      0 | 2023-02-13 16:00:04.736157+01\n walsender           | relation      | vacuum     |     0 |      0 |       0 |     8192 |         0 |      0 |        | 2023-02-13 16:00:04.736157+01\n walsender           | temp relation | normal     |     0 |      0 |       0 |     8192 |         0 |        |        | 2023-02-13 16:00:04.736157+01\n(30 rows)\n\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">A nice addition for tracking I\/O related statistics. Documentation for this catalog view is currently only available in the development branch of the <a href=\"https:\/\/www.postgresql.org\/docs\/devel\/monitoring-stats.html#MONITORING-PG-STAT-IO-VIEW\" target=\"_blank\" rel=\"noreferrer noopener\">documentation<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL is already tracking various kinds of statistics which can help in identifying bottlenecks. Some of these statistics are available in the the pg_statio_* catalog views: Other views providing I\/O related statistics are: That&#8217;s what you have up to PostgreSQL 15. The next major version, which will be PostgreSQL 16, will come with more detailed&hellip;&nbsp;<\/p>\n","protected":false},"author":28,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[],"class_list":["post-22549","post","type-post","status-publish","format-standard","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>PostgreSQL 16: More I\/O statistics - dbi services Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-16-more-i-o-statistics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL 16: More I\/O statistics\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL is already tracking various kinds of statistics which can help in identifying bottlenecks. Some of these statistics are available in the the pg_statio_* catalog views: Other views providing I\/O related statistics are: That&#8217;s what you have up to PostgreSQL 15. The next major version, which will be PostgreSQL 16, will come with more detailed&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/postgresql-16-more-i-o-statistics\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-14T09:26:25+00:00\" \/>\n<meta name=\"author\" content=\"Open source Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Open source Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-more-i-o-statistics\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-more-i-o-statistics\\\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\"},\"headline\":\"PostgreSQL 16: More I\\\/O statistics\",\"datePublished\":\"2023-02-14T09:26:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-more-i-o-statistics\\\/\"},\"wordCount\":159,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-more-i-o-statistics\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-more-i-o-statistics\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-more-i-o-statistics\\\/\",\"name\":\"PostgreSQL 16: More I\\\/O statistics - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2023-02-14T09:26:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-more-i-o-statistics\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-more-i-o-statistics\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-16-more-i-o-statistics\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL 16: More I\\\/O statistics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\",\"name\":\"Open source Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"caption\":\"Open source Team\"},\"description\":\"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/open-source-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL 16: More I\/O statistics - dbi services Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-more-i-o-statistics\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL 16: More I\/O statistics","og_description":"PostgreSQL is already tracking various kinds of statistics which can help in identifying bottlenecks. Some of these statistics are available in the the pg_statio_* catalog views: Other views providing I\/O related statistics are: That&#8217;s what you have up to PostgreSQL 15. The next major version, which will be PostgreSQL 16, will come with more detailed&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-more-i-o-statistics\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2023-02-14T09:26:25+00:00","author":"Open source Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Open source Team","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-more-i-o-statistics\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-more-i-o-statistics\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a"},"headline":"PostgreSQL 16: More I\/O statistics","datePublished":"2023-02-14T09:26:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-more-i-o-statistics\/"},"wordCount":159,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-16-more-i-o-statistics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-more-i-o-statistics\/","url":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-more-i-o-statistics\/","name":"PostgreSQL 16: More I\/O statistics - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2023-02-14T09:26:25+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-more-i-o-statistics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-16-more-i-o-statistics\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-16-more-i-o-statistics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL 16: More I\/O statistics"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a","name":"Open source Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","caption":"Open source Team"},"description":"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.","url":"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/22549","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=22549"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/22549\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=22549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=22549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=22549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}