Re: Limit transaction lifetime

> If it's a single command you're trying to limit `SET statement_timeout TO <whatever>` should do the trick.

This will set only statement timeout but won’t work for long transactions that contain a lot of short statements.

> If you want it based on the session's cumulative statement time, off the top of my head I can't think of anything in
vanillaPG without using executor hooks (that requires some coding). 

Yes, that’s exactly I want to do.

> If the queries that worry you are long-lived, you might be able to get by with a scheduled process checking against
pg_stat_activity(eg: age(query_start)) and adding the current query's run-time to some per-session total, but it's an
highlyinaccurate process. 

I think in my case I should check `xact_start`, because not every query initiates a new transaction.