explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oUjO

Settings
# exclusive inclusive rows x rows loops node
1. 39.987 55.198 ↓ 11.5 2,096 1

Bitmap Heap Scan on cars (cost=12.54..1,156.95 rows=183 width=4) (actual time=17.067..55.198 rows=2,096 loops=1)

  • Recheck Cond: (((brand)::text = 'BMW'::text) AND ((model_name)::text = '318i'::text) AND ((sales_state)::text = 'onsale'::text))
  • Filter: has_auto_gear
2. 15.211 15.211 ↓ 12.7 7,411 1

Bitmap Index Scan on index_cars_onsale_on_brand_and_model_name (cost=0.00..12.54 rows=585 width=0) (actual time=15.211..15.211 rows=7,411 loops=1)

  • Index Cond: (((brand)::text = 'BMW'::text) AND ((model_name)::text = '318i'::text))