Hi all,
I'm working on a database (postgresql of course) which has a number of
user-defined functions, some in plperl, some in plpgsql and one in
plpython. Some of these seem pretty slow - I'm not experienced with
databases however so I don't know what to expect speed-wise.
In a test example, adding data to about 4 tables via one of these
functions uses:
Total runtime: 11700.112 ms
Anyway, the problem comes down to this. I have functions which call
other functions, which do inserts, and some of those inserts set off
triggers, e.g.
function_a -> function_b -> inserts data in table 1 -> trigger_a
-> inserts data in table 2 -> trigger_b
-> function_c -> inserts data in table 3 -> trigger_c
-> trigger_d
Now, I'd like to know how much time each of these user-defined functions
is taking, preferably with a simple summary for each function and not
including lots of stats I don't need. EXPLAIN ANALYZE only gives the
time for function_a, and EXPLAIN ANALYZE VERBOSE gives output which is
(to me) incomprehensible and doesn't seem to answer my question - btw I
guess this output is documented somewhere but if so I haven't found it,
so maybe the answer is buried in there somewhere? I've tried other
options, such as debugging via the postmaster, but haven't found what I
need.
I can't be the only one with this problem so I guess there must be a
tool to do this somewhere. Any suggestions?
Thanks,
Sue Fitt
