explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q2Uw

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

Nested Loop Left Join (cost=11.95..28.52 rows=5 width=157) (actual rows= loops=)

  • Join Filter: (exam_1.id = rel_users_exams.exam_id)
2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on rel_users_exams (cost=11.80..20.27 rows=5 width=52) (actual rows= loops=)

  • Recheck Cond: (1 = exam_id)
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on rel_users_exams_pkey (cost=0.00..11.80 rows=5 width=0) (actual rows= loops=)

  • Index Cond: (1 = exam_id)
4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.15..8.17 rows=1 width=105) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using exam_pkey on exam exam_1 (cost=0.15..8.17 rows=1 width=105) (actual rows= loops=)

  • Index Cond: (id = 1)