Re: Add sub-transaction overflow status in pg_stat_activity

I can see putting counts that people would want to use for statistics elsewhere but IIUC the whole purpose of "overflowed" is to inform someone that their session presently has degraded performance because it has created too many subtransactions.  Just because the "degraded" condition itself is rare doesn't mean the field "is my session degraded" is going to be seldom consulted.  In fact, I would rather think it is always briefly consulted to confirm it has the expected value of "false" (blank, IMO, don't show anything in that column unless it is exceptional) and the presence of a value there would draw attention to the desired fact that something is wrong and warrants further investigation.  The pg_stat_activity view seems like the perfect place to at least display that exception flag.

David J.