explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MknI

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

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

  • Group Key: lineitem.l_shipmode
2. 3.837 1,244.635 ↑ 2.3 6 1

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 6.695 1,240.798 ↑ 3.5 2 3 / 3

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

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

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

  • Sort Key: lineitem.l_shipmode
  • Sort Method: quicksort Memory: 2,088kB
5. 5.818 1,225.235 ↑ 1.2 20,846 3 / 3

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

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

Seq Scan on lineitem lineitem (cost=0..337,401.21 rows=24,038 width=15) (actual time=0.102..1,156.879 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.147 ms
Execution time : 1,244.7 ms