supabase / pg_net / 26045847251

93%

master: 93%

push

github

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.

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

500 of 535 relevant lines covered (93.46%)

200.14 hits per line