hot_tablets

Creates, updates, deletes, gets or lists a hot_tablets resource.

Overview

Name	hot_tablets
Type	Resource
Id	google.bigtableadmin.hot_tablets

Fields

Name	Datatype	Description
name	string	The unique name of the hot tablet. Values are of the form projects/{project}/instances/{instance}/clusters/{cluster}/hotTablets/[a-zA-Z0-9_-]*.
endKey	string	Tablet End Key (inclusive).
endTime	string	Output only. The end time of the hot tablet.
nodeCpuUsagePercent	number	Output only. The average CPU usage spent by a node on this tablet over the start_time to end_time time range. The percentage is the amount of CPU used by the node to serve the tablet, from 0% (tablet was not interacted with) to 100% (the node spent all cycles serving the hot tablet).
startKey	string	Tablet Start Key (inclusive).
startTime	string	Output only. The start time of the hot tablet.
tableName	string	Name of the table that contains the tablet. Values are of the form projects/{project}/instances/{instance}/tables/_a-zA-Z0-9*.

Methods

Name	Accessible by	Required Params	Description
list	SELECT	clustersId, instancesId, projectsId	Lists hot tablets in a cluster, within the time range provided. Hot tablets are ordered based on CPU usage.

SELECT examples

Lists hot tablets in a cluster, within the time range provided. Hot tablets are ordered based on CPU usage.

SELECT
name,
endKey,
endTime,
nodeCpuUsagePercent,
startKey,
startTime,
tableName
FROM google.bigtableadmin.hot_tablets
WHERE clustersId = '{{ clustersId }}'
AND instancesId = '{{ instancesId }}'
AND projectsId = '{{ projectsId }}';