pg_stat_activity.backend_type
Type of current backend. Possible types are autovacuum launcher, autovacuum worker, logical replication launcher, logical replication worker, parallel worker, background writer, client backend, checkpointer, archiver, standalone backend, startup, walreceiver, walsender, walwriter and walsummarizer. In addition, background workers registered by extensions may have additional types.
Reading PG 18·Select a recorded version
- View
- pg_stat_activity
- Field
- backend_type
- SQL type
- text
- Units named in the field definition
- Not specified
- Reset observation
- No stats_reset field is documented for this view
- documented
- true
- field
- backend_type
- manual path
- /docs/18/monitoring-stats.html
- signature
- SELECT backend_type FROM pg_catalog.pg_stat_activity;
- source only
- false
- sql type
- text
- units mentioned
- Unknown
- view
- pg_stat_activity
Definition PG 18
Type of current backend. Possible types are autovacuum launcher, autovacuum worker, logical replication launcher, logical replication worker, parallel worker, background writer, client backend, checkpointer, archiver, standalone backend, startup, walreceiver, walsender, walwriter and walsummarizer. In addition, background workers registered by extensions may have additional types.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f