george young <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
