Show queries launched inside trigger postgres

Question

I'm looking for a way to log queries launched inside trigger procedures. after setting: log_statement = 'mod' in config i can see queries launched by application, but select's inserts and other queries launched inside trigger procedure are not available in log file. is there any way to show those queries

Ihor Romanchenko · Accepted Answer · 2012-11-27 14:25:01Z

1

Try this http://www.postgresql.org/docs/current/static/pgstatstatements.html It creates a special table with all queries, the server executes.

You will need pg_stat_statements.track ('all').

If you need only to track the statements of the trigger consider setting pg_stat_statements.track ('none') and then pg_stat_statements.track ('all') right before the query that will call trigger. pg_stat_statements.track ('none') again after the trigger.

answered Nov 27, 2012 at 14:25

Ihor Romanchenko

29k9 gold badges56 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

Show queries launched inside trigger postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related