supabase / pg_net / 26056941098

93%

push

github

fix: report worker activity to pg_stat_activity (#255)

* fix: report worker activity to pg_stat_activity

Background workers must call pgstat_report_activity() themselves to
update state/state_change in pg_stat_activity; regular user backends
get this for free via tcop/postgres.c. Without it the pg_net worker
shows up with a blank state column, making it impossible to tell
from monitoring whether the worker is idle, processing a tick, or
stuck in a transaction. Adds STATE_IDLE / STATE_RUNNING transitions
around the inner work loop.

cmd_str is NULL, matching what other background workers (e.g.
logical replication apply worker) do; backend_type already
identifies it as "pg_net <ver> worker" so a query-column label
would be redundant.

* test: verify worker state is reported in pg_stat_activity

3 of 3 new or added lines in 1 file covered. (100.0%)

501 of 536 relevant lines covered (93.47%)

202.83 hits per line