pg_stat_checkpointer.slru_written

Description

Number of SLRU buffers written during checkpoints and restartpoints

View

pg_stat_checkpointer

Field

slru_written

SQL type

bigint

Units named in the field definition

Not specified

Reset observation

Time at which these statistics were last reset

Usage

SELECT slru_written FROM pg_catalog.pg_stat_checkpointer;

View semantics

The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster.

Collection and reset context

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.

Inspect this field

Example query; no execution result or measured value is asserted.

SELECT slru_written FROM pg_catalog.pg_stat_checkpointer;

Related entries

• pg_stat_checkpointer columns
• Statistics collection and reset functions

Documentation and source

• PostgreSQL 18 English manual

Compare versions

PostgreSQL 17 → 18: added.

--- PostgreSQL 17
+++ PostgreSQL 18
@@ -1 +1,6 @@
-Not recorded in this version
+{
+  "field": "slru_written",
+  "sql_type": "bigint",
+  "units_mentioned": [],
+  "view": "pg_stat_checkpointer"
+}

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

• pg_stat_checkpointer.buffers_written
• pg_stat_checkpointer.num_done
• pg_stat_checkpointer.num_requested
• pg_stat_checkpointer.num_timed
• pg_stat_checkpointer.restartpoints_done
• pg_stat_checkpointer.restartpoints_req
• pg_stat_checkpointer.restartpoints_timed
• pg_stat_checkpointer.stats_reset
• pg_stat_checkpointer.sync_time
• pg_stat_checkpointer.write_time