explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v1H8

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1.704 ↓ 0.0 0 1

Update on screening_applicant_result_values (cost=3.81..4.83 rows=1 width=92) (actual time=1.703..1.704 rows=0 loops=1)

2. 0.003 1.701 ↓ 0.0 0 1

Bitmap Heap Scan on screening_applicant_result_values (cost=3.81..4.83 rows=1 width=92) (actual time=1.700..1.701 rows=0 loops=1)

  • Recheck Cond: ((screening_applicant_id = 2414816) AND (screening_id = 1463413))
  • Filter: ((cid = 12523) AND (screening_config_preference_type_id = 9))
3. 0.001 1.698 ↓ 0.0 0 1

BitmapAnd (cost=3.81..3.81 rows=1 width=0) (actual time=1.698..1.698 rows=0 loops=1)

4. 1.697 1.697 ↓ 0.0 0 1

Bitmap Index Scan on idx_screening_applicant_result_values_applicant_id (cost=0.00..1.74 rows=42 width=0) (actual time=1.696..1.697 rows=0 loops=1)

  • Index Cond: (screening_applicant_id = 2414816)
5. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_screening_applicant_result_values_screening_id (cost=0.00..1.82 rows=52 width=0) (never executed)

  • Index Cond: (screening_id = 1463413)
Planning time : 0.216 ms