Key Visualizer Metrics

This page describes the metrics that you can view in Key Visualizer heatmaps.

Most Key Visualizer metrics represent a quantity per row. For example, the Ops metric measures the number of operations per row per minute.

A Cloud Bigtable table can have trillions of rows, so it's not always practical to report metrics for each individual row. Instead, Key Visualizer divides all of the row keys into 1,000 contiguous ranges, with roughly the same number of row keys in each range. These ranges are known as key buckets.

Key Visualizer reports most metrics as averages over each key bucket, or as maximum values within each key bucket. For Warnings metrics and Performance metrics, Key Visualizer provides higher precision by reporting metrics for individual row keys or for specific key ranges within the key bucket.

Before you read this page, you should be familiar with the overview of Key Visualizer.

Activity

The Activity category includes the Ops metric, which measures the number of operations per row per minute. This metric is roughly equal to the combined number of reads and writes.

Warnings

The Warnings category includes metrics that identify possible performance issues with a table. This category includes the following metrics:

  • Read pressure index: An opaque, composite index for a row key or key range that incorporates the CPU utilization and latency for reads.

    This index reflects all of the values that were observed during a 15-minute interval. A value of 100 or greater generally indicates poor performance for a key range. Poor performance can occur when you access a single row or a small range of rows very frequently, or when a row contains more than 256 MB of data.

    To learn how to view and act on this metric, see Reviewing warning metrics.

  • Write pressure index: An opaque, composite index for a row key or key range that incorporates the CPU utilization and latency for writes.

    This index reflects all of the values that were observed during a 15-minute interval. A value of 100 or greater generally indicates poor performance for a key range. Poor performance can occur when you access a single row or a small range of rows very frequently, or when a row contains more than 256 MB of data.

    To learn how to view and act on this metric, see Reviewing warning metrics.

  • Large rows: The amount of data stored in rows that each contain more than 1 GB of data.

    Storing more than 256 MB of data per row can cause performance issues and is not recommended.

    To learn how to view and act on this metric, see Reviewing warning metrics.

For these metrics, when you move your cursor over the heatmap, Key Visualizer does not display aggregated information for a key bucket. Instead, it displays information about specific row keys or key ranges in your table, so that you can pinpoint the source of the issue.

Reads

The Reads category includes metrics related to reading data from a table. This category includes the following metrics:

  • Read CPU: The average CPU utilization, expressed as the number of nodes that were used to read a row.
  • Read bytes client: The number of bytes read by the client per minute per row.

Writes

The Writes category includes metrics related to writing data to a table. This category includes the following metrics:

  • Write CPU: The average CPU utilization, expressed as the number of nodes that were used to write a row.
  • Write bytes client: The number of bytes written by the client per minute per row.

Performance

The Performance category includes metrics related to latency. This category includes the following metrics:

  • Latency: The latency for read and write operations.
  • Max latency: The maximum latency for reads or writes.

For these metrics, when you move your cursor over the heatmap, Key Visualizer does not display aggregated information for a key bucket. Instead, it displays information about specific row keys or key ranges in your table, so that you can pinpoint the source of the issue.

Size

The Size category includes the Data stored metric, which measures the amount of data stored per row. This metric reflects the fact that Cloud Bigtable compresses your data when it is stored.

What's next

Was this page helpful? Let us know how we did:

Send feedback about...

Cloud Bigtable Documentation