How to tell if/when Postgres triggers are executing

Question

I'm working in a legacy codebase/database. The code previously depended on triggers but at one point stopped using them - the logic was moved into the main (Nodejs) codebase and the CREATE TRIGGER statements were removed. Nonetheless, the triggers still exist in the DB. I can see them searching the pg_trigger table:

As far as I can tell they're still enabled which is weird because to my knowledge they shouldn't be doing anything. If they're not being used I'd like to remove them. My questions:

Is there way to tell the last time a trigger executed?
Are there any other ways I can figure out if these triggers are even doing anything anymore?

Laurenz Albe · Accepted Answer · 2020-06-12 08:10:50Z

2

There is no way to do that, unless you modify the triggers to record the execution somewhere.

Perhaps session_replication_role is set to replica. Then normal triggers (tgenabled = 'O') don't fire.

answered Jun 12, 2020 at 8:10

Laurenz Albe

257k22 gold badges314 silver badges390 bronze badges

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

Collectives™ on Stack Overflow

How to tell if/when Postgres triggers are executing

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