explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4iC1

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

Sort (cost=50,986.81..50,986.82 rows=3 width=442) (actual rows= loops=)

  • Sort Key: tblcandidatepoolusers.candidatepooluserid
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..50,986.79 rows=3 width=442) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on tblcandidatepools (cost=0.00..8.01 rows=89 width=99) (actual rows= loops=)

  • Filter: (redeploymentemailtimeup AND (pooltype = 'Redeployment'::nn_pooltypes))
4. 0.000 0.000 ↓ 0.0

Index Scan using fk_tblcandidatepoolusers_candidatepoolid_autoidx on tblcandidatepoolusers (cost=0.28..572.78 rows=1 width=323) (actual rows= loops=)

  • Index Cond: (candidatepoolid = tblcandidatepools.candidatepoolid)
  • Filter: ((pooluserrecruiteddatetime IS NULL) AND (pooluserdeadlinedate <= CURRENT_DATE) AND ((SubPlan 1) = 0))
5.          

SubPlan (forIndex Scan)

6. 0.000 0.000 ↓ 0.0

Aggregate (cost=13.19..13.20 rows=1 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.69..13.19 rows=1 width=0) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..11.30 rows=2 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using fk_comms_group_candidatepooluserid_autoidx on comms_group (cost=0.56..2.60 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (tblcandidatepoolusers.candidatepooluserid = candidatepooluserid)
10. 0.000 0.000 ↓ 0.0

Index Scan using fk_comms_thread_groupid_autoidx on comms_thread (cost=0.56..8.63 rows=7 width=8) (actual rows= loops=)

  • Index Cond: (groupid = comms_group.groupid)
11. 0.000 0.000 ↓ 0.0

Index Scan using fk_comms_message_threadid_autoidx on comms_message (cost=0.56..0.93 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (threadid = comms_thread.threadid)
  • Filter: ((applicationtype = 'NursingNet_Redeployment_Time_Up'::comms_templatetype) AND (commtype = 'Email'::comms_commtype))