explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pT5Y

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

Aggregate (cost=3,973,637.46..3,973,637.47 rows=1 width=8) (actual rows= loops=)

2.          

CTE cte

3. 0.000 0.000 ↓ 0.0

Unique (cost=0.56..1,610,437.52 rows=729,039 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using mix1_mvw_sales_view_id on mvw_sales_view sales (cost=0.56..1,593,761.76 rows=6,670,301 width=16) (actual rows= loops=)

  • Filter: (((administrative_area)::text = 'California'::text) OR ((administrative_area)::text = 'New York'::text) OR ((administrative_area)::text = 'Texas'::text) OR ((administrative_area)::text = 'Florida'::text))
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,296,255.18..2,362,743.69 rows=182,504 width=0) (actual rows= loops=)

  • Hash Cond: (sl.id = summ.id)
6. 0.000 0.000 ↓ 0.0

CTE Scan on cte sl (cost=0.00..14,580.78 rows=729,039 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=2,172,506.79..2,172,506.79 rows=7,118,991 width=16) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mvw_summary_view summ (cost=173,916.13..2,172,506.79 rows=7,118,991 width=16) (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[]))
9. 0.000 0.000 ↓ 0.0

BitmapOr (cost=173,916.13..173,916.13 rows=7,861,185 width=0) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

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

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

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

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

Bitmap Index Scan on mix11_mvw_administrative_area (cost=0.00..67,618.62 rows=3,186,941 width=0) (actual rows= loops=)

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

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

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