From: James Sewell [mailto:james(dot)sewell(at)jirotech(dot)com]
> From the temp table namespace I can get the backend ID using a regex - but
> I have no idea how I can map that to a PID - any thoughts?
>
SELECT pg_stat_get_backend_pid(backendid);
https://www.postgresql.org/docs/devel/monitoring-stats.html
This mailing list is for PostgreSQL development. You can post questions as a user to pgsql-general(at)lists(dot)postgresql(dot)org(dot)
Regards
Takayuki Tsunakawa