pg_stat_database.blks_hit
Number of times disk blocks were found already in the buffer cache, so that a read was not necessary (this only includes hits in the PostgreSQL buffer cache, not the operating system's file system cache)
Reading PG 18·Select a recorded version
- View
- pg_stat_database
- Field
- blks_hit
- SQL type
- bigint
- Units named in the field definition
- blocks
- Reset observation
- Time at which these statistics were last reset
- documented
- true
- field
- blks_hit
- manual path
- /docs/18/monitoring-stats.html
- signature
- SELECT blks_hit FROM pg_catalog.pg_stat_database;
- source only
- false
- sql type
- bigint
- units mentioned
- blocks
- view
- pg_stat_database
Definition PG 18
Number of times disk blocks were found already in the buffer cache, so that a read was not necessary (this only includes hits in the PostgreSQL buffer cache, not the operating system's file system cache)
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f