pg_stat_io.evictions
Number of times a block has been written out from a shared or local buffer in order to make it available for another use. In context normal, this counts the number of times a block was evicted from a buffer and replaced with another block. In contexts bulkwrite, bulkread, and vacuum, this counts the number of times a block was evicted from shared buffers in order to add the shared buffer to a separate, size-limited ring buffer for use in a bulk I/O operation.
Reading PG 18·Select a recorded version
- View
- pg_stat_io
- Field
- evictions
- SQL type
- bigint
- Units named in the field definition
- Not specified
- Reset observation
- Time at which these statistics were last reset.
- documented
- true
- field
- evictions
- manual path
- /docs/18/monitoring-stats.html
- signature
- SELECT evictions FROM pg_catalog.pg_stat_io;
- source only
- false
- sql type
- bigint
- units mentioned
- Unknown
- view
- pg_stat_io
Definition PG 18
Number of times a block has been written out from a shared or local buffer in order to make it available for another use. In context normal, this counts the number of times a block was evicted from a buffer and replaced with another block. In contexts bulkwrite, bulkread, and vacuum, this counts the number of times a block was evicted from shared buffers in order to add the shared buffer to a separate, size-limited ring buffer for use in a bulk I/O operation.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f