Skip to main content
On a secure cluster, this area of the DB Console can only be accessed by users belonging to the admin role or a SQL user with the VIEWCLUSTERMETADATA system privilege (or the legacy VIEWACTIVITY or VIEWACTIVITYREDACTED role option) defined. The VIEWACTIVITY or VIEWACTIVITYREDACTED system privileges do not grant access to this page.
The Top Ranges page of the DB Console provides details about the highest-ranked ranges by metrics such as reads, writes, queries per second (QPS), and CPU. Ranges that rank highly by these measures may indicate hot ranges, but are not necessarily problematic. When optimizing or troubleshooting statement performance, this page can help you identify nodes, ranges, or tables that are experiencing hotspots. To view this page, access the DB Console and click Top Ranges in the left-hand navigation.

​
Select nodes

In the Select Nodes filter, choose one or more nodes with high activity, such as high CPU usage, to investigate potential hotspots. Selecting fewer nodes can help identify the hottest ranges more quickly and improve page load time. Selecting a region, such as us-east1, selects all nodes in that region. In the Select Nodes search box, enter numbers to search for specific node IDs. For example, in a cluster with 12 nodes, entering 1 returns checkboxes for node IDs n1, n10, n11, and n12. Click Apply to view the top ranges list for the selected nodes.

​
Filter top ranges

After selecting nodes, use the Filter menu to filter the top ranges list. You can choose to view top ranges across a specific table, index, store ID, and one or more databases. In the Databases dropdown list, you can choose to filter by specific databases (optional). In the Table and Index search boxes, enter the complete name of a table or index to return results. For example, in the movr database, search for the exact index name users_pkey to return results. Entering a partial index name, such as user or users returns no results. In the Store ID search box, enter numbers to search for specific store IDs. For example, in a cluster with 12 stores, entering 1 returns results for store IDs 1, 10, 11, and 12. Click Apply to view the filtered top ranges list.

​
Top ranges list

The Top ranges list displays the ranges with the highest queries per second (QPS) from each node store.
Top ranges are not necessarily problematic. Some ranges naturally experience higher QPS than others. For example, a range for a frequently accessed table will have a higher QPS.However, a significant increase in traffic can also indicate a hotspot on the range that should be reduced. For more information, refer to Understand hotspots.
To view the Range Report for a top range, click its range ID.

​
Range Report

The Range Report is typically used for advanced debugging purposes. If your aim is to reduce hotspots, refer to the following fields:
  • Key Range shows the interval of the key space that is “hottest” (i.e., read by the processor). This is expressed as a span of key values.
  • Lease Holder QPS shows the queries executed per second on the node that holds the range lease. If a top range is not properly using load-based splitting, this will be greater than the value configured by the kv.range_split.load_qps_threshold cluster setting ( 2500 by default).

​
See also