#	exclusive	inclusive	rows x	rows	loops	node
1.	341.802	1,921.880	↑ 1.1	22,428	1	→ Finalize GroupAggregate (cost=12,360.03..15,310.59 rows=25,081 width=1,391) (actual time=445.257..1,921.880 rows=22,428 loops=1) Group Key: product_uuid
2.	0.000	1,580.078	↓ 1.1	22,428	1	→ Gather Merge (cost=12,360.03..14,955.28 rows=20,900 width=1,391) (actual time=445.222..1,580.078 rows=22,428 loops=1) Workers Planned: 2 Workers Launched: 2
3.	341.205	1,797.513	↑ 1.4	7,476	3	→ Partial GroupAggregate (cost=11,360.01..11,542.88 rows=10,450 width=1,391) (actual time=429.006..599.171 rows=7,476 loops=3) Group Key: product_uuid
4.	713.481	1,456.308	↑ 1.4	7,476	3	→ Sort (cost=11,360.01..11,386.13 rows=10,450 width=1,383) (actual time=428.946..485.436 rows=7,476 loops=3) Sort Key: product_uuid Sort Method: external merge Disk: 9512kB
5.	742.827	742.827	↑ 1.4	7,476	3	→ Parallel Seq Scan on product_sizes (cost=0.00..4,372.90 rows=10,450 width=1,383) (actual time=0.067..247.609 rows=7,476 loops=3) Filter: ((product_uuid)::text ~~ '%a%'::text) Rows Removed by Filter: 885

QUERY PLAN
Finalize GroupAggregate  (cost=12360.03..15310.59 rows=25081 width=1391) (actual time=445.257..1921.880 rows=22428 loops=1)
  Group Key: product_uuid
  ->  Gather Merge  (cost=12360.03..14955.28 rows=20900 width=1391) (actual time=445.222..1580.078 rows=22428 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        ->  Partial GroupAggregate  (cost=11360.01..11542.88 rows=10450 width=1391) (actual time=429.006..599.171 rows=7476 loops=3)
              Group Key: product_uuid
              ->  Sort  (cost=11360.01..11386.13 rows=10450 width=1383) (actual time=428.946..485.436 rows=7476 loops=3)
                    Sort Key: product_uuid
                    Sort Method: external merge  Disk: 9512kB
                    ->  Parallel Seq Scan on product_sizes  (cost=0.00..4372.90 rows=10450 width=1383) (actual time=0.067..247.609 rows=7476 loops=3)
                          Filter: ((product_uuid)::text ~~ '%a%'::text)
                          Rows Removed by Filter: 885
Planning time: 0.182 ms
Execution time: 2069.758 ms

Per node type stats

node type	count	sum of times	% of query
Finalize GroupAggregate	1	341.802 ms	17.8 %
Gather Merge	1	0.000 ms	0.0 %
Parallel Seq Scan	1	742.827 ms	38.7 %
Partial GroupAggregate	1	341.205 ms	17.8 %
Sort	1	713.481 ms	37.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
product_sizes	1	742.827 ms	38.7 %
Parallel Seq Scan	1	742.827 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NsT35

Color mode:

Visible columns:

Per node type stats

Per table stats