Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

PROFILE format= "dot" sentence miss the return profiling data #4163

Closed
whitewum opened this issue Apr 15, 2022 · 3 comments
Closed

PROFILE format= "dot" sentence miss the return profiling data #4163

whitewum opened this issue Apr 15, 2022 · 3 comments
Assignees
@yixinglu
Labels
affects/none PR/issue: this bug affects none version. process/done Process of bug severity/trivial Severity of bug type/bug/functionality Bugs preventing the database to deliver a promised function. type/bug Type: something is unexpected wontfix Solution: this will not be worked on recently
Milestone
v3.4.0

Comments

@whitewum
Copy link
Contributor

It returns exactly the same as EXPLAIN.
@whitewum whitewum added the type/feature req Type: feature request label Apr 15, 2022
@jamieliu1023 jamieliu1023 mentioned this issue Apr 16, 2022
Closed
@yixinglu yixinglu mentioned this issue Apr 18, 2022
Closed
@xtcyclist
Copy link
Contributor 

(root@nebula) [nba]> profile format = "dot" MATCH x =  (n0)-[e1]->(n1)-[e2]-(n0) WHERE id(n0) == "Hades" and id(n1) == "Hades" return e1, e2
+--------------------------------------------------------------------+--------------------------------------------------------------------+
| e1                                                                 | e2                                                                 |
+--------------------------------------------------------------------+--------------------------------------------------------------------+
| [:teammate "Hades"->"Hades" @0 {end_year: 3000, start_year: 3000}] | [:like "Hades"->"Hades" @0 {likeness: 3000}]                       |
| [:like "Hades"->"Hades" @0 {likeness: 3000}]                       | [:teammate "Hades"->"Hades" @0 {end_year: 3000, start_year: 3000}] |
+--------------------------------------------------------------------+--------------------------------------------------------------------+
Got 2 rows (time spent 6468/7110 us)

Execution Plan (optimize time 1929 us)

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  plan
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  digraph exec_plan {
      rankdir=BT;
      "Project_13"[label="{Project_13|outputVar: \{\"colNames\":\[\"e1\",\"e2\"\],\"name\":\"__Project_10\",\"type\":\"DATASET\"\}|inputVar: __Filter_11}", shape=Mrecord];
      "Filter_11"->"Project_13";
      "Filter_11"[label="{Filter_11|outputVar: \{\"colNames\":\[\"n0\",\"e1\",\"n1\",\"e2\",\"n0\"\],\"type\":\"DATASET\",\"name\":\"__Filter_11\"\}|inputVar: __AppendVertices_7}", shape=Mrecord];
      "AppendVertices_7"->"Filter_11";
      "AppendVertices_7"[label="{AppendVertices_7|outputVar: \{\"colNames\":\[\"n0\",\"e1\",\"n1\",\"e2\",\"n0\"\],\"name\":\"__AppendVertices_7\",\"type\":\"DATASET\"\}|inputVar: __Filter_6}", shape=Mrecord];
      "Filter_6"->"AppendVertices_7";
      "Filter_6"[label="{Filter_6|outputVar: \{\"colNames\":\[\"n0\",\"e1\",\"n1\",\"e2\"\],\"type\":\"DATASET\",\"name\":\"__Filter_6\"\}|inputVar: __Traverse_5}", shape=Mrecord];
      "Traverse_5"->"Filter_6";
      "Traverse_5"[label="{Traverse_5|outputVar: \{\"colNames\":\[\"n0\",\"e1\",\"n1\",\"e2\"\],\"name\":\"__Traverse_5\",\"type\":\"DATASET\"\}|inputVar: __Traverse_4}", shape=Mrecord];
      "Traverse_4"->"Traverse_5";
      "Traverse_4"[label="{Traverse_4|outputVar: \{\"colNames\":\[\"n0\",\"e1\"\],\"name\":\"__Traverse_4\",\"type\":\"DATASET\"\}|inputVar: __Dedup_2}", shape=Mrecord];
      "Dedup_2"->"Traverse_4";
      "Dedup_2"[label="{Dedup_2|outputVar: \{\"colNames\":\[\"_vid\"\],\"name\":\"__Dedup_2\",\"type\":\"DATASET\"\}|inputVar: __VAR_0}", shape=Mrecord];
      "PassThrough_1"->"Dedup_2";
      "PassThrough_1"[label="{PassThrough_1|outputVar: \{\"colNames\":\[\"_vid\"\],\"name\":\"__VAR_0\",\"type\":\"DATASET\"\}|inputVar: }", shape=Mrecord];
      "Start_3"->"PassThrough_1";
      "Start_3"[label="{Start_3|outputVar: \{\"colNames\":\[\],\"type\":\"DATASET\",\"name\":\"__Start_3\"\}|inputVar: }", shape=Mrecord];
  }
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Tue, 29 Nov 2022 14:05:33 CST

(root@nebula) [nba]> explain format = "dot" MATCH x =  (n0)-[e1]->(n1)-[e2]-(n0) WHERE id(n0) == "Hades" and id(n1) == "Hades" return e1, e2
Execution succeeded (time spent 3192/3716 us)

Execution Plan (optimize time 1929 us)

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  plan
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  digraph exec_plan {
      rankdir=BT;
      "Project_13"[label="{Project_13|outputVar: \{\"colNames\":\[\"e1\",\"e2\"\],\"name\":\"__Project_10\",\"type\":\"DATASET\"\}|inputVar: __Filter_11}", shape=Mrecord];
      "Filter_11"->"Project_13";
      "Filter_11"[label="{Filter_11|outputVar: \{\"colNames\":\[\"n0\",\"e1\",\"n1\",\"e2\",\"n0\"\],\"name\":\"__Filter_11\",\"type\":\"DATASET\"\}|inputVar: __AppendVertices_7}", shape=Mrecord];
      "AppendVertices_7"->"Filter_11";
      "AppendVertices_7"[label="{AppendVertices_7|outputVar: \{\"colNames\":\[\"n0\",\"e1\",\"n1\",\"e2\",\"n0\"\],\"type\":\"DATASET\",\"name\":\"__AppendVertices_7\"\}|inputVar: __Filter_6}", shape=Mrecord];
      "Filter_6"->"AppendVertices_7";
      "Filter_6"[label="{Filter_6|outputVar: \{\"colNames\":\[\"n0\",\"e1\",\"n1\",\"e2\"\],\"name\":\"__Filter_6\",\"type\":\"DATASET\"\}|inputVar: __Traverse_5}", shape=Mrecord];
      "Traverse_5"->"Filter_6";
      "Traverse_5"[label="{Traverse_5|outputVar: \{\"colNames\":\[\"n0\",\"e1\",\"n1\",\"e2\"\],\"type\":\"DATASET\",\"name\":\"__Traverse_5\"\}|inputVar: __Traverse_4}", shape=Mrecord];
      "Traverse_4"->"Traverse_5";
      "Traverse_4"[label="{Traverse_4|outputVar: \{\"colNames\":\[\"n0\",\"e1\"\],\"name\":\"__Traverse_4\",\"type\":\"DATASET\"\}|inputVar: __Dedup_2}", shape=Mrecord];
      "Dedup_2"->"Traverse_4";
      "Dedup_2"[label="{Dedup_2|outputVar: \{\"colNames\":\[\"_vid\"\],\"type\":\"DATASET\",\"name\":\"__Dedup_2\"\}|inputVar: __VAR_0}", shape=Mrecord];
      "PassThrough_1"->"Dedup_2";
      "PassThrough_1"[label="{PassThrough_1|outputVar: \{\"colNames\":\[\"_vid\"\],\"type\":\"DATASET\",\"name\":\"__VAR_0\"\}|inputVar: }", shape=Mrecord];
      "Start_3"->"PassThrough_1";
      "Start_3"[label="{Start_3|outputVar: \{\"colNames\":\[\],\"name\":\"__Start_3\",\"type\":\"DATASET\"\}|inputVar: }", shape=Mrecord];
  }
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

@xtcyclist
Copy link
Contributor

This is an open bug. Need to be fixed.

@xtcyclist xtcyclist added type/bug Type: something is unexpected type/bug/functionality Bugs preventing the database to deliver a promised function. and removed type/feature req Type: feature request labels Nov 29, 2022
@github-actions github-actions bot removed the type/bug Type: something is unexpected label Nov 29, 2022
@xtcyclist
Copy link
Contributor

xtcyclist commented Nov 29, 2022 •
edited
Loading

vesoft-inc/nebula-go#192 This pr has not been merged.

Checked. It's not addressing this issue.

@xtcyclist xtcyclist added type/bug Type: something is unexpected severity/trivial Severity of bug labels Nov 29, 2022
@Sophie-Xie Sophie-Xie added this to the v3.4.0 milestone Dec 2, 2022
@xtcyclist xtcyclist added the wontfix Solution: this will not be worked on recently label Dec 15, 2022
@github-actions github-actions bot added the affects/none PR/issue: this bug affects none version. label Dec 15, 2022
@github-actions github-actions bot added the process/fixed Process of bug label Dec 26, 2022
@wey-gu wey-gu mentioned this issue Dec 31, 2022
Closed
@Hester-Gu Hester-Gu added the process/done Process of bug label Jan 13, 2023
@github-actions github-actions bot removed the process/fixed Process of bug label Jan 13, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@yixinglu yixinglu

Labels
affects/none PR/issue: this bug affects none version. process/done Process of bug severity/trivial Severity of bug type/bug/functionality Bugs preventing the database to deliver a promised function. type/bug Type: something is unexpected wontfix Solution: this will not be worked on recently
Projects
None yet
Milestone
v3.4.0
Development

Successfully merging a pull request may close this issue.

Generate graphviz string by go-graphviz library yixinglu/nebula-go
5 participants
@yixinglu @xtcyclist @Hester-Gu @whitewum @Sophie-Xie