backend cpu usage? [7.2]

From: george young <gry(at)ll(dot)mit(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: backend cpu usage? [7.2]
Date: 2003-08-01 20:23:01
Message-ID: 20030801162301.4ae86d31.gry@ll.mit.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

[postgresql-7.2, x86 linux]
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.

-- George Young

--
I cannot think why the whole bed of the ocean is
not one solid mass of oysters, so prolific they seem. Ah,
I am wandering! Strange how the brain controls the brain!
-- Sherlock Holmes in "The Dying Detective"

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Poole 2003-08-01 20:26:16 Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs
Previous Message Denis Zaitsev 2003-08-01 20:12:57 Re: NEW and a subselect in a rule