explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f9SN

Settings
# exclusive inclusive rows x rows loops node
1. 280.466 15,373.427 ↓ 1.4 903,477 1

Finalize GroupAggregate (cost=670,815.10..901,431.98 rows=650,092 width=60) (actual time=12,907.820..15,373.427 rows=903,477 loops=1)

  • Group Key: stat.product_id
  • Functions: 48
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 14.902 ms, Inlining 609.721 ms, Optimization 1004.318 ms, Emission 733.915 ms, Total 2362.857 ms
2. 1,658.144 15,092.961 ↑ 1.4 903,477 1

Gather Merge (cost=670,815.10..870,552.61 rows=1,300,184 width=52) (actual time=12,907.801..15,092.961 rows=903,477 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 468.804 13,434.817 ↑ 2.2 301,159 3 / 3

Partial GroupAggregate (cost=669,815.07..719,479.09 rows=650,092 width=52) (actual time=12,846.384..13,434.817 rows=301,159 loops=3)

  • Group Key: stat.product_id
4. 977.097 12,966.013 ↑ 1.2 731,535 3 / 3

Sort (cost=669,815.07..671,973.23 rows=863,262 width=20) (actual time=12,845.254..12,966.013 rows=731,535 loops=3)

  • Sort Key: stat.product_id
  • Sort Method: external merge Disk: 21,672kB
  • Worker 0: Sort Method: external merge Disk: 21,384kB
  • Worker 1: Sort Method: external merge Disk: 21,384kB
5. 1,750.859 11,988.916 ↑ 1.2 731,535 3 / 3

Parallel Hash Join (cost=50,906.58..566,993.36 rows=863,262 width=20) (actual time=10,563.855..11,988.916 rows=731,535 loops=3)

  • Hash Cond: (product.itemid = stat.product_id)
6. 8,376.747 8,376.747 ↑ 1.3 932,200 3 / 3

Parallel Seq Scan on product (cost=0.00..493,938.44 rows=1,166,244 width=4) (actual time=0.876..8,376.747 rows=932,200 loops=3)

7. 470.517 1,861.310 ↑ 1.2 732,684 3 / 3

Parallel Hash (cost=35,033.59..35,033.59 rows=864,559 width=20) (actual time=1,861.310..1,861.310 rows=732,684 loops=3)

  • Buckets: 65,536 Batches: 64 Memory Usage: 2,464kB
8. 1,390.793 1,390.793 ↑ 1.2 732,684 3 / 3

Parallel Seq Scan on stat (cost=0.00..35,033.59 rows=864,559 width=20) (actual time=787.743..1,390.793 rows=732,684 loops=3)

Execution time : 15,549.990 ms