{"push_id":2817514554,"size":2,"distinct_size":2,"ref":"refs/heads/explain-fragments","head":"503cb2f691f6168a5d9669390b5ea903c4d7c074","before":"336d56e3cd2ac64e49ad4b4ec70c0c4bde0852cc","commits":[{"sha":"631b6ec33d396c1083459827f84b23e7b1f086d4","author":{"name":"Rebecca Schlussel","email":"90232c8f9ce2491888432636b2ae27896be49b63@fb.com"},"message":"Simplify formatFragment in PlanPrinter","distinct":true,"url":"https://api.github.com/repos/rschlussel/presto/commits/631b6ec33d396c1083459827f84b23e7b1f086d4"},{"sha":"503cb2f691f6168a5d9669390b5ea903c4d7c074","author":{"name":"Rebecca Schlussel","email":"90232c8f9ce2491888432636b2ae27896be49b63@fb.com"},"message":"Propagate stats/costs across fragments in EXPLAIN\n\nPrint estimated stats and costs for all fragements in a distributed\nexplain plan.\n\nSample output:\npresto:sf1> explain (type distributed) select * from nation n join region r on n.regionkey = r.regionkey;\n                                                                                                        Query Plan\n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n Fragment 0 [SINGLE]\n     Output layout: [nationkey, name, regionkey, comment, regionkey, name_1, comment_2]\n     Output partitioning: SINGLE []\n     Execution Flow: UNGROUPED_EXECUTION\n     - Output[nationkey, name, regionkey, comment, regionkey, name, comment] => [nationkey:bigint, name:varchar(25), regionkey:bigint, comment:varchar(152), regionkey:bigint, name_1:varchar(25), comment_2:varchar(152)]\n             Cost: {rows: 25 (4.91kB), cpu: 15427.00, memory: 504.00, network: 0.00}\n             name := name_1\n             comment := comment_2\n         - RemoteSource[1] => [nationkey:bigint, name:varchar(25), regionkey:bigint, comment:varchar(152), name_1:varchar(25), comment_2:varchar(152)]\n                 Cost: {rows: 25 (4.69kB), cpu: 15427.00, memory: 504.00, network: 0.00}\n\n Fragment 1 [HASH]\n     Output layout: [nationkey, name, regionkey, comment, name_1, comment_2]\n     Output partitioning: SINGLE []\n     Execution Flow: UNGROUPED_EXECUTION\n     - InnerJoin[(\"regionkey\" = \"regionkey_0\")][$hashvalue, $hashvalue_34] => [nationkey:bigint, name:varchar(25), regionkey:bigint, comment:varchar(152), name_1:varchar(25), comment_2:varchar(152)]\n             Distribution: PARTITIONED\n             Cost: {rows: 25 (4.69kB), cpu: 15427.00, memory: 504.00, network: 0.00}\n         - RemoteSource[2] => [nationkey:bigint, name:varchar(25), regionkey:bigint, comment:varchar(152), $hashvalue:bigint]\n                 Cost: {rows: 25 (2.89kB), cpu: 5693.00, memory: 0.00, network: 0.00}\n         - LocalExchange[HASH][$hashvalue_34] (\"regionkey_0\") => regionkey_0:bigint, name_1:varchar(25), comment_2:varchar(152), $hashvalue_34:bigint\n                 Cost: {rows: 5 (504B), cpu: 1467.00, memory: 0.00, network: 0.00}\n             - RemoteSource[3] => [regionkey_0:bigint, name_1:varchar(25), comment_2:varchar(152), $hashvalue_35:bigint]\n                     Cost: {rows: 5 (504B), cpu: 963.00, memory: 0.00, network: 0.00}\n\n Fragment 2 [SOURCE]\n     Output layout: [nationkey, name, regionkey, comment, $hashvalue_33]\n     Output partitioning: HASH [regionkey][$hashvalue_33]\n     Execution Flow: UNGROUPED_EXECUTION\n     - ScanProject[table = tpch:tpch:nation:sf1.0, originalConstraint = true] => [nationkey:bigint, name:varchar(25), regionkey:bigint, comment:varchar(152), $hashvalue_33:bigint]\n             Cost: {rows: 25 (2.67kB), cpu: 2734.00, memory: 0.00, network: 0.00}/{rows: 25 (2.89kB), cpu: 5693.00, memory: 0.00, network: 0.00}\n             $hashvalue_33 := \"combine_hash\"(bigint '0', COALESCE(\"$operator$hash_code\"(\"regionkey\"), 0))\n             nationkey := tpch:nationkey\n             regionkey := tpch:regionkey\n             name := tpch:name\n             comment := tpch:comment\n\n Fragment 3 [SOURCE]\n     Output layout: [regionkey_0, name_1, comment_2, $hashvalue_36]\n     Output partitioning: HASH [regionkey_0][$hashvalue_36]\n     Execution Flow: UNGROUPED_EXECUTION\n     - ScanProject[table = tpch:tpch:region:sf1.0, originalConstraint = true] => [regionkey_0:bigint, name_1:varchar(25), comment_2:varchar(152), $hashvalue_36:bigint]\n             Cost: {rows: 5 (459B), cpu: 459.00, memory: 0.00, network: 0.00}/{rows: 5 (504B), cpu: 963.00, memory: 0.00, network: 0.00}\n             $hashvalue_36 := \"combine_hash\"(bigint '0', COALESCE(\"$operator$hash_code\"(\"regionkey_0\"), 0))\n             comment_2 := tpch:comment\n             name_1 := tpch:name\n             regionkey_0 := tpch:regionkey\n\n(1 row)","distinct":true,"url":"https://api.github.com/repos/rschlussel/presto/commits/503cb2f691f6168a5d9669390b5ea903c4d7c074"}]}
{"actor":{"display_login":"rschlussel"}}