explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5dNn

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

GroupAggregate (cost=428,674.5..429,157.12 rows=7 width=27) (actual time=1,527.815..1,527.817 rows=2 loops=1)

  • Group Key: lineitem.l_shipmode
2. 5.840 1,529.400 ↑ 2.3 6 1

Gather Merge (cost=428,674.5..429,156.95 rows=14 width=27) (actual time=1,523.235..1,529.4 rows=6 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 6.908 1,523.560 ↑ 3.5 2 3 / 3

GroupAggregate (cost=427,674.48..428,155.31 rows=7 width=27) (actual time=1,519.408..1,523.56 rows=2 loops=3)

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

Sort (cost=427,674.48..427,734.57 rows=24,038 width=27) (actual time=1,515.241..1,516.652 rows=20,846 loops=3)

  • Sort Key: lineitem.l_shipmode
  • Sort Method: quicksort Memory: 2,189kB
5. 212.687 1,508.633 ↑ 1.2 20,846 3 / 3

Hash Join (cost=337,701.69..425,925.35 rows=24,038 width=27) (actual time=1,172.634..1,508.633 rows=20,846 loops=3)

6. 123.584 123.584 ↑ 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.006..123.584 rows=1,000,000 loops=3)

7. 7.894 1,172.362 ↑ 1.2 20,846 3 / 3

Hash (cost=337,401.21..337,401.21 rows=24,038 width=15) (actual time=1,172.362..1,172.362 rows=20,846 loops=3)

8. 1,164.468 1,164.468 ↑ 1.2 20,846 3 / 3

Seq Scan on lineitem lineitem (cost=0..337,401.21 rows=24,038 width=15) (actual time=0.095..1,164.468 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))
Planning time : 0.199 ms
Execution time : 1,529.465 ms