gpsupport analyze_session

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.

Usage

gpsupport analyze_session [-session <session_id> ] [-coordinator-dir <directory>] 
[-segment-dir <directory>] 

Options

-session
Greenplum session ID which is referenced in pg_stat_activity.
-coordinator-dir
Working directory for coordinator process.
-segment-dir
Working directory for segment processes.
-free-space
Free space threshold which will exit log collection if reached. Default value is 10%.
-a
Answer Yes to all prompts.

Examples

Collect process information for a given Greenplum Database session id:

gpsupport 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.

Note: 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 gpsupport global option -hostfile to limit the collection size.

check-circle-line exclamation-circle-line close-line
Scroll to top icon