Greenplum Performance Monitor

Greenplum Database 3.3 includes a highly interactive web-based performance monitoring tool - the Greenplum Performance Monitor. This tool connects to the Greenplum Database’s low-level performance tracking infrastructure to provide a powerful graphical view into the system and the queries running within it. It provides both real-time and historic information about:

• system resource utilization, including CPU, memory, network, disk I/O, swap and more.
• queries in the system, including full query text, and a wide range of relevant information (user, database, resource consumption, etc)
• internals of any query, including the query plan and real-time information about individual scans, joins and more

This information is available via a secure web login, and allows DBAs to see all queries in the system while restricting end-users to seeing just the queries that they initiated. With these capabilities, DBAs are in a better position than ever before to:

• understand how the system is being used — both in real-time and trending over time
• identify and diagnose problem queries, while they are running — detect skew, runaway queries, etc.
• review and balance the query load on the system by better optimizing and scheduling the query load