view what command a function is running is postgres

Question

Say I run a function: select somefunction() and I wanna know what statement it is performing at the moment

select * from t does not help because it shows the 'select somefunction()' line and not the exact statement.

Is there a way to see what's up?

Thanks, h

SELECT * FROM t ? Eh? Do you mean select * from pg_stat_activity ? — Craig Ringer
– Craig Ringer, Commented Sep 10, 2012 at 7:12

Craig Ringer · Accepted Answer · 2012-09-10 07:15:09Z

1

You may want to use the PL/PgSQL debugger - which should be preinstalled in most PostgreSQL installs and is used via PgAdmin-III after activating it in postgresql.conf.

Alternately, consider adding RAISE NOTICE statements in your code at significant points you wish to know about.

There is no facility that I know of to get a "stack trace" of an active SQL statement including the (possibly nested) function calls. It'd be quite nice, but AFAIK nobody's implemented such a feature.

answered Sep 10, 2012 at 7:15

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TraviJuu · Accepted Answer · 2012-09-11 06:11:07Z

0

This can help you.

CREATE FUNCTION somefunction() returns table(query text) as $$ select current_query::text from pg_stat_activity where current_query not like '% somefunction();' $$ language sql;

answered Sep 11, 2012 at 6:11

TraviJuu

3765 silver badges12 bronze badges

Collectives™ on Stack Overflow

view what command a function is running is postgres

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related