tag的索引如下
查询语句
lookup on logic_device_port where logic_device_port.logic == "xxx" and logic_device_port.pod == "xx" and logic_device_port.region == "xx" yield id(vertex) as Vid | go from $-.Vid over edge_special_line yield $-.Vid as srcVid,properties($^) as srcInfo,properties(edge) as e,id($$) as dstVid,properties($$) as dstInfo
语句2
profile format="row" lookup on logic_device_port where logic_device_port.logic == "xxx" and logic_device_port.pod == "xx" and logic_device_port.region == "xx" yield id(vertex) as Vid | go from $-.Vid over edge_special_line yield $-.Vid as srcVid,properties($^) as srcInfo,properties(edge) as e,id($$) as dstVid,properties($$) as dstInfo
-----+--------------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------
| id | name | dependencies | profiling data | operator info |
-----+--------------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------
| 12 | Project | 11 | { | outputVar: { |
| | | | "execTime": "6443(us)", | "colNames": [ |
| | | | "rows": 512, | "srcVid", |
| | | | "totalTime": "6446(us)", | "srcInfo", |
| | | | "version": 0 | "e", |
| | | | } | "dstVid", |
| | | | | "dstInfo" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Project_12" |
| | | | | } |
| | | | | inputVar: __InnerJoin_11 |
| | | | | columns: [ |
| | | | | "$Vid AS srcVid", |
| | | | | "properties($^) AS srcInfo", |
| | | | | "properties(EDGE) AS e", |
| | | | | "$__COL_0 AS dstVid", |
| | | | | "properties($$) AS dstInfo" |
| | | | | ] |
-----+--------------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------
| 11 | InnerJoin | 10 | { | outputVar: { |
| | | | "execTime": "1764(us)", | "colNames": [ |
| | | | "rows": 512, | "$^", |
| | | | "totalTime": "1767(us)", | "EDGE", |
| | | | "version": 0 | "__COL_0", |
| | | | } | "_vid", |
| | | | | "JOIN_DST_VID", |
| | | | | "$$", |
| | | | | "DST_VID", |
| | | | | "Vid" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__InnerJoin_11" |
| | | | | } |
| | | | | inputVar: { |
| | | | | "rightVar": { |
| | | | | "__Project_3": 0 |
| | | | | }, |
| | | | | "leftVar": { |
| | | | | "__LeftJoin_10": 0 |
| | | | | } |
| | | | | } |
| | | | | hashKeys: [ |
| | | | | "$__LeftJoin_10._vid" |
| | | | | ] |
| | | | | probeKeys: [ |
| | | | | "$-.Vid" |
| | | | | ] |
| | | | | kind: InnerJoin |
-----+--------------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------
| 10 | LeftJoin | 9 | { | outputVar: { |
| | | | "execTime": "998(us)", | "colNames": [ |
| | | | "rows": 512, | "$^", |
| | | | "totalTime": "1003(us)", | "EDGE", |
| | | | "version": 0 | "__COL_0", |
| | | | } | "_vid", |
| | | | | "JOIN_DST_VID", |
| | | | | "$$", |
| | | | | "DST_VID" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__LeftJoin_10" |
| | | | | } |
| | | | | inputVar: { |
| | | | | "rightVar": { |
| | | | | "__Project_9": 0 |
| | | | | }, |
| | | | | "leftVar": { |
| | | | | "__Project_7": 0 |
| | | | | } |
| | | | | } |
| | | | | hashKeys: [ |
| | | | | "COLUMN[-1]" |
| | | | | ] |
| | | | | probeKeys: [ |
| | | | | "COLUMN[-1]" |
| | | | | ] |
| | | | | kind: LeftJoin |
-----+--------------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------
| 9 | Project | 8 | { | outputVar: { |
| | | | "execTime": "3637(us)", | "colNames": [ |
| | | | "rows": 512, | "$$", |
| | | | "totalTime": "3640(us)", | "DST_VID" |
| | | | "version": 0 | ], |
| | | | } | "type": "DATASET", |
| | | | | "name": "__Project_9" |
| | | | | } |
| | | | | inputVar: __GetVertices_8 |
| | | | | columns: [ |
| | | | | "$$ AS $$", |
| | | | | "COLUMN[0] AS DST_VID" |
| | | | | ] |
-----+--------------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------
| 8 | GetVertices | 7 | { | outputVar: { |
| | | | "execTime": "2216(us)", | "colNames": [], |
| | | | "resp[0]": { | "type": "DATASET", |
| | | | "exec": "3001(us)", | "name": "__GetVertices_8" |
| | | | "host": "11.97.22.167:9779", | } |
| | | | "total": "5466(us)" | inputVar: __Project_7 |
| | | | }, | space: 5 |
| | | | "resp[1]": { | dedup: true |
| | | | "exec": "1892(us)", | limit: 9223372036854775807 |
| | | | "host": "11.97.22.67:9779", | filter: |
| | | | "total": "3114(us)" | orderBy: [] |
| | | | }, | src: COLUMN[-1] |
| | | | "resp[2]": { | props: [ |
| | | | "exec": "3849(us)", | { |
| | | | "host": "11.97.22.76:9779", | "props": [ |
| | | | "total": "6646(us)" | "_tag", |
| | | | }, | "c_time", |
| | | | "rows": 512, | "d_time", |
| | | | "totalTime": "8575(us)", | "dev_type", |
| | | | "total_rpc": "7819(us)", | "flag", |
| | | | "version": 0 | "mac", |
| | | | } | "mode", |
| | | | | "server_ip", |
| | | | | "status", |
| | | | | "u_time" |
| | | | | ], |
| | | | | "tagId": 57 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag", |
| | | | | "c_time", |
| | | | | "id", |
| | | | | "name", |
| | | | | "uuid" |
| | | | | ], |
| | | | | "tagId": 26 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag", |
| | | | | "c_time", |
| | | | | "d_time", |
| | | | | "dev_ip", |
| | | | | "manufacture_date", |
| | | | | "mode", |
| | | | | "slot", |
| | | | | "slot_type", |
| | | | | "stack_no", |
| | | | | "status", |
| | | | | "u_time", |
| | | | | "unit_type" |
| | | | | ], |
| | | | | "tagId": 12 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag", |
| | | | | "admin_status", |
| | | | | "c_time", |
| | | | | "d_time", |
| | | | | "dev_ip", |
| | | | | "ipv4", |
| | | | | "ipv6", |
| | | | | "mode", |
| | | | | "name", |
| | | | | "operation_status", |
| | | | | "speed", |
| | | | | "status", |
| | | | | "u_time" |
| | | | | ], |
| | | | | "tagId": 78 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag", |
| | | | | "c_time", |
| | | | | "id", |
| | | | | "name", |
| | | | | "uuid" |
| | | | | ], |
| | | | | "tagId": 27 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag", |
| | | | | "building", |
| | | | | "c_time", |
| | | | | "d_time", |
| | | | | "dev_ip", |
| | | | | "group", |
| | | | | "isp", |
| | | | | "isp_type", |
| | | | | "logic", |
| | | | | "mode", |
| | | | | "pod", |
| | | | | "port", |
| | | | | "region", |
| | | | | "role", |
| | | | | "status", |
| | | | | "u_time" |
| | | | | ], |
| | | | | "tagId": 72 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag", |
| | | | | "c_time", |
| | | | | "id", |
| | | | | "name", |
| | | | | "uuid" |
| | | | | ], |
| | | | | "tagId": 28 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag", |
| | | | | "c_time", |
| | | | | "d_time", |
| | | | | "datacenter_name", |
| | | | | "logic_name", |
| | | | | "mode", |
| | | | | "pod", |
| | | | | "role", |
| | | | | "sn", |
| | | | | "status", |
| | | | | "u_time", |
| | | | | "unit_type" |
| | | | | ], |
| | | | | "tagId": 76 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag", |
| | | | | "c_time", |
| | | | | "d_time", |
| | | | | "dev_ip", |
| | | | | "mode", |
| | | | | "name", |
| | | | | "status", |
| | | | | "u_time" |
| | | | | ], |
| | | | | "tagId": 14 |
| | | | | } |
| | | | | ] |
| | | | | exprs: |
-----+--------------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------
| 7 | Project | 15 | { | outputVar: { |
| | | | "execTime": "11233(us)", | "colNames": [ |
| | | | "rows": 512, | "$^", |
| | | | "totalTime": "11241(us)", | "EDGE", |
| | | | "version": 0 | "__COL_0", |
| | | | } | "_vid", |
| | | | | "JOIN_DST_VID" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Project_7" |
| | | | | } |
| | | | | inputVar: __GetNeighbors_6 |
| | | | | columns: [ |
| | | | | "$^ AS $^", |
| | | | | "EDGE AS EDGE", |
| | | | | "*._dst AS __COL_0", |
| | | | | "COLUMN[0] AS _vid", |
| | | | | "*._dst AS JOIN_DST_VID" |
| | | | | ] |
-----+--------------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------
| 15 | GetNeighbors | 3 | { | outputVar: { |
| | | | "execTime": "3140(us)", | "colNames": [], |
| | | | "resp[0]": { | "type": "DATASET", |
| | | | "exec": "23724(us)", | "name": "__GetNeighbors_6" |
| | | | "host": "11.97.22.67:9779", | } |
| | | | "storage_detail": { | inputVar: __Project_3 |
| | | | "GetNeighborsNode": "22900(us)", | space: 5 |
| | | | "HashJoinNode": "21910(us)", | dedup: true |
| | | | "RelNode": "22917(us)", | limit: -1 |
| | | | "SingleEdgeNode": "4232(us)", | filter: |
| | | | "TagNode": "16214(us)" | orderBy: [] |
| | | | }, | src: $-.Vid |
| | | | "total": "26781(us)", | edgeTypes: [] |
| | | | "vertices": 232 | edgeDirection: OUT_EDGE |
| | | | }, | vertexProps: [ |
| | | | "resp[1]": { | { |
| | | | "exec": "34622(us)", | "props": [ |
| | | | "host": "11.97.22.167:9779", | "_tag", |
| | | | "storage_detail": { | "c_time", |
| | | | "GetNeighborsNode": "256473(us)", | "d_time", |
| | | | "HashJoinNode": "244283(us)", | "dev_type", |
| | | | "RelNode": "256788(us)", | "flag", |
| | | | "SingleEdgeNode": "57225(us)", | "mac", |
| | | | "TagNode": "168893(us)" | "mode", |
| | | | }, | "server_ip", |
| | | | "total": "48760(us)", | "status", |
| | | | "vertices": 2460 | "u_time" |
| | | | }, | ], |
| | | | "resp[2]": { | "tagId": 57 |
| | | | "exec": "30573(us)", | }, |
| | | | "host": "11.97.22.76:9779", | { |
| | | | "storage_detail": { | "props": [ |
| | | | "GetNeighborsNode": "285285(us)", | "_tag", |
| | | | "HashJoinNode": "271396(us)", | "c_time", |
| | | | "RelNode": "285691(us)", | "id", |
| | | | "SingleEdgeNode": "55041(us)", | "name", |
| | | | "TagNode": "196962(us)" | "uuid" |
| | | | }, | ], |
| | | | "total": "46456(us)", | "tagId": 26 |
| | | | "vertices": 2748 | }, |
| | | | }, | { |
| | | | "rows": 512, | "props": [ |
| | | | "totalTime": "55436(us)", | "_tag", |
| | | | "total_rpc_time": "52277(us)", | "c_time", |
| | | | "version": 0 | "d_time", |
| | | | } | "dev_ip", |
| | | | | "manufacture_date", |
| | | | | "mode", |
| | | | | "slot", |
| | | | | "slot_type", |
| | | | | "stack_no", |
| | | | | "status", |
| | | | | "u_time", |
| | | | | "unit_type" |
| | | | | ], |
| | | | | "tagId": 12 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag", |
| | | | | "admin_status", |
| | | | | "c_time", |
| | | | | "d_time", |
| | | | | "dev_ip", |
| | | | | "ipv4", |
| | | | | "ipv6", |
| | | | | "mode", |
| | | | | "name", |
| | | | | "operation_status", |
| | | | | "speed", |
| | | | | "status", |
| | | | | "u_time" |
| | | | | ], |
| | | | | "tagId": 78 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag", |
| | | | | "c_time", |
| | | | | "id", |
| | | | | "name", |
| | | | | "uuid" |
| | | | | ], |
| | | | | "tagId": 27 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag", |
| | | | | "building", |
| | | | | "c_time", |
| | | | | "d_time", |
| | | | | "dev_ip", |
| | | | | "group", |
| | | | | "isp", |
| | | | | "isp_type", |
| | | | | "logic", |
| | | | | "mode", |
| | | | | "pod", |
| | | | | "port", |
| | | | | "region", |
| | | | | "role", |
| | | | | "status", |
| | | | | "u_time" |
| | | | | ], |
| | | | | "tagId": 72 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag", |
| | | | | "c_time", |
| | | | | "id", |
| | | | | "name", |
| | | | | "uuid" |
| | | | | ], |
| | | | | "tagId": 28 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag", |
| | | | | "c_time", |
| | | | | "d_time", |
| | | | | "datacenter_name", |
| | | | | "logic_name", |
| | | | | "mode", |
| | | | | "pod", |
| | | | | "role", |
| | | | | "sn", |
| | | | | "status", |
| | | | | "u_time", |
| | | | | "unit_type" |
| | | | | ], |
| | | | | "tagId": 76 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag", |
| | | | | "c_time", |
| | | | | "d_time", |
| | | | | "dev_ip", |
| | | | | "mode", |
| | | | | "name", |
| | | | | "status", |
| | | | | "u_time" |
| | | | | ], |
| | | | | "tagId": 14 |
| | | | | } |
| | | | | ] |
| | | | | edgeProps: [ |
| | | | | { |
| | | | | "props": [ |
| | | | | "_dst", |
| | | | | "_rank", |
| | | | | "_src", |
| | | | | "_type", |
| | | | | "c_time", |
| | | | | "cn_name", |
| | | | | "d_time", |
| | | | | "mode", |
| | | | | "name", |
| | | | | "special_line", |
| | | | | "speed", |
| | | | | "status", |
| | | | | "u_time" |
| | | | | ], |
| | | | | "type": 74 |
| | | | | } |
| | | | | ] |
| | | | | statProps: |
| | | | | exprs: |
| | | | | random: false |
-----+--------------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------
| 3 | Project | 13 | { | outputVar: { |
| | | | "execTime": "26592(us)", | "colNames": [ |
| | | | "rows": 5440, | "Vid" |
| | | | "totalTime": "26601(us)", | ], |
| | | | "version": 0 | "type": "DATASET", |
| | | | } | "name": "__Project_3" |
| | | | | } |
| | | | | inputVar: __Filter_2 |
| | | | | columns: [ |
| | | | | "id(VERTEX) AS Vid" |
| | | | | ] |
-----+--------------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------
| 13 | TagIndexPrefixScan | 0 | { | outputVar: { |
| | | | "execTime": "0(us)", | "colNames": [ |
| | | | "resp[0]": { | "_vid", |
| | | | "exec": "10183(us)", | "logic_device_port._tag", |
| | | | "host": "11.97.22.76:9779", | "logic_device_port.building", |
| | | | "storage_detail": { | "logic_device_port.c_time", |
| | | | "IndexLimitNode(limit=9223372036854775807)": "67134(us)", | "logic_device_port.d_time", |
| | | | "IndexProjectionNode(projectColumn=[_vid,_tag,building,c_time,d_time,dev_ip,group,isp,isp_type,logic,mode,pod,port,region,role,status,u_time])": "66616(us)", | "logic_device_port.dev_ip", |
| | | | "IndexVertexScanNode(IndexID=73, Path=(region=\"华北\", logic=\"廊坊_京东_润惠商城机房\", pod=\"POD001\", ))": "65698(us)" | "logic_device_port.group", |
| | | | }, | "logic_device_port.isp", |
| | | | "total": "21050(us)" | "logic_device_port.isp_type", |
| | | | }, | "logic_device_port.logic", |
| | | | "resp[1]": { | "logic_device_port.mode", |
| | | | "exec": "4715(us)", | "logic_device_port.pod", |
| | | | "host": "11.97.22.67:9779", | "logic_device_port.port", |
| | | | "storage_detail": { | "logic_device_port.region", |
| | | | "IndexLimitNode(limit=9223372036854775807)": "3828(us)", | "logic_device_port.role", |
| | | | "IndexProjectionNode(projectColumn=[_vid,_tag,building,c_time,d_time,dev_ip,group,isp,isp_type,logic,mode,pod,port,region,role,status,u_time])": "3837(us)", | "logic_device_port.status", |
| | | | "IndexVertexScanNode(IndexID=73, Path=(region=\"华北\", logic=\"廊坊_京东_润惠商城机房\", pod=\"POD001\", ))": "3835(us)" | "logic_device_port.u_time" |
| | | | }, | ], |
| | | | "total": "6863(us)" | "type": "DATASET", |
| | | | }, | "name": "__Filter_2" |
| | | | "resp[2]": { | } |
| | | | "exec": "11221(us)", | inputVar: |
| | | | "host": "11.97.22.167:9779", | space: 5 |
| | | | "storage_detail": { | dedup: false |
| | | | "IndexLimitNode(limit=9223372036854775807)": "63485(us)", | limit: 9223372036854775807 |
| | | | "IndexProjectionNode(projectColumn=[_vid,_tag,building,c_time,d_time,dev_ip,group,isp,isp_type,logic,mode,pod,port,region,role,status,u_time])": "63456(us)", | filter: |
| | | | "IndexVertexScanNode(IndexID=73, Path=(region=\"华北\", logic=\"廊坊_京东_润惠商城机房\", pod=\"POD001\", ))": "63037(us)" | orderBy: [] |
| | | | }, | schemaId: 72 |
| | | | "total": "20611(us)" | isEdge: false |
| | | | }, | returnCols: [ |
| | | | "rows": 5440, | "_vid", |
| | | | "totalTime": "28924(us)", | "_tag", |
| | | | "version": 0 | "building", |
| | | | } | "c_time", |
| | | | | "d_time", |
| | | | | "dev_ip", |
| | | | | "group", |
| | | | | "isp", |
| | | | | "isp_type", |
| | | | | "logic", |
| | | | | "mode", |
| | | | | "pod", |
| | | | | "port", |
| | | | | "region", |
| | | | | "role", |
| | | | | "status", |
| | | | | "u_time" |
| | | | | ] |
| | | | | indexCtx: [ |
| | | | | { |
| | | | | "columnHints": [ |
| | | | | { |
| | | | | "includeEnd": false, |
| | | | | "includeBegin": true, |
| | | | | "endValue": "__EMPTY__", |
| | | | | "beginValue": "华北", |
| | | | | "scanType": "PREFIX", |
| | | | | "column": "region" |
| | | | | }, |
| | | | | { |
| | | | | "includeEnd": false, |
| | | | | "includeBegin": true, |
| | | | | "endValue": "__EMPTY__", |
| | | | | "beginValue": "廊坊_京东_润惠商城机房", |
| | | | | "scanType": "PREFIX", |
| | | | | "column": "logic" |
| | | | | }, |
| | | | | { |
| | | | | "includeEnd": false, |
| | | | | "includeBegin": true, |
| | | | | "endValue": "__EMPTY__", |
| | | | | "beginValue": "POD001", |
| | | | | "scanType": "PREFIX", |
| | | | | "column": "pod" |
| | | | | } |
| | | | | ], |
| | | | | "filter": "", |
| | | | | "index_id": 73 |
| | | | | } |
| | | | | ] |
-----+--------------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------
| 0 | Start | | { | outputVar: { |
| | | | "execTime": "0(us)", | "colNames": [], |
| | | | "rows": 0, | "type": "DATASET", |
| | | | "totalTime": "30(us)", | "name": "__Start_0" |
| | | | "version": 0 | } |
| | | | } | |
-----+--------------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------
Fri, 22 Mar 2024 17:04:19 CST
111
我看了下你的执行计划里的东西，filter 是为空的，应该是没有相关的下推计算。
没有的 我就是这条语句要查出来东西 其余的都是数据处理计算 ，不涉及nebula的
您这个执行计划是执行了15s的那个吗？看profile这个算子的时间远小于15s啊，另外看到执行计划中有TagIndexPrefixScan，索引应该是生效了
此话题已在最后回复的 30 天后被自动关闭。不再允许新回复。