Does the gpperfmon database resides in each segment servers and the master hosts of GP database

posted Sep 11, 2012, 11:03 AM by Sachchida Ojha
Greenplum Performance Monitor is comprised of data collection agents that run on the master host and each segment host. The agents collect performance data about active queries and system utilization and send it to the Greenplum master at regular intervals. The data is stored in a dedicated database on the master, where it can be accessed through the Greenplum Performance Monitor Console or through SQL queries.