Skip to main content
The Custom Chart debug page in the DB Console lets you create one or multiple custom charts showing any combination of available metrics. The definition of the customized dashboard is encoded in the URL. To share the dashboard with someone, send them the URL. Like any other URL, it can be bookmarked, sit in a pinned tab in your browser, etc. To view the Custom Chart page, , click Advanced Debug In the left-hand navigation bar, and in the Reports section select Custom Time Series Chart.

​
Use the Custom Chart page

DB Console On the Custom Chart page, you can set the time span for all charts, add new custom charts, and customize each chart:
  • To set the time span for the page, use the dropdown menu above the charts and select the desired time span. In addition, once you have selected a metric to display, you can drag within the chart itself to a set a custom time range.
  • To add a chart, click Add Chart and customize the new chart.
  • To customize each chart, use the Units dropdown menu to set the units to display. Then use the table below the chart to select the metrics being queried, and how they’ll be combined and displayed. Options include:
Column Description
Metric Name How the system refers to this metric, e.g., sql.bytesin.
Downsampler

The “Downsampler” operation is used to combine the individual datapoints over the longer period into a single datapoint. We store one data point every ten seconds, but for queries over long time spans the backend lowers the resolution of the returned data, perhaps only returning one data point for every minute, five minutes, or even an entire hour in the case of the 30 day view.

Options:

  • AVG: Returns the average value over the time period.
  • MIN: Returns the lowest value seen.
  • MAX: Returns the highest value seen.
  • SUM: Returns the sum of all values seen.

Aggregator

Used to combine data points from different nodes. It has the same operations available as the Downsampler.

Options:

  • AVG: Returns the average value over the time period.
  • MIN: Returns the lowest value seen.
  • MAX: Returns the highest value seen.
  • SUM: Returns the sum of all values seen.

Rate

Determines how to display the rate of change during the selected time period.

Options:

  • Normal: Returns the actual recorded value.
  • Rate: Returns the rate of change of the value per second.
  • Non-negative Rate: Returns the rate-of-change, but returns 0 instead of negative values. A large number of the stats we track are actually tracked as monotonically increasing counters so each sample is just the total value of that counter. The rate of change of that counter represents the rate of events being counted, which is usually what you want to graph. “Non-negative Rate” is needed because the counters are stored in memory, and thus if a node resets it goes back to zero (whereas normally they only increase).

Source The set of nodes being queried, which is either:
  • The entire cluster.
  • A single, named node.
Per Node If checked, the chart will show a line for each node’s value of this metric.

​
Examples

​
Query user and system CPU usage

DB Console To compare system vs. userspace CPU usage, select the following values under Metric Name:
  • sys.cpu.sys.percent
  • sys.cpu.user.percent
The Y-axis label is the Count. A count of 1 represents 100% utilization. The Aggregator of Sum can show the count to be above 1, which would mean CPU utilization is greater than 100%. Checking Per Node displays statistics for each node, which could show whether an individual node’s CPU usage was higher or lower than the average.

​
Essential Metrics to Monitor

For important metrics to visualize in a custom dashboard, refer to:

​
Available metrics

Some of the metrics listed below are already visible in other areas of the .

​
See also