explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xCDL

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

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

2. 0.000 0.177 ↓ 0.0 0 1

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

3. 0.003 0.177 ↓ 0.0 0 1

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

4. 0.001 0.111 ↑ 1.0 1 1

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

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

  • Index Cond: (id = '59ed0a0d-8414-4573-bb56-9c452c037e14'::text)
  • Heap Fetches: 1
6. 0.028 0.028 ↑ 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.028 rows=1 loops=1)

  • Index Cond: (id = '59ed0a0d-8414-4573-bb56-9c452c037e14'::text)
  • Heap Fetches: 1
7. 0.005 0.063 ↓ 0.0 0 1

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

  • Recheck Cond: ((arbeitsort_id)::text = '59ed0a0d-8414-4573-bb56-9c452c037e14'::text)
8. 0.058 0.058 ↓ 0.0 0 1

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

  • Index Cond: ((arbeitsort_id)::text = '59ed0a0d-8414-4573-bb56-9c452c037e14'::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)
Planning time : 2.750 ms