explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rPCMH

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

Nested Loop Left Join (cost=395.07..436.97 rows=1 width=1,117) (actual rows= loops=)

  • Join Filter: ((i1.newtalismainteractionid)::text = (tblemailassignmenthistory.emailinteractionid)::text)
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=383.42..420.95 rows=1 width=1,203) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=383.29..420.72 rows=1 width=993) (actual rows= loops=)

  • Join Filter: (upper((i1.createdby)::text) = upper((u1.userid)::text))
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=383.29..402.60 rows=1 width=981) (actual rows= loops=)

  • Hash Cond: ((bmd.interactionid)::text = (i1.interactionid)::text)
5. 0.000 0.000 ↓ 0.0

Seq Scan on tblinteractionbmddetails bmd (cost=0.00..15.89 rows=389 width=92) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=383.27..383.27 rows=1 width=905) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=366.05..383.27 rows=1 width=905) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=365.91..382.68 rows=3 width=695) (actual rows= loops=)

  • Hash Cond: ((i1.newtalismainteractionid)::text = axe.emailinteractionid)
9. 0.000 0.000 ↓ 0.0

Index Scan using ind_intdet_touchpointid on tblinteractiondetails i1 (cost=0.29..15.84 rows=317 width=53) (actual rows= loops=)

  • Index Cond: (touchpointid = 37)
10. 0.000 0.000 ↓ 0.0

Hash (cost=364.15..364.15 rows=118 width=642) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Subquery Scan on axe (cost=362.68..364.15 rows=118 width=642) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Sort (cost=362.68..362.97 rows=118 width=658) (actual rows= loops=)

  • Sort Key: e.createddate, ((e.emailinteractionid)::text) DESC
13. 0.000 0.000 ↓ 0.0

Append (cost=14.29..358.62 rows=118 width=658) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash Join (cost=14.29..27.39 rows=1 width=246) (actual rows= loops=)

  • Hash Cond: ((m.userid)::text = (e.modifiedby)::text)
15. 0.000 0.000 ↓ 0.0

Seq Scan on usermaster m (cost=0.00..11.68 rows=368 width=20) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Hash (cost=14.28..14.28 rows=1 width=120) (actual rows= loops=)

  • -> Index Scan using ind_emailint_teamid on tblemailinteraction e (cost=0.27..14.28 rows=1 width=120) Index Cond: (teamid = 37)
  • Filter: (((emailinteractionid)::text <> '0'::text) AND CASE WHEN ((mailtype)::text = 'RE'::text) THEN (isreverted AND (date(modifieddate) >= '2020-08-13'::date) AND (date(modifieddate) <= '2020-08-28'::date)) WHEN ((mailtype)::text = 'F'::text) THEN (((isreverted IS NULL) OR isreverted) AND (date(modifieddate) >= '2020-08-13'::date) AND (date(modifieddate) <= '2020-08-28'::date)) ELSE NULL::boolean END)
17. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=44.30..330.63 rows=117 width=282) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash Join (cost=44.30..329.46 rows=117 width=253) (actual rows= loops=)

  • Hash Cond: ((up.createdby)::text = (m_1.userid)::text)
19. 0.000 0.000 ↓ 0.0

Hash Join (cost=28.02..310.70 rows=117 width=156) (actual rows= loops=)

  • Hash Cond: ((i1_1.interactionid)::text = (up.emailinteractionid)::text)
20. 0.000 0.000 ↓ 0.0

Seq Scan on tblinteractiondetails i1_1 (cost=0.00..276.59 rows=281 width=21) (actual rows= loops=)

  • Filter: ((newtalismainteractionid)::text <> '0'::text)
21. 0.000 0.000 ↓ 0.0

Hash (cost=26.98..26.98 rows=83 width=158) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Index Scan using ind_emaildetupd_fromdate on tblinteractionemailstatusupdatedetails up (cost=0.14..26.98 rows=83 width=158) (actual rows= loops=)

  • Index Cond: ((date(fromdate) >= '2020-08-13'::date) AND (date(fromdate) <= '2020-08-28'::date))
23. 0.000 0.000 ↓ 0.0

Hash (cost=11.68..11.68 rows=368 width=20) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Seq Scan on usermaster m_1 (cost=0.00..11.68 rows=368 width=20) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Index Scan using srtmaster_pkey on srtmaster srt (cost=0.14..0.20 rows=1 width=222) (actual rows= loops=)

  • Index Cond: (srtid = i1.srtid)
26. 0.000 0.000 ↓ 0.0

Seq Scan on usermaster u1 (cost=0.00..11.68 rows=368 width=20) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Index Scan using pk_productid on productmaster pro (cost=0.14..0.22 rows=1 width=222) (actual rows= loops=)

  • Index Cond: (productid = i1.productid)
28. 0.000 0.000 ↓ 0.0

HashAggregate (cost=11.65..12.75 rows=110 width=226) (actual rows= loops=)

  • Group Key: tblemailassignmenthistory.emailinteractionid
29. 0.000 0.000 ↓ 0.0

Seq Scan on tblemailassignmenthistory (cost=0.00..11.10 rows=110 width=218) (actual rows= loops=)