explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hoDP

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 259,434.358 ↓ 1.5 3 1

Group (cost=2,222.47..2,222.48 rows=2 width=8) (actual time=259,434.356..259,434.358 rows=3 loops=1)

  • Group Key: cal.cid, cal.lease_id
2. 0.038 259,434.355 ↓ 1.5 3 1

Sort (cost=2,222.47..2,222.47 rows=2 width=8) (actual time=259,434.354..259,434.355 rows=3 loops=1)

  • Sort Key: cal.cid, cal.lease_id
  • Sort Method: quicksort Memory: 25kB
3. 0.017 259,434.317 ↓ 1.5 3 1

Nested Loop (cost=0.96..2,222.46 rows=2 width=8) (actual time=12,201.935..259,434.317 rows=3 loops=1)

4. 0.122 259,434.267 ↑ 2.7 3 1

Nested Loop (cost=0.81..2,220.99 rows=8 width=12) (actual time=12,201.911..259,434.267 rows=3 loops=1)

5. 29.729 29.729 ↓ 38.0 38 1

Function Scan on load_properties lp (cost=0.25..2.12 rows=1 width=8) (actual time=29.607..29.729 rows=38 loops=1)

  • Filter: ((is_student_property = 1) AND (is_test = 0) AND (is_disabled = 0))
  • Rows Removed by Filter: 512
6. 259,404.416 259,404.416 ↓ 0.0 0 38

Index Scan using idx_cached_application_logs_temp on cached_application_logs cal (cost=0.56..2,218.57 rows=10 width=12) (actual time=5,389.689..6,826.432 rows=0 loops=38)

  • Index Cond: ((cid = lp.cid) AND (property_id = lp.property_id))
  • Filter: ((application_stage_id >= 3) AND (application_stage_id >= 3) AND ((details ->> 'application_name'::text) = 'product_id:2|module:application_roommate|action:update_roommate'::text))
  • Rows Removed by Filter: 104,781
7. 0.033 0.033 ↑ 1.0 1 3

Index Scan using pk_clients on clients c (cost=0.14..0.18 rows=1 width=4) (actual time=0.011..0.011 rows=1 loops=3)

  • Index Cond: (id = cal.cid)
  • Filter: (company_status_type_id = 4)
Planning time : 3.171 ms
Execution time : 259,435.178 ms