{"kind": "metric", "major": "18", "item": {"slug": "pg_stat_checkpointer-num_timed", "name": "pg_stat_checkpointer.num_timed", "name_zh": "", "category": "pg_stat_checkpointer", "summary": "Number of scheduled checkpoints due to timeout", "aliases": ["num_timed", "pg_stat_checkpointer"], "content_hash": "0c8b800b6df0e4424bc61b528d03742e3ec9565a8c491e2375e8f27b27abf913", "versions": {"17": {"view": "pg_stat_checkpointer", "facts": [{"label": "View", "value": "pg_stat_checkpointer"}, {"label": "Field", "value": "num_timed"}, {"label": "SQL type", "value": "bigint"}, {"label": "Units named in the field definition", "value": "Not specified"}, {"label": "Reset observation", "value": "Time at which these statistics were last reset"}], "field": "num_timed", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_checkpointer/?v=17", "label": "pg_stat_checkpointer columns"}, {"url": "/docs/17/monitoring-stats.html", "label": "Statistics collection and reset functions"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "sources": [{"url": "/docs/17/monitoring-stats.html#PG-STAT-CHECKPOINTER-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 17 English manual", "sha256": "007af6e8ab39b925963273ec3ba7f06f8ee6fbfaad821f07a1dc78383dbb9b99"}], "sections": [{"title": "View semantics", "paragraphs": ["The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster."]}, {"title": "Collection and reset context", "paragraphs": ["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."]}, {"code": "SELECT num_timed FROM pg_catalog.pg_stat_checkpointer;", "title": "Inspect this field", "paragraphs": ["Example query; no execution result or measured value is asserted."]}], "sql_type": "bigint", "signature": "SELECT num_timed FROM pg_catalog.pg_stat_checkpointer;", "documented": true, "description": ["Number of scheduled checkpoints due to timeout. Note that checkpoints may be skipped if the server has been idle since the last one, and this value counts both completed and skipped checkpoints"], "manual_html": "", "manual_path": "/docs/17/monitoring-stats.html", "source_only": false, "comparison_data": {"view": "pg_stat_checkpointer", "field": "num_timed", "sql_type": "bigint", "units_mentioned": []}, "comparison_hash": "425c34098d98b4554f2dd6d86b351a98e939c14bfc0a78eda334cc502e4bcbd7", "units_mentioned": []}, "18": {"view": "pg_stat_checkpointer", "facts": [{"label": "View", "value": "pg_stat_checkpointer"}, {"label": "Field", "value": "num_timed"}, {"label": "SQL type", "value": "bigint"}, {"label": "Units named in the field definition", "value": "Not specified"}, {"label": "Reset observation", "value": "Time at which these statistics were last reset"}], "field": "num_timed", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_checkpointer/?v=18", "label": "pg_stat_checkpointer columns"}, {"url": "/docs/18/monitoring-stats.html", "label": "Statistics collection and reset functions"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "/docs/18/monitoring-stats.html#PG-STAT-CHECKPOINTER-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 18 English manual", "sha256": "aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722"}], "sections": [{"title": "View semantics", "paragraphs": ["The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster."]}, {"title": "Collection and reset context", "paragraphs": ["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."]}, {"code": "SELECT num_timed FROM pg_catalog.pg_stat_checkpointer;", "title": "Inspect this field", "paragraphs": ["Example query; no execution result or measured value is asserted."]}], "sql_type": "bigint", "signature": "SELECT num_timed FROM pg_catalog.pg_stat_checkpointer;", "documented": true, "description": ["Number of scheduled checkpoints due to timeout"], "manual_html": "", "manual_path": "/docs/18/monitoring-stats.html", "source_only": false, "comparison_data": {"view": "pg_stat_checkpointer", "field": "num_timed", "sql_type": "bigint", "units_mentioned": []}, "comparison_hash": "425c34098d98b4554f2dd6d86b351a98e939c14bfc0a78eda334cc502e4bcbd7", "units_mentioned": []}, "19": {"view": "pg_stat_checkpointer", "facts": [{"label": "View", "value": "pg_stat_checkpointer"}, {"label": "Field", "value": "num_timed"}, {"label": "SQL type", "value": "bigint"}, {"label": "Units named in the field definition", "value": "Not specified"}, {"label": "Reset observation", "value": "Time at which these statistics were last reset"}], "field": "num_timed", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_checkpointer/?v=19", "label": "pg_stat_checkpointer columns"}, {"url": "/docs/19/monitoring-stats.html", "label": "Statistics collection and reset functions"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "sources": [{"url": "/docs/19/monitoring-stats.html#PG-STAT-CHECKPOINTER-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 19 English manual", "sha256": "26e1b6632bdf05ebe081987cb60ab4ded526eec7db73e41316fbd69466c494fe"}], "sections": [{"title": "View semantics", "paragraphs": ["The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster."]}, {"title": "Collection and reset context", "paragraphs": ["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."]}, {"code": "SELECT num_timed FROM pg_catalog.pg_stat_checkpointer;", "title": "Inspect this field", "paragraphs": ["Example query; no execution result or measured value is asserted."]}], "sql_type": "bigint", "signature": "SELECT num_timed FROM pg_catalog.pg_stat_checkpointer;", "documented": true, "description": ["Number of scheduled checkpoints due to timeout"], "manual_html": "", "manual_path": "/docs/19/monitoring-stats.html", "source_only": false, "comparison_data": {"view": "pg_stat_checkpointer", "field": "num_timed", "sql_type": "bigint", "units_mentioned": []}, "comparison_hash": "425c34098d98b4554f2dd6d86b351a98e939c14bfc0a78eda334cc502e4bcbd7", "units_mentioned": []}, "20": {"view": "pg_stat_checkpointer", "facts": [{"label": "View", "value": "pg_stat_checkpointer"}, {"label": "Field", "value": "num_timed"}, {"label": "SQL type", "value": "bigint"}, {"label": "Units named in the field definition", "value": "Not specified"}, {"label": "Reset observation", "value": "Time at which these statistics were last reset"}], "field": "num_timed", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_checkpointer/?v=20", "label": "pg_stat_checkpointer columns"}, {"url": "/docs/devel/monitoring-stats.html", "label": "Statistics collection and reset functions"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "/docs/devel/monitoring-stats.html#PG-STAT-CHECKPOINTER-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 20 English manual", "sha256": "dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251"}], "sections": [{"title": "View semantics", "paragraphs": ["The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster."]}, {"title": "Collection and reset context", "paragraphs": ["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."]}, {"code": "SELECT num_timed FROM pg_catalog.pg_stat_checkpointer;", "title": "Inspect this field", "paragraphs": ["Example query; no execution result or measured value is asserted."]}], "sql_type": "bigint", "signature": "SELECT num_timed FROM pg_catalog.pg_stat_checkpointer;", "documented": true, "description": ["Number of scheduled checkpoints due to timeout"], "manual_html": "", "manual_path": "/docs/devel/monitoring-stats.html", "source_only": false, "comparison_data": {"view": "pg_stat_checkpointer", "field": "num_timed", "sql_type": "bigint", "units_mentioned": []}, "comparison_hash": "425c34098d98b4554f2dd6d86b351a98e939c14bfc0a78eda334cc502e4bcbd7", "units_mentioned": []}}}, "snapshot": {"view": "pg_stat_checkpointer", "facts": [{"label": "View", "value": "pg_stat_checkpointer"}, {"label": "Field", "value": "num_timed"}, {"label": "SQL type", "value": "bigint"}, {"label": "Units named in the field definition", "value": "Not specified"}, {"label": "Reset observation", "value": "Time at which these statistics were last reset"}], "field": "num_timed", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_checkpointer/?v=18", "label": "pg_stat_checkpointer columns"}, {"url": "/docs/18/monitoring-stats.html", "label": "Statistics collection and reset functions"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "/docs/18/monitoring-stats.html#PG-STAT-CHECKPOINTER-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 18 English manual", "sha256": "aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722"}], "sections": [{"title": "View semantics", "paragraphs": ["The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster."]}, {"title": "Collection and reset context", "paragraphs": ["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."]}, {"code": "SELECT num_timed FROM pg_catalog.pg_stat_checkpointer;", "title": "Inspect this field", "paragraphs": ["Example query; no execution result or measured value is asserted."]}], "sql_type": "bigint", "signature": "SELECT num_timed FROM pg_catalog.pg_stat_checkpointer;", "documented": true, "description": ["Number of scheduled checkpoints due to timeout"], "manual_html": "", "manual_path": "/docs/18/monitoring-stats.html", "source_only": false, "comparison_data": {"view": "pg_stat_checkpointer", "field": "num_timed", "sql_type": "bigint", "units_mentioned": []}, "comparison_hash": "425c34098d98b4554f2dd6d86b351a98e939c14bfc0a78eda334cc502e4bcbd7", "units_mentioned": []}, "comparison": {"left": "16", "right": "17", "status": "added", "diff": "--- PostgreSQL 16\n+++ PostgreSQL 17\n@@ -1 +1,6 @@\n-Not recorded in this version\n+{\n+  \"field\": \"num_timed\",\n+  \"sql_type\": \"bigint\",\n+  \"units_mentioned\": [],\n+  \"view\": \"pg_stat_checkpointer\"\n+}"}}