On 09/08/2018 19:57, hubert depesz lubaczewski wrote:
> I just noticed that when I called a procedure that commits and rollbacks
> - the xact_start in pg_stat_activity is not updated. Is it intentional?
It's an artifact of the way this is computed. The reported transaction
timestamp is the timestamp of the first top-level statement of the
transaction. This assumes that transactions contain statements, not the
other way around, like it is now possible. I'm not sure what an
appropriate improvement would be here.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services