explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ztnR

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 7.788 ↓ 0.0 0 1

Sort (cost=51,015.33..51,015.33 rows=1 width=442) (actual time=7.788..7.788 rows=0 loops=1)

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

Nested Loop (cost=0.28..51,015.32 rows=1 width=442) (actual time=7.778..7.778 rows=0 loops=1)

3. 0.103 0.103 ↑ 1.5 59 1

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

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

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

  • Index Cond: (candidatepoolid = tblcandidatepools.candidatepoolid)
  • Filter: ((pooluserrecruiteddatetime IS NULL) AND (pooluserdeadlinedate <= CURRENT_DATE) AND (pooluserdeadlinedate >= (CURRENT_DATE - '2 days'::interval day)) AND ((SubPlan 1) = 0))
  • Rows Removed by Filter: 15
5.          

SubPlan (forIndex Scan)

6. 0.012 1.758 ↑ 1.0 1 3

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

7. 0.018 1.746 ↑ 1.0 1 3

Nested Loop (cost=1.69..13.19 rows=1 width=0) (actual time=0.356..0.582 rows=1 loops=3)

8. 0.015 0.480 ↓ 1.5 3 3

Nested Loop (cost=1.12..11.30 rows=2 width=4) (actual time=0.128..0.160 rows=3 loops=3)

9. 0.213 0.213 ↑ 1.0 1 3

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

  • Index Cond: (tblcandidatepoolusers.candidatepooluserid = candidatepooluserid)
10. 0.252 0.252 ↑ 2.3 3 3

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

  • Index Cond: (groupid = comms_group.groupid)
11. 1.248 1.248 ↓ 0.0 0 8

Index Scan using fk_comms_message_threadid_autoidx on comms_message (cost=0.56..0.93 rows=1 width=4) (actual time=0.096..0.156 rows=0 loops=8)

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