This tool traces busy processes associated with a Greenplum Database session. The information collected can be used by VMware Support for root cause analysis on hung sessions.
**gpmt** **analyze\_session** [-session SESSION\_ID ] [-master-dir DIRECTORY] [-segment-dir DIRECTORY]
Collect process information for a given Greenplum Database session id:
gpmt analyze_session -session 12345
The tool prompt gives a high-level list of only the servers that are running busy processes and how processes are distributed across the Greenplum hosts. This gives an idea of what hosts are busier than others, which might be caused by processing skew or other environmental issue with the affected hosts.
lsof, strace, pstack, gcore, gdb must be installed on all hosts.
gcore will perform a memory dump of the Greenplum process and the size could be anywhere from 300MB to several Gigabytes. Isolating which hosts to collect using the
-hostfile to limit the collection size.