explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8MV2

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gps_alerts (cost=3,555.11..213,521.17 rows=121,619 width=768) (actual rows= loops=)

  • Recheck Cond: ((truck_number)::text = 'RJ14GF4821'::text)
2. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_truck (cost=0.00..3,524.70 rows=121,619 width=0) (actual rows= loops=)

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