Forum OpenACS Development: What's that PG process doing???

Collapse
1: What's that PG process doing???
Posted by Janine Ohmer on 02/09/04 06:05 PM
Oracle maintains session tables which allow you to see what's running at a particular point in time, and even map it to a process ID so you can see what that runaway process is doing.  Is there something similar in Postgres?  I've needed to do this several times lately but I don't know how.
Collapse
2: Re: What's that PG process doing??? (response to 1)
Posted by Bruno Mattarollo on 02/09/04 06:23 PM

Hello Janine.

It's quite simple. What I did was to enable PGSQL to keep stats and then you can query some tables that contain all that information. You can see more in the postgresql docs.

Hope this helps,

/B