explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cw9x

Settings
# exclusive inclusive rows x rows loops node
1. 7.360 443.353 ↓ 1.6 662 1

Hash Semi Join (cost=27,204.83..90,395.28 rows=419 width=5) (actual time=265.331..443.353 rows=662 loops=1)

  • Hash Cond: ((used_vehicles_usedcarinventory.dealer_zipcode)::text = (u0.zipcode)::text)
2. 180.746 426.011 ↓ 2.6 21,360 1

Bitmap Heap Scan on used_vehicles_usedcarinventory (cost=25,904.34..89,068.15 rows=8,371 width=5) (actual time=252.914..426.011 rows=21,360 loops=1)

  • 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[])))
  • Rows Removed by Filter: 10183
  • Heap Blocks: exact=26399
3. 54.620 245.265 ↓ 0.0 0 1

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

4. 79.212 79.212 ↓ 1.2 399,909 1

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

  • Index Cond: (removed = false)
5. 111.433 111.433 ↓ 1.2 560,727 1

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

  • Index Cond: (model_id = ANY ('{1120,1282,2329,1197,1425,1145}'::integer[]))
6. 0.262 9.982 ↓ 5.1 869 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 41kB
7. 9.720 9.720 ↓ 5.1 869 1

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

  • Filter: ((longitude >= '-82.4986548'::numeric) AND (longitude <= '-77.6599452'::numeric) AND (latitude >= 24.0370452) AND (latitude <= 28.8757548))
  • Rows Removed by Filter: 40049
Planning time : 0.633 ms
Execution time : 444.272 ms