On Tue, Apr 27, 2021 at 09:26:11AM +0800, Julien Rouhaud wrote: > -1. It's already annoying enough to have to type "WHERE pid != > pg_backend_pid()" to exclude my own backend, and I usually need it quite > often. > Unless we add some new view which integrate that, something like > pg_stat_activity_except_me with a better name. I also don't see how we could > join a new dedicated view with the old one without that information.
Err, sorry for the confusion. What I meant here is to also keep the PID in pg_stat_activity, but also add it to this new view to be able to join things across the board. -- Michael
signature.asc
Description: PGP signature