explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f0Q

Settings
# exclusive inclusive rows x rows loops node
1. 3.879 1,476.967 ↓ 10,000.0 20,000 1

Hash Join (cost=10,972.45..10,974.01 rows=2 width=1,419) (actual time=1,467.978..1,476.967 rows=20,000 loops=1)

  • Hash Cond: (l.linktypeid = lt.linktypeid)
2. 5.149 1,473.076 ↓ 10,000.0 20,000 1

Hash Join (cost=10,971.36..10,972.92 rows=2 width=1,414) (actual time=1,467.947..1,473.076 rows=20,000 loops=1)

  • Hash Cond: (at.assettypeid = a.assettypeid)
3. 0.009 0.009 ↑ 1.0 39 1

Seq Scan on assettype at (cost=0.00..1.39 rows=39 width=12) (actual time=0.002..0.009 rows=39 loops=1)

4. 12.631 1,467.918 ↓ 10,000.0 20,000 1

Hash (cost=10,971.33..10,971.33 rows=2 width=1,410) (actual time=1,467.918..1,467.918 rows=20,000 loops=1)

  • Buckets: 32768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 10119kB
5. 4.826 1,455.287 ↓ 10,000.0 20,000 1

Nested Loop Left Join (cost=10,954.39..10,971.33 rows=2 width=1,410) (actual time=1,341.325..1,455.287 rows=20,000 loops=1)

6. 7.558 1,350.461 ↓ 10,000.0 20,000 1

Unique (cost=10,953.69..10,953.76 rows=2 width=952) (actual time=1,341.266..1,350.461 rows=20,000 loops=1)

7. 5.974 1,342.903 ↓ 10,000.0 20,000 1

Sort (cost=10,953.69..10,953.69 rows=2 width=952) (actual time=1,341.265..1,342.903 rows=20,000 loops=1)

  • Sort Key: l.linkid, b.docker, l.assetid, l.domainid, i.contractid, cu.customerid, l.linktypeid, a.assettypeid, l.url, mr.nextcadenceid, (COALESCE(a.matchingthreshold, cu.matchingthreshold)), (trunc((((tu.hourequivalence * (cad.cadence)::numeric) / '2'::numeric) * '3600'::numeric), 0)), (to_char(mr.lastrequest, 'YYYY-MM-DD HH24:MI:SS'::text)), (COALESCE(mdc.queue, mastermdc.queue))
  • Sort Method: quicksort Memory: 6081kB
8. 1.383 1,336.929 ↓ 10,000.0 20,000 1

Append (cost=5,415.51..10,953.68 rows=2 width=952) (actual time=699.679..1,336.929 rows=20,000 loops=1)

9. 0.829 704.994 ↓ 10,000.0 10,000 1

Limit (cost=5,415.51..5,415.55 rows=1 width=300) (actual time=699.677..704.994 rows=10,000 loops=1)

10. 3.989 704.165 ↓ 10,000.0 10,000 1

Unique (cost=5,415.51..5,415.55 rows=1 width=300) (actual time=699.676..704.165 rows=10,000 loops=1)

11. 41.375 700.176 ↓ 10,094.0 10,094 1

Sort (cost=5,415.51..5,415.52 rows=1 width=300) (actual time=699.674..700.176 rows=10,094 loops=1)

  • Sort Key: l.linkid, b.docker, l.assetid, l.domainid, i.contractid, cu.customerid, a.assettypeid, l.url, mr.nextcadenceid, (COALESCE(a.matchingthreshold, cu.matchingthreshold)), (trunc((((tu.hourequivalence * (cad.cadence)::numeric) / '2'::numeric) * '3600'::numeric), 0)), (to_char(mr.lastrequest, 'YYYY-MM-DD HH24:MI:SS'::text)), (COALESCE(mdc.queue, mastermdc.queue))
  • Sort Method: quicksort Memory: 11249kB
12. 111.170 658.801 ↓ 37,348.0 37,348 1

Nested Loop (cost=1,008.01..5,415.50 rows=1 width=300) (actual time=4.494..658.801 rows=37,348 loops=1)

  • Join Filter: ((cad.timeunitid = tu.timeunitid) AND (mr.retry OR (mr.lastrequest IS NULL) OR ((mr.monitorimportstatusid = ANY ('{3,4}'::integer[])) AND (mr.lastrequest <= (statement_timestamp() - ('24 HOUR'::cstring)::interval))) OR ((mr.nextrequest > mr.lastrequest) AND (mr.nextrequest <= statement_timestamp())) OR (((mr.nextrequest IS NULL) OR (mr.nextrequest <= mr.lastrequest)) AND (mr.lastrequest <= (statement_timestamp() - (((((tu.hourequivalence * (cad.cadence)::numeric) * '2'::numeric))::text || ' HOUR'::text))::interval)))))
  • Rows Removed by Join Filter: 105
13. 51.463 547.631 ↓ 37,348.0 37,348 1

Nested Loop (cost=1,008.01..5,414.11 rows=1 width=197) (actual time=4.467..547.631 rows=37,348 loops=1)

  • Join Filter: ((mr.nextcadenceid = cad.cadenceid) OR ((mr.nextcadenceid IS NULL) AND (o.obsolescenceid = cad.obsolescenceid) AND (cad.age = 0)))
  • Rows Removed by Join Filter: 560220
14. 42.651 421.472 ↓ 37,348.0 37,348 1

Nested Loop Left Join (cost=1,008.01..5,412.62 rows=1 width=193) (actual time=4.459..421.472 rows=37,348 loops=1)

15. 7.142 341.473 ↓ 37,348.0 37,348 1

Nested Loop (cost=1,007.72..5,412.22 rows=1 width=168) (actual time=4.443..341.473 rows=37,348 loops=1)

  • Join Filter: (COALESCE(a.monitorobsolescenceid, mdc.monitorobsolescenceid, mastermdc.monitorobsolescenceid) = o.obsolescenceid)
  • Rows Removed by Join Filter: 149701
16. 108.552 296.983 ↓ 37,348.0 37,348 1

Nested Loop Left Join (cost=1,007.72..5,410.97 rows=1 width=176) (actual time=4.438..296.983 rows=37,348 loops=1)

  • Join Filter: ((cps.domainusageid <> 1) AND (cps.contractprotectionserviceid = cpsd.contractprotectionserviceid) AND (d.domainid = cpsd.domainid))
  • Rows Removed by Join Filter: 1656248
  • Filter: ((cps.domainusageid = 1) OR ((cps.domainusageid = 2) AND (cpsd.domainid IS NOT NULL)) OR ((cps.domainusageid = 3) AND (cpsd.domainid IS NULL)))
  • Rows Removed by Filter: 294
17. 0.000 37.863 ↓ 37,642.0 37,642 1

Gather (cost=1,007.72..5,408.43 rows=1 width=188) (actual time=4.424..37.863 rows=37,642 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
18. 15.023 232.875 ↓ 18,821.0 18,821 2 / 2

Nested Loop (cost=7.72..4,408.33 rows=1 width=188) (actual time=1.957..232.875 rows=18,821 loops=2)

19. 15.747 199.031 ↓ 752.8 18,821 2 / 2

Nested Loop Left Join (cost=7.57..4,403.88 rows=25 width=169) (actual time=1.942..199.031 rows=18,821 loops=2)

  • Filter: COALESCE(mdc.monitorautomation, mastermdc.monitorautomation)
  • Rows Removed by Filter: 213
20. 16.179 183.284 ↓ 380.7 19,034 2 / 2

Nested Loop Left Join (cost=7.29..4,384.76 rows=50 width=139) (actual time=1.931..183.284 rows=19,034 loops=2)

21. 14.897 148.071 ↓ 380.7 19,034 2 / 2

Nested Loop Left Join (cost=7.01..4,366.14 rows=50 width=107) (actual time=1.915..148.071 rows=19,034 loops=2)

22. 17.448 133.174 ↓ 380.7 19,034 2 / 2

Nested Loop (cost=6.73..4,346.67 rows=50 width=107) (actual time=1.903..133.174 rows=19,034 loops=2)

23. 5.358 96.692 ↓ 333.9 19,034 2 / 2

Hash Join (cost=6.45..4,329.56 rows=57 width=95) (actual time=1.889..96.692 rows=19,034 loops=2)

  • Hash Cond: (l.enforcementstatusid = es.enforcementstatusid)
24. 8.528 91.320 ↓ 121.1 22,896 2 / 2

Nested Loop (cost=5.31..4,327.72 rows=189 width=99) (actual time=1.351..91.320 rows=22,896 loops=2)

  • Join Filter: (a.assetid = l.assetid)
25. 5.242 36.942 ↓ 13.7 22,925 2 / 2

Hash Join (cost=4.90..3,393.55 rows=1,668 width=44) (actual time=1.326..36.942 rows=22,925 loops=2)

  • Hash Cond: (i.contractid = cps.contractid)
26. 4.968 31.682 ↓ 8.6 22,925 2 / 2

Hash Join (cost=3.04..3,382.41 rows=2,652 width=36) (actual time=1.295..31.682 rows=22,925 loops=2)

  • Hash Cond: (a.customerid = cu.customerid)
27. 8.712 26.701 ↓ 2.0 22,925 2 / 2

Hash Join (cost=1.74..3,340.93 rows=11,546 width=36) (actual time=1.268..26.701 rows=22,925 loops=2)

  • Hash Cond: ((i.assetid = a.assetid) AND (i.customerid = a.customerid))
28. 17.971 17.971 ↑ 1.2 59,952 2 / 2

Parallel Seq Scan on incident i (cost=0.00..2,961.80 rows=70,599 width=16) (actual time=0.006..17.971 rows=59,952 loops=2)

  • Filter: ((NOT deleted) AND (incidentstatusid <> ALL ('{4,11,17}'::integer[])))
  • Rows Removed by Filter: 1792
29. 0.006 0.018 ↑ 1.0 21 2 / 2

Hash (cost=1.43..1.43 rows=21 width=20) (actual time=0.018..0.018 rows=21 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
30. 0.012 0.012 ↑ 1.0 21 2 / 2

Seq Scan on asset a (cost=0.00..1.43 rows=21 width=20) (actual time=0.005..0.012 rows=21 loops=2)

  • Filter: active
  • Rows Removed by Filter: 22
31. 0.006 0.013 ↑ 1.0 13 2 / 2

Hash (cost=1.13..1.13 rows=13 width=8) (actual time=0.012..0.013 rows=13 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
32. 0.007 0.007 ↑ 1.0 13 2 / 2

Seq Scan on customer cu (cost=0.00..1.13 rows=13 width=8) (actual time=0.004..0.007 rows=13 loops=2)

33. 0.005 0.018 ↓ 1.6 13 2 / 2

Hash (cost=1.76..1.76 rows=8 width=12) (actual time=0.018..0.018 rows=13 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
34. 0.013 0.013 ↓ 1.6 13 2 / 2

Seq Scan on contract_protectionservice cps (cost=0.00..1.76 rows=8 width=12) (actual time=0.009..0.013 rows=13 loops=2)

  • Filter: ((NOT deleted) AND (protectionserviceid = 2) AND ((domainusageid = 1) OR (domainusageid = 2) OR (domainusageid = 3)))
  • Rows Removed by Filter: 25
35. 45.850 45.850 ↑ 1.0 1 45,850 / 2

Index Scan using uq_link_linkid_linktypeid on link l (cost=0.42..0.55 rows=1 width=67) (actual time=0.002..0.002 rows=1 loops=45,850)

  • Index Cond: ((linkid = i.detectionlinkid) AND (linktypeid = 1))
  • Filter: ((NOT deleted) AND (monitorexecutiontypeid <> 3) AND (i.assetid = assetid))
  • Rows Removed by Filter: 0
36. 0.004 0.014 ↑ 1.0 3 2 / 2

Hash (cost=1.10..1.10 rows=3 width=4) (actual time=0.014..0.014 rows=3 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
37. 0.010 0.010 ↑ 1.0 3 2 / 2

Seq Scan on enforcementstatus es (cost=0.00..1.10 rows=3 width=4) (actual time=0.009..0.010 rows=3 loops=2)

  • Filter: monitorizable
  • Rows Removed by Filter: 7
38. 19.035 19.035 ↑ 1.0 1 38,069 / 2

Index Scan using uq_domain_domainid_domaintypeid on domain d (cost=0.28..0.30 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=38,069)

  • Index Cond: (domainid = l.domainid)
  • Filter: active
  • Rows Removed by Filter: 0
39. 0.000 0.000 ↓ 0.0 0 38,068 / 2

Index Scan using uq_domain_domainid_domaintypeid on domain masterdomain (cost=0.28..0.39 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=38,068)

  • Index Cond: (d.masterdomainid = domainid)
  • Filter: active
40. 19.034 19.034 ↑ 1.0 1 38,068 / 2

Index Scan using pk_monitordomainconfiguration on monitordomainconfiguration mdc (cost=0.28..0.37 rows=1 width=40) (actual time=0.001..0.001 rows=1 loops=38,068)

  • Index Cond: (d.monitordomainconfigurationid = monitordomainconfigurationid)
41. 0.000 0.000 ↓ 0.0 0 38,068 / 2

Index Scan using pk_monitordomainconfiguration on monitordomainconfiguration mastermdc (cost=0.28..0.37 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=38,068)

  • Index Cond: (masterdomain.monitordomainconfigurationid = monitordomainconfigurationid)
42. 18.821 18.821 ↑ 1.0 1 37,642 / 2

Index Scan using idx_bot_bottypeid_botid on bot b (cost=0.15..0.18 rows=1 width=43) (actual time=0.001..0.001 rows=1 loops=37,642)

  • Index Cond: ((COALESCE(mdc.monitorbottypeid, mastermdc.monitorbottypeid) = bottypeid) AND (COALESCE(mdc.monitorbotid, mastermdc.monitorbotid) = botid))
  • Filter: active
43. 150.568 150.568 ↑ 1.0 44 37,642

Seq Scan on contract_protectionservice__domain cpsd (cost=0.00..1.44 rows=44 width=8) (actual time=0.001..0.004 rows=44 loops=37,642)

  • Filter: (NOT deleted)
44. 37.348 37.348 ↑ 2.2 5 37,348

Seq Scan on obsolescence o (cost=0.00..1.11 rows=11 width=4) (actual time=0.000..0.001 rows=5 loops=37,348)

45. 37.348 37.348 ↑ 1.0 1 37,348

Index Scan using idx_uq_detectionrequest_lastsearch on monitorrequest mr (cost=0.29..0.40 rows=1 width=29) (actual time=0.001..0.001 rows=1 loops=37,348)

  • Index Cond: (l.linkid = linkid)
46. 74.696 74.696 ↑ 1.0 16 37,348

Seq Scan on cadence cad (cost=0.00..1.21 rows=16 width=20) (actual time=0.000..0.002 rows=16 loops=37,348)

  • Filter: (cadence > 0)
  • Rows Removed by Filter: 1
47. 0.000 0.000 ↑ 5.0 1 37,348

Seq Scan on timeunit tu (cost=0.00..1.05 rows=5 width=9) (actual time=0.000..0.000 rows=1 loops=37,348)

48. 0.794 630.552 ↓ 10,000.0 10,000 1

Limit (cost=5,538.06..5,538.10 rows=1 width=300) (actual time=625.385..630.552 rows=10,000 loops=1)

49. 3.879 629.758 ↓ 10,000.0 10,000 1

Unique (cost=5,538.06..5,538.10 rows=1 width=300) (actual time=625.383..629.758 rows=10,000 loops=1)

50. 9.164 625.879 ↓ 10,000.0 10,000 1

Sort (cost=5,538.06..5,538.06 rows=1 width=300) (actual time=625.381..625.879 rows=10,000 loops=1)

  • Sort Key: l_1.linkid, b_1.docker, l_1.assetid, l_1.domainid, i_1.contractid, cu_1.customerid, a_1.assettypeid, l_1.url, mr_1.nextcadenceid, (COALESCE(a_1.matchingthreshold, cu_1.matchingthreshold)), (trunc((((tu_1.hourequivalence * (cad_1.cadence)::numeric) / '2'::numeric) * '3600'::numeric), 0)), (to_char(mr_1.lastrequest, 'YYYY-MM-DD HH24:MI:SS'::text)), (COALESCE(mdc_1.queue, mastermdc_1.queue))
  • Sort Method: quicksort Memory: 4712kB
51. 46.484 616.715 ↓ 16,291.0 16,291 1

Nested Loop (cost=1,006.73..5,538.05 rows=1 width=300) (actual time=265.815..616.715 rows=16,291 loops=1)

  • Join Filter: ((cad_1.timeunitid = tu_1.timeunitid) AND (mr_1.retry OR (mr_1.lastrequest IS NULL) OR ((mr_1.monitorimportstatusid = ANY ('{3,4}'::integer[])) AND (mr_1.lastrequest <= (statement_timestamp() - ('24 HOUR'::cstring)::interval))) OR ((mr_1.nextrequest > mr_1.lastrequest) AND (mr_1.nextrequest <= statement_timestamp())) OR (((mr_1.nextrequest IS NULL) OR (mr_1.nextrequest <= mr_1.lastrequest)) AND (mr_1.lastrequest <= (statement_timestamp() - (((((tu_1.hourequivalence * (cad_1.cadence)::numeric) * '2'::numeric))::text || ' HOUR'::text))::interval)))))
52. 21.063 570.231 ↓ 16,291.0 16,291 1

Nested Loop (cost=1,006.73..5,536.66 rows=1 width=197) (actual time=265.786..570.231 rows=16,291 loops=1)

  • Join Filter: ((mr_1.nextcadenceid = cad_1.cadenceid) OR ((mr_1.nextcadenceid IS NULL) AND (o_1.obsolescenceid = cad_1.obsolescenceid) AND (cad_1.age = 0)))
  • Rows Removed by Join Filter: 244365
53. 18.781 516.586 ↓ 16,291.0 16,291 1

Nested Loop Left Join (cost=1,006.73..5,535.17 rows=1 width=193) (actual time=265.777..516.586 rows=16,291 loops=1)

54. 42.398 481.514 ↓ 16,291.0 16,291 1

Nested Loop Left Join (cost=1,006.43..5,534.61 rows=1 width=168) (actual time=265.748..481.514 rows=16,291 loops=1)

  • Join Filter: ((cps_1.domainusageid <> 1) AND (cps_1.contractprotectionserviceid = cpsd_1.contractprotectionserviceid) AND (d_1.domainid = cpsd_1.domainid))
  • Rows Removed by Join Filter: 717552
  • Filter: ((cps_1.domainusageid = 1) OR ((cps_1.domainusageid = 2) AND (cpsd_1.domainid IS NOT NULL)) OR ((cps_1.domainusageid = 3) AND (cpsd_1.domainid IS NULL)))
  • Rows Removed by Filter: 17
55. 18.496 373.884 ↓ 16,308.0 16,308 1

Nested Loop (cost=1,006.43..5,532.07 rows=1 width=180) (actual time=265.733..373.884 rows=16,308 loops=1)

  • Join Filter: ((COALESCE(mdc_1.monitorbotid, mastermdc_1.monitorbotid) = b_1.botid) AND (COALESCE(mdc_1.monitorbottypeid, mastermdc_1.monitorbottypeid) = b_1.bottypeid))
  • Rows Removed by Join Filter: 209476
56. 29.802 290.156 ↓ 16,308.0 16,308 1

Nested Loop (cost=1,006.43..5,522.37 rows=1 width=161) (actual time=265.716..290.156 rows=16,308 loops=1)

  • Join Filter: (COALESCE(a_1.monitorobsolescenceid, mdc_1.monitorobsolescenceid, mastermdc_1.monitorobsolescenceid) = o_1.obsolescenceid)
  • Rows Removed by Join Filter: 163080
57. 0.017 0.017 ↑ 1.0 11 1

Seq Scan on obsolescence o_1 (cost=0.00..1.11 rows=11 width=4) (actual time=0.008..0.017 rows=11 loops=1)

58. 16.367 260.337 ↓ 4,077.0 16,308 11

Materialize (cost=1,006.43..5,520.61 rows=4 width=169) (actual time=3.076..23.667 rows=16,308 loops=11)

59. 15.541 243.970 ↓ 4,077.0 16,308 1

Nested Loop Left Join (cost=1,006.43..5,520.59 rows=4 width=169) (actual time=33.830..243.970 rows=16,308 loops=1)

  • Filter: COALESCE(mdc_1.monitorautomation, mastermdc_1.monitorautomation)
  • Rows Removed by Filter: 690
60. 20.718 228.429 ↓ 2,428.3 16,998 1

Nested Loop Left Join (cost=1,006.15..5,517.91 rows=7 width=139) (actual time=33.816..228.429 rows=16,998 loops=1)

61. 15.120 190.713 ↓ 2,428.3 16,998 1

Nested Loop Left Join (cost=1,005.88..5,515.30 rows=7 width=107) (actual time=33.798..190.713 rows=16,998 loops=1)

62. 23.263 175.593 ↓ 2,428.3 16,998 1

Nested Loop (cost=1,005.60..5,512.58 rows=7 width=107) (actual time=33.780..175.593 rows=16,998 loops=1)

63. 11.126 135.332 ↓ 2,124.8 16,998 1

Nested Loop (cost=1,005.32..5,510.14 rows=8 width=95) (actual time=33.755..135.332 rows=16,998 loops=1)

  • Join Filter: (l_1.enforcementstatusid = es_1.enforcementstatusid)
  • Rows Removed by Join Filter: 34050
64. 46.549 124.206 ↓ 607.7 17,016 1

Gather (cost=1,005.32..5,507.84 rows=28 width=99) (actual time=33.744..124.206 rows=17,016 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
65. 14.665 77.657 ↓ 531.8 8,508 2 / 2

Nested Loop (cost=5.31..4,505.04 rows=16 width=99) (actual time=16.915..77.657 rows=8,508 loops=2)

  • Join Filter: (a_1.assetid = l_1.assetid)
66. 5.152 40.270 ↓ 13.7 22,722 2 / 2

Hash Join (cost=4.90..3,573.60 rows=1,662 width=44) (actual time=1.372..40.270 rows=22,722 loops=2)

  • Hash Cond: (i_1.contractid = cps_1.contractid)
67. 4.970 35.094 ↓ 8.6 22,722 2 / 2

Hash Join (cost=3.04..3,562.49 rows=2,642 width=36) (actual time=1.299..35.094 rows=22,722 loops=2)

  • Hash Cond: (a_1.customerid = cu_1.customerid)
68. 9.149 30.114 ↓ 2.0 22,722 2 / 2

Hash Join (cost=1.74..3,521.15 rows=11,504 width=36) (actual time=1.278..30.114 rows=22,722 loops=2)

  • Hash Cond: ((i_1.assetid = a_1.assetid) AND (i_1.customerid = a_1.customerid))
69. 20.947 20.947 ↑ 1.2 59,735 2 / 2

Parallel Seq Scan on incident i_1 (cost=0.00..3,143.40 rows=70,342 width=16) (actual time=0.006..20.947 rows=59,735 loops=2)

  • Filter: ((NOT deleted) AND (incidentstatusid <> ALL ('{4,7,11,16,17}'::integer[])))
  • Rows Removed by Filter: 2009
70. 0.005 0.018 ↑ 1.0 21 2 / 2

Hash (cost=1.43..1.43 rows=21 width=20) (actual time=0.018..0.018 rows=21 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
71. 0.013 0.013 ↑ 1.0 21 2 / 2

Seq Scan on asset a_1 (cost=0.00..1.43 rows=21 width=20) (actual time=0.006..0.013 rows=21 loops=2)

  • Filter: active
  • Rows Removed by Filter: 22
72. 0.003 0.010 ↑ 1.0 13 2 / 2

Hash (cost=1.13..1.13 rows=13 width=8) (actual time=0.010..0.010 rows=13 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
73. 0.007 0.007 ↑ 1.0 13 2 / 2

Seq Scan on customer cu_1 (cost=0.00..1.13 rows=13 width=8) (actual time=0.004..0.007 rows=13 loops=2)

74. 0.005 0.024 ↓ 1.6 13 2 / 2

Hash (cost=1.76..1.76 rows=8 width=12) (actual time=0.024..0.024 rows=13 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
75. 0.019 0.019 ↓ 1.6 13 2 / 2

Seq Scan on contract_protectionservice cps_1 (cost=0.00..1.76 rows=8 width=12) (actual time=0.014..0.019 rows=13 loops=2)

  • Filter: ((NOT deleted) AND (protectionserviceid = 2) AND ((domainusageid = 1) OR (domainusageid = 2) OR (domainusageid = 3)))
  • Rows Removed by Filter: 25
76. 22.722 22.722 ↓ 0.0 0 45,444 / 2

Index Scan using uq_link_linkid_linktypeid on link l_1 (cost=0.42..0.55 rows=1 width=67) (actual time=0.001..0.001 rows=0 loops=45,444)

  • Index Cond: ((linkid = i_1.contentlinkid) AND (linktypeid = 2))
  • Filter: ((NOT deleted) AND (monitorexecutiontypeid <> 3) AND (i_1.assetid = assetid))
  • Rows Removed by Filter: 0
77. 0.000 0.000 ↑ 1.0 3 17,016

Materialize (cost=0.00..1.11 rows=3 width=4) (actual time=0.000..0.000 rows=3 loops=17,016)

78. 0.006 0.006 ↑ 1.0 3 1

Seq Scan on enforcementstatus es_1 (cost=0.00..1.10 rows=3 width=4) (actual time=0.005..0.006 rows=3 loops=1)

  • Filter: monitorizable
  • Rows Removed by Filter: 7
79. 16.998 16.998 ↑ 1.0 1 16,998

Index Scan using uq_domain_domainid_domaintypeid on domain d_1 (cost=0.28..0.30 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=16,998)

  • Index Cond: (domainid = l_1.domainid)
  • Filter: active
80. 0.000 0.000 ↓ 0.0 0 16,998

Index Scan using uq_domain_domainid_domaintypeid on domain masterdomain_1 (cost=0.28..0.39 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=16,998)

  • Index Cond: (d_1.masterdomainid = domainid)
  • Filter: active
81. 16.998 16.998 ↑ 1.0 1 16,998

Index Scan using pk_monitordomainconfiguration on monitordomainconfiguration mdc_1 (cost=0.28..0.37 rows=1 width=40) (actual time=0.001..0.001 rows=1 loops=16,998)

  • Index Cond: (d_1.monitordomainconfigurationid = monitordomainconfigurationid)
82. 0.000 0.000 ↓ 0.0 0 16,998

Index Scan using pk_monitordomainconfiguration on monitordomainconfiguration mastermdc_1 (cost=0.28..0.37 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=16,998)

  • Index Cond: (masterdomain_1.monitordomainconfigurationid = monitordomainconfigurationid)
83. 65.232 65.232 ↑ 9.0 14 16,308

Seq Scan on bot b_1 (cost=0.00..7.81 rows=126 width=43) (actual time=0.001..0.004 rows=14 loops=16,308)

  • Filter: active
  • Rows Removed by Filter: 30
84. 65.232 65.232 ↑ 1.0 44 16,308

Seq Scan on contract_protectionservice__domain cpsd_1 (cost=0.00..1.44 rows=44 width=8) (actual time=0.001..0.004 rows=44 loops=16,308)

  • Filter: (NOT deleted)
85. 16.291 16.291 ↑ 1.0 1 16,291

Index Scan using idx_uq_detectionrequest_lastsearch on monitorrequest mr_1 (cost=0.29..0.56 rows=1 width=29) (actual time=0.001..0.001 rows=1 loops=16,291)

  • Index Cond: (l_1.linkid = linkid)
86. 32.582 32.582 ↑ 1.0 16 16,291

Seq Scan on cadence cad_1 (cost=0.00..1.21 rows=16 width=20) (actual time=0.000..0.002 rows=16 loops=16,291)

  • Filter: (cadence > 0)
  • Rows Removed by Filter: 1
87. 0.000 0.000 ↑ 5.0 1 16,291

Seq Scan on timeunit tu_1 (cost=0.00..1.05 rows=5 width=9) (actual time=0.000..0.000 rows=1 loops=16,291)

88. 20.000 100.000 ↑ 1.0 1 20,000

Nested Loop Left Join (cost=0.70..8.77 rows=1 width=466) (actual time=0.004..0.005 rows=1 loops=20,000)

89. 40.000 80.000 ↑ 1.0 1 20,000

Nested Loop Left Join (cost=0.56..8.60 rows=1 width=216) (actual time=0.003..0.004 rows=1 loops=20,000)

90. 40.000 40.000 ↑ 1.0 1 20,000

Index Scan using uq_evidence_link_evidencetype on evidence e (cost=0.42..8.44 rows=1 width=208) (actual time=0.002..0.002 rows=1 loops=20,000)

  • Index Cond: ((l.linkid = linkid) AND (evidencetypeid = 1))
91. 0.000 0.000 ↑ 1.0 1 19,634

Index Scan using pk_searchkeyword on searchkeyword sk (cost=0.14..0.16 rows=1 width=8) (actual time=0.000..0.000 rows=1 loops=19,634)

  • Index Cond: (searchkeywordid = e.searchkeywordid)
92. 0.000 0.000 ↑ 1.0 1 19,634

Index Scan using pk_effectivesearchkeyword on effectivesearchkeyword esk (cost=0.14..0.16 rows=1 width=262) (actual time=0.000..0.000 rows=1 loops=19,634)

  • Index Cond: (effectivesearchkeywordid = e.effectivesearchkeywordid)
  • Filter: (e.searchkeywordid = searchkeywordid)
93. 0.004 0.012 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=13) (actual time=0.012..0.012 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
94. 0.008 0.008 ↑ 1.0 4 1

Seq Scan on linktype lt (cost=0.00..1.04 rows=4 width=13) (actual time=0.007..0.008 rows=4 loops=1)

Planning time : 134.891 ms
Execution time : 1,481.025 ms