On Wed, Feb 13, 2019 at 12:38:51AM +0000, Andrew Gierth wrote:
> Doesn't work - that function's idea of "backend id" doesn't match the
> real one, since it's looking at a local copy of the stats from which
> unused slots have been removed.
The temporary namespace OID is added to PGPROC since v11, so it could
be easy enough to add a system function which maps a temp schema to a
PID. Now, it could actually make sense to add this information into
pg_stat_get_activity() and that would be cheaper.
--
Michael