explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ta6

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,238.667 ↑ 3.5 2 1

GroupAggregate (cost=426,785.99..427,268.61 rows=7 width=27) (actual time=1,238.664..1,238.667 rows=2 loops=1)

  • Group Key: lineitem.l_shipmode
2. 3.562 1,239.658 ↑ 2.3 6 1

Gather Merge (cost=426,785.99..427,268.44 rows=14 width=27) (actual time=1,234.536..1,239.658 rows=6 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 6.681 1,236.096 ↑ 3.5 2 3 / 3

GroupAggregate (cost=425,785.97..426,266.8 rows=7 width=27) (actual time=1,232.089..1,236.096 rows=2 loops=3)

  • Group Key: lineitem.l_shipmode
4. 8.702 1,229.415 ↑ 1.2 20,846 3 / 3

Sort (cost=425,785.97..425,846.06 rows=24,038 width=27) (actual time=1,228.036..1,229.415 rows=20,846 loops=3)

  • Sort Key: lineitem.l_shipmode
  • Sort Method: quicksort Memory: 2,082kB
5. 4.462 1,220.713 ↑ 1.2 20,846 3 / 3

Nested Loop (cost=0.43..424,036.84 rows=24,038 width=27) (actual time=0.108..1,220.713 rows=20,846 loops=3)

6. 1,153.713 1,153.713 ↑ 1.2 20,846 3 / 3

Seq Scan on lineitem lineitem (cost=0..337,401.21 rows=24,038 width=15) (actual time=0.096..1,153.713 rows=20,846 loops=3)

  • Filter: ((l_shipmode = ANY ('{MAIL,RAIL}'::bpchar[])) AND (l_commitdate < l_receiptdate) AND (l_shipdate < l_commitdate) AND (l_receiptdate >= '1993-01-01'::date) AND (l_receiptdate < '1994-01-01 00:00:00'::timestamp without time zone))
7. 62.538 62.538 ↑ 1.0 1 62,538 / 3

Index Scan using orders_orderkey on orders orders (cost=0.43..3.59 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=62,538)

  • Index Cond: (o_orderkey = lineitem.l_orderkey)
Planning time : 0.184 ms
Execution time : 1,239.723 ms