Wiki / Statistics & Metrics

Current overall state of this backend. Possible values are: starting: The backend is in initial startup. Client authentication is performed during this phase. active: The backend is executing a query. idle: The backend is waiting for a new client command. idle in transaction: The backend is in a transaction, but is not currently executing a query. idle in transaction (aborted): This state is similar to idle in transaction, except one of the statements in the transaction caused an error. fastpath function call: The backend is executing a fast-path function. disabled: This state is reported if track_activities is disabled in this backend.

View

pg_stat_activity

Field

state

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

state

manual path

/docs/18/monitoring-stats.html

signature

SELECT state FROM pg_catalog.pg_stat_activity;

source only

false

sql type

text

units mentioned

Unknown

view

pg_stat_activity