cleverxiao001 commented on issue #1251:
URL: https://github.com/apache/cloudberry/issues/1251#issuecomment-3116134121
explain(verbose) output:
QUERY PLAN
Gather Motion 36:1 (slice1; segments: 36) (cost=0.00..431.00 rows=1
width=32)
" Output: country, ref_year, (count(*)), (count(DISTINCT ref_uid))"
-> GroupAggregate (cost=0.00..431.00 rows=1 width=32)
" Output: country, ref_year, count(*), count(DISTINCT ref_uid)"
" Group Key: paper_reference_first_au.country,
paper_reference_first_au.ref_year"
-> Sort (cost=0.00..431.00 rows=1 width=24)
" Output: country, ref_uid, ref_year"
" Sort Key: paper_reference_first_au.country,
paper_reference_first_au.ref_year"
-> Redistribute Motion 36:36 (slice2; segments: 36)
(cost=0.00..431.00 rows=1 width=24)
" Output: country, ref_uid, ref_year"
" Hash Key: country, ref_year"
-> Seq Scan on reference_info (cost=0.00..431.00
rows=1 width=24)
" Output: country, ref_uid, ref_year"
Optimizer: GPORCA
explain(verbose,analyze) output:
QUERY PLAN
Gather Motion 36:1 (slice1; segments: 36) (cost=0.00..431.00 rows=1
width=32) (actual time=72085.217..115653.745 rows=2480 loops=1)
" Output: country, ref_year, (count(*)), (count(DISTINCT ref_uid))"
-> GroupAggregate (cost=0.00..431.00 rows=1 width=32) (actual
time=69972.797..88910.012 rows=92 loops=1)
" Output: country, ref_year, count(*), count(DISTINCT ref_uid)"
" Group Key: paper_reference_first_au.country,
paper_reference_first_au.ref_year"
-> Sort (cost=0.00..431.00 rows=1 width=24) (actual
time=69832.795..71977.819 rows=8223755 loops=1)
" Output: country, ref_uid, ref_year"
" Sort Key: paper_reference_first_au.country,
paper_reference_first_au.ref_year"
Sort Method: quicksort Memory: 122481kB
Max Memory: 62527kB Avg Memory: 61240kB (2 segments)
Sort Method: external merge Disk: 3588512kB
Max Memory: 377088kB Avg Memory: 105544kB (34 segments)
work_mem: 2236160kB Segments: 36 Max: 63854kB (segment 1)
Workfile: (34 spilling)
-> Redistribute Motion 36:36 (slice2; segments: 36)
(cost=0.00..431.00 rows=1 width=24) (actual time=3.000..66710.760 rows=8223755
loops=1)
" Output: country, ref_uid, ref_year"
" Hash Key: country, ref_year"
-> Seq Scan on reference_info (cost=0.00..431.00
rows=1 width=24) (actual time=5.000..2059.006 rows=2290316 loops=1)
" Output: country, ref_uid, ref_year"
Planning Time: 13.835 ms
(slice0) Executor memory: 117K bytes.
" (slice1) Executor memory: 106412K bytes avg x 36x(0) workers, 141357K
bytes max (seg23). Work_mem: 63854K bytes max."
" (slice2) Executor memory: 530K bytes avg x 36x(0) workers, 530K bytes
max (seg0)."
Memory used: 128000kB
Optimizer: GPORCA
Execution Time: 115751.813 ms
Both of them is worked
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
