[Design Update][Dashboard]

Hello Hackers,

Below is an update on our findings for the Dashboard in pgAdmin. You can
also find all updates here:
https://docs.google.com/document/d/1J_GhsL0nR4dbTI6F-XlxspvXutghzj-3UGjDWf8MtVA/edit?usp=sharing

. . .

*Summary*

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