explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 41IN

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.229 ↓ 0.0 0 1

Nested Loop (cost=6.40..72.79 rows=4 width=1,989) (actual time=0.229..0.229 rows=0 loops=1)

2. 0.000 0.228 ↓ 0.0 0 1

Nested Loop (cost=5.98..71.07 rows=4 width=758) (actual time=0.228..0.228 rows=0 loops=1)

3. 0.005 0.228 ↓ 0.0 0 1

Nested Loop (cost=5.43..36.78 rows=4 width=37) (actual time=0.228..0.228 rows=0 loops=1)

4. 0.003 0.176 ↑ 1.0 1 1

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

5. 0.115 0.115 ↑ 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.115..0.115 rows=1 loops=1)

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

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

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

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

Bitmap Index Scan on sub_index (cost=0.00..4.45 rows=4 width=0) (actual time=0.039..0.040 rows=0 loops=1)

  • Index Cond: ((arbeitsort_id)::text = 'e72307a5-e686-4535-8fa2-0dde5cb1b6fe'::text)
9. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((id)::text = (arbeitsort1_.massnahme_id)::text)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using index_id on massnahme massnahme0_ (cost=0.41..0.43 rows=1 width=1,305) (never executed)

  • Index Cond: ((id)::text = (massnahme0_1_.id)::text)