explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 066DI

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

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

  • Buffers: shared hit=1,161,956
2. 6.174 1,507.247 ↓ 10,000.0 20,000 1

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

  • Buffers: shared hit=1,161,955
3. 0.011 0.011 ↑ 1.0 39 1

Seq Scan on assettype at (cost=0..1.39 rows=39 width=12) (actual time=0.003..0.011 rows=39 loops=1)

  • Buffers: shared hit=1
4. 12.802 1,501.062 ↓ 10,000.0 20,000 1

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

  • Buffers: shared hit=1,161,954
5. 5.093 1,488.260 ↓ 10,000.0 20,000 1

Nested Loop (cost=10,954.39..10,971.33 rows=2 width=1,410) (actual time=1,374.087..1,488.26 rows=20,000 loops=1)

  • Buffers: shared hit=1,161,954
6. 7.452 1,383.167 ↓ 10,000.0 20,000 1

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

  • Buffers: shared hit=1,042,292
7. 6.184 1,375.715 ↓ 10,000.0 20,000 1

Sort (cost=10,953.69..10,953.69 rows=2 width=952) (actual time=1,374.034..1,375.715 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: 6,081kB
  • Buffers: shared hit=1,042,292
8. 1.560 1,369.531 ↓ 10,000.0 20,000 1

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

  • Buffers: shared hit=1,042,292
9. 0.898 753.336 ↓ 10,000.0 10,000 1

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

  • Buffers: shared hit=752,150
10. 4.123 752.438 ↓ 10,000.0 10,000 1

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

  • Buffers: shared hit=752,150
11. 41.821 748.315 ↓ 10,094.0 10,094 1

Sort (cost=5,415.51..5,415.52 rows=1 width=300) (actual time=747.796..748.315 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: 11,249kB
  • Buffers: shared hit=752,150
12. 115.889 706.494 ↓ 37,348.0 37,348 1

Nested Loop (cost=1,008.01..5,415.5 rows=1 width=300) (actual time=4.55..706.494 rows=37,348 loops=1)

  • Buffers: shared hit=752,150
13. 60.726 590.605 ↓ 37,348.0 37,348 1

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

  • Buffers: shared hit=714,802
14. 46.953 455.183 ↓ 37,348.0 37,348 1

Nested Loop (cost=1,008.01..5,412.62 rows=1 width=193) (actual time=4.517..455.183 rows=37,348 loops=1)

  • Buffers: shared hit=677,454
15. 11.284 370.882 ↓ 37,348.0 37,348 1

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

  • Buffers: shared hit=565,224
16. 132.907 322.250 ↓ 37,348.0 37,348 1

Nested Loop (cost=1,007.72..5,410.97 rows=1 width=176) (actual time=4.496..322.25 rows=37,348 loops=1)

  • Filter: ((cps.domainusageid = 1) OR ((cps.domainusageid = 2) AND (cpsd.domainid IS NOT NULL)) OR ((cps.domainusageid = 3) AND (cpsd.domainid IS NULL)))
  • Buffers: shared hit=527,876
17. 0.000 38.775 ↓ 37,642.0 37,642 1

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

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=490,234
18. 16.322 245.173 ↓ 18,821.0 18,821 2 / 2

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

  • Buffers: shared hit=490,234
19. 16.704 210.030 ↓ 752.8 18,821 2 / 2

Nested Loop (cost=7.57..4,403.88 rows=25 width=169) (actual time=2.005..210.03 rows=18,821 loops=2)

  • Filter: COALESCE(mdc.monitorautomation, mastermdc.monitorautomation)
  • Buffers: shared hit=414,949
20. 17.647 193.326 ↓ 380.7 19,034 2 / 2

Nested Loop (cost=7.29..4,384.76 rows=50 width=139) (actual time=1.994..193.326 rows=19,034 loops=2)

  • Buffers: shared hit=414,208
21. 15.772 156.645 ↓ 380.7 19,034 2 / 2

Nested Loop (cost=7.01..4,366.14 rows=50 width=107) (actual time=1.977..156.645 rows=19,034 loops=2)

  • Buffers: shared hit=300,744
22. 19.336 140.873 ↓ 380.7 19,034 2 / 2

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

  • Buffers: shared hit=300,003
23. 5.826 102.502 ↓ 333.9 19,034 2 / 2

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

  • Buffers: shared hit=185,795
24. 11.423 96.662 ↓ 121.1 22,896 2 / 2

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

  • Buffers: shared hit=185,764
25. 5.518 39.389 ↓ 13.7 22,925 2 / 2

Hash Join (cost=4.9..3,393.55 rows=1,668 width=44) (actual time=1.366..39.389 rows=22,925 loops=2)

  • Buffers: shared hit=1,969
26. 5.329 33.853 ↓ 8.6 22,925 2 / 2

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

  • Buffers: shared hit=1,967
27. 9.510 28.513 ↓ 2.0 22,925 2 / 2

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

  • Buffers: shared hit=1,965
28. 18.984 18.984 ↑ 1.2 59,952 2 / 2

Seq Scan on incident i (cost=0..2,961.8 rows=70,599 width=16) (actual time=0.005..18.984 rows=59,952 loops=2)

  • Filter: ((NOT i.deleted) AND (i.incidentstatusid <> ALL ('{4,11,17}'::integer[])))
  • Buffers: shared hit=1,963
29. 0.006 0.019 ↑ 1.0 21 2 / 2

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

  • Buffers: shared hit=2
30. 0.013 0.013 ↑ 1.0 21 2 / 2

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

  • Filter: a.active
  • Buffers: shared hit=2
31. 0.004 0.011 ↑ 1.0 13 2 / 2

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

  • Buffers: shared hit=2
32. 0.007 0.007 ↑ 1.0 13 2 / 2

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

  • Buffers: shared hit=2
33. 0.004 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)

  • Buffers: shared hit=2
34. 0.014 0.014 ↓ 1.6 13 2 / 2

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

  • Filter: ((NOT cps.deleted) AND (cps.protectionserviceid = 2) AND ((cps.domainusageid = 1) OR (cps.domainusageid = 2) OR (cps.domainusageid = 3)))
  • Buffers: shared hit=2
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: ((l.linkid = i.detectionlinkid) AND (l.linktypeid = 1))
  • Filter: ((NOT l.deleted) AND (l.monitorexecutiontypeid <> 3) AND (i.assetid = l.assetid))
  • Buffers: shared hit=183,795
36. 0.003 0.014 ↑ 1.0 3 2 / 2

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

  • Buffers: shared hit=2
37. 0.011 0.011 ↑ 1.0 3 2 / 2

Seq Scan on enforcementstatus es (cost=0..1.1 rows=3 width=4) (actual time=0.009..0.011 rows=3 loops=2)

  • Filter: es.monitorizable
  • Buffers: shared hit=2
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.3 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=38,069)

  • Index Cond: (d.domainid = l.domainid)
  • Filter: d.active
  • Buffers: shared hit=114,208
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..0 rows=0 loops=38,068)

  • Index Cond: (d.masterdomainid = masterdomain.domainid)
  • Filter: masterdomain.active
  • Buffers: shared hit=741
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 = mdc.monitordomainconfigurationid)
  • Buffers: shared hit=113,464
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..0 rows=0 loops=38,068)

  • Index Cond: (masterdomain.monitordomainconfigurationid = mastermdc.monitordomainconfigurationid)
  • Buffers: shared hit=741
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) = b.bottypeid) AND (COALESCE(mdc.monitorbotid, mastermdc.monitorbotid) = b.botid))
  • Filter: b.active
  • Buffers: shared hit=75,285
43. 150.568 150.568 ↑ 1.0 44 37,642

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

  • Filter: (NOT cpsd.deleted)
  • Buffers: shared hit=37,642
44. 37.348 37.348 ↑ 2.2 5 37,348

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

  • Buffers: shared hit=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.4 rows=1 width=29) (actual time=0.001..0.001 rows=1 loops=37,348)

  • Index Cond: (l.linkid = mr.linkid)
  • Buffers: shared hit=112,230
46. 74.696 74.696 ↑ 1.0 16 37,348

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

  • Filter: (cad.cadence > 0)
  • Buffers: shared hit=37,348
47. 0.000 0.000 ↑ 5.0 1 37,348

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

  • Buffers: shared hit=37,348
48. 0.901 614.635 ↓ 10,000.0 10,000 1

Limit (cost=5,538.06..5,538.1 rows=1 width=300) (actual time=609.142..614.635 rows=10,000 loops=1)

  • Buffers: shared hit=290,142
49. 4.079 613.734 ↓ 10,000.0 10,000 1

Unique (cost=5,538.06..5,538.1 rows=1 width=300) (actual time=609.14..613.734 rows=10,000 loops=1)

  • Buffers: shared hit=290,142
50. 9.443 609.655 ↓ 10,000.0 10,000 1

Sort (cost=5,538.06..5,538.06 rows=1 width=300) (actual time=609.138..609.655 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: 4,712kB
  • Buffers: shared hit=290,142
51. 47.439 600.212 ↓ 16,291.0 16,291 1

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

  • Buffers: shared hit=290,142
52. 23.797 552.773 ↓ 16,291.0 16,291 1

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

  • Buffers: shared hit=273,851
53. 18.952 496.394 ↓ 16,291.0 16,291 1

Nested Loop (cost=1,006.73..5,535.17 rows=1 width=193) (actual time=231.112..496.394 rows=16,291 loops=1)

  • Buffers: shared hit=257,560
54. 50.031 461.151 ↓ 16,291.0 16,291 1

Nested Loop (cost=1,006.43..5,534.61 rows=1 width=168) (actual time=231.083..461.151 rows=16,291 loops=1)

  • 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)))
  • Buffers: shared hit=208,603
55. 23.139 345.888 ↓ 16,308.0 16,308 1

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

  • Buffers: shared hit=192,295
56. 30.569 257.517 ↓ 16,308.0 16,308 1

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

  • Buffers: shared hit=172,181
57. 0.018 0.018 ↑ 1.0 11 1

Seq Scan on obsolescence o_1 (cost=0..1.11 rows=11 width=4) (actual time=0.009..0.018 rows=11 loops=1)

  • Buffers: shared hit=1
58. 15.882 226.930 ↓ 4,077.0 16,308 11

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

  • Buffers: shared hit=172,180
59. 15.935 211.048 ↓ 4,077.0 16,308 1

Nested Loop (cost=1,006.43..5,520.59 rows=4 width=169) (actual time=37.966..211.048 rows=16,308 loops=1)

  • Filter: COALESCE(mdc_1.monitorautomation, mastermdc_1.monitorautomation)
  • Buffers: shared hit=172,180
60. 19.142 195.113 ↓ 2,428.3 16,998 1

Nested Loop (cost=1,006.15..5,517.91 rows=7 width=139) (actual time=37.955..195.113 rows=16,998 loops=1)

  • Buffers: shared hit=172,180
61. 14.142 158.973 ↓ 2,428.3 16,998 1

Nested Loop (cost=1,005.88..5,515.3 rows=7 width=107) (actual time=37.937..158.973 rows=16,998 loops=1)

  • Buffers: shared hit=121,182
62. 22.220 144.831 ↓ 2,428.3 16,998 1

Nested Loop (cost=1,005.6..5,512.58 rows=7 width=107) (actual time=37.926..144.831 rows=16,998 loops=1)

  • Buffers: shared hit=121,182
63. 11.912 105.613 ↓ 2,124.8 16,998 1

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

  • Buffers: shared hit=70,188
64. 16.374 93.701 ↓ 607.7 17,016 1

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

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=70,187
65. 9.947 77.327 ↓ 531.8 8,508 2 / 2

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

  • Buffers: shared hit=70,187
66. 5.740 44.658 ↓ 13.7 22,722 2 / 2

Hash Join (cost=4.9..3,573.6 rows=1,662 width=44) (actual time=1.518..44.658 rows=22,722 loops=2)

  • Buffers: shared hit=1,998
67. 5.481 38.892 ↓ 8.6 22,722 2 / 2

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

  • Buffers: shared hit=1,967
68. 10.314 33.400 ↓ 2.0 22,722 2 / 2

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

  • Buffers: shared hit=1,965
69. 23.062 23.062 ↑ 1.2 59,735 2 / 2

Seq Scan on incident i_1 (cost=0..3,143.4 rows=70,342 width=16) (actual time=0.008..23.062 rows=59,735 loops=2)

  • Filter: ((NOT i_1.deleted) AND (i_1.incidentstatusid <> ALL ('{4,7,11,16,17}'::integer[])))
  • Buffers: shared hit=1,963
70. 0.008 0.024 ↑ 1.0 21 2 / 2

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

  • Buffers: shared hit=2
71. 0.016 0.016 ↑ 1.0 21 2 / 2

Seq Scan on asset a_1 (cost=0..1.43 rows=21 width=20) (actual time=0.007..0.016 rows=21 loops=2)

  • Filter: a_1.active
  • Buffers: shared hit=2
72. 0.003 0.011 ↑ 1.0 13 2 / 2

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

  • Buffers: shared hit=2
73. 0.008 0.008 ↑ 1.0 13 2 / 2

Seq Scan on customer cu_1 (cost=0..1.13 rows=13 width=8) (actual time=0.005..0.008 rows=13 loops=2)

  • Buffers: shared hit=2
74. 0.006 0.026 ↓ 1.6 13 2 / 2

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

  • Buffers: shared hit=2
75. 0.020 0.020 ↓ 1.6 13 2 / 2

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

  • Filter: ((NOT cps_1.deleted) AND (cps_1.protectionserviceid = 2) AND ((cps_1.domainusageid = 1) OR (cps_1.domainusageid = 2) OR (cps_1.domainusageid = 3)))
  • Buffers: shared hit=2
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: ((l_1.linkid = i_1.contentlinkid) AND (l_1.linktypeid = 2))
  • Filter: ((NOT l_1.deleted) AND (l_1.monitorexecutiontypeid <> 3) AND (i_1.assetid = l_1.assetid))
  • Buffers: shared hit=68,189
77. 0.000 0.000 ↑ 1.0 3 17,016

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

  • Buffers: shared hit=1
78. 0.006 0.006 ↑ 1.0 3 1

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

  • Filter: es_1.monitorizable
  • Buffers: shared hit=1
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.3 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=16,998)

  • Index Cond: (d_1.domainid = l_1.domainid)
  • Filter: d_1.active
  • Buffers: shared hit=50,994
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..0 rows=0 loops=16,998)

  • Index Cond: (d_1.masterdomainid = masterdomain_1.domainid)
  • Filter: masterdomain_1.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 = mdc_1.monitordomainconfigurationid)
  • Buffers: shared hit=50,998
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..0 rows=0 loops=16,998)

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

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

  • Filter: b_1.active
  • Buffers: shared hit=20,114
84. 65.232 65.232 ↑ 1.0 44 16,308

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

  • Filter: (NOT cpsd_1.deleted)
  • Buffers: shared hit=16,308
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 = mr_1.linkid)
  • Buffers: shared hit=48,957
86. 32.582 32.582 ↑ 1.0 16 16,291

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

  • Filter: (cad_1.cadence > 0)
  • Buffers: shared hit=16,291
87. 0.000 0.000 ↑ 5.0 1 16,291

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

  • Buffers: shared hit=16,291
88. 40.000 100.000 ↑ 1.0 1 20,000

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

  • Buffers: shared hit=119,662
89. 20.000 60.000 ↑ 1.0 1 20,000

Nested Loop (cost=0.56..8.6 rows=1 width=216) (actual time=0.003..0.003 rows=1 loops=20,000)

  • Buffers: shared hit=99,726
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 = e.linkid) AND (e.evidencetypeid = 1))
  • Buffers: shared hit=79,790
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..0 rows=1 loops=19,634)

  • Index Cond: (sk.searchkeywordid = e.searchkeywordid)
  • Buffers: shared hit=19,936
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..0 rows=1 loops=19,634)

  • Index Cond: (esk.effectivesearchkeywordid = e.effectivesearchkeywordid)
  • Filter: (e.searchkeywordid = esk.searchkeywordid)
  • Buffers: shared hit=19,936
93. 0.005 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)

  • Buffers: shared hit=1
94. 0.007 0.007 ↑ 1.0 4 1

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

  • Buffers: shared hit=1
Planning time : 124.353 ms
Execution time : 1,516.315 ms