explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ra7u

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

Nested Loop (cost=122,253.87..122,372.77 rows=4 width=3,082) (actual time=734.872..734.872 rows=0 loops=1)

2. 0.002 0.058 ↑ 1.0 1 1

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

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

  • Index Cond: (id = 'e72307a5-e686-4535-8fa2-0dde5cb1b6fe'::text)
  • Heap Fetches: 1
4. 0.022 0.022 ↑ 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.020..0.022 rows=1 loops=1)

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

Gather (cost=122,252.89..122,355.71 rows=4 width=3,119) (actual time=734.812..751.087 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 0.002 720.357 ↓ 0.0 0 3

Merge Join (cost=121,252.89..121,355.31 rows=2 width=3,119) (actual time=720.357..720.357 rows=0 loops=3)

  • Merge Cond: ((massnahme0_.id)::text = (arbeitsort1_.massnahme_id)::text)
7. 0.002 720.320 ↑ 8,003.0 1 3

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

  • Merge Cond: ((massnahme0_.id)::text = (massnahme0_11_.id)::text)
8. 0.002 720.312 ↑ 8,003.0 1 3

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

  • Merge Cond: ((massnahme0_.id)::text = (massnahme0_3_.id)::text)
9. 0.007 720.301 ↑ 8,003.0 1 3

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

  • Merge Cond: ((massnahme0_.id)::text = (massnahme0_2_.id)::text)
10. 15.315 720.209 ↑ 8,003.0 1 3

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

  • Sort Key: massnahme0_.id
  • Sort Method: quicksort Memory: 3656kB
11. 310.945 704.894 ↑ 1.2 6,403 3

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

  • Hash Cond: ((massnahme0_1_.id)::text = (massnahme0_.id)::text)
12. 370.601 370.601 ↑ 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.066..370.601 rows=1,344,200 loops=3)

13. 13.416 23.348 ↑ 1.0 19,208 3

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

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

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

15. 0.049 0.085 ↑ 66.0 1 3

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

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

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

17. 0.003 0.009 ↓ 0.0 0 3

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

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

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

19. 0.002 0.006 ↓ 0.0 0 3

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

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

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

21. 0.005 0.035 ↓ 0.0 0 3

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

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

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

  • Recheck Cond: ((arbeitsort_id)::text = 'e72307a5-e686-4535-8fa2-0dde5cb1b6fe'::text)
23. 0.028 0.028 ↓ 0.0 0 3

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

  • Index Cond: ((arbeitsort_id)::text = 'e72307a5-e686-4535-8fa2-0dde5cb1b6fe'::text)
Planning time : 2.494 ms