We wanted to learn if the graphs within the ‘Dashboard’ option had relevance for Greenplum users (Greenplum has a product, Command Center, which supplies DBAs with similar information).
Database Sessions
Users know it’s for understanding how many active and idle sessions there are
Most useful for DBAs
Transactions per Second
Not useful for users, only DBAs
Users felt like a longer time frame would be more useful, like per hour or 30 min
Block I/O
Information that is found in Command Center
Provides useful feedback for DBAs on how to improve the system
Tuples In
Used as a way to determine what actions to take given what kinds of queries are going on in the system
Would be more useful if could see table information (which tables are being calculated)
Part of Command Center
Tuples Out
Not particularly useful for users
Distinction between metrics is difficult to remember
Actions
Share these learnings with GPCC team
Remove these graphs for users who are connected to a Greenplum database
Information provided is useful for DBAs who are using a Postgres Database and should remain for those users