Collect this information: ps ax output for all postgres processes on master/all nodes: gpssh -f <hosts_file> "hostname; ps ax | grep postgres" pstack/gstack output for all postgres processes on master/all nodes: gpssh -f <hosts_file> "ps ax | grep postgres | awk '{ print \$1}' \| while read pid; do hostname; echo $pid; gstack \$pid; done" df -h/zfs list output for all postgres processes on master/all nodes: gpssh -f <hosts_file> "df -h" pg_locks from master and segments: select * from pg_locks; select * from gp_distrandom('pg_locks'); pg_stat_activity from master and segments: select * from pg_stat_activity; select * from gp_distrandom('pg_stat_activity'); |