george young <gry(at)ll(dot)mit(dot)edu> writes:
> How can I get cpu usage info in 7.2 about the backend process of my db
> connection? I tried looking at the pg_stat_get_backend_pid function
> but it requires a backend_id that I don't know how to get.
> If I can get the backend pid I can fork a 'ps' command from my app,
> though it would be nicer to get it directly through sql.
There's a pg_backend_pid() function in 7.3 that returns your own PID.
Not sure if it was in 7.2.
regards, tom lane