explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HIUZ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 1.224 ↑ 1.0 1 1

Limit (cost=13.18..13.18 rows=1 width=86) (actual time=1.222..1.224 rows=1 loops=1)

2. 1.174 1.222 ↑ 1.0 1 1

Sort (cost=13.18..13.18 rows=1 width=86) (actual time=1.221..1.222 rows=1 loops=1)

  • Sort Key: effective_date DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.009 0.048 ↑ 1.0 1 1

Bitmap Heap Scan on t_uw_exceptions uwexceptio0_ (cost=9.15..13.17 rows=1 width=86) (actual time=0.047..0.048 rows=1 loops=1)

  • Recheck Cond: ((chassis_number)::text = 'MB1HTLHD1JPGC2738'::text)
  • Filter: (((engine_number)::text ~~ 'JGPZ110428'::text) AND ((vehicle_type)::text = '14'::text) AND ((product_code)::text = '20302'::text))
  • Heap Blocks: exact=1
4. 0.001 0.039 ↓ 0.0 0 1

BitmapAnd (cost=9.15..9.15 rows=1 width=0) (actual time=0.039..0.039 rows=0 loops=1)

5. 0.028 0.028 ↑ 4.0 1 1

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

  • Index Cond: ((engine_number)::text = 'JGPZ110428'::text)
6. 0.010 0.010 ↑ 4.0 1 1

Bitmap Index Scan on t_uw_exceptions_ix2 (cost=0.00..4.45 rows=4 width=0) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: ((chassis_number)::text = 'MB1HTLHD1JPGC2738'::text)
Planning time : 0.183 ms
Execution time : 1.282 ms