explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rleU : q18-norm

Settings
# exclusive inclusive rows x rows loops node
1. 0.087 4,524.451 ↑ 52,642.4 57 1

Sort (cost=1,627,860.44..1,635,361.98 rows=3,000,616 width=71) (actual time=4,524.445..4,524.451 rows=57 loops=1)

  • Sort Key: o.o_totalprice DESC, o.o_orderdate
  • Sort Method: quicksort Memory: 29kB
2. 0.204 4,524.364 ↑ 52,642.4 57 1

GroupAggregate (cost=1,061,943.12..1,151,961.60 rows=3,000,616 width=44) (actual time=4,524.169..4,524.364 rows=57 loops=1)

  • Group Key: c.c_name, c.c_custkey, o.o_orderkey, o.o_orderdate, o.o_totalprice
3. 1.285 4,524.160 ↑ 7,520.3 399 1

Sort (cost=1,061,943.12..1,069,444.66 rows=3,000,616 width=44) (actual time=4,524.138..4,524.160 rows=399 loops=1)

  • Sort Key: c.c_name, c.c_custkey, o.o_orderkey, o.o_orderdate, o.o_totalprice
  • Sort Method: quicksort Memory: 56kB
4. 1.835 4,522.875 ↑ 7,520.3 399 1

Hash Join (cost=380,534.34..646,818.94 rows=3,000,616 width=44) (actual time=3,385.139..4,522.875 rows=399 loops=1)

  • Hash Cond: (o.o_custkey = c.c_custkey)
5. 579.460 4,461.041 ↑ 7,520.3 399 1

Hash Join (cost=373,574.34..598,600.47 rows=3,000,616 width=25) (actual time=3,323.894..4,461.041 rows=399 loops=1)

  • Hash Cond: (l.l_orderkey = o.o_orderkey)
6. 564.146 564.146 ↑ 1.0 6,001,215 1

Seq Scan on lineitem l (cost=0.00..172,515.33 rows=6,001,233 width=9) (actual time=0.004..564.146 rows=6,001,215 loops=1)

7. 0.241 3,317.435 ↑ 13,157.9 57 1

Hash (cost=364,199.34..364,199.34 rows=750,000 width=24) (actual time=3,317.435..3,317.435 rows=57 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 8196kB
8. 192.605 3,317.194 ↑ 13,157.9 57 1

Hash Join (cost=313,454.10..364,199.34 rows=750,000 width=24) (actual time=2,973.418..3,317.194 rows=57 loops=1)

  • Hash Cond: (o.o_orderkey = l2.l_orderkey)
9. 154.476 154.476 ↑ 1.0 1,500,000 1

Seq Scan on orders o (cost=0.00..41,095.00 rows=1,500,000 width=20) (actual time=0.011..154.476 rows=1,500,000 loops=1)

10. 0.280 2,970.113 ↑ 7,061.8 57 1

Hash (cost=308,422.55..308,422.55 rows=402,524 width=4) (actual time=2,970.113..2,970.113 rows=57 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 4099kB
11. 1,790.549 2,969.833 ↑ 7,061.8 57 1

GroupAggregate (cost=0.43..304,397.31 rows=402,524 width=9) (actual time=3.530..2,969.833 rows=57 loops=1)

  • Group Key: l2.l_orderkey
  • Filter: (sum(l2.l_quantity) > '300'::numeric)
  • Rows Removed by Filter: 1499943
12. 1,179.284 1,179.284 ↑ 1.0 6,001,215 1

Index Scan using lineitem_idx_4 on lineitem l2 (cost=0.43..268,353.29 rows=6,001,233 width=9) (actual time=0.018..1,179.284 rows=6,001,215 loops=1)

13. 32.245 59.999 ↑ 1.0 150,000 1

Hash (cost=5,085.00..5,085.00 rows=150,000 width=23) (actual time=59.999..59.999 rows=150,000 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 10252kB
14. 27.754 27.754 ↑ 1.0 150,000 1

Seq Scan on customer c (cost=0.00..5,085.00 rows=150,000 width=23) (actual time=0.007..27.754 rows=150,000 loops=1)

Planning time : 4.583 ms
Execution time : 4,525.920 ms