↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Statistics & Metrics

pg_stat_io.backend_type

Type of backend (e.g. background worker, autovacuum worker). See pg_stat_activity for more information on backend_types. Some backend_types do not accumulate I/O operation statistics and will not be included in the view.

Reading PG 18·Select a recorded version

View
pg_stat_io
Field
backend_type
SQL type
text
Units named in the field definition
Not specified
Reset observation
Time at which these statistics were last reset.
documented
true
field
backend_type
manual path
/docs/18/monitoring-stats.html
signature
SELECT backend_type FROM pg_catalog.pg_stat_io;
source only
false
sql type
text
units mentioned
Unknown
view
pg_stat_io

Definition PG 18

Type of backend (e.g. background worker, autovacuum worker). See pg_stat_activity for more information on backend_types. Some backend_types do not accumulate I/O operation statistics and will not be included in the view.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f