Key Visualizer metrics

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

Metrics

Key Visualizer automtically captures and aggregates metrics about performance and resource usage for Cloud Spanner databases that have enabled it. All metrics in Key Visualizer are normalized by the number of rows. This means that the metric value inside a row range is the aggregated count divided by the number of rows inside the range.

Metrics Description
CPU seconds Number of CPU seconds spent per (wall clock) second reading / writing in a row range.
Logical stored bytes Bytes used to store data in a row range.
Number of rows read Number of rows read per second from a row range.
Number of bytes read Number of bytes read (not bytes returned) per second from a row range.
Number of rows written Number of rows inserted / updated per second in a row range.
Number of bytes written Number of bytes inserted / updated per second in a row range.

Time window granularity

Cloud Spanner Key Visualizer aggregates metrics at several different granularities over time. The most recent data is aggregated at the finest granularity, while earlier data is aggregated more coarsely.

Period Granularity
Past 6 hours 1 minute
Past 4 days 10 minutes
Past 28 days 1 hour

Data retention and wipeout

Cloud Spanner stores key ranges and metrics in an internal metadata table as part of the user's database. Cloud Spanner Key Visualizer data retention is as follows:

  • Data that is collected every minute will be deleted after six hours.
  • Data that is collected every ten minutes will be deleted after four days.
  • Data that is collected every hour will be deleted after 28 days.

Key Visualizer stores row key data in the metadata table. If your data retention requirements aren't compatible with Key Visualizer's data retention schedule, you can disable Key Visualizer.

What's next