explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C5uS

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

Nested Loop (cost=1,956.93..121,779.61 rows=4 width=1,989) (actual time=17.964..17.964 rows=0 loops=1)

2. 0.002 0.099 ↑ 1.0 1 1

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

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

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

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

Gather (cost=1,955.95..121,762.54 rows=4 width=2,026) (actual time=17.862..21.016 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 0.172 0.229 ↓ 0.0 0 3

Hash Join (cost=955.95..120,762.14 rows=2 width=2,026) (actual time=0.229..0.229 rows=0 loops=3)

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

Hash Join (cost=936.18..120,682.33 rows=8,003 width=2,026) (never executed)

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

Parallel Seq Scan on objekt massnahme0_1_ (cost=0.00..115,335.50 rows=1,680,250 width=721) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Hash (cost=696.08..696.08 rows=19,208 width=1,305) (never executed)

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

11. 0.000 0.057 ↓ 0.0 0 3

Hash (cost=19.72..19.72 rows=4 width=74) (actual time=0.057..0.057 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
12. 0.005 0.057 ↓ 0.0 0 3

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

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

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

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