常见问题
示例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:...
HTMLStream API
删除一个元素使用remove，多数情况下需要根据这个标签跳过该元素，因为元素已经被删除。namespaceURI：只读，表示该元素的命名空间URI，例如svg或script元素。方法 修改属性 getAttribute(name)：查询某个元素的属性名称。setAttribute...
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....
HTMLStream API
删除一个元素使用remove，多数情况下需要根据这个标签跳过该元素，因为元素已经被删除。namespaceURI：只读，表示该元素的命名空间URI，例如svg或script元素。方法 修改属性 getAttribute(name)：查询某个元素的属性名称。setAttribute...
变量
select_time_-_time_%60 as time,COUNT(*)as pv,avg(request_time)as duration,request_method GROUP BY time,request_method order by time limit 1000 在 通用配置 中设置变量替换。设置 变量key 为date，变量的 显示名 为时间，变量值的...
探测指标说明
中文名 英文名 单位 解释 总响应时间 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 外部...
估算函数
查询和分析语句*|SELECT approx_percentile(request_time,case when request_time,0.5)查询和分析结果 示例4：根据 request_time 与权重的乘积对 request_time 列进行排序后，返回大约处于80%和90%位置的 request_time 字段的值。...
压测指标和任务参数说明
指标类型 指标名称 指标说明 主分片索引相关指标 Cumulative indexing time of primary shards 所有主分片索引累积时间总和。说明 该时间总和是指多个indexing线程消耗CPU时间的总和，而不是自然时间。例如有M个indexing线程，运行了N分钟...
常见分析案例
status:500|select_topic_,max_by(error_count,window_time)/1.0/sum(error_count)as error_ratio,sum(error_count)as total_error from(select_topic_,count(*)as error_count,_time_-_time_%300 as window_time from log group by_topic_...
SQL
total_time double precision 在该语句中花费的总时间。单位：毫秒。min_time double precision 在该语句中花费的最小时间。单位：毫秒。max_time double precision 在该语句中花费的最大时间。单位：毫秒。mean_time double precision 在...
日志分析
time>10 and response_time~100毫秒' when response_time>100 and response_time毫秒~1秒' when response_time>1000 and response_time秒~10秒' when response_time>10000 and response_time秒~1分钟' else '>1分钟' end as latency_type,...
Application Real-Time Monitoring Service(ARMS)
Application Real-Time Monitoring Service(ARMS)
SQL Detail
time:822 Wait_time:229 Error_code:1050 Rows_sent:0 Rows_examined:0 Rows_affected:0 Logical_read:55 Phy_sync_read:0 Phy_async_read:0 Process_info:NULL Extra:NULL Create_time:2023-01-13 16:18:23.393071 Update_time:2023-01-13...
SQL
total_time double precision 在该语句中花费的总时间。单位：毫秒。min_time double precision 在该语句中花费的最小时间。单位：毫秒。max_time double precision 在该语句中花费的最大时间。单位：毫秒。mean_time double precision 在...
SQL查询
SELECT time_bin(_time,"2h"),max_by(usage_user,_time),max_by(usage_system,_time),max_by(usage_nice,_time)FROM `device:cpu` WHERE_time>unix_timestamp_micros("2023-01-05 05:14:00.000000")AND_time("2023-01-07 09:14:00.000000")...
使用GetLogs接口查询日志
from_time=int(time.time())-3600 to_time=time.time()+3600 print("ready to query logs from logstore%s"%logstore)#该示例中，query参数用于设置查询和分析语句，line参数无效，返回条数以query参数中的设置为准，返回1条。request=...
TRIM
trim 是一个过程，用于从变长数组或嵌套表的末尾删除元素并销毁位置（以下简称为销毁元素）。trim 的形式如下：collection.trim()：如果集合至少有一个元素，则TRIM从集合末尾销毁元素；否则，会引发预定义的异常 SUBSCRIPT_BEYOND_COUNT。...
get_cursor_time
请求语法 aliyunlog log get_cursor_time-project_name=<value>-logstore_name=<value>-shard_id=<value>-cursor=[-access-id=][-access-key=][-sts-token=][-region-endpoint=][-client-name=][-jmes-filter=][-format-output=][-decode-...
DELETE
delete 是一个过程，用于从集合中删除元素。delete 的形式如下：collection.delete()：从任何类型的集合中删除所有元素，该操作会立即释放分配给已删除元素的内存。collection.delete(index)：删除索引为index的元素（如果该元素存在），...
ORDER BY子句
ORDER BY子句用于根据指定的列名对查询和分析结果进行排序。...查询和分析语句*|SELECT"content.time.request_time",count(*)AS count GROUP BY"content.time.request_time"ORDER BY"content.time.request_time"查询和分析结果
get_project_logs
time":"10:10:00"},{"_source_":"","_time_":"1","pv":"3056","time":"10:20:00"},{"_source_":"","_time_":"1","pv":"3316","time":"10:30:00"},{"_source_":"","_time_":"1","pv":"3300","time":"10:40:00"},{"_source_":"","_time_":"1...
Intel与AMD处理器实例性能测试
14.60%50th percentile service time term 7.13231 7.69349 0.56117 ms 7.87%90th percentile service time term 8.7835 16.1963 7.41283 ms 84.39%99th percentile service time term 11.7613 17.6558 5.89451 ms 50.12%100th percentile ...
alicloud_gpdb_db_instance_plan
in below.scale_out-(Optional,Set)Scale out instance plan config.See scale_out below.plan_config-resume The resume supports the following:execute_time-(Optional)The executed time of the Plan.plan_cron_time-(Optional)The ...
dbms_sql.add_trace
range} ERROR_CODE:0 REF_BY:SQL_TRACE(DEMAND)FIRST_LOAD_TIME:2022-11-07 19:17:21 LAST_HIT_TIME:2022-11-07 19:17:21 EXECUTIONS:1 SUM_WAIT_TIME:179 MIN_WAIT_TIME:179 MAX_WAIT_TIME:179 SUM_EXEC_TIME:438 MIN_EXEC_TIME:438 MAX_...
系统表
last_active_time 上次活跃时间。create_time 建立连接的时间。connection_id 连接ID。ip_port AnalyticDB for MySQL 接入层节点IP和端口号。access_ip 客户端IP。user 用户名。kepler_persist_plan_summary 用于查询配置过Hints的所有SQL ...
CommandBarControl
方法 CommandBars(CommandBarId).Controls.Item()单个定制元素，即具体到对应的自定义元素，我们可以获取该元素，从而控制该元素的标题、点击该元素等等。效果演示 新增 删除 语法 表达式.CommandBars(CommandBarId).Controls.Item(Index)...
SecretReport
free_ring_time":"2021-08-25 20:11:35","control_msg":"OK","id":101456851*,"secret_no":"186*7614","call_type":1,"control_type":"CONTINUE","release_time":"2021-08-25 20:11:41","pool_key":"FC10000009708*","sub_id":...
日志分析
and response_time>0|select case when response_time毫秒' when response_time>10 and response_time~100毫秒' when response_time>100 and response_time毫秒~1秒' when response_time>1000 and response_time秒~10秒' when response_...
alicloud_fnf_schedules
Specifies whether to enable the time-based schedule you want to create.flow_name-The name of the flow bound to the time-based schedule you want to create.id-The ID of the Schedule.last_modified_time-The time when the time-...
alicloud_hbr_restore_jobs
hash-The hashcode of Snapshot.restore_type-The type of recovery destination.Valid Values:ECS_FILE,OSS,NAS.create_time-The creation time of restore job.start_time-The start time of restore job.Unix Time in Seconds.updated_...
配置连接池实现熔断功能
usr/bin/env python3 import requests import time import sys from datetime import datetime import_thread def timedisplay(t):return t.strftime("%H:%M:%S")def get(url):try:stime=datetime.now()start=time.time()response=requests...
TimeStream API功能介绍
示例 请求示例 GET_time_stream/_stats 返回示例 {"_shards":{"total":4,"successful":4,"failed":0 },"time_stream_count":2,"indices_count":2,"total_store_size_bytes":1278822,"time_streams":[{"time_stream":"test_stream","indices...
日期和时间函数
CURRENT_TIME Synonyms for CURTIME()支持的语法：CURRENT_TIME，CURRENT_TIME()例子：SELECT CURRENT_TIME;SELECT CURRENT_TIME();CURTIME Returns the current date as a value in‘HH.MM.SS’.CURRENT_TIME and CURRENT_TIME()are ...
alicloud_hbr_nas_backup_plans
Whether to be suspended.Valid values:true,false.options-Options field of Nas backup plan.created_time-The creation time of the backup plan.UNIX time in seconds.updated_time-The update time of the backup plan.UNIX time in ...
get_log_all
[{"_source_":"","_time_":"1672905271","method":"HEAD","pv":"21"},{"_source_":"","_time_":"1672905271","method":"DELETE","pv":"502"},{"_source_":"","_time_":"1672905271","method":"PUT","pv":"1275"},{"_source_":"","_time_":...
角色SSO的SAML响应
本文为您介绍进行角色SSO时SAML响应中必须包含的元素，尤其是SAML断言中的元素。背景信息 在基于SAML 2.0的SSO流程中，当企业用户在IdP登录后，IdP将根据SAML 2.0 HTTP-POST绑定的要求生成包含SAML断言的认证响应，并由浏览器（或程序）...
时间字段转换示例
例如：把_time_转化成时间戳 把_time_以固定格式打印 把timestamp转化成指定格式 把_time_转化成时间戳 把字段_time_转化成时间戳格式，建议使用from_unixtime函数。更多信息，请参见 from_unixtime函数。select from_unixtime(_time_)把_...
时序补点函数
and Method:GetLogStoreLogs and ProjectName:lunar and LogStore:geos and Latency>800000|select series_padding(time,num,60,'zero')from(select_time_-_time_%60 as time,COUNT(*)*1.0 as num from log group by time order by time ...
- 产品推荐
- 这些文档可能帮助您