explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uizq

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

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

  • Buffers: shared hit=1
2. 0.002 0.006 ↓ 0.0 0 1

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

  • Buffers: shared hit=1
3. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on rel_users_exams_pkey (cost=0..11.8 rows=5 width=0) (actual time=0.003..0.004 rows=0 loops=1)

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

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

5. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (exam_1.id = 1)