explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QIj9

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

Hash Semi Join (cost=27,204.83..90,395.28 rows=419 width=5) (actual rows= loops=)

  • Hash Cond: ((used_vehicles_usedcarinventory.dealer_zipcode)::text = (u0.zipcode)::text)
2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on used_vehicles_usedcarinventory (cost=25,904.34..89,068.15 rows=8,371 width=5) (actual rows= loops=)

  • Recheck Cond: (model_id = ANY ('{1120,1282,2329,1197,1425,1145}'::integer[]))
  • Filter: ((NOT removed) AND ((condition)::text = 'Pre-Owned'::text) AND (lead_provider_id = ANY ('{1,2,3,4,6}'::integer[])) AND (year_id = ANY ('{1,2,3,33,30,31}'::integer[])))
3. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=25,904.34..25,904.34 rows=17,482 width=0) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on used_vehicles_usedcarinventory_removed_eca6c46f (cost=0.00..9,426.01 rows=328,210 width=0) (actual rows= loops=)

  • Index Cond: (removed = false)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on used_vehicles_usedcarinventory_477cbf8a (cost=0.00..16,473.89 rows=484,703 width=0) (actual rows= loops=)

  • Index Cond: (model_id = ANY ('{1120,1282,2329,1197,1425,1145}'::integer[]))
6. 0.000 0.000 ↓ 0.0

Hash (cost=1,298.36..1,298.36 rows=171 width=6) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on extralibs_zipcode u0 (cost=0.00..1,298.36 rows=171 width=6) (actual rows= loops=)

  • Filter: ((longitude >= '-82.4986548'::numeric) AND (longitude <= '-77.6599452'::numeric) AND (latitude >= 24.0370452) AND (latitude <= 28.8757548))