explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BGwz

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 7,177.174 ↑ 5.9 17 1

Limit (cost=812,451.88..812,465.46 rows=100 width=71) (actual time=7,177.144..7,177.174 rows=17 loops=1)

2. 0.000 7,177.171 ↑ 30,231.2 17 1

GroupAggregate (cost=812,451.88..882,228.65 rows=513,930 width=71) (actual time=7,177.143..7,177.171 rows=17 loops=1)

  • Group Key: orders.o_totalprice, orders.o_orderdate, customer.c_name, customer.c_custkey, orders.o_orderkey
3. 3.879 7,178.594 ↑ 25,192.7 17 1

Gather Merge (cost=812,451.88..868,309.7 rows=428,276 width=71) (actual time=7,177.134..7,178.594 rows=17 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.040 7,174.715 ↑ 35,689.7 6 3 / 3

GroupAggregate (cost=811,451.85..817,875.99 rows=214,138 width=71) (actual time=7,174.694..7,174.715 rows=6 loops=3)

  • Group Key: orders.o_totalprice, orders.o_orderdate, customer.c_name, customer.c_custkey, orders.o_orderkey
5. 0.087 7,174.675 ↑ 5,353.4 40 3 / 3

Sort (cost=811,451.85..811,987.2 rows=214,138 width=44) (actual time=7,174.672..7,174.675 rows=40 loops=3)

  • Sort Key: orders.o_totalprice DESC, orders.o_orderdate, customer.c_name, customer.c_custkey, orders.o_orderkey
  • Sort Method: quicksort Memory: 26kB
6. 0.018 7,174.588 ↑ 5,353.4 40 3 / 3

Nested Loop (cost=689,448.41..785,901.38 rows=214,138 width=44) (actual time=7,150.066..7,174.588 rows=40 loops=3)

7. 13.087 7,174.468 ↑ 8,923.8 6 3 / 3

Hash Join (cost=689,447.98..698,558.83 rows=53,543 width=43) (actual time=7,150.03..7,174.468 rows=6 loops=3)

8. 13.477 13.477 ↑ 1.2 100,000 3 / 3

Seq Scan on customer customer (cost=0..8,419 rows=125,000 width=23) (actual time=0.008..13.477 rows=100,000 loops=3)

9. 224.231 7,147.904 ↑ 8,923.8 6 3 / 3

Hash (cost=688,778.69..688,778.69 rows=53,543 width=24) (actual time=7,147.904..7,147.904 rows=6 loops=3)

10. 262.632 6,923.673 ↑ 8,923.8 6 3 / 3

Hash Join (cost=605,659.44..688,778.69 rows=53,543 width=24) (actual time=6,532.945..6,923.673 rows=6 loops=3)

11. 202.406 202.406 ↑ 1.2 1,000,000 3 / 3

Seq Scan on orders orders (cost=0..64,686 rows=1,250,000 width=20) (actual time=0.008..202.406 rows=1,000,000 loops=3)

12. 0.123 6,458.635 ↑ 7,559.1 17 3 / 3

Hash (cost=603,551.14..603,551.14 rows=128,504 width=4) (actual time=6,458.635..6,458.635 rows=17 loops=3)

13. 3,953.529 6,458.512 ↑ 7,559.1 17 3 / 3

GroupAggregate (cost=0.43..602,266.1 rows=128,504 width=4) (actual time=736.54..6,458.512 rows=17 loops=3)

  • Group Key: lineitem_1.l_orderkey
  • Filter: (sum(lineitem_1.l_quantity) > '315'::numeric)
14. 2,504.983 2,504.983 ↑ 1.0 11,997,996 3 / 3

Index Scan using lineitem_key on lineitem lineitem_1 (cost=0.43..536,493.46 rows=11,997,996 width=9) (actual time=0.013..2,504.983 rows=11,997,996 loops=3)

15. 0.102 0.102 ↑ 4.4 7 17 / 3

Index Scan using lineitem_key on lineitem lineitem (cost=0.43..1.32 rows=31 width=9) (actual time=0.016..0.018 rows=7 loops=17)

  • Index Cond: (l_orderkey = orders.o_orderkey)
Planning time : 0.529 ms
Execution time : 7,178.7 ms