hot_tablets

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

Overview

Name	hot_tablets
Type	Resource
Id	google.bigtableadmin.hot_tablets

Fields

The following fields are returned by SELECT queries:

list

Successful response

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 (google-datetime)	Output only. The end time of the hot tablet.
nodeCpuUsagePercent	number (float)	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 (google-datetime)	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

The following methods are available for this resource:

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

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
clustersId	string
instancesId	string
projectsId	string
endTime	string (google-datetime)
pageSize	integer (int32)
pageToken	string
startTime	string (google-datetime)

SELECT examples

list

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 projectsId = '{{ projectsId }}' -- required
AND instancesId = '{{ instancesId }}' -- required
AND clustersId = '{{ clustersId }}' -- required
AND startTime = '{{ startTime }}'
AND endTime = '{{ endTime }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}';