explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J1rp

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 160.525 ↓ 0.0 0 1

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

  • Sort Key: tblcandidatepoolusers.candidatepooluserid
  • Sort Method: quicksort Memory: 25kB
2. 0.055 160.506 ↓ 0.0 0 1

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

3. 0.089 0.089 ↑ 1.5 59 1

Seq Scan on tblcandidatepools (cost=0.00..8.01 rows=89 width=99) (actual time=0.006..0.089 rows=59 loops=1)

  • Filter: (redeploymentemailtimeup AND (pooltype = 'Redeployment'::nn_pooltypes))
  • Rows Removed by Filter: 185
4. 2.169 160.362 ↓ 0.0 0 59

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

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

SubPlan (forIndex Scan)

6. 0.729 158.193 ↑ 1.0 1 729

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

7. 0.735 157.464 ↑ 1.0 1 729

Nested Loop (cost=1.69..13.19 rows=1 width=0) (actual time=0.061..0.216 rows=1 loops=729)

8. 1.458 32.805 ↑ 1.0 2 729

Nested Loop (cost=1.12..11.30 rows=2 width=4) (actual time=0.032..0.045 rows=2 loops=729)

9. 9.477 9.477 ↑ 1.0 1 729

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

  • Index Cond: (tblcandidatepoolusers.candidatepooluserid = candidatepooluserid)
10. 21.870 21.870 ↑ 3.5 2 729

Index Scan using fk_comms_thread_groupid_autoidx on comms_thread (cost=0.56..8.63 rows=7 width=8) (actual time=0.018..0.030 rows=2 loops=729)

  • Index Cond: (groupid = comms_group.groupid)
11. 123.924 123.924 ↓ 0.0 0 1,796

Index Scan using fk_comms_message_threadid_autoidx on comms_message (cost=0.56..0.93 rows=1 width=4) (actual time=0.027..0.069 rows=0 loops=1,796)

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