> Someone in this group mentioned a while back that > pg_backend_pid() function works only after some 1/2 second > after the connection has been established. This had > something to do with the stats collector to make its sweep > every .5 seconds?. Does anyone have more information on this? No, pg_backend_pid() returns MyProcPid, which is set on backend startup. However, the different pg_stat_* views won't work until a message has been passed down to the stats collector, that is correct. //Magnus
