From: Andrew Gierth [mailto:and...@tao11.riddles.org.uk] > Tsunakawa> SELECT pg_stat_get_backend_pid(backendid); > > 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.
Ouch, the argument of pg_stat_get_backend_pid() and the number in pg_temp_N are both backend IDs, but they are allocated from two different data structures. Confusing. From: Michael Paquier [mailto:mich...@paquier.xyz] > 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. That sounds good. Regards Takayuki Tsunakawa
