(root@nebula) [cmis_test]> EXPLAIN format="dot" match (v:email)-[:emailid]->(mid:id)<-[:phoneid]-(phone:phone)-[:phoneid]->(ids:id) with v, count(distinct phone) as pnum,count(distinct mid) as midnum,count(distinct ids) as idsnum , sum(ids.isblack) as black where pnum > 2 and midnum>5 and midnum < 100 and idsnum > 5 and idsnum < 300 and black > 0 return v.value1, true as result
Execution succeeded (time spent 1614/3030 us)
Execution Plan (optimize time 344 us)
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
plan
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
digraph exec_plan {
rankdir=BT;
"Project_32"[label="{Project_32|outputVar: \[\{\"colNames\":\[\"v.value1\",\"result\"\],\"name\":\"__Project_32\",\"type\":\"DATASET\"\}\]|inputVar: __Filter_31}", shape=Mrecord];
"Filter_31"->"Project_32";
"Filter_31"[label="{Filter_31|outputVar: \[\{\"colNames\":\[\"v\",\"pnum\",\"midnum\",\"idsnum\",\"black\"\],\"name\":\"__Filter_31\",\"type\":\"DATASET\"\}\]|inputVar: __Aggregate_30}", shape=Mrecord];
"Aggregate_30"->"Filter_31";
"Aggregate_30"[label="{Aggregate_30|outputVar: \[\{\"colNames\":\[\"v\",\"pnum\",\"midnum\",\"idsnum\",\"black\"\],\"name\":\"__Aggregate_30\",\"type\":\"DATASET\"\}\]|inputVar: __Filter_29}", shape=Mrecord];
"Filter_29"->"Aggregate_30";
"Filter_29"[label="{Filter_29|outputVar: \[\{\"colNames\":\[\"v\",\"mid\",\"phone\",\"ids\",\"__COL_0\"\],\"name\":\"__Filter_29\",\"type\":\"DATASET\"\}\]|inputVar: __Project_28}", shape=Mrecord];
"Project_28"->"Filter_29";
"Project_28"[label="{Project_28|outputVar: \[\{\"colNames\":\[\"v\",\"mid\",\"phone\",\"ids\",\"__COL_0\"\],\"name\":\"__Project_28\",\"type\":\"DATASET\"\}\]|inputVar: __InnerJoin_27}", shape=Mrecord];
"InnerJoin_27"->"Project_28";
"InnerJoin_27"[label="{InnerJoin_27|outputVar: \[\{\"colNames\":\[\"_path_0\",\"_path_1\",\"_path_2\",\"_path_3\"\],\"name\":\"__InnerJoin_27\",\"type\":\"DATASET\"\}\]|inputVar: \{\"rightVar\":\{\"__Project_26\":\"0\"\},\"leftVar\":\{\"__InnerJoin_21\":\"0\"\}\}}", shape=Mrecord];
"Project_26"->"InnerJoin_27";
"Project_26"[label="{Project_26|outputVar: \[\{\"colNames\":\[\"_path\"\],\"name\":\"__Project_26\",\"type\":\"DATASET\"\}\]|inputVar: __Filter_25}", shape=Mrecord];
"Filter_25"->"Project_26";
"Filter_25"[label="{Filter_25|outputVar: \[\{\"colNames\":\[\],\"name\":\"__Filter_25\",\"type\":\"DATASET\"\}\]|inputVar: __GetVertices_24}", shape=Mrecord];
"GetVertices_35"->"Filter_25";
"GetVertices_35"[label="{GetVertices_35|outputVar: \[\{\"colNames\":\[\],\"name\":\"__GetVertices_24\",\"type\":\"DATASET\"\}\]|inputVar: __InnerJoin_21}", shape=Mrecord];
"InnerJoin_21"->"GetVertices_35";
"InnerJoin_21"[label="{InnerJoin_21|outputVar: \[\{\"colNames\":\[\"_path_0\",\"_path_1\",\"_path_2\"\],\"name\":\"__InnerJoin_21\",\"type\":\"DATASET\"\}\]|inputVar: \{\"rightVar\":\{\"__Filter_20\":\"0\"\},\"leftVar\":\{\"__InnerJoin_14\":\"0\"\}\}}", shape=Mrecord];
"Filter_20"->"InnerJoin_21";
"Filter_20"[label="{Filter_20|outputVar: \[\{\"colNames\":\[\"_path\"\],\"name\":\"__Filter_20\",\"type\":\"DATASET\"\}\]|inputVar: __Project_19}", shape=Mrecord];
"Project_19"->"Filter_20";
"Project_19"[label="{Project_19|outputVar: \[\{\"colNames\":\[\"_path\"\],\"name\":\"__Project_19\",\"type\":\"DATASET\"\}\]|inputVar: __Filter_18}", shape=Mrecord];
"Filter_18"->"Project_19";
"Filter_18"[label="{Filter_18|outputVar: \[\{\"colNames\":\[\],\"name\":\"__Filter_18\",\"type\":\"DATASET\"\}\]|inputVar: __GetNeighbors_17}", shape=Mrecord];
"GetNeighbors_41"->"Filter_18";
"GetNeighbors_41"[label="{GetNeighbors_41|outputVar: \[\{\"colNames\":\[\],\"name\":\"__GetNeighbors_17\",\"type\":\"DATASET\"\}\]|inputVar: __InnerJoin_14}", shape=Mrecord];
"InnerJoin_14"->"GetNeighbors_41";
"InnerJoin_14"[label="{InnerJoin_14|outputVar: \[\{\"colNames\":\[\"_path_0\",\"_path_1\"\],\"name\":\"__InnerJoin_14\",\"type\":\"DATASET\"\}\]|inputVar: \{\"rightVar\":\{\"__Filter_13\":\"0\"\},\"leftVar\":\{\"__Filter_7\":\"0\"\}\}}", shape=Mrecord];
"Filter_13"->"InnerJoin_14";
"Filter_13"[label="{Filter_13|outputVar: \[\{\"colNames\":\[\"_path\"\],\"name\":\"__Filter_13\",\"type\":\"DATASET\"\}\]|inputVar: __Project_12}", shape=Mrecord];
"Project_12"->"Filter_13";
"Project_12"[label="{Project_12|outputVar: \[\{\"colNames\":\[\"_path\"\],\"name\":\"__Project_12\",\"type\":\"DATASET\"\}\]|inputVar: __Filter_11}", shape=Mrecord];
"Filter_11"->"Project_12";
"Filter_11"[label="{Filter_11|outputVar: \[\{\"colNames\":\[\],\"name\":\"__Filter_11\",\"type\":\"DATASET\"\}\]|inputVar: __GetNeighbors_10}", shape=Mrecord];
"GetNeighbors_40"->"Filter_11";
"GetNeighbors_40"[label="{GetNeighbors_40|outputVar: \[\{\"colNames\":\[\],\"name\":\"__GetNeighbors_10\",\"type\":\"DATASET\"\}\]|inputVar: __Filter_7}", shape=Mrecord];
"Filter_7"->"GetNeighbors_40";
"Filter_7"[label="{Filter_7|outputVar: \[\{\"colNames\":\[\"_path\"\],\"name\":\"__Filter_7\",\"type\":\"DATASET\"\}\]|inputVar: __Project_6}", shape=Mrecord];
"Project_6"->"Filter_7";
"Project_6"[label="{Project_6|outputVar: \[\{\"colNames\":\[\"_path\"\],\"name\":\"__Project_6\",\"type\":\"DATASET\"\}\]|inputVar: __Filter_5}", shape=Mrecord];
"Filter_5"->"Project_6";
"Filter_5"[label="{Filter_5|outputVar: \[\{\"colNames\":\[\],\"name\":\"__Filter_5\",\"type\":\"DATASET\"\}\]|inputVar: __GetNeighbors_4}", shape=Mrecord];
"GetNeighbors_39"->"Filter_5";
"GetNeighbors_39"[label="{GetNeighbors_39|outputVar: \[\{\"colNames\":\[\],\"name\":\"__GetNeighbors_4\",\"type\":\"DATASET\"\}\]|inputVar: __IndexScan_1}", shape=Mrecord];
"IndexScan_33"->"GetNeighbors_39";
"IndexScan_33"[label="{IndexScan_33|outputVar: \[\{\"colNames\":\[\"_vid\"\],\"name\":\"__IndexScan_1\",\"type\":\"DATASET\"\}\]|inputVar: }", shape=Mrecord];
"Start_0"->"IndexScan_33";
"Start_0"[label="{Start_0|outputVar: \[\{\"colNames\":\[\],\"name\":\"__Start_0\",\"type\":\"DATASET\"\}\]|inputVar: }", shape=Mrecord];
}
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Thu, 01 Apr 2021 19:50:22 CST