API tools faq
paste
Advertisement
Guest User

Vertica Concurrency

a guest
Nov 27th, 2014
135
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 7.78 KB | None | 0 0
raw download clone embed print report
  1.  
  2. ------------------------------
  3.  QUERY PLAN DESCRIPTION:
  4.  ------------------------------
  5.  
  6.  Opt Vertica Options
  7.  --------------------
  8.  PLAN_OUTPUT_SUPER_VERBOSE
  9.  
  10.  
  11.  EXPLAIN VERBOSE SELECT account_id, name FROM account WHERE state = 1;
  12.  
  13.  Access Path:
  14.  Sort KEY: (account.account_id, account.name, account.currency_code, account.time_zone)
  15.   LDISTRIB_SEGMENTED
  16.  +-STORAGE ACCESS FOR account [Cost: 52.000000, ROWS: 46.000000 Disk(B): 0.000000 CPU(B): 0.000000 Memory(B): 0.000000 Netwrk(B): 0.000000 Parallelism: 1.000000] [OutRowSz (B): 271] (PATH ID: 1)
  17.  |  COLUMN Cost Aspects: [ Disk(B): 196608.000000 CPU(B): 65536.000000 Memory(B): 12522.000000 Netwrk(B): 0.000000 Parallelism: 1.000000 ]
  18.  |  Projection: public.account_tmp_super
  19.  |  Materialize: account.account_id, account.name
  20.  |  FILTER: (account.state = 1)/* sel=0.867925 ndv= 1 */
  21.  |  Sort KEY: (account.account_id, account.name, account.currency_code, account.time_zone)
  22.  |  LDISTRIB_SEGMENTED
  23.  
  24.  
  25.  ------------------------------
  26.  -----------------------------------------------
  27.  Plan Extras
  28.  -----------------------------------------------
  29.  
  30.  
  31.  digraph G {
  32.  graph [rankdir=BT, label = "JoinGraph(Base)", labelloc=t, labeljust=l ]
  33.  node140389674934528_0[label = "node 0 account (public.account)\noid 45035996277504710 varno = 1\npreds: \n(account.state = 1)", color = "black"];
  34.  }
  35.  
  36.  TABLE Name -> JoinGraph Node Mappings:
  37.  public.account: Node 0(JoinGraph ID: 1)
  38.  
  39.  JOIN Descriptions:
  40.  
  41.  
  42.  Projections chosen FOR TABLES:
  43.        public.account: account_tmp_super
  44.  
  45.  Simplified JOIN ORDER:
  46.  -----------------------
  47. digraph G {
  48.  graph [label = "Simplified Join Order: \n(1,0) [account] --> account_tmp_super for public.account\n", labelloc=t, labeljust=l ]
  49.  0[shape = "record" label = "SELECT"];
  50.  0->1 [label = "" color = "black" ];
  51.  1[shape = "record" label = "P(1,0)"];
  52.  }
  53.  
  54.  
  55.  
  56.  -----------------------------------------------
  57.  PLAN: BASE QUERY PLAN (GraphViz Format)
  58.  -----------------------------------------------
  59.  digraph G {
  60.  graph [rankdir=BT, label = "BASE QUERY PLAN\nQuery: EXPLAIN VERBOSE SELECT account_id, name FROM account WHERE state = 1;\n\nAll Nodes Vector: \n\n  node[0]=v_biddy_node0001 (initiator) Up\n", labelloc=t, labeljust=l ordering=OUT]
  61.  0[label = "Root \nNode Set: [Name: v_biddy_node0001 , index: 0 , (initiator))]\nNode ID: 0", color = "green", shape = "house"];
  62.  1[label = "NewEENode \nOutBlk=[UncTuple<int, varchar(255).255>]\nNode Set: [Name: v_biddy_node0001 , index: 0 , (initiator))]\nNode ID: 0", color = "green", shape = "box"];
  63.  2[label = "StorageUnionStep: account_tmp_super\nstartEpoch 0\nendEpoch 70065\nthreads 8\nnodeSet: [0] \n[Local Segmented Properties: UNSEGMENTED]\nUnc: account.account_id[1,1] - Integer(8)\nUnc: account.name[1,3] - Varchar(255)", color = "purple", shape = "box"];
  64.  3[label = "ScanStep: account_tmp_super\n(account.state = 1)\nVALINDEX[0]\nstartEpoch 0\nendEpoch 70065\naccount_id\nstate (not emitted)\nname\nnodeSet: [0] \n[Local Segmented Properties: SEGMENTED]\nUnc: account_id[1,1] - Integer(8)\nUnc: name[1,3] - Varchar(255)", color = "brown", shape = "box"];
  65.  1->0 [label = "V[0] S=0, D=0",color = "black"];
  66.  1->0 [label = "V[0] S=1, D=1",color = "black"];
  67.  2->1 [label = "0",color = "blue"];
  68.  3->2 [label = "0",color = "blue"];
  69.  }
  70.  Estimated resources FOR plan:
  71.  -----------------------------
  72.  Scratch Memory MB: 28
  73.  File Handles:      48
  74.  Worker Threads:    12
  75.  Blocking Threads:  0
  76.  Externalizing Ops: 0
  77.  Unbounded Mem Ops: 0
  78.  MAX Threads:     8
  79.  
  80.  Extra Memory Reservation MB 0
  81.  -----------------------------
  82.  -----------------------------------------------
  83.  PLAN:  ANNOTATED BY DISTRIBUTOR  (GraphViz Format)
  84.  -----------------------------------------------
  85.  digraph G {
  86.  graph [rankdir=BT, label = " ANNOTATED BY DISTRIBUTOR \n", labelloc=t, labeljust=l ordering=OUT]
  87.  0[label = "Root \nOutBlk=[UncTuple<int, varchar(255).255>]\nNode Set: [Name: v_biddy_node0001 , index: 0 , (initiator))]\nNode ID: 0", color = "green", shape = "house"];
  88.  1[label = "NewEENode \nOutBlk=[UncTuple<int, varchar(255).255>]\nNode Set: [Name: v_biddy_node0001 , index: 0 , (initiator))]\nNode ID: 0", color = "green", shape = "box"];
  89.  2[label = "StorageUnionStep: account_tmp_super\nstartEpoch 0\nendEpoch 70065\nthreads 8\nnodeSet: [0] \n[Local Segmented Properties: UNSEGMENTED]\nUnc: account.account_id[1,1] - Integer(8)\nUnc: account.name[1,3] - Varchar(255)", color = "purple", shape = "box"];
  90.  3[label = "ScanStep: account_tmp_super\n(account.state = 1)\nVALINDEX[0]\nstartEpoch 0\nendEpoch 70065\naccount_id\nstate (not emitted)\nname\nnodeSet: [0] \n[Local Segmented Properties: SEGMENTED]\nUnc: account_id[1,1] - Integer(8)\nUnc: name[1,3] - Varchar(255)", color = "brown", shape = "box"];
  91.  1->0 [label = "V[0] S=0, D=0",color = "black"];
  92.  1->0 [label = "V[0] S=1, D=1",color = "black"];
  93.  2->1 [label = "0",color = "blue"];
  94.  3->2 [label = "0",color = "blue"];
  95.  }
  96. 0[label = "Root \nNode Set: [Name: v_biddy_node0001 , index: 0 , (initiator))]\nNode ID: 0", color = "green", shape = "house"];
  97.  1[label = "NewEENode \nOutBlk=[UncTuple<int, varchar(255).255>]\nNode Set: [Name: v_biddy_node0001 , index: 0 , (initiator))]\nNode ID: 0", color = "green", shape = "box"];
  98.  2[label = "StorageUnionStep: account_tmp_super\nstartEpoch 0\nendEpoch 70065\nthreads 8\nnodeSet: [0] \n[Local Segmented Properties: UNSEGMENTED]\nUnc: account.account_id[1,1] - Integer(8)\nUnc: account.name[1,3] - Varchar(255)", color = "purple", shape = "box"];
  99.  3[label = "ScanStep: account_tmp_super\n(account.state = 1)\nVALINDEX[0]\nstartEpoch 0\nendEpoch 70065\naccount_id\nstate (not emitted)\nname\nnodeSet: [0] \n[Local Segmented Properties: SEGMENTED]\nUnc: account_id[1,1] - Integer(8)\nUnc: name[1,3] - Varchar(255)", color = "brown", shape = "box"];
  100.  1->0 [label = "V[0] S=0, D=0",color = "black"];
  101.  1->0 [label = "V[0] S=1, D=1",color = "black"];
  102.  2->1 [label = "0",color = "blue"];
  103.  3->2 [label = "0",color = "blue"];
  104.  }
  105.  Estimated resources FOR plan:
  106.  -----------------------------
  107.  Scratch Memory MB: 28
  108.  File Handles:      48
  109.  Worker Threads:    12
  110.  Blocking Threads:  0
  111.  Externalizing Ops: 0
  112.  Unbounded Mem Ops: 0
  113.  MAX Threads:     8
  114.  
  115.  Extra Memory Reservation MB 0
  116.  -----------------------------
  117.  -----------------------------------------------
  118.  PLAN:  ANNOTATED BY DISTRIBUTOR  (GraphViz Format)
  119.  -----------------------------------------------
  120.  digraph G {
  121.  graph [rankdir=BT, label = " ANNOTATED BY DISTRIBUTOR \n", labelloc=t, labeljust=l ordering=OUT]
  122.  0[label = "Root \nOutBlk=[UncTuple<int, varchar(255).255>]\nNode Set: [Name: v_biddy_node0001 , index: 0 , (initiator))]\nNode ID: 0", color = "green", shape = "house"];
  123.  1[label = "NewEENode \nOutBlk=[UncTuple<int, varchar(255).255>]\nNode Set: [Name: v_biddy_node0001 , index: 0 , (initiator))]\nNode ID: 0", color = "green", shape = "box"];
  124.  2[label = "StorageUnionStep: account_tmp_super\nstartEpoch 0\nendEpoch 70065\nthreads 8\nnodeSet: [0] \n[Local Segmented Properties: UNSEGMENTED]\nUnc: account.account_id[1,1] - Integer(8)\nUnc: account.name[1,3] - Varchar(255)", color = "purple", shape = "box"];
  125.  3[label = "ScanStep: account_tmp_super\n(account.state = 1)\nVALINDEX[0]\nstartEpoch 0\nendEpoch 70065\naccount_id\nstate (not emitted)\nname\nnodeSet: [0] \n[Local Segmented Properties: SEGMENTED]\nUnc: account_id[1,1] - Integer(8)\nUnc: name[1,3] - Varchar(255)", color = "brown", shape = "box"];
  126.  1->0 [label = "V[0] S=0, D=0",color = "black"];
  127.  1->0 [label = "V[0] S=1, D=1",color = "black"];
  128.  2->1 [label = "0",color = "blue"];
  129.  3->2 [label = "0",color = "blue"];
  130.  }
  131.  Estimated resources FOR plan:
  132.  -----------------------------
  133.  Scratch Memory MB: 28
  134.  File Handles:      48
  135.  Worker Threads:    12
  136.  Blocking Threads:  0
  137.  Externalizing Ops: 0
  138.  Unbounded Mem Ops: 0
  139.  MAX Threads:     8
  140.  
  141.  Extra Memory Reservation MB 0
  142.  -----------------------------
  143. (108 ROWS)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!