explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NsT35

Settings
# 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