History

The History page allows you to display system metrics and queries executed during a specified time period.

On the Admin> Settings page you can enable saving the real-time metrics collected by the Greenplum Database metrics collector extension to history in the gpmetrics schema of the gpperfmon database. When you enable collecting this history, the Command Center History, Query Monitor, and Query Detail views all use data derived from the same data collection method.

If you disable GPCC query history collection on the Admin> Settings page, the history views display data collected and saved in the gpperfmon database by the gpmmon and gpsmon agents. That data is not derived from the real-time metrics displayed on the Query Monitor and Query Detail view. Variations should be expected due to the different data collection methods.

History

Set the time period to display by entering dates and times in the From and To date and time fields. You can enter dates by typing them into the date field or by choosing from the pop-up calendar. Enter 24-hour times in HH:MM format.

Search

In the Filter Queries By section you can restrict queries that display in the query table at the bottom of the page.

  • Database - Choose only queries that ran in a specified database.
  • User - Choose only queried executed by a specified user.
  • Status - Choose queries that completed with the specified status: Done, Cancelled, or Error.
  • Res Queue or Res Group - Choose queries executed by a specified resource queue or resource group.
  • Priority - Choose queries that executed with a relative CPU priority: min, low, medium, high, or max. This option is only available when Greenplum Database is using resource queue-based resource management.
  • Has CPU Skew - Choose queries that completed with CPU skew greater than zero.
  • Has Spill - Choose queries that generated spill files.

Click Search to display results that match your choices.

Hover over a timeline to see the metrics at that point in time for all unhidden charts.

You can click and drag on a chart to zoom in on a time range. Click Search to update the query list and charts to the selected range.

Scroll charts left or right by hovering over the edge of the chart and clicking an arrow. Click ‹ or › to move in half steps. Click « or » to move in full steps.

Charts of the following metrics are available. Show or hide them at any time with the checklist at the upper right of the view.

Queries
The number of queries running, the number of queries queued to run, and the number of queries blocked.
CPU
The percentage of CPU used by system processes and the percentage of CPU used by user processes.
Memory
Percentage of memory in use.
Disk I/O
Disk read and write rates in megabytes per second.
Network
Network I/O read and write rates in megabytes per second. Network metrics include traffic over all NICs (network interface cards), including internal interconnect and administrative traffic.
Load
System load average for 1-minute, 5-minute, and 15-minute periods.
Swap
Percentage of swap space used.

Query Metrics

The Query table displays queries that were active during the specified time period, including queries that started before or finished after the specified time. However, queries that are still active are not included in the table; these queries can be viewed on the Query Monitor page.

The query table has the following columns:

Query ID
An identification string for the query. In the Console, this looks like “1295397846-56415-2”.

Status
The final status of the query. This can be one of the following:

  • Done
  • Cancelled
  • Error

User
The Greenplum Database user who submitted the query.

Database
The name of the database that was queried.

Submitted
The time the query was submitted to the query planner.

Queued Time
The time the query waited before it was executed. In addition to time in the queue, this includes other time such as time in the optimizer.

Run Time
The amount of time the query required to produce a result.

Ended
The time the query completed or was cancelled.

CPU Skew
The amount of CPU skew. CPU skew occurs when query executor processes for one segment use a disproportionate amount of CPU compared to processes for other segments executing the query. This value is the coefficient of variation for the CPU used by processes running this query on each segment, multiplied by 100. For example, a value of .95 is shown as 95.

Spill Files
The total size of spill files created for the query. Greenplum Database creates spill files when there is insufficient memory to execute the query in memory. See Managing Spill Files Generated by Queries for information about spill files.

Res Group or Res Queue
The name of the resource group or resource queue for the query.

Priority
(Res Queue only) A query executes with the CPU priority assigned to its resource queue.

For more information about Resource Queues, Resource Groups, and Query Plans, refer to the Greenplum Database Administrator Guide.