Monitoring Greenplum Database Log Files

The following table shows the locations of the various Greenplum Database log files. In file paths:

• refers to the home directory of the gpadmin operating system user.
• $GPDATA_DIR refers to a data directory on the Greenplum Database segment host.
• segprefix identifies the segment prefix.
• date is a date in the format YYYYMMDD.

To search log files on the segment hosts, use the Greenplum gplogfilter utility with gpssh to connect to segment hosts from the master host. You can identify corresponding log entries in segment logs by the statement_id.

Parent topic: System Monitoring and Maintenance