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

Collapse
Posted by Janine Ohmer on
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
Posted by Bruno Mattarollo on

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