explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FILM

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 6,327.910 ↓ 40.0 40 1

Limit (cost=24,036.15..24,036.23 rows=1 width=389) (actual time=6,327.853..6,327.910 rows=40 loops=1)

2. 0.033 6,327.874 ↓ 42.0 42 1

Unique (cost=24,036.07..24,036.15 rows=1 width=389) (actual time=6,327.840..6,327.874 rows=42 loops=1)

3. 16.707 6,327.841 ↓ 42.0 42 1

Sort (cost=24,036.07..24,036.08 rows=1 width=389) (actual time=6,327.838..6,327.841 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: 3520kB
4. 15.618 6,311.134 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=5.87..24,036.06 rows=1 width=389) (actual time=24.027..6,311.134 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. 6.551 6,295.516 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=5.72..24,027.88 rows=1 width=404) (actual time=24.012..6,295.516 rows=11,868 loops=1)

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

Nested Loop Left Join (cost=5.58..24,019.70 rows=1 width=404) (actual time=24.000..6,277.097 rows=11,868 loops=1)

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

Nested Loop Left Join (cost=5.58..24,007.95 rows=1 width=400) (actual time=23.997..6,270.595 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. 53.114 6,237.457 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=5.44..23,999.28 rows=1 width=400) (actual time=23.981..6,237.457 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. 25.737 6,160.607 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=5.01..23,981.27 rows=1 width=392) (actual time=23.960..6,160.607 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. 13.969 6,123.002 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=5.01..23,979.33 rows=1 width=392) (actual time=23.950..6,123.002 rows=11,868 loops=1)

  • Join Filter: (tdlesh.enforcementstatusid = l.enforcementstatusid)
11. 41.975 6,109.033 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=4.58..23,966.21 rows=1 width=392) (actual time=23.938..6,109.033 rows=11,868 loops=1)

  • Join Filter: (tdles.enforcementstatusid = tdl.enforcementstatusid)
  • Rows Removed by Join Filter: 118091
  • 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. 14.122 6,055.190 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=4.58..23,933.73 rows=1 width=408) (actual time=23.928..6,055.190 rows=11,868 loops=1)

  • Join Filter: (elesh.enforcementstatusid = l.enforcementstatusid)
13. 16.500 6,041.068 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=4.15..23,916.81 rows=1 width=404) (actual time=23.916..6,041.068 rows=11,868 loops=1)

  • Join Filter: (eles.enforcementstatusid = el.enforcementstatusid)
  • Rows Removed by Join Filter: 118680
14. 14.588 6,012.700 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=4.15..23,915.59 rows=1 width=400) (actual time=23.909..6,012.700 rows=11,868 loops=1)

  • Join Filter: (slesh.enforcementstatusid = l.enforcementstatusid)
15. 17.205 5,998.112 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=3.72..23,898.67 rows=1 width=396) (actual time=23.898..5,998.112 rows=11,868 loops=1)

  • Join Filter: (sles.enforcementstatusid = sl.enforcementstatusid)
  • Rows Removed by Join Filter: 118680
16. 16.447 5,969.039 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=3.72..23,897.44 rows=1 width=392) (actual time=23.893..5,969.039 rows=11,868 loops=1)

  • Join Filter: (clesh.enforcementstatusid = l.enforcementstatusid)
17. 12.254 5,940.724 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=3.29..23,882.50 rows=1 width=388) (actual time=23.878..5,940.724 rows=11,868 loops=1)

  • Join Filter: (cles.enforcementstatusid = cl.enforcementstatusid)
  • Rows Removed by Join Filter: 82515
18. 14.966 5,916.602 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=3.29..23,881.28 rows=1 width=384) (actual time=23.873..5,916.602 rows=11,868 loops=1)

19. 13.246 5,877.900 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=2.87..23,868.90 rows=1 width=380) (actual time=23.857..5,877.900 rows=11,868 loops=1)

  • Join Filter: (les.enforcementstatusid = l.enforcementstatusid)
  • Rows Removed by Join Filter: 59004
20. 14.081 5,852.786 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=2.87..23,867.67 rows=1 width=372) (actual time=23.850..5,852.786 rows=11,868 loops=1)

21. 12.507 5,838.705 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=2.57..23,859.87 rows=1 width=321) (actual time=23.841..5,838.705 rows=11,868 loops=1)

22. 13.465 5,826.198 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=2.28..23,849.02 rows=1 width=270) (actual time=23.830..5,826.198 rows=11,868 loops=1)

23. 51.586 5,812.733 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=1.99..23,838.16 rows=1 width=219) (actual time=23.822..5,812.733 rows=11,868 loops=1)

  • Join Filter: (cl.linkid = cler.linkid)
  • Rows Removed by Join Filter: 11868
  • 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. 19.673 5,761.147 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=1.99..23,835.63 rows=1 width=227) (actual time=23.811..5,761.147 rows=11,868 loops=1)

25. 11.804 5,729.606 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=1.70..23,827.83 rows=1 width=176) (actual time=23.794..5,729.606 rows=11,868 loops=1)

  • Join Filter: (l.linkid = dler.linkid)
  • Rows Removed by Join Filter: 11868
26. 56.389 5,717.802 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=1.70..23,826.81 rows=1 width=168) (actual time=23.789..5,717.802 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.273 5,625.809 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=1.27..23,808.88 rows=1 width=160) (actual time=23.751..5,625.809 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. 27.372 5,600.536 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=1.27..23,805.74 rows=1 width=164) (actual time=23.746..5,600.536 rows=11,868 loops=1)

  • Join Filter: (istatg.incidentstatusgroupid = istat.incidentstatusgroupid)
  • Rows Removed by Join Filter: 12104
  • Filter: ((public.buildintarray(NULL::bytea) IS NULL) OR (istatg.incidentstatusgroupid = ANY (public.buildintarray(NULL::bytea))))
29. 69.703 5,573.164 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=1.27..23,799.93 rows=1 width=168) (actual time=23.738..5,573.164 rows=11,868 loops=1)

  • Join Filter: (mdcfg.domainplatformid = mdp.domainplatformid)
  • Rows Removed by Join Filter: 854496
  • Filter: ((public.buildintarray(NULL::bytea) IS NULL) OR ((dp.domainplatformid IS NOT NULL) AND (dp.domainplatformid = ANY (public.buildintarray(NULL::bytea)))) OR ((dp.domainplatformid IS NULL) AND (mdp.domainplatformid IS NOT NULL) AND (mdp.domainplatformid = ANY (public.buildintarray(NULL::bytea)))))
30. 1,495.833 5,444.121 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=1.27..23,741.51 rows=1 width=176) (actual time=23.724..5,444.121 rows=11,868 loops=1)

  • Join Filter: (dcfg.domainconfigurationid = md.domainconfigurationid)
  • Rows Removed by Join Filter: 31414596
31. 17.284 1,788.312 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=1.27..23,655.95 rows=1 width=180) (actual time=23.396..1,788.312 rows=11,868 loops=1)

  • Join Filter: (dcfg.domainplatformid = dp.domainplatformid)
  • Rows Removed by Join Filter: 80029
32. 411.534 1,759.160 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=1.27..23,653.33 rows=1 width=172) (actual time=23.390..1,759.160 rows=11,868 loops=1)

  • Join Filter: (dcfg.domainconfigurationid = d.domainconfigurationid)
  • Rows Removed by Join Filter: 6612999
33. 13.390 908.510 ↓ 11,868.0 11,868 1

Nested Loop Left Join (cost=1.27..23,567.77 rows=1 width=168) (actual time=23.314..908.510 rows=11,868 loops=1)

  • Join Filter: (d.domainconfigurationid IS NULL)
34. 12.021 895.120 ↓ 11,868.0 11,868 1

Nested Loop (cost=0.99..23,562.42 rows=1 width=168) (actual time=23.305..895.120 rows=11,868 loops=1)

35. 17.126 847.495 ↓ 11,868.0 11,868 1

Nested Loop (cost=0.71..23,561.55 rows=1 width=142) (actual time=23.284..847.495 rows=11,868 loops=1)

  • Join Filter: (i.enforcementlevelid = iel.enforcementlevelid)
  • Rows Removed by Join Filter: 81945
36. 4.846 735.425 ↓ 11,868.0 11,868 1

Nested Loop (cost=0.71..23,554.19 rows=1 width=138) (actual time=23.271..735.425 rows=11,868 loops=1)

  • Join Filter: (i.incidentstatusid = istat.incidentstatusid)
  • Rows Removed by Join Filter: 8808
37. 14.824 694.975 ↓ 11,868.0 11,868 1

Nested Loop (cost=0.71..23,543.16 rows=1 width=134) (actual time=23.255..694.975 rows=11,868 loops=1)

  • Join Filter: (a.assetid = asp.assetid)
  • Rows Removed by Join Filter: 59567
38. 6.639 656.415 ↓ 11,868.0 11,868 1

Nested Loop (cost=0.71..23,540.23 rows=1 width=142) (actual time=23.247..656.415 rows=11,868 loops=1)

  • Join Filter: (coa.assetid = a.assetid)
  • Rows Removed by Join Filter: 2687
39. 10.463 626.040 ↓ 11,868.0 11,868 1

Nested Loop (cost=0.71..23,538.59 rows=1 width=120) (actual time=23.238..626.040 rows=11,868 loops=1)

  • Join Filter: (i.assetid = coa.assetid)
  • Rows Removed by Join Filter: 2687
40. 2.637 603.709 ↓ 11,868.0 11,868 1

Nested Loop (cost=0.71..23,536.95 rows=1 width=116) (actual time=23.232..603.709 rows=11,868 loops=1)

41. 10.773 565.468 ↓ 11,868.0 11,868 1

Nested Loop (cost=0.71..23,535.72 rows=1 width=108) (actual time=23.224..565.468 rows=11,868 loops=1)

42. 6.030 433.270 ↓ 9.7 8,095 1

Nested Loop (cost=0.29..21,713.43 rows=833 width=68) (actual time=2.629..433.270 rows=8,095 loops=1)

  • Join Filter: (dl.infringementprotectiontypeid = pt.protectiontypeid)
  • Rows Removed by Join Filter: 48570
43. 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.035..0.065 rows=7 loops=1)

  • Filter: ((public.parseintarg(NULL::bytea) IS NULL) OR (protectiontypeid = public.parseintarg(NULL::bytea)))
44. 29.267 427.175 ↓ 1.4 8,095 7

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

45. 178.780 178.780 ↑ 1.0 15,652 7

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

  • Filter: (customerid = 36)
  • Rows Removed by Filter: 93626
46. 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)))
47. 121.425 121.425 ↑ 1.0 1 8,095

Index Scan using idx_incident_detectionlinkid_customerid on incident i (cost=0.42..2.18 rows=1 width=44) (actual time=0.008..0.015 rows=1 loops=8,095)

  • Index Cond: ((detectionlinkid = dl.detectionlinkid) AND (customerid = 36))
  • Filter: ((NOT deleted) 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
48. 35.604 35.604 ↑ 1.0 1 11,868

Seq Scan on contract c (cost=0.00..1.23 rows=1 width=8) (actual time=0.001..0.003 rows=1 loops=11,868)

  • Filter: (active AND (contractid = 38) AND (customerid = 36))
  • Rows Removed by Filter: 14
49. 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
50. 23.736 23.736 ↑ 8.0 1 11,868

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

  • Filter: (customerid = 36)
  • Rows Removed by Filter: 5
51. 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
52. 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))))
53. 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))))
54. 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))))
55. 0.000 0.000 ↓ 0.0 0 11,868

Index Scan using uq_domain_domainid_domaintypeid on domain md (cost=0.28..5.34 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=11,868)

  • Index Cond: (domainid = d.masterdomainid)
  • Filter: (hierarchylevelid = 1)
56. 439.116 439.116 ↑ 4.7 558 11,868

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

57. 11.868 11.868 ↑ 9.0 8 11,868

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

58. 2,159.976 2,159.976 ↑ 1.0 2,647 11,868

Seq Scan on domainconfiguration mdcfg (cost=0.00..52.47 rows=2,647 width=4) (actual time=0.001..0.182 rows=2,647 loops=11,868)

59. 59.340 59.340 ↑ 1.0 72 11,868

Seq Scan on domainplatform mdp (cost=0.00..1.72 rows=72 width=4) (actual time=0.001..0.005 rows=72 loops=11,868)

60. 0.000 0.000 ↑ 4.5 2 11,868

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

61. 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)

62. 33.354 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
63.          

SubPlan (for Index Scan)

64. 1.350 2.250 ↑ 1.0 1 450

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

65. 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)
66. 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)

67. 11.868 11.868 ↑ 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.001..0.001 rows=1 loops=11,868)

  • Index Cond: ((i.contentlinkid = linkid) AND (linktypeid = 2))
  • Filter: (customerid = 36)
68. 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)

69. 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)
70. 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)
71. 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)
72. 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)

73. 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
74.          

SubPlan (for Index Scan)

75. 0.000 0.000 ↓ 0.0 0

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

76. 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)
77. 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)

78. 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
79.          

SubPlan (for Index Scan)

80. 0.000 0.000 ↓ 0.0 0

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

81. 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)
82. 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)

83. 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)))
84.          

SubPlan (for Index Scan)

85. 0.000 0.000 ↓ 0.0 0

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

86. 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)
87. 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)

88. 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)))
89.          

SubPlan (for Index Scan)

90. 0.000 0.000 ↓ 0.0 0

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

91. 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)
92. 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)

93. 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
94.          

SubPlan (for Index Scan)

95. 0.000 0.000 ↓ 0.0 0

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

96. 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)
97. 11.868 11.868 ↓ 0.0 0 11,868

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

  • Filter: ((createdby)::text = 'system'::text)
  • Rows Removed by Filter: 14
98. 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))
99.          

SubPlan (for Index Scan)

100. 0.000 0.000 ↓ 0.0 0

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

101. 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))
102. 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)
103. 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)

104. 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
105. 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 : 158.257 ms
Execution time : 6,329.022 ms