[Postgres-xc-general] Fwd: postgress query plan question

[Nirmal S. <sha...@gm...>]

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