explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TwyC

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.121 ↓ 0.0 0 1

Nested Loop (cost=89.24..139,962.67 rows=4 width=3,655) (actual time=0.121..0.121 rows=0 loops=1)

2. 0.002 0.072 ↑ 1.0 1 1

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

3. 0.036 0.036 ↑ 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.035..0.036 rows=1 loops=1)

  • Index Cond: (id = 'e72307a5-e686-4535-8fa2-0dde5cb1b6fe'::text)
  • Heap Fetches: 1
4. 0.034 0.034 ↑ 1.0 1 1

Index Only Scan using objekt_pkey on objekt arbeitsort2_1_ (cost=0.56..8.57 rows=1 width=37) (actual time=0.033..0.034 rows=1 loops=1)

  • Index Cond: (id = 'e72307a5-e686-4535-8fa2-0dde5cb1b6fe'::text)
  • Heap Fetches: 1
5. 0.001 0.047 ↓ 0.0 0 1

Nested Loop Left Join (cost=88.26..139,945.61 rows=4 width=3,692) (actual time=0.047..0.047 rows=0 loops=1)

6. 0.024 0.046 ↓ 0.0 0 1

Hash Join (cost=87.98..139,944.35 rows=4 width=3,164) (actual time=0.046..0.046 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=68.22..139,780.48 rows=19,208 width=3,164) (never executed)

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

Hash Left Join (cost=29.71..139,691.54 rows=19,208 width=3,127) (never executed)

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

Hash Left Join (cost=27.32..139,638.72 rows=19,208 width=3,119) (never executed)

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

Hash Left Join (cost=16.19..139,577.16 rows=19,208 width=2,063) (never executed)

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

Hash Left Join (cost=3.04..139,513.58 rows=19,208 width=2,058) (never executed)

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

Nested Loop (cost=0.56..139,460.66 rows=19,208 width=2,026) (never executed)

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

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

  • Index Cond: ((id)::text = (massnahme0_.id)::text)
15. 0.000 0.000 ↓ 0.0 0

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

16. 0.000 0.000 ↓ 0.0 0

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

17. 0.000 0.000 ↓ 0.0 0

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

18. 0.000 0.000 ↓ 0.0 0

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

19. 0.000 0.000 ↓ 0.0 0

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

20. 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)

21. 0.000 0.000 ↓ 0.0 0

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

22. 0.000 0.000 ↓ 0.0 0

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

23. 0.000 0.000 ↓ 0.0 0

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

24. 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)

25. 0.001 0.022 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
26. 0.002 0.021 ↓ 0.0 0 1

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

  • Recheck Cond: ((arbeitsort_id)::text = 'e72307a5-e686-4535-8fa2-0dde5cb1b6fe'::text)
27. 0.019 0.019 ↓ 0.0 0 1

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

  • Index Cond: ((arbeitsort_id)::text = 'e72307a5-e686-4535-8fa2-0dde5cb1b6fe'::text)
28. 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)