30.1.1 Graph Controls

This section describes the controls available on the All Timeseries Graphs page.

View Filter

The contents of the Timeseries Graphs page depend on the selections made in the View filter. The View filter is a pair of drop-down menus on the top-left side of the page. They enable you to drill down into the assets to which you have access.

For example, if you select a group in the Global Summaries drop-down list, and a MySQL instance in the All Targets drop-down list, the graphs displayed are the instance-specific graphs, only. If you select a host in the All Targets drop-down list, only host-specific graphs are displayed.

Important

The View filter displays only those assets to which you have access.

Graph Filter

The graph filter enables you to display a subset of the available graphs.

Table 30.1 Timeseries Graph Filter

Name	Description
Graph Name	Opens a drop-down menu listing the available search types: Contains Doesn't Contain Regex Negative Regex
Value	Free text field for the search term or regular expression.
Time Range	Drop-down lists containing the time periods to apply to the graphs. The possible values are: Interval: select the duration for the overview data. If you select 1 hour, the data collected in the last hour is displayed. From/To: select a date and time range for the overview data.
Filter	Apply the defined filter.
Save as Default	Sets the selected group and time range as the default. It is not possible to save a date range, using From/To, as the default for a group.
Reset to Default	Resets the graph display to the previously saved values.

Graph Manipulation

This section describes the various actions you can perform on individual graphs.

• Graph Height: slider which enables you to increase or decrease the height of the graph in pixels. This slider does not affect the values of the x or y axes, just resizes the graph.

• Export as CSV: downloads a CSV containing all data currently displayed in the selected graph.

• Export as PNG: generates a PNG image file of the selected graph. The image is displayed in a pop-up. To save the image, right-click and select Save image as....

• Move: enables you to move the selected graph to another location on the page.

• Stacked/Line: enables you to change how the graph is displayed. Line displays a line graph, while Stacked displays each data source as a solid color.

• Legend: lists the sources of information displayed in the graph. The color of the name matches the line/stack used in the graph. To display individual sources, click the required source in the Legend. To highlight individual sources in the graph, hover the cursor over the source's name.

Graph Query Analysis

Graph Query Analysis enables you to examine the queries which were running during specific intervals. To open the Query Analyzer for a specific range on a graph, do the following:

1. On a graph, select a range by clicking at the required start point, and dragging the cursor across the graph until you reach the required interval endpoint and release the mouse button. This selects the range.

2. Several icons are displayed in the top-right corner of the selection. An x to close the selection, a database icon, and a magnifying glass. Click the database icon to open the Query Analyzer's Browse Queries page. Click the magnifying glass to zoom in on the selected range.

   Browse Queries displays all the queries which were running during the defined time period. This enables you to drill down into potential query bottlenecks and performance hotspots and tune your queries accordingly.

   For more information on the Query Analyzer, see Section 32.3, “Query Analyzer User Interface”.