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