Skip to content

G
Gpdb

Greenplum / Gpdb

通知 7
Star 1
Fork 0
G
Gpdb

体验新版 GitCode，发现更多精彩内容 >>

切换分支/标签
查找文件 普通视图历史永久链接Permalink
groupingfunc192.ans 2.4 KB
Newer Older
H
optimizer functional part 2 [#135663277]  
Haisheng Yuan and Jesse Zhang 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 
-- @author tungs1
-- @modified 2013-07-28 12:00:00
-- @created 2013-07-28 12:00:00
-- @description groupingfunction groupingfunc192.sql
-- @db_name groupingfunction
-- @executemode normal
-- @tags groupingfunction
-- order 1
-- start_ignore
SET optimizer_log=on;SET optimizer=on;SET client_min_messages='log';
SET
SET
SET
-- end_ignore
select 'a', * from ((SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc192_gucs.sql:12: LOG:  statement: select 'a', * from ((SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc192_gucs.sql:12: LOG:  
[OPT]: Using default search strategy
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc192_gucs.sql:12: LOG:  2013-11-08 10:05:04:827272 PST,THD000,TRACE,"CAutoTrace.cpp:53: [OPT]: Search terminated at stage 1/1",
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc192_gucs.sql:12: LOG:  Query plan size to dispatch: 32KB
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc192_gucs.sql:12: LOG:  Material node creates shareinput rwfile pgsql_tmp_SIRW_2898_5_0  (seg0 slice3 rh55-qavm19:40500 pid=26902)
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc192_gucs.sql:12: LOG:  Material node creates shareinput rwfile pgsql_tmp_SIRW_2898_5_0  (seg1 slice3 rh55-qavm63:40500 pid=11051)
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc192_gucs.sql:12: LOG:  Material Exec on CrossSlice, current slice 1  (seg0 slice1 rh55-qavm19:40500 pid=26906)
psql:/data/tungs1_cdbfast/tincrepo/main/olap/groupingfunction/sql/../output/groupingfunc192_gucs.sql:12: LOG:  Material Exec on CrossSlice, current slice 1  (seg1 slice1 rh55-qavm63:40500 pid=11055)
 ?column? |  g1  
----------+------
 a        |  400
 a        |  800
 a        |  300
 a        | 1000
 a        |  500
 a        |  200
 a        |  600
 a        |  700
 a        |  100
 a        | 1600
(10 rows)