explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6uuk

Settings
# exclusive inclusive rows x rows loops node
1. 0.038 62.034 ↓ 10.0 10 1

Sort (cost=195.78..195.78 rows=1 width=303) (actual time=62.034..62.034 rows=10 loops=1)

  • Sort Key: cusp.property_name, (CASE WHEN (pf.floorplan_name IS NOT NULL) THEN 1 ELSE 2 END), (COALESCE(pf.floorplan_name, 'Unknown'::character varying))
  • Sort Method: quicksort Memory: 27kB
2. 0.137 61.996 ↓ 10.0 10 1

GroupAggregate (cost=195.67..195.77 rows=1 width=303) (actual time=61.887..61.996 rows=10 loops=1)

  • Group Key: cusp.cid, cusp.property_id, cusp.property_name, cusp.property_floorplan_id, pf.floorplan_name
3. 0.198 61.859 ↓ 148.0 148 1

Sort (cost=195.67..195.68 rows=1 width=92) (actual time=61.850..61.859 rows=148 loops=1)

  • Sort Key: cusp.property_id, cusp.property_name, cusp.property_floorplan_id, pf.floorplan_name
  • Sort Method: quicksort Memory: 60kB
4. 0.054 61.661 ↓ 148.0 148 1

Nested Loop Left Join (cost=85.83..195.66 rows=1 width=92) (actual time=18.840..61.661 rows=148 loops=1)

5. 0.049 61.459 ↓ 148.0 148 1

Nested Loop Left Join (cost=85.70..195.42 rows=1 width=88) (actual time=18.831..61.459 rows=148 loops=1)

6. 0.194 61.114 ↓ 148.0 148 1

Nested Loop Left Join (cost=85.56..195.13 rows=1 width=72) (actual time=18.813..61.114 rows=148 loops=1)

7. 0.205 59.440 ↓ 148.0 148 1

Nested Loop (cost=85.28..191.54 rows=1 width=58) (actual time=18.328..59.440 rows=148 loops=1)

8. 0.328 27.415 ↓ 37.0 148 1

Merge Join (cost=84.84..157.73 rows=4 width=61) (actual time=17.422..27.415 rows=148 loops=1)

  • Merge Cond: (pu.id = cusp.property_unit_id)
9. 26.911 26.911 ↑ 1.5 1,736 1

Index Only Scan using pk_property_units on property_units pu (cost=0.29..5,751.59 rows=2,555 width=8) (actual time=0.064..26.911 rows=1,736 loops=1)

  • Index Cond: (cid = 224)
  • Heap Fetches: 1,736
10. 0.114 0.176 ↑ 1.0 148 1

Sort (cost=10.18..10.55 rows=148 width=69) (actual time=0.147..0.176 rows=148 loops=1)

  • Sort Key: cusp.property_unit_id
  • Sort Method: quicksort Memory: 45kB
11. 0.062 0.062 ↑ 1.0 148 1

Seq Scan on cached_unit_space_periods_temp cusp (cost=0.00..4.85 rows=148 width=69) (actual time=0.011..0.062 rows=148 loops=1)

  • Filter: (cid = 224)
12. 31.820 31.820 ↑ 1.0 1 148

Index Scan using pk_unit_space_logs on unit_space_logs usl (cost=0.43..8.45 rows=1 width=9) (actual time=0.215..0.215 rows=1 loops=148)

  • Index Cond: ((cid = 224) AND (id = cusp.unit_space_log_id))
13. 1.480 1.480 ↑ 1.0 1 148

Index Scan using pk_property_floorplans on property_floorplans pf (cost=0.28..3.55 rows=1 width=22) (actual time=0.010..0.010 rows=1 loops=148)

  • Index Cond: ((cid = cusp.cid) AND (cid = 224) AND (id = cusp.property_floorplan_id))
14. 0.296 0.296 ↑ 1.0 1 148

Index Scan using idx_move_in_move_out_data_temp_unit_space_id on move_in_move_out_data_temp mimod (cost=0.14..0.28 rows=1 width=24) (actual time=0.001..0.002 rows=1 loops=148)

  • Index Cond: (unit_space_id = cusp.unit_space_id)
  • Filter: ((cid = 224) AND (cid = cusp.cid))
15. 0.148 0.148 ↓ 0.0 0 148

Index Scan using idx_maintenance_data_temp_unit_space_id on maintenance_data_temp md (cost=0.13..0.23 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=148)

  • Index Cond: (unit_space_id = cusp.unit_space_id)
  • Filter: ((cid = 224) AND (cid = cusp.cid))