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
signature.asc
Description: PGP signature