explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S4Ur

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

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

  • Output: rel_users_exams.user_username, rel_users_exams.exam_id, rel_users_exams.started_at, rel_users_exams.finished_at, exam_1.id, exam_1.title, exam_1.date_from, exam_1.date_to, exam_1.created, exam_1.created_by_, exam_1.duration, exam_1.success_threshold, exam_1.published
  • Inner Unique: true
  • Join Filter: (exam_1.id = rel_users_exams.exam_id)
  • Buffers: shared hit=1
2. 0.004 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on public.rel_users_exams (cost=11.80..20.27 rows=5 width=52) (actual time=0.009..0.009 rows=0 loops=1)

  • Output: rel_users_exams.user_username, rel_users_exams.exam_id, rel_users_exams.started_at, rel_users_exams.finished_at
  • Recheck Cond: (1 = rel_users_exams.exam_id)
  • Buffers: shared hit=1
3. 0.005 0.005 ↓ 0.0 0 1

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

  • Index Cond: (1 = rel_users_exams.exam_id)
  • Buffers: shared hit=1
4. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.15..8.17 rows=1 width=105) (never executed)

  • Output: exam_1.id, exam_1.title, exam_1.date_from, exam_1.date_to, exam_1.created, exam_1.created_by_, exam_1.duration, exam_1.success_threshold, exam_1.published
5. 0.000 0.000 ↓ 0.0 0

Index Scan using exam_pkey on public.exam exam_1 (cost=0.15..8.17 rows=1 width=105) (never executed)

  • Output: exam_1.id, exam_1.title, exam_1.date_from, exam_1.date_to, exam_1.created, exam_1.created_by_, exam_1.duration, exam_1.success_threshold, exam_1.published
  • Index Cond: (exam_1.id = 1)
Planning time : 1.110 ms
Execution time : 0.170 ms