explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hn8p

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

Nested Loop (cost=122,341.49..122,512.12 rows=4 width=3,655) (actual time=650.137..650.137 rows=0 loops=1)

2. 0.003 0.617 ↑ 1.0 1 1

Nested Loop (cost=0.98..17.03 rows=1 width=37) (actual time=0.614..0.617 rows=1 loops=1)

3. 0.488 0.488 ↑ 1.0 1 1

Index Only Scan using arbeitsort_pkey on arbeitsort arbeitsort2_ (cost=0.42..8.44 rows=1 width=37) (actual time=0.487..0.488 rows=1 loops=1)

  • Index Cond: (id = '59ed0a0d-8414-4573-bb56-9c452c037e14'::text)
  • Heap Fetches: 1
4. 0.126 0.126 ↑ 1.0 1 1

Index Only Scan using id_index on objekt arbeitsort2_1_ (cost=0.56..8.57 rows=1 width=37) (actual time=0.124..0.126 rows=1 loops=1)

  • Index Cond: (id = '59ed0a0d-8414-4573-bb56-9c452c037e14'::text)
  • Heap Fetches: 1
5. 30.897 665.598 ↓ 0.0 0 1

Gather (cost=122,340.51..122,495.06 rows=4 width=3,692) (actual time=649.518..665.598 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 0.001 634.701 ↓ 0.0 0 3

Nested Loop Left Join (cost=121,340.51..121,494.66 rows=2 width=3,692) (actual time=634.701..634.701 rows=0 loops=3)

7. 0.002 634.700 ↓ 0.0 0 3

Merge Join (cost=121,340.23..121,494.03 rows=2 width=3,164) (actual time=634.700..634.700 rows=0 loops=3)

  • Merge Cond: ((massnahme0_.id)::text = (arbeitsort1_.massnahme_id)::text)
8. 0.003 634.598 ↑ 8,003.0 1 3

Merge Left Join (cost=121,320.47..121,454.23 rows=8,003 width=3,164) (actual time=634.598..634.598 rows=1 loops=3)

  • Merge Cond: ((massnahme0_.id)::text = (massnahme0_14_.id)::text)
9. 0.004 633.396 ↑ 8,003.0 1 3

Merge Left Join (cost=121,236.60..121,339.55 rows=8,003 width=3,127) (actual time=633.396..633.396 rows=1 loops=3)

  • Merge Cond: ((massnahme0_.id)::text = (massnahme0_13_.id)::text)
10. 0.001 633.345 ↑ 8,003.0 1 3

Merge Left Join (cost=121,233.14..121,315.51 rows=8,003 width=3,119) (actual time=633.345..633.345 rows=1 loops=3)

  • Merge Cond: ((massnahme0_.id)::text = (massnahme0_11_.id)::text)
11. 0.003 633.339 ↑ 8,003.0 1 3

Merge Left Join (cost=121,221.22..121,283.13 rows=8,003 width=2,063) (actual time=633.339..633.339 rows=1 loops=3)

  • Merge Cond: ((massnahme0_.id)::text = (massnahme0_3_.id)::text)
12. 0.005 633.329 ↑ 8,003.0 1 3

Merge Left Join (cost=121,204.83..121,245.45 rows=8,003 width=2,058) (actual time=633.329..633.329 rows=1 loops=3)

  • Merge Cond: ((massnahme0_.id)::text = (massnahme0_2_.id)::text)
13. 12.925 633.251 ↑ 8,003.0 1 3

Sort (cost=121,201.18..121,221.19 rows=8,003 width=2,026) (actual time=633.251..633.251 rows=1 loops=3)

  • Sort Key: massnahme0_.id
  • Sort Method: quicksort Memory: 3699kB
14. 268.034 620.326 ↑ 1.2 6,403 3

Hash Join (cost=936.18..120,682.33 rows=8,003 width=2,026) (actual time=20.965..620.326 rows=6,403 loops=3)

  • Hash Cond: ((massnahme0_1_.id)::text = (massnahme0_.id)::text)
15. 331.852 331.852 ↑ 1.2 1,344,200 3

Parallel Seq Scan on objekt massnahme0_1_ (cost=0.00..115,335.50 rows=1,680,250 width=721) (actual time=0.042..331.852 rows=1,344,200 loops=3)

16. 11.696 20.440 ↑ 1.0 19,208 3

Hash (cost=696.08..696.08 rows=19,208 width=1,305) (actual time=20.440..20.440 rows=19,208 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 4260kB
17. 8.744 8.744 ↑ 1.0 19,208 3

Seq Scan on massnahme massnahme0_ (cost=0.00..696.08 rows=19,208 width=1,305) (actual time=0.024..8.744 rows=19,208 loops=3)

18. 0.040 0.073 ↑ 66.0 1 3

Sort (cost=3.65..3.82 rows=66 width=69) (actual time=0.073..0.073 rows=1 loops=3)

  • Sort Key: massnahme0_2_.id
  • Sort Method: quicksort Memory: 30kB
19. 0.033 0.033 ↑ 1.0 66 3

Seq Scan on bonitierung massnahme0_2_ (cost=0.00..1.66 rows=66 width=69) (actual time=0.028..0.033 rows=66 loops=3)

20. 0.002 0.007 ↓ 0.0 0 3

Sort (cost=16.39..16.74 rows=140 width=521) (actual time=0.007..0.007 rows=0 loops=3)

  • Sort Key: massnahme0_3_.id
  • Sort Method: quicksort Memory: 25kB
21. 0.005 0.005 ↓ 0.0 0 3

Seq Scan on beregnung massnahme0_3_ (cost=0.00..11.40 rows=140 width=521) (actual time=0.005..0.005 rows=0 loops=3)

22. 0.002 0.005 ↓ 0.0 0 3

Sort (cost=11.91..12.04 rows=50 width=1,572) (actual time=0.005..0.005 rows=0 loops=3)

  • Sort Key: massnahme0_11_.id
  • Sort Method: quicksort Memory: 25kB
23. 0.003 0.003 ↓ 0.0 0 3

Seq Scan on ernte massnahme0_11_ (cost=0.00..10.50 rows=50 width=1,572) (actual time=0.003..0.003 rows=0 loops=3)

24. 0.034 0.047 ↑ 62.0 1 3

Sort (cost=3.47..3.62 rows=62 width=45) (actual time=0.047..0.047 rows=1 loops=3)

  • Sort Key: massnahme0_13_.id
  • Sort Method: quicksort Memory: 29kB
25. 0.013 0.013 ↑ 1.0 62 3

Seq Scan on wartung massnahme0_13_ (cost=0.00..1.62 rows=62 width=45) (actual time=0.009..0.013 rows=62 loops=3)

26. 1.046 1.199 ↑ 1,178.0 1 3

Sort (cost=83.87..86.82 rows=1,178 width=74) (actual time=1.199..1.199 rows=1 loops=3)

  • Sort Key: massnahme0_14_.id
  • Sort Method: quicksort Memory: 165kB
27. 0.153 0.153 ↑ 1.0 1,178 3

Seq Scan on erntegutbergung massnahme0_14_ (cost=0.00..23.78 rows=1,178 width=74) (actual time=0.008..0.153 rows=1,178 loops=3)

28. 0.005 0.100 ↓ 0.0 0 3

Sort (cost=19.76..19.77 rows=4 width=74) (actual time=0.100..0.100 rows=0 loops=3)

  • Sort Key: arbeitsort1_.massnahme_id
  • Sort Method: quicksort Memory: 25kB
29. 0.002 0.095 ↓ 0.0 0 3

Bitmap Heap Scan on massnahme2arbeitsort arbeitsort1_ (cost=4.45..19.72 rows=4 width=74) (actual time=0.095..0.095 rows=0 loops=3)

  • Recheck Cond: ((arbeitsort_id)::text = '59ed0a0d-8414-4573-bb56-9c452c037e14'::text)
30. 0.093 0.093 ↓ 0.0 0 3

Bitmap Index Scan on sub_index (cost=0.00..4.45 rows=4 width=0) (actual time=0.093..0.093 rows=0 loops=3)

  • Index Cond: ((arbeitsort_id)::text = '59ed0a0d-8414-4573-bb56-9c452c037e14'::text)
31. 0.000 0.000 ↓ 0.0 0

Index Scan using pflanzenschutz_pkey on pflanzenschutz massnahme0_18_ (cost=0.28..0.31 rows=1 width=565) (never executed)

  • Index Cond: ((massnahme0_.id)::text = (id)::text)
Planning time : 4.984 ms