Re: [GENERAL] Monitoring activities of PostgreSQL

2010-06-17 Thread Allan Kamau
2010/6/16 Filip RembiaƂkowski : > > 2010/6/15 Allan Kamau >> >> I do have a PL/SQL function that gets executed called many times but >> with different parameter values each of these times. For most >> invocations of this function run in a couple of seconds however some >> invocations of the same f

Re: [GENERAL] Monitoring activities of PostgreSQL

2010-06-16 Thread Dimitri Fontaine
Allan Kamau writes: > How can I monitor the actual DB activities during such times so I may > better understand what the situation truly is. I have seen some users > on this list posting some complex log/outputs, this are the kind of > outputs I would like to capture and view. Where are they? The

Re: [GENERAL] Monitoring activities of PostgreSQL

2010-06-16 Thread Filip RembiaƂkowski
2010/6/15 Allan Kamau > I do have a PL/SQL function that gets executed called many times but > with different parameter values each of these times. For most > invocations of this function run in a couple of seconds however some > invocations of the same function run (on the same dataset) for hour

[GENERAL] Monitoring activities of PostgreSQL

2010-06-15 Thread Allan Kamau
I do have a PL/SQL function that gets executed called many times but with different parameter values each of these times. For most invocations of this function run in a couple of seconds however some invocations of the same function run (on the same dataset) for hours with very little disk activity