explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6q9L

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2,728.874 ↓ 0.0 0 1

Group (cost=148.50..148.51 rows=1 width=8) (actual time=2,728.874..2,728.874 rows=0 loops=1)

  • Group Key: cal.cid, cal.lease_id
2. 0.004 2,728.873 ↓ 0.0 0 1

Sort (cost=148.50..148.51 rows=1 width=8) (actual time=2,728.873..2,728.873 rows=0 loops=1)

  • Sort Key: cal.cid, cal.lease_id
  • Sort Method: quicksort Memory: 25kB
3. 0.003 2,728.869 ↓ 0.0 0 1

Nested Loop (cost=0.96..148.49 rows=1 width=8) (actual time=2,728.869..2,728.869 rows=0 loops=1)

4. 0.101 2,728.857 ↑ 1.0 1 1

Nested Loop (cost=0.81..148.30 rows=1 width=12) (actual time=1,112.805..2,728.857 rows=1 loops=1)

5. 62.642 62.642 ↓ 242.0 242 1

Function Scan on load_properties lp (cost=0.25..2.12 rows=1 width=8) (actual time=62.309..62.642 rows=242 loops=1)

  • Filter: ((is_student_property = 1) AND (is_test = 0) AND (is_disabled = 0))
  • Rows Removed by Filter: 1,873
6. 2,666.114 2,666.114 ↓ 0.0 0 242

Index Scan using idx_cached_application_logs_temp on cached_application_logs cal (cost=0.56..146.15 rows=1 width=12) (actual time=11.002..11.017 rows=0 loops=242)

  • 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: 5,707
7. 0.009 0.009 ↓ 0.0 0 1

Index Scan using pk_clients on clients c (cost=0.14..0.19 rows=1 width=4) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = cal.cid)
  • Filter: (company_status_type_id = 4)
  • Rows Removed by Filter: 1
Planning time : 0.644 ms
Execution time : 2,728.997 ms