explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zTx8

Settings
# exclusive inclusive rows x rows loops node
1. 1.410 8.643 ↑ 1.4 580 1

Sort (cost=486.15..488.14 rows=799 width=1,629) (actual time=8.427..8.643 rows=580 loops=1)

  • Sort Key: property_name, display_number, bldg_unit, bldg, unit, unit_designation, resident_name, (max(balance)), (sum(CASE WHEN ((is_future = 0) OR ((unit_space_id > 0) AND (row_number = 1))) THEN market_rent ELSE NULL::numeric END)), (sum(CASE WHEN ((is_future = 0) OR ((unit_space_id > 0) AND (row_number = 1))) THEN budgeted_rent ELSE NULL::numeric END)), (sum(COALESCE(actual_charges, '0'::numeric)))
  • Sort Method: quicksort Memory: 321kB
2. 5.797 7.233 ↑ 1.4 580 1

HashAggregate (cost=411.67..447.63 rows=799 width=1,629) (actual time=5.575..7.233 rows=580 loops=1)

  • Group Key: cid, property_id, property_name, lookup_code, display_number, bldg_unit, bldg, unit, unit_designation, floorplan_name, floorplan_id, unit_type, unit_type_id, unit_type_sort, sqft, unit_status, lease_occupancy_type, unit_occupancy_type, unit_space_id, property_unit_id, lease_id, lease_term_name, lease_term, customer_id, student_id_number, resident_name, is_future
3. 1.436 1.436 ↑ 1.0 1,116 1

Seq Scan on rent_roll_temp ctrr (cost=0.00..168.72 rows=1,117 width=1,232) (actual time=0.162..1.436 rows=1,116 loops=1)

  • Filter: (is_reportable AND (cid = 13531) AND (is_future = 0) AND (lease_unit_occupancy_type_id = ANY ('{6,2,1,12,9,10,0}'::integer[])))
  • Rows Removed by Filter: 304