On Fri, Feb 09, 2018 at 07:33:57PM +0530, Ashutosh Bapat wrote: > I didn't pay attention to the second one. Thanks for pointing that > out. But then like me a user may first land on OldSerXidLock since > that is first in the list and get confused. May be we should use names > which are not prefix of others.
Yeah, I don't think that it would be good to have users abuse of things like ~ 'oldserxid' to track different event types. This encourages such filters on pg_stat_activity. -- Michael