explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nTDW

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

Aggregate (cost=744,415.96..744,415.97 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mvw_sales_view sales (cost=156,777.12..727,808.58 rows=6,642,950 width=16) (actual rows= loops=)

  • Recheck Cond: (((administrative_area)::text = 'California'::text) OR ((administrative_area)::text = 'New York'::text) OR ((administrative_area)::text = 'Texas'::text) OR ((administrative_area)::text = 'Florida'::text))
3. 0.000 0.000 ↓ 0.0

BitmapOr (cost=156,777.12..156,777.12 rows=7,280,523 width=0) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mix1_mvw_sales_view_administrative_area (cost=0.00..54,101.65 rows=2,623,612 width=0) (actual rows= loops=)

  • Index Cond: ((administrative_area)::text = 'California'::text)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mix1_mvw_sales_view_administrative_area (cost=0.00..42,585.04 rows=2,065,130 width=0) (actual rows= loops=)

  • Index Cond: ((administrative_area)::text = 'New York'::text)
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mix1_mvw_sales_view_administrative_area (cost=0.00..21,523.99 rows=1,043,657 width=0) (actual rows= loops=)

  • Index Cond: ((administrative_area)::text = 'Texas'::text)
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mix1_mvw_sales_view_administrative_area (cost=0.00..31,923.49 rows=1,548,124 width=0) (actual rows= loops=)

  • Index Cond: ((administrative_area)::text = 'Florida'::text)