Usage Report

The Usage Report page allows an administrator to perform a variety of tasks, including:

• Displaying resource usage for each role for a specific month
• Displaying resource usage for specific roles
• Displaying resource usage for for one or more specific departments
• Displaying resource usage for roles with no department
• Displaying roles holding a specific permission
• Displaying resource usage for all permission levels
• Creating a department name
• Assigning a department name to a specific role
• Changing a role’s permissions
• Exporting resource usage of specific roles

The resources displayed include:

• CPU Time
• Peak Memory
• Total Queries
• Spill Files
• Disk Read
• Disk Write

Display Resource Usage by Role Per Month

This task requires Operator Basic or higher permission.

To display resource usage by role per month:

1. Select Time > Month
2. Click the SEARCH button

Command Center displays resource usage for all roles for that month.

Display Resource Usage for Specific Roles

This task requires Operator Basic or higher permission.

Note: The results returned may not cover up to the preceding 6 hours, due to delays.

To display resource usage for specific roles:

1. Enter the role name in the Role Name field
2. Click the SEARCH button

Command Center displays resource usage for that role.

Note: The resource usage of the gpmon and gpadmin roles is not included.

Display Resource Usage for Departments

These tasks require Operator Basic or higher permission.

To display resource usage for a specific department:

1. Select a department from the Department dropdown menu
2. Click the SEARCH button

Command Center displays resource usage for that department.

To display resource usage for all departments:

1. Select all departments from the Department dropdown menu
2. Click the SEARCH button

Command Center displays resource usage for all departments.

To display resource usage for a selection of departments:

1. Select multiple departments from the Department dropdown menu
2. Click the SEARCH button

Command Center displays resource usage for this selection of departments.

Display Resource Usage for Roles with No Department

This task requires Operator Basic or higher permission.

To display resource usage for roles with no department:

1. Select “–” from the Department dropdown
2. Click the SEARCH button

Command Center displays resource usage for roles who have no department.

Display Resource Usage for Roles Holding a Specific Permission

This task requires Operator Basic or higher permission.

To display resource usage for roles holding a specific permission:

1. Select a permission from the Permission dropdown menu
2. Click the SEARCH button

Command Center displays resource usage for roles with that permission.

Display Resource Usage for All Permission Levels

This task requires Operator Basic or higher permission.

To display resource usage for all permission levels:

1. Select “All” from the Permission dropdown menu
2. Click the SEARCH button

Command Center displays resource usage for all permission levels.

Create a Department Name

This task requires Admin permission.

To create a department name and apply it to a specific role:

1. Click Department dropdown menu
2. Enter a new department name
3. Hit Enter
4. Click the Department dropdown menu again; the new department name is now visible

Assign a Department Name to a Specific Role

This task requires Admin permission.

To assign a department name to a specific role:

1. Click the Department dropdown menu
2. Select a name from the list
3. That department name is now associated with the role

Change a Role’s Permissions

This task requires Admin permission.

To set a role’s permission level:

1. Click the Permissions dropdown menu
2. Select the desired permission
3. That permission is now associated with the role

Export Resource Usage of Specific Roles

This task requires Operator Basic permission.

To export resource usage of specific roles:

1. Specify search conditions in the Usage Report interface
2. Click the SEARCH button
3. View the resource usage report
4. Click the EXPORT ALL button

A CSV file that begins with the string gpcc_user_usage_report is downloaded to your machine’s default download location.