> 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