Re: backend cpu usage? [7.2]

george young <gry@ll.mit.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