This page describes the metrics that you can view in Key Visualizer heatmaps.
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.
|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.
|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.
- Get started with Key Visualizer.
- Learn how Key Visualizer displays data in heatmaps.
- Find out how to explore Key Visualizer heatmaps.