explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4XkD

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

Aggregate (cost=2,190,579.18..2,190,579.19 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mvw_summary_view summ (cost=173,944.21..2,172,779.52 rows=7,119,862 width=0) (actual rows= loops=)

  • Recheck Cond: ((administrative_area = 'California'::text) OR (administrative_area = 'New York'::text) OR (administrative_area = 'Texas'::text) OR (administrative_area = 'Florida'::text))
  • Filter: (type = ANY ('{building,land}'::property_type_enum[]))
3. 0.000 0.000 ↓ 0.0

BitmapOr (cost=173,944.21..173,944.21 rows=7,862,147 width=0) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mix11_mvw_administrative_area (cost=0.00..42,987.38 rows=2,025,975 width=0) (actual rows= loops=)

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

Bitmap Index Scan on mix11_mvw_administrative_area (cost=0.00..28,446.59 rows=1,340,537 width=0) (actual rows= loops=)

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

Bitmap Index Scan on mix11_mvw_administrative_area (cost=0.00..67,629.54 rows=3,187,331 width=0) (actual rows= loops=)

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

Bitmap Index Scan on mix11_mvw_administrative_area (cost=0.00..27,760.84 rows=1,308,304 width=0) (actual rows= loops=)

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