explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rlIu

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 7,623.053 ↓ 40.0 40 1

Limit (cost=26,566.35..26,566.42 rows=1 width=389) (actual time=7,622.999..7,623.053 rows=40 loops=1)

2. 0.030 7,623.019 ↓ 42.0 42 1

Unique (cost=26,566.27..26,566.35 rows=1 width=389) (actual time=7,622.987..7,623.019 rows=42 loops=1)

3. 18.921 7,622.989 ↓ 42.0 42 1

Sort (cost=26,566.27..26,566.27 rows=1 width=389) (actual time=7,622.986..7,622.989 rows=42 loops=1)

  • Sort Key: i.incidentstatusid, i.incidentid, a.assetid, a.name, i.createdat, ielh.setat, ish.setat, pt.protectiontypeid, i.enforcementlevelid, d.domainid, d.url, dp.name, dl.highrisk, (CASE WHEN (dlw.detectionlinkwatcherid IS NOT NULL) THEN true ELSE false END), l.url, les.enforcementstatusid, lesh.setat, cl.url, cles.enforcementstatusid, clesh.setat, sl.url, sles.enforcementstatusid, slesh.setat, el.url, eles.enforcementstatusid, elesh.setat, tdl.url, tdles.enforcementstatusid, tdlesh.setat
  • Sort Method: quicksort Memory: 3,520kB
4. 17.103 7,604.068 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=5.59..26,566.26 rows=1 width=389) (actual time=23.963..7,604.068 rows=11,868 loops=1)

  • Filter: (((cd.customerdivisionid IS NOT NULL) AND (dcd.domainid IS NOT NULL) AND (cc.scopeid IS NOT NULL) AND (ccd.contractid IS NOT NULL)) OR (cd.customerdivisionid IS NULL))
5. 7.801 7,586.965 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=5.44..26,558.08 rows=1 width=404) (actual time=23.944..7,586.965 rows=11,868 loops=1)

  • Join Filter: ((c.contractid = ccd.contractid) AND (ccd.customerdivisionid = cd.customerdivisionid))
6. 7.668 7,567.296 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=5.29..26,549.90 rows=1 width=404) (actual time=23.929..7,567.296 rows=11,868 loops=1)

  • Join Filter: ((d.domainid = dcd.domainid) AND (dcd.customerdivisionid = cd.customerdivisionid))
7. 22.190 7,559.628 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=5.29..26,538.15 rows=1 width=400) (actual time=23.924..7,559.628 rows=11,868 loops=1)

  • Join Filter: (cd.customerid = c.customerid)
  • Filter: ((public.parseintarg(NULL::bytea) IS NULL) OR (cd.customerdivisionid = public.parseintarg(NULL::bytea)))
8. 58.078 7,525.570 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=5.16..26,529.48 rows=1 width=400) (actual time=23.906..7,525.570 rows=11,868 loops=1)

  • Filter: (((public.parsedatearg(NULL::bytea) IS NULL) OR (ish.setat >= public.parsedatearg(NULL::bytea))) AND ((public.parsedatearg(NULL::bytea) IS NULL) OR (ish.setat < public.parsedatearg(NULL::bytea))))
9. 16.624 7,443.756 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=4.73..26,511.47 rows=1 width=392) (actual time=23.879..7,443.756 rows=11,868 loops=1)

  • Join Filter: (dlw.detectionlinkid = dl.detectionlinkid)
  • Filter: ((public.parseboolarg(NULL::bytea) IS NULL) OR ((public.parseboolarg(NULL::bytea) IS TRUE) AND (dlw.detectionlinkwatcherid IS NOT NULL)) OR ((public.parseboolarg(NULL::bytea) IS FALSE) AND (dlw.detectionlinkwatcherid IS NULL)))
10. 16.221 7,403.396 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=4.73..26,509.53 rows=1 width=392) (actual time=23.868..7,403.396 rows=11,868 loops=1)

  • Join Filter: (tdlesh.enforcementstatusid = l.enforcementstatusid)
11. 43.042 7,387.175 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=4.30..26,496.41 rows=1 width=392) (actual time=23.853..7,387.175 rows=11,868 loops=1)

  • Join Filter: (tdles.enforcementstatusid = tdl.enforcementstatusid)
  • Rows Removed by Join Filter: 118,091
  • Filter: (((public.buildintarray(NULL::bytea) IS NULL) OR (les.enforcementstatusid = ANY (public.buildintarray(NULL::bytea))) OR (cles.enforcementstatusid = ANY (public.buildintarray(NULL::bytea))) OR (sles.enforcementstatusid = ANY (public.buildintarray(NULL::bytea))) OR (eles.enforcementstatusid = ANY (public.buildintarray(NULL::bytea))) OR (tdles.enforcementstatusid = ANY (public.buildintarray(NULL::bytea)))) AND ((public.buildintarray(NULL::bytea) IS NULL) OR (les.enforcementstatusgroupid = ANY (public.buildintarray(NULL::bytea))) OR (cles.enforcementstatusgroupid = ANY (public.buildintarray(NULL::bytea))) OR (sles.enforcementstatusgroupid = ANY (public.buildintarray(NULL::bytea))) OR (eles.enforcementstatusgroupid = ANY (public.buildintarray(NULL::bytea))) OR (tdles.enforcementstatusgroupid = ANY (public.buildintarray(NULL::bytea)))))
12. 15.971 7,332.265 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=4.30..26,463.93 rows=1 width=408) (actual time=23.841..7,332.265 rows=11,868 loops=1)

  • Join Filter: (elesh.enforcementstatusid = l.enforcementstatusid)
13. 17.264 7,316.294 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=3.87..26,447.01 rows=1 width=404) (actual time=23.828..7,316.294 rows=11,868 loops=1)

  • Join Filter: (eles.enforcementstatusid = el.enforcementstatusid)
  • Rows Removed by Join Filter: 118,680
14. 15.032 7,287.162 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=3.87..26,445.79 rows=1 width=400) (actual time=23.821..7,287.162 rows=11,868 loops=1)

  • Join Filter: (slesh.enforcementstatusid = l.enforcementstatusid)
15. 17.543 7,272.130 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=3.44..26,428.87 rows=1 width=396) (actual time=23.807..7,272.130 rows=11,868 loops=1)

  • Join Filter: (sles.enforcementstatusid = sl.enforcementstatusid)
  • Rows Removed by Join Filter: 118,680
16. 18.239 7,242.719 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=3.44..26,427.64 rows=1 width=392) (actual time=23.800..7,242.719 rows=11,868 loops=1)

  • Join Filter: (clesh.enforcementstatusid = l.enforcementstatusid)
17. 13.773 7,212.612 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=3.01..26,412.70 rows=1 width=388) (actual time=23.780..7,212.612 rows=11,868 loops=1)

  • Join Filter: (cles.enforcementstatusid = cl.enforcementstatusid)
  • Rows Removed by Join Filter: 82,515
18. 19.323 7,186.971 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=3.01..26,411.47 rows=1 width=384) (actual time=23.774..7,186.971 rows=11,868 loops=1)

19. 13.988 7,143.912 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=2.59..26,399.10 rows=1 width=380) (actual time=23.752..7,143.912 rows=11,868 loops=1)

  • Join Filter: (les.enforcementstatusid = l.enforcementstatusid)
  • Rows Removed by Join Filter: 59,004
20. 15.080 7,118.056 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=2.59..26,397.87 rows=1 width=372) (actual time=23.745..7,118.056 rows=11,868 loops=1)

21. 13.142 7,102.976 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=2.29..26,390.07 rows=1 width=321) (actual time=23.729..7,102.976 rows=11,868 loops=1)

22. 15.447 7,089.834 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=2.00..26,379.22 rows=1 width=270) (actual time=23.720..7,089.834 rows=11,868 loops=1)

23. 53.089 7,074.387 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=1.71..26,368.36 rows=1 width=219) (actual time=23.711..7,074.387 rows=11,868 loops=1)

  • Join Filter: (cl.linkid = cler.linkid)
  • Rows Removed by Join Filter: 11,868
  • Filter: (((public.parsedatearg(NULL::bytea) IS NULL) OR (dler.lastrequest >= public.parsedatearg(NULL::bytea)) OR (cler.lastrequest >= public.parsedatearg(NULL::bytea))) AND ((public.parsedatearg(NULL::bytea) IS NULL) OR (dler.lastrequest < public.parsedatearg(NULL::bytea)) OR (cler.lastrequest < public.parsedatearg(NULL::bytea))))
24. 11.476 7,021.298 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=1.71..26,365.83 rows=1 width=227) (actual time=23.700..7,021.298 rows=11,868 loops=1)

25. 12.426 6,986.086 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=1.42..26,358.03 rows=1 width=176) (actual time=23.669..6,986.086 rows=11,868 loops=1)

  • Join Filter: (l.linkid = dler.linkid)
  • Rows Removed by Join Filter: 11,868
26. 64.928 6,973.660 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=1.42..26,357.01 rows=1 width=168) (actual time=23.664..6,973.660 rows=11,868 loops=1)

  • Filter: (((public.parsedatearg(NULL::bytea) IS NULL) OR (ielh.setat >= public.parsedatearg(NULL::bytea))) AND ((public.parsedatearg(NULL::bytea) IS NULL) OR (ielh.setat < public.parsedatearg(NULL::bytea))))
27. 25.838 6,873.128 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=0.99..26,339.08 rows=1 width=160) (actual time=23.618..6,873.128 rows=11,868 loops=1)

  • Join Filter: (ielg.enforcementlevelgroupid = iel.enforcementlevelgroupid)
  • Rows Removed by Join Filter: 679
  • Filter: ((public.buildintarray(NULL::bytea) IS NULL) OR (ielg.enforcementlevelgroupid = ANY (public.buildintarray(NULL::bytea))))
28. 17.008 6,847.290 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=0.99..26,335.94 rows=1 width=164) (actual time=23.612..6,847.290 rows=11,868 loops=1)

  • Join Filter: (istatg.incidentstatusgroupid = istat.incidentstatusgroupid)
  • Rows Removed by Join Filter: 12,104
  • Filter: ((public.buildintarray(NULL::bytea) IS NULL) OR (istatg.incidentstatusgroupid = ANY (public.buildintarray(NULL::bytea))))
29. 36.450 6,818.414 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=0.99..26,330.13 rows=1 width=168) (actual time=23.605..6,818.414 rows=11,868 loops=1)

  • Join Filter: (dcfg.domainplatformid = dp.domainplatformid)
  • Rows Removed by Join Filter: 66,286
  • Filter: ((public.buildintarray(NULL::bytea) IS NULL) OR (dp.domainplatformid = ANY (public.buildintarray(NULL::bytea))))
30. 408.881 6,770.096 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=0.99..26,290.61 rows=1 width=164) (actual time=23.594..6,770.096 rows=11,868 loops=1)

  • Join Filter: (COALESCE(d.domainconfigurationid, md.domainconfigurationid) = dcfg.domainconfigurationid)
  • Rows Removed by Join Filter: 6,458,453
31. 59.414 5,933.967 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=0.99..26,205.05 rows=1 width=168) (actual time=23.521..5,933.967 rows=11,868 loops=1)

  • Join Filter: ((d.domainconfigurationid IS NULL) AND (md.domainid = d.masterdomainid))
  • Rows Removed by Join Filter: 1,054,038
32. 14.519 878.125 ↓ 11,868.0 11,868 1

Nested Loop (cost=0.99..26,126.46 rows=1 width=168) (actual time=23.032..878.125 rows=11,868 loops=1)

33. 15.484 828.002 ↓ 11,868.0 11,868 1

Nested Loop (cost=0.71..26,125.59 rows=1 width=142) (actual time=23.016..828.002 rows=11,868 loops=1)

  • Join Filter: (i.enforcementlevelid = iel.enforcementlevelid)
  • Rows Removed by Join Filter: 81,945
34. 3.528 717.574 ↓ 11,868.0 11,868 1

Nested Loop (cost=0.71..26,118.23 rows=1 width=138) (actual time=22.999..717.574 rows=11,868 loops=1)

  • Join Filter: (i.incidentstatusid = istat.incidentstatusid)
  • Rows Removed by Join Filter: 8,808
35. 16.378 678.442 ↓ 11,868.0 11,868 1

Nested Loop (cost=0.71..26,107.21 rows=1 width=134) (actual time=22.980..678.442 rows=11,868 loops=1)

  • Join Filter: (a.assetid = asp.assetid)
  • Rows Removed by Join Filter: 59,567
36. 6.854 638.328 ↓ 11,868.0 11,868 1

Nested Loop (cost=0.71..26,104.27 rows=1 width=142) (actual time=22.972..638.328 rows=11,868 loops=1)

  • Join Filter: (coa.assetid = a.assetid)
  • Rows Removed by Join Filter: 2,687
37. 13.887 607.738 ↓ 11,868.0 11,868 1

Nested Loop (cost=0.71..26,102.63 rows=1 width=120) (actual time=22.964..607.738 rows=11,868 loops=1)

  • Join Filter: (i.assetid = coa.assetid)
  • Rows Removed by Join Filter: 2,687
38. 7.893 581.983 ↓ 11,868.0 11,868 1

Nested Loop (cost=0.71..26,100.99 rows=1 width=116) (actual time=22.954..581.983 rows=11,868 loops=1)

39. 6.148 444.570 ↓ 9.7 8,095 1

Nested Loop (cost=0.29..21,714.66 rows=833 width=76) (actual time=2.722..444.570 rows=8,095 loops=1)

  • Join Filter: (pt.protectiontypeid = dl.infringementprotectiontypeid)
  • Rows Removed by Join Filter: 48,570
40. 0.009 0.089 ↓ 7.0 7 1

Nested Loop (cost=0.00..5.82 rows=1 width=12) (actual time=0.045..0.089 rows=7 loops=1)

41. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on contract c (cost=0.00..1.23 rows=1 width=8) (actual time=0.012..0.015 rows=1 loops=1)

  • Filter: (active AND (contractid = 38) AND (customerid = 36))
  • Rows Removed by Filter: 14
42. 0.065 0.065 ↓ 7.0 7 1

Seq Scan on protectiontype pt (cost=0.00..4.59 rows=1 width=4) (actual time=0.032..0.065 rows=7 loops=1)

  • Filter: ((public.parseintarg(NULL::bytea) IS NULL) OR (protectiontypeid = public.parseintarg(NULL::bytea)))
43. 36.393 438.333 ↓ 1.4 8,095 7

Nested Loop (cost=0.29..21,635.91 rows=5,834 width=68) (actual time=0.503..62.619 rows=8,095 loops=7)

44. 182.812 182.812 ↑ 1.0 15,652 7

Seq Scan on link l (cost=0.00..4,223.98 rows=15,995 width=59) (actual time=0.490..26.116 rows=15,652 loops=7)

  • Filter: (customerid = 36)
  • Rows Removed by Filter: 93,626
45. 219.128 219.128 ↑ 1.0 1 109,564

Index Scan using uq_detectionlink_detectionlinkid_linktypeid on detectionlink dl (cost=0.29..1.09 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=109,564)

  • Index Cond: (detectionlinkid = l.linkid)
  • Filter: ((public.parseboolarg(NULL::bytea) IS NULL) OR (highrisk = public.parseboolarg(NULL::bytea)))
46. 129.520 129.520 ↑ 1.0 1 8,095

Index Scan using incident_detectionlinkid_targetdetectionlinkid_contentlinki_key on incident i (cost=0.42..5.26 rows=1 width=44) (actual time=0.008..0.016 rows=1 loops=8,095)

  • Index Cond: (detectionlinkid = dl.detectionlinkid)
  • Filter: ((NOT deleted) AND (customerid = 36) AND ((public.parseintarg(NULL::bytea) IS NULL) OR (assetid = public.parseintarg(NULL::bytea))) AND ((public.parsedatearg('2020-01-01'::character varying) IS NULL) OR (createdat >= public.parsedatearg('2020-01-01'::character varying))) AND ((public.parsedatearg('2020-02-21'::character varying) IS NULL) OR (createdat < public.parsedatearg('2020-02-21'::character varying))))
  • Rows Removed by Filter: 0
47. 11.868 11.868 ↑ 8.0 1 11,868

Seq Scan on contract_asset coa (cost=0.00..1.54 rows=8 width=8) (actual time=0.001..0.001 rows=1 loops=11,868)

  • Filter: (contractid = 38)
  • Rows Removed by Filter: 5
48. 23.736 23.736 ↑ 8.0 1 11,868

Seq Scan on asset a (cost=0.00..1.54 rows=8 width=26) (actual time=0.002..0.002 rows=1 loops=11,868)

  • Filter: (customerid = 36)
  • Rows Removed by Filter: 5
49. 23.736 23.736 ↑ 7.2 6 11,868

Seq Scan on asset_scope asp (cost=0.00..2.40 rows=43 width=4) (actual time=0.002..0.002 rows=6 loops=11,868)

  • Filter: (scopeid = 1)
  • Rows Removed by Filter: 6
50. 35.604 35.604 ↑ 4.0 2 11,868

Seq Scan on incidentstatus istat (cost=0.00..10.93 rows=8 width=8) (actual time=0.002..0.003 rows=2 loops=11,868)

  • Filter: ((public.buildintarray(NULL::bytea) IS NULL) OR (incidentstatusid = ANY (public.buildintarray(NULL::bytea))))
51. 94.944 94.944 ↓ 1.1 8 11,868

Seq Scan on enforcementlevel iel (cost=0.00..7.27 rows=7 width=8) (actual time=0.002..0.008 rows=8 loops=11,868)

  • Filter: ((public.buildintarray(NULL::bytea) IS NULL) OR (enforcementlevelid = ANY (public.buildintarray(NULL::bytea))))
52. 35.604 35.604 ↑ 1.0 1 11,868

Index Scan using uq_domain_domainid_domaintypeid on domain d (cost=0.28..0.82 rows=1 width=30) (actual time=0.003..0.003 rows=1 loops=11,868)

  • Index Cond: (domainid = l.domainid)
  • Filter: ((public.buildintarray(NULL::bytea) IS NULL) OR (domainid = ANY (public.buildintarray(NULL::bytea))))
53. 4,996.428 4,996.428 ↑ 1.0 89 11,868

Seq Scan on domain md (cost=0.00..77.47 rows=89 width=8) (actual time=0.002..0.421 rows=89 loops=11,868)

  • Filter: (hierarchylevelid = 1)
  • Rows Removed by Filter: 2,576
54. 427.248 427.248 ↑ 4.9 545 11,868

Seq Scan on domainconfiguration dcfg (cost=0.00..52.47 rows=2,647 width=8) (actual time=0.002..0.036 rows=545 loops=11,868)

55. 11.868 11.868 ↑ 10.3 7 11,868

Seq Scan on domainplatform dp (cost=0.00..1.72 rows=72 width=12) (actual time=0.001..0.001 rows=7 loops=11,868)

56. 11.868 11.868 ↑ 4.5 2 11,868

Seq Scan on incidentstatusgroup istatg (cost=0.00..1.09 rows=9 width=4) (actual time=0.001..0.001 rows=2 loops=11,868)

57. 0.000 0.000 ↑ 4.0 1 11,868

Seq Scan on enforcementlevelgroup ielg (cost=0.00..1.04 rows=4 width=4) (actual time=0.000..0.000 rows=1 loops=11,868)

58. 32.904 35.604 ↓ 0.0 0 11,868

Index Scan using idx_incidentenforcementlevelhistory_incidentid on incidentenforcementlevelhistory ielh (cost=0.43..16.91 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=11,868)

  • Index Cond: (incidentid = i.incidentid)
  • Filter: ((enforcementlevelid = ANY ('{1,6}'::integer[])) AND (enforcementlevelid = i.enforcementlevelid) AND (setat = (SubPlan 1)))
  • Rows Removed by Filter: 1
59.          

SubPlan (for Index Scan)

60. 1.800 2.700 ↑ 1.0 1 450

Aggregate (cost=8.45..8.46 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=450)

61. 0.900 0.900 ↓ 2.0 2 450

Index Scan using idx_incidentenforcementlevelhistory_incidentid on incidentenforcementlevelhistory ielhd (cost=0.43..8.45 rows=1 width=8) (actual time=0.002..0.002 rows=2 loops=450)

  • Index Cond: (incidentid = i.incidentid)
62. 0.000 0.000 ↑ 1.0 1 11,868

Seq Scan on enforcementrequest dler (cost=0.00..1.01 rows=1 width=12) (actual time=0.000..0.000 rows=1 loops=11,868)

63. 23.736 23.736 ↑ 1.0 1 11,868

Index Scan using uq_link_linkid_linktypeid on link cl (cost=0.29..7.80 rows=1 width=55) (actual time=0.002..0.002 rows=1 loops=11,868)

  • Index Cond: ((i.contentlinkid = linkid) AND (linktypeid = 2))
  • Filter: (customerid = 36)
64. 0.000 0.000 ↑ 1.0 1 11,868

Seq Scan on enforcementrequest cler (cost=0.00..1.01 rows=1 width=12) (actual time=0.000..0.000 rows=1 loops=11,868)

65. 0.000 0.000 ↓ 0.0 0 11,868

Index Scan using uq_link_linkid_linktypeid on link sl (cost=0.29..5.57 rows=1 width=55) (actual time=0.000..0.000 rows=0 loops=11,868)

  • Index Cond: ((i.shortenerlinkid = linkid) AND (linktypeid = 3))
  • Filter: (customerid = 36)
66. 0.000 0.000 ↓ 0.0 0 11,868

Index Scan using uq_link_linkid_linktypeid on link el (cost=0.29..5.57 rows=1 width=55) (actual time=0.000..0.000 rows=0 loops=11,868)

  • Index Cond: ((i.embeddedlinkid = linkid) AND (linktypeid = 4))
  • Filter: (customerid = 36)
67. 0.000 0.000 ↓ 0.0 0 11,868

Index Scan using uq_link_linkid_linktypeid on link tdl (cost=0.29..7.80 rows=1 width=55) (actual time=0.000..0.000 rows=0 loops=11,868)

  • Index Cond: ((i.targetdetectionlinkid = linkid) AND (linktypeid = 1))
  • Filter: (customerid = 36)
68. 11.868 11.868 ↑ 1.7 6 11,868

Seq Scan on enforcementstatus les (cost=0.00..1.10 rows=10 width=8) (actual time=0.001..0.001 rows=6 loops=11,868)

69. 23.736 23.736 ↓ 0.0 0 11,868

Index Scan using idx_linkenforcementstatushistory_linkid on linkenforcementstatushistory lesh (cost=0.43..12.37 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=11,868)

  • Index Cond: (linkid = l.linkid)
  • Filter: ((enforcementstatusid = 4) AND (enforcementstatusid = l.enforcementstatusid) AND (setat = (SubPlan 2)))
  • Rows Removed by Filter: 1
70.          

SubPlan (for Index Scan)

71. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.45..8.46 rows=1 width=8) (never executed)

72. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_linkenforcementstatushistory_linkid on linkenforcementstatushistory lesh_1 (cost=0.43..8.45 rows=1 width=8) (never executed)

  • Index Cond: (linkid = l.linkid)
73. 11.868 11.868 ↑ 1.2 8 11,868

Seq Scan on enforcementstatus cles (cost=0.00..1.10 rows=10 width=8) (actual time=0.000..0.001 rows=8 loops=11,868)

74. 11.868 11.868 ↓ 0.0 0 11,868

Index Scan using idx_linkenforcementstatushistory_linkid on linkenforcementstatushistory clesh (cost=0.43..14.93 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=11,868)

  • Index Cond: (linkid = cl.linkid)
  • Filter: ((enforcementstatusid = 4) AND (setat = (SubPlan 3)))
  • Rows Removed by Filter: 1
75.          

SubPlan (for Index Scan)

76. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.45..8.46 rows=1 width=8) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_linkenforcementstatushistory_linkid on linkenforcementstatushistory lesh_2 (cost=0.43..8.45 rows=1 width=8) (never executed)

  • Index Cond: (linkid = cl.linkid)
78. 11.868 11.868 ↑ 1.0 10 11,868

Seq Scan on enforcementstatus sles (cost=0.00..1.10 rows=10 width=8) (actual time=0.000..0.001 rows=10 loops=11,868)

79. 0.000 0.000 ↓ 0.0 0 11,868

Index Scan using idx_linkenforcementstatushistory_linkid on linkenforcementstatushistory slesh (cost=0.43..16.91 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=11,868)

  • Index Cond: (linkid = sl.linkid)
  • Filter: ((enforcementstatusid = 4) AND (setat = (SubPlan 4)))
80.          

SubPlan (for Index Scan)

81. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.45..8.46 rows=1 width=8) (never executed)

82. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_linkenforcementstatushistory_linkid on linkenforcementstatushistory lesh_3 (cost=0.43..8.45 rows=1 width=8) (never executed)

  • Index Cond: (linkid = sl.linkid)
83. 11.868 11.868 ↑ 1.0 10 11,868

Seq Scan on enforcementstatus eles (cost=0.00..1.10 rows=10 width=8) (actual time=0.000..0.001 rows=10 loops=11,868)

84. 0.000 0.000 ↓ 0.0 0 11,868

Index Scan using idx_linkenforcementstatushistory_linkid on linkenforcementstatushistory elesh (cost=0.43..16.91 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=11,868)

  • Index Cond: (linkid = el.linkid)
  • Filter: ((enforcementstatusid = 4) AND (setat = (SubPlan 5)))
85.          

SubPlan (for Index Scan)

86. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.45..8.46 rows=1 width=8) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_linkenforcementstatushistory_linkid on linkenforcementstatushistory lesh_4 (cost=0.43..8.45 rows=1 width=8) (never executed)

  • Index Cond: (linkid = el.linkid)
88. 11.868 11.868 ↑ 1.0 10 11,868

Seq Scan on enforcementstatus tdles (cost=0.00..1.10 rows=10 width=8) (actual time=0.000..0.001 rows=10 loops=11,868)

89. 0.000 0.000 ↓ 0.0 0 11,868

Index Scan using idx_linkenforcementstatushistory_linkid on linkenforcementstatushistory tdlesh (cost=0.43..13.11 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=11,868)

  • Index Cond: (linkid = tdl.linkid)
  • Filter: ((enforcementstatusid = 4) AND (setat = (SubPlan 6)))
  • Rows Removed by Filter: 0
90.          

SubPlan (for Index Scan)

91. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.45..8.46 rows=1 width=8) (never executed)

92. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_linkenforcementstatushistory_linkid on linkenforcementstatushistory lesh_5 (cost=0.43..8.45 rows=1 width=8) (never executed)

  • Index Cond: (linkid = tdl.linkid)
93. 23.736 23.736 ↓ 0.0 0 11,868

Seq Scan on detectionlinkwatcher dlw (cost=0.00..1.18 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=11,868)

  • Filter: ((createdby)::text = 'system'::text)
  • Rows Removed by Filter: 14
94. 23.736 23.736 ↓ 0.0 0 11,868

Index Scan using idx_incidentstatushistory_incidentid_setby_incidentstatusid on incidentstatushistory ish (cost=0.43..16.99 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=11,868)

  • Index Cond: ((incidentid = i.incidentid) AND (incidentstatusid = 9))
  • Filter: (setat = (SubPlan 7))
95.          

SubPlan (for Index Scan)

96. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.49..8.50 rows=1 width=8) (never executed)

97. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_incidentstatushistory_incidentid_setby_incidentstatusid on incidentstatushistory aush (cost=0.43..8.49 rows=1 width=8) (never executed)

  • Index Cond: ((incidentid = i.incidentid) AND (incidentstatusid = 9))
98. 11.868 11.868 ↓ 0.0 0 11,868

Index Scan using uq_customerdivision_customerid_name on customerdivision cd (cost=0.14..8.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=11,868)

  • Index Cond: (customerid = 36)
99. 0.000 0.000 ↓ 0.0 0 11,868

Seq Scan on domain_customerdivision dcd (cost=0.00..10.70 rows=70 width=8) (actual time=0.000..0.000 rows=0 loops=11,868)

100. 11.868 11.868 ↓ 0.0 0 11,868

Index Only Scan using uq_contract_customerdivision__contract_customerdivision on contract_customerdivision ccd (cost=0.14..8.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=11,868)

  • Index Cond: (contractid = 38)
  • Heap Fetches: 0
101. 0.000 0.000 ↓ 0.0 0 11,868

Index Only Scan using uq_customerdivisionscope_customerdivision_scope on customerdivision_scope cc (cost=0.15..8.17 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=11,868)

  • Index Cond: ((customerdivisionid = cd.customerdivisionid) AND (scopeid = 1))
  • Heap Fetches: 0
Planning time : 170.140 ms
Execution time : 7,624.130 ms