I use this to figure out what’s going happening on the nodes and if I might have hanging queries on one of them
gpssh -f hosts.seg
=> ps -ef | grep postgres | grep con | awk '{print $12}' | sort | uniq -c; echo "===="
[node02] 8 con5397
[node02] 12 con5769
[node02] 9 con5782
[node02] 4 con5989
[node02] ====
[node04] 8 con5397
[node04] 12 con5769
[node04] 8 con5782
[node04] 4 con5989
[node04] ====
[node03] 8 con5397
[node03] 12 con5769
[node03] 8 con5782
[node03] 4 con5989
[node03] ====
[node01] 8 con5397
[node01] 12 con5769
[node01] 8 con5782
[node01] 4 con5989
[node01] ====
=>