explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YWAL

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

Nested Loop (cost=0.28..9,763.48 rows=1 width=482) (actual rows= loops=)

  • Join Filter: (tblcandidatepoolusers.candidatepoolid = tblcandidatepools.candidatepoolid)
2. 0.000 0.000 ↓ 0.0

Index Scan using tblcandidatepoolusers_pkey on tblcandidatepoolusers (cost=0.28..9,758.01 rows=1 width=379) (actual rows= loops=)

  • Filter: ((pooluserrecruiteddatetime IS NULL) AND (pooluserdeadlinedate <= CURRENT_DATE) AND ((SubPlan 1) = 0))
3.          

SubPlan (for Index Scan)

4. 0.000 0.000 ↓ 0.0

Aggregate (cost=17.69..17.70 rows=1 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.28..17.69 rows=1 width=0) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..14.03 rows=6 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

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

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

Index Scan using fk_comms_thread_groupid_autoidx on comms_thread (cost=0.43..11.47 rows=10 width=8) (actual rows= loops=)

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

Index Scan using fk_comms_message_threadid_autoidx on comms_message (cost=0.43..0.60 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))
10. 0.000 0.000 ↓ 0.0

Seq Scan on tblcandidatepools (cost=0.00..4.69 rows=56 width=83) (actual rows= loops=)

  • Filter: (redeploymentemailtimeup AND (pooltype = 'Redeployment'::nn_pooltypes))