explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S80j

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

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

2. 0.003 0.085 ↑ 1.0 1 1

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

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

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

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

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

  • Workers Planned: 2
  • Workers Launched: 2
6. 0.098 0.145 ↓ 0.0 0 3

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

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

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

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

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

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

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