Hi,
I ran a query and generated this plan. Now i want to know where this query
is taking most time? Is it the co-ordinatore that is taking time while
sorting/aggregating and how how am i reduce this time ?
"HashAggregate (cost=190.96..191.72 rows=100 width=64) (actual
time=25115.936..25121.042 rows=24360 loops=1)"
" -> Subquery Scan on zz (cost=49.83..190.71 rows=100 width=64) (actual
time=18290.491..25059.508 rows=59192 loops=1)"
" -> GroupAggregate (cost=49.83..189.95 rows=1 width=384) (actual
time=18290.239..20885.314 rows=38786 loops=1)"
" -> Sort (cost=49.83..52.33 rows=1000 width=384) (actual
time=18290.101..18340.226 rows=343158 loops=1)"
" Sort Key: kw.expr_names, kw.expr_values"
" Sort Method: quicksort Memory: 66021kB"
" -> Data Node Scan on "_REMOTE_TABLE_QUERY_"
(cost=0.00..0.00 rows=1000 width=384) (actual time=295.532..12126.271
rows=343158 loops=1)"
" Node/s: d11, d12, d13, d14, d15, d16"
"Total runtime: 25145.074 ms"
Nirmal
|
