Performance diagnostics

For performance diagnostics, a Greenplum® cluster uses:

• In versions 6.22 and lower, a dedicated gpperfmon database.
• In versions 6.25 or higher, Greenplum® Command Center.

The gpperfmon database saves statistics on system queries and states. The gpperfmon database can be accessed by:

• Admin user.
• User with the mdb_admin role.
• User with the gpperfmon database privileges.

The gpperfmon database contains the following information tables:

• database_history: Greenplum® database workload.
• diskspace_history: Disk space usage.
• dynamic_memory_info: All segments and the amount of dynamic memory used for each host.
• memory_info: Information about memory for each host from the system_history and segment_history tables.
• network_interface_history: Networking for each active Greenplum® database interface.
• queries_history: Status of high-level queries.
• segment_history: Memory allocation for a Greenplum® database segment.
• socket_history: Use of Greenplum® database sockets.
• system_history: System usage.

To view the table, connect to the gpperfmon database and run this query:

SELECT * FROM <table_name>;

To learn more about information tables of the gpperfmon database, see the Greenplum® guide.

Greenplum® and Greenplum Database® are registered trademarks or trademarks of Broadcom Inc. in the United States and/or other countries.