explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SyeH

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

Nested Loop (cost=224.02..1,411.22 rows=4 width=3,655) (actual time=0.126..0.126 rows=0 loops=1)

2. 0.003 0.126 ↓ 0.0 0 1

Nested Loop (cost=223.46..1,382.32 rows=4 width=3,008) (actual time=0.125..0.126 rows=0 loops=1)

3. 0.001 0.097 ↑ 1.0 1 1

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

4. 0.054 0.054 ↑ 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.053..0.054 rows=1 loops=1)

  • Index Cond: (id = '59ed0a0d-8414-4573-bb56-9c452c037e14'::text)
  • Heap Fetches: 1
5. 0.042 0.042 ↑ 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.041..0.042 rows=1 loops=1)

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

Hash Join (cost=222.48..1,365.25 rows=4 width=3,045) (actual time=0.026..0.026 rows=0 loops=1)

  • Hash Cond: ((massnahme0_.id)::text = (arbeitsort1_.massnahme_id)::text)
7. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=202.72..1,201.39 rows=19,208 width=2,971) (never executed)

  • Hash Cond: ((massnahme0_.id)::text = (massnahme0_18_.id)::text)
8. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=67.66..1,015.90 rows=19,208 width=2,443) (never executed)

  • Hash Cond: ((massnahme0_.id)::text = (massnahme0_14_.id)::text)
9. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=29.16..926.96 rows=19,208 width=2,406) (never executed)

  • Hash Cond: ((massnahme0_.id)::text = (massnahme0_13_.id)::text)
10. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=26.76..874.14 rows=19,208 width=2,398) (never executed)

  • Hash Cond: ((massnahme0_.id)::text = (massnahme0_11_.id)::text)
11. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=15.64..812.58 rows=19,208 width=1,342) (never executed)

  • Hash Cond: ((massnahme0_.id)::text = (massnahme0_3_.id)::text)
12. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2.49..749.00 rows=19,208 width=1,337) (never executed)

  • Hash Cond: ((massnahme0_.id)::text = (massnahme0_2_.id)::text)
13. 0.000 0.000 ↓ 0.0 0

Seq Scan on massnahme massnahme0_ (cost=0.00..696.08 rows=19,208 width=1,305) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.66..1.66 rows=66 width=69) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Seq Scan on bonitierung massnahme0_2_ (cost=0.00..1.66 rows=66 width=69) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Hash (cost=11.40..11.40 rows=140 width=521) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on beregnung massnahme0_3_ (cost=0.00..11.40 rows=140 width=521) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.50..10.50 rows=50 width=1,572) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Seq Scan on ernte massnahme0_11_ (cost=0.00..10.50 rows=50 width=1,572) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.62..1.62 rows=62 width=45) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Seq Scan on wartung massnahme0_13_ (cost=0.00..1.62 rows=62 width=45) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Hash (cost=23.78..23.78 rows=1,178 width=74) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Seq Scan on erntegutbergung massnahme0_14_ (cost=0.00..23.78 rows=1,178 width=74) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Hash (cost=80.58..80.58 rows=4,358 width=565) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Seq Scan on pflanzenschutz massnahme0_18_ (cost=0.00..80.58 rows=4,358 width=565) (never executed)

26. 0.001 0.018 ↓ 0.0 0 1

Hash (cost=19.72..19.72 rows=4 width=74) (actual time=0.018..0.018 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
27. 0.002 0.017 ↓ 0.0 0 1

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

  • Recheck Cond: ((arbeitsort_id)::text = '59ed0a0d-8414-4573-bb56-9c452c037e14'::text)
28. 0.015 0.015 ↓ 0.0 0 1

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

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

Index Scan using id_index on objekt massnahme0_1_ (cost=0.56..7.22 rows=1 width=721) (never executed)

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