prioritize

pig repo add pgdg -u    # add pgdg repo and update cache

pig install pg_prioritize;		# install via package name, for the active PG version
pig install prioritize;		# install by extension name, for the current active PG version

pig install prioritize -v 18;   # install for PG 18
pig install prioritize -v 17;   # install for PG 17
pig install prioritize -v 16;   # install for PG 16
pig install prioritize -v 15;   # install for PG 15
pig install prioritize -v 14;   # install for PG 14

CREATE EXTENSION prioritize;

SELECT get_backend_priority(pg_backend_pid());

SELECT set_backend_priority(pg_backend_pid(), 10);

-- Increase priority of all current user's backends by 5
SELECT set_backend_priority(pid, get_backend_priority(pid) + 5)
  FROM pg_stat_activity
  WHERE usename = CURRENT_USER;