Querying Slow Query Logs of a GeminiDB Redis Instance

project_id

Yes

String

Explanation:

Project ID of a tenant in a region. To obtain this value, see Obtaining a Project ID.

Constraints:

N/A

Values:

N/A

Default value:

N/A

instance_id

Yes

String

Explanation:

Instance ID

Constraints:

N/A

Values:

N/A

Default value:

N/A

X-Auth-Token

Yes

String

Explanation:

User token

You can obtain the token by calling the IAM API by following Obtaining a User Token Through Password Authentication.

Constraints:

N/A

Values:

N/A

Default value:

N/A

start_time

Yes

String

Explanation:

Start time

Constraints:

The start time cannot be 30 days earlier than the current time.

Values:

Format: yyyy-mm-ddThh:mm:ssZ

T is the separator between calendar and hourly notation of time. Z indicates the time zone offset.

Default value:

N/A

end_time

Yes

String

Explanation:

End time

Constraints:

The end time cannot be later than the current time.

Values:

Format: yyyy-mm-ddThh:mm:ssZ

T is the separator between calendar and hourly notation of time. Z indicates the time zone offset.

Default value:

N/A

limit

Yes

Integer

Explanation:

Number of logs queried each time

Constraints:

N/A

Values:

1 to 100

Default value:

N/A

line_num

No

String

Explanation:

Sequence number of a single log line. The current query starts from the next log of line_num, excluding the log of line_num.

Constraints:

This parameter is not required for the first query. The value can be obtained from the response of the last query.

Values:

N/A

Default value:

N/A

operate_type

No

String

Explanation:

Statement type

Constraints:

N/A

Values:

If this parameter is left blank, all statement types are queried.

The following statement types can be queried: SET, GET, DEL, INCR, INCRBY, INCRBYFLOAT, DECR, DECRBY, GETSET, APPEND, MGET, KEYS, SETNX, SETEX, PSETEX, DELVX, MSET, MSETNX, GETRANGE, SUBSTR, SETRANGE, STRLEN, EXISTS, EXPIRE, PEXPIRE, EXPIREAT, PEXPIREAT, TTL, PTTL, PERSIST, TYPE, SCANX, PKSETEXAT, SORT, HDEL, HSET, HGET, HGETALL, HEXISTS, HINCRBY, HINCRBYFLOAT, HKEYS, HLEN, HMGET, HMSET, HSETNX, HSTRLEN, HVALS, HSCAN, HSCANX, PKHSCANRANGE, PKHRSCANRANGE, LINDEX, LINSERT, LLEN, LPOP, LPUSH, LPUSHX, LRANGE, LREM, LSET, LTRIM, RPOP, RPOPLPUSH, RPUSH, RPUSHX, ZADD, ZCARD, ZSCAN, ZINCRBY, ZRANGE, ZREVRANGE, ZRANGEBYSCORE, ZREVRANGEBYSCORE, ZCOUNT, ZREM, ZUNIONSTORE, ZINTERSTORE, ZRANK, ZREVRANK, ZSCORE, ZRANGEBYLEX, ZREVRANGEBYLEX, ZLEXCOUNT, ZREMRANGEBYRANK, ZREMRANGEBYSCORE, ZREMRANGEBYLEX, ZPOPMAX, ZPOPMIN, SADD, SPOP, SCARD, SMEMBERS, SSCAN, SREM, SUNION, SUNIONSTORE, SINTER, SINTERSTORE, SISMEMBER, SDIFF, SDIFFSTORE, SMOVE, SRANDMEMBER, BITSET, BITGET, BITCOUNT, BITPOS, BITOP, BITFIELD, PFADD, PFCOUNT, PFMERGE, GEOADD, GEORADIUSBYMEMBER, GEORADIUS, GEOHASH, GEODIST, GEOPOS, XADD, XACK, XGROUP, XDEL, XTRIM, XLEN, XRANGE, XREVRANGE, XCLAIM, XPENDING, XINFO, XREAD, and XREADGROUP

Default value:

N/A

node_id

No

String

Explanation:

Node ID

Constraints:

N/A

Values:

If this parameter is left blank, all nodes in the instance can be queried. For details about the value, see field id in Table 10.

Default value:

N/A

keywords

No

Array of strings

Explanation:

Full-text log search based on multiple keywords, indicating that all keywords are matched.

Constraints:

• A maximum of 10 keywords are supported.
• Each keyword can contain a maximum of 512 characters.

max_cost_time

No

Double

Explanation:

Logs can be searched based on the maximum execution duration. The unit is millisecond.

Constraints:

N/A

Values:

N/A

Default value:

N/A

min_cost_time

No

Double

Explanation:

Logs can be searched based on the minimum execution duration. The unit is millisecond.

Constraints:

N/A

Values:

N/A

Default value:

N/A

slow_logs

Array of objects

Explanation:

Slow log information. For details, see Table 5.

node_name

String

Explanation:

Node name

Values:

N/A

node_id

String

Explanation:

Node ID

Values:

N/A

whole_message

String

Explanation:

Statement

Values:

N/A

operate_type

String

Explanation:

Statement type

Values:

N/A

cost_time

Double

Explanation:

Execution time (ms)

Values:

N/A

log_time

String

Explanation:

UTC time when a log is generated

Values:

The format is yyyy-mm-ddThh:mm:ssZ. T is the separator between calendar and hourly notation of time. Z indicates the time zone offset.

line_num

String

Explanation:

Sequence number of a log event.

Values:

N/A