explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kl2g

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=388,075.82..388,726.96 rows=2,406 width=40) (never executed)

  • Group Key: (date_part('year'::text, (orders.o_orderdate)::timestamp without time zone))
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=388,075.82..388,622.8 rows=4,002 width=72) (never executed)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=387,075.8..387,160.84 rows=2,001 width=72) (never executed)

  • Group Key: (date_part('year'::text, (orders.o_orderdate)::timestamp without time zone))
4. 0.000 0.000 ↓ 0.0

Sort (cost=387,075.8..387,080.8 rows=2,001 width=46) (never executed)

  • Sort Key: (date_part('year'::text, (orders.o_orderdate)::timestamp without time zone))
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=377,914.09..386,966.08 rows=2,001 width=46) (never executed)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=377,912.53..386,927 rows=2,001 width=20) (never executed)

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=377,019.53..386,006.49 rows=2,001 width=20) (never executed)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=377,017..385,946.43 rows=10,004 width=24) (never executed)

9. 0.000 0.000 ↓ 0.0

Seq Scan on customer customer (cost=0..8,419 rows=125,000 width=8) (never executed)

10. 0.000 0.000 ↓ 0.0

Hash (cost=376,891.95..376,891.95 rows=10,004 width=24) (never executed)

11. 0.000 0.000 ↓ 0.0

Hash Join (cost=304,505.24..376,891.95 rows=10,004 width=24) (never executed)

12. 0.000 0.000 ↓ 0.0

Seq Scan on orders orders (cost=0..70,936.68 rows=375,559 width=12) (never executed)

  • Filter: ((o_orderdate >= '1995-01-01'::date) AND (o_orderdate <= '1996-12-31'::date))
13. 0.000 0.000 ↓ 0.0

Hash (cost=304,089.05..304,089.05 rows=33,295 width=20) (never executed)

14. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,290.21..304,089.05 rows=33,295 width=20) (never executed)

15. 0.000 0.000 ↓ 0.0

Seq Scan on lineitem lineitem (cost=0..274,912.81 rows=4,999,281 width=24) (never executed)

16. 0.000 0.000 ↓ 0.0

Hash (cost=10,276.33..10,276.33 rows=1,110 width=4) (never executed)

17. 0.000 0.000 ↓ 0.0

Seq Scan on part part (cost=0..10,276.33 rows=1,110 width=4) (never executed)

  • Filter: ((p_type)::text = 'ECONOMY POLISHED STEEL'::text)
18. 0.000 0.000 ↓ 0.0

Hash (cost=2.47..2.47 rows=5 width=4) (never executed)

19. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.07..2.47 rows=5 width=4) (never executed)

20. 0.000 0.000 ↓ 0.0

Seq Scan on nation n1 (cost=0..1.25 rows=25 width=8) (never executed)

21. 0.000 0.000 ↓ 0.0

Hash (cost=1.06..1.06 rows=1 width=4) (never executed)

22. 0.000 0.000 ↓ 0.0

Seq Scan on region region (cost=0..1.06 rows=1 width=4) (never executed)

  • Filter: (r_name = 'EUROPE'::bpchar)
23. 0.000 0.000 ↓ 0.0

Hash (cost=643..643 rows=20,000 width=8) (never executed)

24. 0.000 0.000 ↓ 0.0

Seq Scan on supplier supplier (cost=0..643 rows=20,000 width=8) (never executed)

25. 0.000 0.000 ↓ 0.0

Hash (cost=1.25..1.25 rows=25 width=30) (never executed)

26. 0.000 0.000 ↓ 0.0

Seq Scan on nation n2 (cost=0..1.25 rows=25 width=30) (never executed)