分析Nginx访问日志
select max(inflow)/avg(inflow)as max_ratio from(select sum(inflow)/(max(_time_)-min(_time_))as inflow,_time_-_time_%60 as window_time from log group by window_time order by window_time limit 15)计算最近值变化率，查看最新的...
时间相关
示例 say(concat('time:',time()))输出：time:1559109666 now 函数详细信息，请参见下表：项目 描述 语法 now()。说明 返回当前的UNIX时间戳（数值类型，包含毫秒的小数部分），单位：秒。说明 UNIX时间戳不区分时区，表示的是从1970年1月1...
Time
简介 Time类提供了一系列与时间操作相关的函数，用户可以通过这些函数获取当前时间，判断一个文档的新旧程度。函数列表 函数原型 函数简介 static long now()获取当前时间，返回从1970-01-01 00:00:00到现在的秒数 static float timeliness...
VoiceReport
time":"2023-02-06 17:50:47","voice_type":"voice","b_duration":330,"originate_time":"2023-02-06 17:50:47","b_ring_time":"2023-02-06 17:50:48","b_start_time":"2023-02-06 17:50:47","a_end_time":"2023-02-06 17:56:17","b_...
日期时间函数
FORMAT()Format as time TIME_TO_SEC()Return the argument converted to seconds TIMEDIFF()Subtract time TIMESTAMP()With a single argument,this function returns the date or datetime expression;with two arguments,the sum of the...
alicloud_hbr_snapshots
hbr_oss_backup_plans.default.plans.0.vault_id bucket=data.alicloud_hbr_oss_backup_plans.default.plans.0.bucket complete_time="2021-07-20T14:17:15CST,2021-07-24T14:17:15CST"complete_time_checker="BETWEEN"} data"alicloud_hbr...
alicloud_rds_cross_region_backups
you must specify the start_time and end_time parameters.start_time-(Optional,ForceNew)The beginning of the time range to query.Specify the time in the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format.The time must be ...
指标说明
request_time_p50 请求时间的50分位值 request_time_p90 请求时间的90分位值 request_time_p99 请求时间的99分位值 upstream_response_time_avg 请求连接时长的平均值 说明 upstream_response_time 表示请求连接时长，该时长包括从负载均衡...
Time travel
基于Delta Table，计算引擎可高效支持 Time travel查询 的典型业务场景，即查询历史版本的数据，可用于回溯历史状态的业务数据，或数据出错时，用来恢复历史状态数据进行数据纠正，当然也支持直接使用restore操作恢复到指定的历史版本。...
转换函数
示例2：计算measurement中每个field key对应的field value的反余弦 SELECT ACOS(*)FROM"park_occupancy"WHERE time>='2017-05-01T00:00:00Z' AND time<='2017-05-09T00:00:00Z' name: park_occupancy time acos_of_capacity-2017-05-01T00:00...
alicloud_cdn_real_time_log_delivery
store"shard_count=3 auto_split=true max_split_shard_count=60 append_meta=true } data"alicloud_regions""default"{ current=true } resource"alicloud_cdn_real_time_log_delivery""default"{ domain=alicloud_cdn_domain_new.default...
ST_JaccardSimilarity
to_timestamp(1590296025)AT TIME ZONE 'UTC',to_timestamp(1590296032)AT TIME ZONE 'UTC',to_timestamp(1590296055)AT TIME ZONE 'UTC',to_timestamp(1590296073)AT TIME ZONE 'UTC',to_timestamp(1590296081)AT TIME ZONE 'UTC',to_...
使用前须知
response_time_p50:alb upstream_response_time_p90:alb upstream_response_time_p99:alb request_time_avg:alb request_time_p50:alb request_time_p90:alb request_time_p99:alb 专属仪表盘 仪表盘名称 关联的Logstore或Metricstore 说明...
ST_JaccardSimilarity
to_timestamp(1590296025)AT TIME ZONE 'UTC',to_timestamp(1590296032)AT TIME ZONE 'UTC',to_timestamp(1590296055)AT TIME ZONE 'UTC',to_timestamp(1590296073)AT TIME ZONE 'UTC',to_timestamp(1590296081)AT TIME ZONE 'UTC',to_...
请求OSS资源提示“...time and the current time is too ...
问题描述 请求阿里云对象存储OSS中的资源时，提示以下错误：[ResponseError]:RequestTimeTooSkewed The difference between the request time and the current time is too large.问题原因 请求发起的时间超过OSS服务器当前时间15分钟，OSS...
ST_JaccardSimilarity
to_timestamp(1590296025)AT TIME ZONE 'UTC',to_timestamp(1590296032)AT TIME ZONE 'UTC',to_timestamp(1590296055)AT TIME ZONE 'UTC',to_timestamp(1590296073)AT TIME ZONE 'UTC',to_timestamp(1590296081)AT TIME ZONE 'UTC',to_...
Hyperledger Fabric 高可用篇
static { System.setProperty(PROPOSAL_WAIT_TIME,PROPOSAL_WAIT_TIME_VALUE);System.setProperty(ORDERER_WAIT_TIME,ORDERER_WAIT_TIME_VALUE);} 也可以在Java项目的 config.properties 中设置。The timeout for a proposal requests to ...
时序模式
select_time_-_time_%3600 as time,COUNT(*)as pv,COUNT(DISTINCT remote_addr)as uv group by time order by time limit 10000_time_-_time_%3600 as time 表示时间间隔为1小时，别名为time。remote_addr 字段表示用户终端的IP地址，您...
添加变量类型的过滤器
替换前查询和分析语句为：*|SELECT date_format(_time_-_time_%60,'%H:%i:%s')as time,count(1)as count GROUP BY time ORDER BY time 替换后查询和分析语句为：*|SELECT date_format(_time_-_time_%${{interval|60}},'%H:%i:%s')as time,...
分析-行车轨迹日志
select avg(tpep_dropoff_time-tpep_pickup_time)/60 as driving_minutes,(tpep_pickup_time%(24*3600)/3600+8)%24 as time group by(tpep_pickup_time%(24*3600)/3600+8)%24 order by time limit 24*|select sum(tpep_dropoff_time-tpep_...
6.8与8.9版本实例性能测试
32.12%99th percentile service time index-append 595.738 394.778-200.96 ms-33.73%99.9th percentile service time index-append 924.456 2125.09 1200.63 ms 129.87%99.99th percentile service time index-append 1329.83 2816.56 ...
alicloud_hbr_ots_snapshots
start_time-(Optional,ForceNew)The start time of the backup.This value must be a UNIX timestamp.Unit:milliseconds.end_time-(Optional,ForceNew)The end time of the backup.This value must be a UNIX timestamp.Unit:milliseconds ...
HUE指标
999th Percentile.This is computed over the past hour hue_requests_response_time_999_percentile 99%的请求响应时间。单位：秒。15-Minute Rate hue_requests_response_time_15m_rate 最近15分钟请求响应速率。99th Percentile.This is...
时间语法
语法 SELECT_clause FROM_clause WHERE time['<rfc3339_date_time_string>'|'<rfc3339_like_date_time_string>'|<epoch_time>][AND['<rfc3339_date_time_string>'|'<rfc3339_like_date_time_string>'|<epoch_time>][.]]语法描述 支持的操作...
VoiceReport
ring_time":"2023-03-15 14:46:12","b_start_time":"2023-03-15 14:46:17","b_originate_time":"2023-03-15 14:46:10","end_time":"2023-03-15 14:46:27","call_id":"1*3^1*2","start_time":"2023-03-15 14:46:17","caller":"0216230*","b_...
alicloud_gpdb_db_instance_plans
time-The executed time of the Plan.plan_cron_time-The Cron Time of the plan.plan_task_status-The Status of the plan Task.segment_node_num-The segment Node Num of the Plan.pause-Pause instance plan config.execute_time-The ...
Event Time Column（Segment Key）
Hologres V1.3.20~1.3.27版本支持Event_time_column对应列的约束为nullable，从V1.3.28版本开始不支持Event_time_column对应列的约束为nullable，为nullable的Event_time_column可能会影响数据正确性，如果业务有强需求设置Event_time_...
CREATE TABLE
CREATE TABLE dt_partition(storeId integer,goodsId varchar,goodsPrice integer,orderTime bigint,constraint pk primary key(storeId))PARTITION BY RANGE TIME(orderTime)PARTITIONS 16 WITH(RANGE_TIME_PARTITION_START='30',RANGE_...
GetHotlineAgentDetailReport
rate_handle_in_60s><hotline_time_agent_idle>1s</hotline_time_agent_idle><hotline_time_agent_rest>1s</hotline_time_agent_rest><servicerName>testAccount</servicerName><hotline_time_incall_avg>1.23</hotline_time_incall_avg>...
链路追踪
local.client.ip":"127.0.0.1","result.code":"00","req.serialize.time":"33","resp.deserialize.time":"39","resp.size":"170","req.size":"582","client.conn.time":"0","client.elapse.time":"155","local.client.port":"59774",...
负载均衡SLB后端服务器中TIME_WAIT状态连接数较多
TIME_WAIT 424 TIME_WAIT 430 TIME_WAIT 437 TIME_WAIT 447 TIME_WAIT 455 TIME_WAIT 464 TIME_WAIT 473 TIME_WAIT 481 TIME_WAIT 490 TIME_WAIT 498 TIME_WAIT 506 TIME_WAIT 513 解决方案 说明 如果您对实例或数据有修改、变更等风险操作...
dbms_sql.reset_trace_stats
2022-11-07 19:17:21 LAST_HIT_TIME:2022-11-07 19:17:21 EXECUTIONS:0 SUM_WAIT_TIME:0 MIN_WAIT_TIME:0 MAX_WAIT_TIME:0 SUM_EXEC_TIME:0 MIN_EXEC_TIME:0 MAX_EXEC_TIME:0 SUM_ROWS_SENT:0 MIN_ROWS_SENT:0 MAX_ROWS_SENT:0 SUM_ROWS_...
VoiceReport
b_start_time":"2023-03-13 11:18:36","b_originate_time":"2023-03-13 11:18:16","end_time":"2023-03-13 11:18:43","call_id":"1*9^1*6","start_time":"2023-03-13 11:18:36","caller":"057*11252","b_end_time":"2023-03-13 11:18:43",...
VoiceReport
b_start_time":"2023-03-13 14:42:22","b_originate_time":"2023-03-13 14:42:16","end_time":"2023-03-13 14:43:11","call_id":"1*3^1*2","start_time":"2023-03-13 14:42:22","caller":"0286*965","b_end_time":"2023-03-13 14:43:11",...
常见问题
示例3：使用聚合函数并且指定时间范围和使用 GROUP BY time()子句>SELECT SUM("water_level")FROM"h2o_feet"WHERE time>='2015-08-18T00:00:00Z' AND time<='2015-08-18T00:18:00Z' GROUP BYtime(12m)name:h2o_feet time sum-2015-08-18T00:...
VoiceReport
time":"2023-03-10 17:57:27","b_originate_time":"2023-03-10 17:57:16","end_time":"2023-03-10 17:57:34","call_id":"1*3^1*2","start_time":"2023-03-10 17:57:27","caller":"02122*75","b_end_time":"2023-03-10 17:57:34","status_...
查询和分析JSON日志
SELECT"content.time.request_time",COUNT(*)AS count GROUP BY"content.time.request_time"ORDER BY"content.time.request_time"计算不同请求方法对应的平均请求时长。SELECT avg("content.time.request_time")AS avg_time,"content....
变量
request_method:*|SELECT_time_-_time_%60 AS time,COUNT(1)AS PV GROUP BY time ORDER BY time 示例2：设置变量替换 在如下查询分析语句中，将 60 设置为变量，格式为${{date|60}}。select_time_-_time_%60 as time,COUNT(*)as pv,avg...
探测指标说明
中文名 英文名 单位 解释 总响应时间 total_time 毫秒 整个探测过程消耗的时间（包含redirect_time）。DNS域名解析时间 http_dns_time 毫秒 解析域名消耗的时间。curl连接时间 curl_connect_time 毫秒 从发起探测到完成curl连接消耗的时间...
SecretReport
说明 release_time和start_time之差表示通话时长，如果结果为0，说明呼叫未接通。sms_number Integer 否 1 短信长度。release_dir Integer 是 0 通话释放方向。取值：0：平台释放。1：主叫挂断。2：被叫挂断。out_id String 否 123456 外部...
- 产品推荐
- 这些文档可能帮助您