explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JIep : Optimization for: plan #lr8X

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 61.861 77.453 ↓ 1.1 127,896 1

Bitmap Heap Scan on gps_alerts (cost=3,555.36..213,579.54 rows=121,652 width=768) (actual time=18.998..77.453 rows=127,896 loops=1)

  • Recheck Cond: ((truck_number)::text = 'RJ14GF4821'::text)
  • Heap Blocks: exact=22737
2. 15.592 15.592 ↓ 1.1 127,987 1

Bitmap Index Scan on idx_truck (cost=0.00..3,524.95 rows=121,652 width=0) (actual time=15.592..15.592 rows=127,987 loops=1)

  • Index Cond: ((truck_number)::text = 'RJ14GF4821'::text)