explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A6Qj

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

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

2. 0.003 0.077 ↑ 1.0 1 1

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

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

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

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

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

  • Workers Planned: 2
  • Workers Launched: 2
6. 0.147 0.206 ↓ 0.0 0 3

Hash Join (cost=955.95..120,762.14 rows=2 width=2,026) (actual time=0.206..0.206 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.001 0.059 ↓ 0.0 0 3

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

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

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

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

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

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