Hi again, > 57033 (master) =# select * from pg_stat_activity where pid = 57033; > ... > total_active_time | 2514.635 > total_idle_in_transaction_time | 2314.703 > > 57033 (master) =# COMMIT; > 57033 (master) =# select * from pg_stat_activity where pid = 57033; > ... > total_active_time | 22.048 > total_idle_in_transaction_time | 7300.911 > ```
My previous message was wrong, total_active_time doesn't track seconds. I got confused by the name of this column. Still I'm pretty confident it shouldn't decrease. -- Best regards, Aleksander Alekseev