explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tyLlw

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,366.241 ↑ 1,203.0 2 1

GroupAggregate (cost=388,051.55..388,694.92 rows=2,406 width=40) (actual time=1,366.235..1,366.241 rows=2 loops=1)

  • Group Key: (date_part('year'::text, (orders.o_orderdate)::timestamp without time zone))
2. 6.886 1,368.136 ↑ 658.3 6 1

Gather Merge (cost=388,051.55..388,591.41 rows=3,950 width=72) (actual time=1,365.571..1,368.136 rows=6 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1.054 1,361.250 ↑ 987.5 2 3 / 3

GroupAggregate (cost=387,051.52..387,135.46 rows=1,975 width=72) (actual time=1,360.683..1,361.25 rows=2 loops=3)

  • Group Key: (date_part('year'::text, (orders.o_orderdate)::timestamp without time zone))
4. 0.707 1,360.196 ↑ 1.2 1,601 3 / 3

Sort (cost=387,051.52..387,056.46 rows=1,975 width=46) (actual time=1,360.087..1,360.196 rows=1,601 loops=3)

  • Sort Key: (date_part('year'::text, (orders.o_orderdate)::timestamp without time zone))
  • Sort Method: quicksort Memory: 157kB
5. 0.670 1,359.489 ↑ 1.2 1,601 3 / 3

Hash Join (cost=377,893.55..386,943.41 rows=1,975 width=46) (actual time=1,322.801..1,359.489 rows=1,601 loops=3)

6. 0.984 1,358.797 ↑ 1.2 1,601 3 / 3

Hash Join (cost=377,891.98..386,904.82 rows=1,975 width=20) (actual time=1,322.748..1,358.797 rows=1,601 loops=3)

7. 1.010 1,349.505 ↑ 1.2 1,601 3 / 3

Hash Join (cost=376,998.98..385,984.66 rows=1,975 width=20) (actual time=1,314.337..1,349.505 rows=1,601 loops=3)

8. 20.036 1,348.444 ↑ 1.2 8,008 3 / 3

Hash Join (cost=376,996.45..385,925.35 rows=9,875 width=24) (actual time=1,314.188..1,348.444 rows=8,008 loops=3)

9. 14.380 14.380 ↑ 1.2 100,000 3 / 3

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

10. 3.409 1,314.028 ↑ 1.2 8,008 3 / 3

Hash (cost=376,873.01..376,873.01 rows=9,875 width=24) (actual time=1,314.028..1,314.028 rows=8,008 loops=3)

11. 70.100 1,310.619 ↑ 1.2 8,008 3 / 3

Hash Join (cost=304,502.43..376,873.01 rows=9,875 width=24) (actual time=1,072.403..1,310.619 rows=8,008 loops=3)

12. 168.510 168.510 ↑ 1.2 303,803 3 / 3

Seq Scan on orders orders (cost=0..70,936 rows=371,582 width=12) (actual time=0.009..168.51 rows=303,803 loops=3)

  • Filter: ((o_orderdate >= '1995-01-01'::date) AND (o_orderdate <= '1996-12-31'::date))
13. 14.251 1,072.009 ↑ 1.3 26,384 3 / 3

Hash (cost=304,087.18..304,087.18 rows=33,220 width=20) (actual time=1,072.009..1,072.009 rows=26,384 loops=3)

14. 665.298 1,057.758 ↑ 1.3 26,384 3 / 3

Hash Join (cost=10,290.18..304,087.18 rows=33,220 width=20) (actual time=20.875..1,057.758 rows=26,384 loops=3)

15. 371.742 371.742 ↑ 1.2 3,999,332 3 / 3

Seq Scan on lineitem lineitem (cost=0..274,911.65 rows=4,999,165 width=24) (actual time=0.004..371.742 rows=3,999,332 loops=3)

16. 0.249 20.718 ↑ 1.3 877 3 / 3

Hash (cost=10,276.33..10,276.33 rows=1,108 width=4) (actual time=20.717..20.718 rows=877 loops=3)

17. 20.469 20.469 ↑ 1.3 877 3 / 3

Seq Scan on part part (cost=0..10,276.33 rows=1,108 width=4) (actual time=0.039..20.469 rows=877 loops=3)

  • Filter: ((p_type)::text = 'ECONOMY POLISHED STEEL'::text)
18. 0.006 0.051 ↑ 1.0 5 3 / 3

Hash (cost=2.47..2.47 rows=5 width=4) (actual time=0.051..0.051 rows=5 loops=3)

19. 0.018 0.045 ↑ 1.0 5 3 / 3

Hash Join (cost=1.07..2.47 rows=5 width=4) (actual time=0.04..0.045 rows=5 loops=3)

20. 0.008 0.008 ↑ 1.0 25 3 / 3

Seq Scan on nation n1 (cost=0..1.25 rows=25 width=8) (actual time=0.005..0.008 rows=25 loops=3)

21. 0.005 0.019 ↑ 1.0 1 3 / 3

Hash (cost=1.06..1.06 rows=1 width=4) (actual time=0.018..0.019 rows=1 loops=3)

22. 0.014 0.014 ↑ 1.0 1 3 / 3

Seq Scan on region region (cost=0..1.06 rows=1 width=4) (actual time=0.013..0.014 rows=1 loops=3)

  • Filter: (r_name = 'EUROPE'::bpchar)
23. 3.889 8.308 ↑ 1.0 20,000 3 / 3

Hash (cost=643..643 rows=20,000 width=8) (actual time=8.308..8.308 rows=20,000 loops=3)

24. 4.419 4.419 ↑ 1.0 20,000 3 / 3

Seq Scan on supplier supplier (cost=0..643 rows=20,000 width=8) (actual time=0.007..4.419 rows=20,000 loops=3)

25. 0.009 0.022 ↑ 1.0 25 3 / 3

Hash (cost=1.25..1.25 rows=25 width=30) (actual time=0.022..0.022 rows=25 loops=3)

26. 0.013 0.013 ↑ 1.0 25 3 / 3

Seq Scan on nation n2 (cost=0..1.25 rows=25 width=30) (actual time=0.01..0.013 rows=25 loops=3)

Planning time : 0.89 ms
Execution time : 1,368.276 ms