Performance diagnostics
Written by
Updated at September 9, 2024
For performance diagnostics, the Managed Service for Greenplum® cluster uses:
- In versions 6.22 and lower, a dedicated
gpperfmon
database. - In versions 6.25 or higher, the Greenplum® command center.
Note
Access to the gpperfmon
database is granted on request. Contact technical support
The gpperfmon
database saves the statistics on the 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 in total for each host.memory_info
: Information about memory for each host from thesystem_history
andsegment_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 execute the query:
SELECT * FROM <table_name>;
To learn more about information tables of the gpperfmon
database, see the Greenplum® documentation
Greenplum® and Greenplum Database® are registered trademarks or trademarks of VMware, Inc. in the United States and/or other countries.