explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OGpc

Settings
# exclusive inclusive rows x rows loops node
1. 0.262 2.993 ↑ 200.3 6 1

Hash Join (cost=67.1..2,396.7 rows=1,202 width=250) (actual time=0.843..2.993 rows=6 loops=1)

  • Filter: ((s.current_backend_pid IS NULL) AND ((s.last_execution_time IS NULL) OR (to_timestamp((((((((date_part('epoch'::text, s.last_execution_time))::bigint + "*SELECT* 1".execution_frequency) - 1) / NULLIF("*SELECT* 1".execution_frequency, 0)) * "*SELECT* 1".execution_frequency) + (s.random_seed % NULLIF("*SELECT* 1".execution_frequency, 0))))::double precision) < now())))
  • Buffers: shared hit=828
2. 0.021 2.582 ↑ 15.4 234 1

Append (cost=55.25..2,365.92 rows=3,605 width=246) (actual time=0.086..2.582 rows=234 loops=1)

  • Buffers: shared hit=822
3. 0.002 0.117 ↑ 76.2 10 1

Subquery Scan on *SELECT* 1 (cost=55.25..194.76 rows=762 width=421) (actual time=0.085..0.117 rows=10 loops=1)

  • Buffers: shared hit=11
4. 0.042 0.115 ↑ 76.2 10 1

Hash Join (cost=55.25..187.14 rows=762 width=474) (actual time=0.084..0.115 rows=10 loops=1)

  • Filter: COALESCE(c.enabled, p.enabled_by_default)
  • Buffers: shared hit=11
5. 0.014 0.070 ↑ 152.3 10 1

Nested Loop (cost=0..120.08 rows=1,523 width=322) (actual time=0.045..0.07 rows=10 loops=1)

  • Buffers: shared hit=8
6. 0.010 0.010 ↑ 165.0 1 1

Seq Scan on agent a (cost=0..13.3 rows=165 width=68) (actual time=0.01..0.01 rows=1 loops=1)

  • Filter: a.active
  • Buffers: shared hit=1
7. 0.011 0.046 ↑ 1.0 12 1

Materialize (cost=0..7.81 rows=12 width=365) (actual time=0.026..0.046 rows=12 loops=1)

  • Buffers: shared hit=7
8. 0.035 0.035 ↑ 1.0 12 1

Seq Scan on probe p (cost=0..7.75 rows=12 width=365) (actual time=0.019..0.035 rows=12 loops=1)

  • Filter: ((NOT p.deleted) AND (p.target_type_id = 100))
  • Buffers: shared hit=7
9. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=28.1..28.1 rows=1,810 width=13) (actual time=0.003..0.003 rows=0 loops=1)

10. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on probe_config_agent c (cost=0..28.1 rows=1,810 width=13) (actual time=0.002..0.002 rows=0 loops=1)

11. 0.004 0.539 ↑ 24.7 21 1

Subquery Scan on *SELECT* 2 (cost=112.63..330.44 rows=519 width=200) (actual time=0.358..0.539 rows=21 loops=1)

  • Buffers: shared hit=25
12. 0.081 0.535 ↑ 24.7 21 1

Hash Join (cost=112.63..325.25 rows=519 width=253) (actual time=0.357..0.535 rows=21 loops=1)

  • Filter: (p_1.any_server_version OR (psv.probe_id IS NOT NULL))
  • Buffers: shared hit=25
13. 0.020 0.225 ↑ 24.7 21 1

Hash Join (cost=86.13..290.84 rows=519 width=366) (actual time=0.113..0.225 rows=21 loops=1)

  • Filter: COALESCE(c_1.enabled, p_1.enabled_by_default)
  • Buffers: shared hit=11
14. 0.040 0.203 ↑ 38.4 27 1

Hash Join (cost=30.89..230.14 rows=1,038 width=363) (actual time=0.097..0.203 rows=27 loops=1)

  • Buffers: shared hit=11
15. 0.039 0.150 ↑ 76.9 27 1

Hash Join (cost=16.39..208.2 rows=2,077 width=363) (actual time=0.068..0.15 rows=27 loops=1)

  • Buffers: shared hit=10
16. 0.006 0.075 ↑ 400.0 27 1

Nested Loop (cost=1.02..158.91 rows=10,800 width=410) (actual time=0.033..0.075 rows=27 loops=1)

  • Buffers: shared hit=9
17. 0.010 0.027 ↑ 400.0 1 1

Hash Join (cost=1.02..16.09 rows=400 width=44) (actual time=0.026..0.027 rows=1 loops=1)

  • Buffers: shared hit=2
18. 0.006 0.006 ↑ 400.0 1 1

Seq Scan on agent_server_binding b (cost=0..14 rows=400 width=40) (actual time=0.006..0.006 rows=1 loops=1)

  • Buffers: shared hit=1
19. 0.002 0.011 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=1)

  • Buffers: shared hit=1
20. 0.009 0.009 ↑ 1.0 1 1

Seq Scan on server_info sd (cost=0..1.01 rows=1 width=8) (actual time=0.008..0.009 rows=1 loops=1)

  • Buffers: shared hit=1
21. 0.019 0.042 ↑ 1.0 27 1

Materialize (cost=0..7.88 rows=27 width=366) (actual time=0.006..0.042 rows=27 loops=1)

  • Buffers: shared hit=7
22. 0.023 0.023 ↑ 1.0 27 1

Seq Scan on probe p_1 (cost=0..7.75 rows=27 width=366) (actual time=0.003..0.023 rows=27 loops=1)

  • Filter: ((NOT p_1.deleted) AND (p_1.target_type_id = 200))
  • Buffers: shared hit=7
23. 0.006 0.009 ↑ 165.0 1 1

Hash (cost=13.3..13.3 rows=165 width=68) (actual time=0.009..0.009 rows=1 loops=1)

  • Buffers: shared hit=1
24. 0.003 0.003 ↑ 165.0 1 1

Seq Scan on agent a_1 (cost=0..13.3 rows=165 width=68) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: a_1.active
  • Buffers: shared hit=1
25.          

SubPlan (for Hash Join)

26. 0.027 0.027 ↑ 100.0 1 27

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0.001..0.001 rows=1 loops=27)

27. 0.000 0.000 ↑ 1.0 1 27

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=27)

28. 0.004 0.013 ↑ 100.0 2 1

Hash (cost=12..12 rows=200 width=5) (actual time=0.013..0.013 rows=2 loops=1)

  • Buffers: shared hit=1
29. 0.009 0.009 ↑ 100.0 2 1

Seq Scan on server s_1 (cost=0..12 rows=200 width=5) (actual time=0.008..0.009 rows=2 loops=1)

  • Buffers: shared hit=1
30.          

SubPlan (for Hash Join)

31. 0.000 0.000 ↑ 100.0 1 27

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=1 loops=27)

32. 0.000 0.000 ↑ 1.0 1 27

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=27)

33. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=28.1..28.1 rows=1,810 width=13) (actual time=0.002..0.002 rows=0 loops=1)

34. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on probe_config_server c_1 (cost=0..28.1 rows=1,810 width=13) (actual time=0.002..0.002 rows=0 loops=1)

35. 0.129 0.229 ↓ 1.0 517 1

Hash (cost=19..19 rows=500 width=512) (actual time=0.229..0.229 rows=517 loops=1)

  • Buffers: shared hit=14
36. 0.100 0.100 ↓ 1.0 517 1

Seq Scan on probe_server_version psv (cost=0..19 rows=500 width=512) (actual time=0.006..0.1 rows=517 loops=1)

  • Buffers: shared hit=14
37. 0.008 0.451 ↑ 34.2 65 1

Subquery Scan on *SELECT* 3 (cost=102.11..422.43 rows=2,222 width=200) (actual time=0.302..0.451 rows=65 loops=1)

  • Buffers: shared hit=25
38. 0.079 0.443 ↑ 34.2 65 1

Hash Join (cost=102.11..400.21 rows=2,222 width=253) (actual time=0.302..0.443 rows=65 loops=1)

  • Filter: (p_2.any_server_version OR (psv_1.probe_id IS NOT NULL))
  • Buffers: shared hit=25
39. 0.034 0.182 ↑ 34.2 65 1

Hash Join (cost=75.61..339.8 rows=2,222 width=366) (actual time=0.104..0.182 rows=65 loops=1)

  • Filter: COALESCE(c_2.enabled, p_2.enabled_by_default)
  • Buffers: shared hit=11
40. 0.033 0.143 ↑ 59.2 75 1

Hash Join (cost=36.46..265.66 rows=4,443 width=363) (actual time=0.081..0.143 rows=75 loops=1)

  • Buffers: shared hit=11
41. 0.014 0.101 ↑ 154.0 75 1

Nested Loop (cost=21.09..218.87 rows=11,550 width=410) (actual time=0.058..0.101 rows=75 loops=1)

  • Buffers: shared hit=10
42. 0.017 0.052 ↑ 154.0 5 1

Hash Join (cost=21.09..66.71 rows=770 width=44) (actual time=0.049..0.052 rows=5 loops=1)

  • Buffers: shared hit=3
43. 0.007 0.007 ↑ 77.0 5 1

Seq Scan on oc_database ocd (cost=0..17.7 rows=385 width=36) (actual time=0.007..0.007 rows=5 loops=1)

  • Filter: ocd.connections_allowed
  • Buffers: shared hit=1
44. 0.002 0.028 ↑ 400.0 1 1

Hash (cost=16.09..16.09 rows=400 width=12) (actual time=0.028..0.028 rows=1 loops=1)

  • Buffers: shared hit=2
45. 0.018 0.026 ↑ 400.0 1 1

Hash Join (cost=1.02..16.09 rows=400 width=12) (actual time=0.026..0.026 rows=1 loops=1)

  • Buffers: shared hit=2
46. 0.002 0.002 ↑ 400.0 1 1

Seq Scan on agent_server_binding b_1 (cost=0..14 rows=400 width=8) (actual time=0.002..0.002 rows=1 loops=1)

  • Buffers: shared hit=1
47. 0.003 0.006 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=1)

  • Buffers: shared hit=1
48. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on server_info sd_1 (cost=0..1.01 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1)

  • Buffers: shared hit=1
49. 0.020 0.035 ↑ 1.0 15 5

Materialize (cost=0..7.83 rows=15 width=366) (actual time=0.002..0.007 rows=15 loops=5)

  • Buffers: shared hit=7
50. 0.015 0.015 ↑ 1.0 15 1

Seq Scan on probe p_2 (cost=0..7.75 rows=15 width=366) (actual time=0.003..0.015 rows=15 loops=1)

  • Filter: ((NOT p_2.deleted) AND (p_2.target_type_id = 300))
  • Buffers: shared hit=7
51. 0.003 0.009 ↑ 165.0 1 1

Hash (cost=13.3..13.3 rows=165 width=68) (actual time=0.009..0.009 rows=1 loops=1)

  • Buffers: shared hit=1
52. 0.006 0.006 ↑ 165.0 1 1

Seq Scan on agent a_2 (cost=0..13.3 rows=165 width=68) (actual time=0.005..0.006 rows=1 loops=1)

  • Filter: a_2.active
  • Buffers: shared hit=1
53. 0.001 0.005 ↓ 0.0 0 1

Hash (cost=20.6..20.6 rows=1,060 width=45) (actual time=0.005..0.005 rows=0 loops=1)

54. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on probe_config_database c_2 (cost=0..20.6 rows=1,060 width=45) (actual time=0.004..0.004 rows=0 loops=1)

55. 0.124 0.182 ↓ 1.0 517 1

Hash (cost=19..19 rows=500 width=512) (actual time=0.181..0.182 rows=517 loops=1)

  • Buffers: shared hit=14
56. 0.058 0.058 ↓ 1.0 517 1

Seq Scan on probe_server_version psv_1 (cost=0..19 rows=500 width=512) (actual time=0.003..0.058 rows=517 loops=1)

  • Buffers: shared hit=14
57. 0.016 0.614 ↓ 7.7 138 1

Subquery Scan on *SELECT* 4 (cost=104.32..135.87 rows=18 width=200) (actual time=0.294..0.614 rows=138 loops=1)

  • Buffers: shared hit=71
58. 0.188 0.598 ↓ 7.7 138 1

Hash Join (cost=104.32..135.69 rows=18 width=253) (actual time=0.293..0.598 rows=138 loops=1)

  • Filter: (p_3.any_server_version OR (psv_2.probe_id IS NOT NULL))
  • Buffers: shared hit=71
59. 0.051 0.236 ↓ 7.7 138 1

Hash Join (cost=77.82..108.91 rows=18 width=398) (actual time=0.101..0.236 rows=138 loops=1)

  • Filter: COALESCE(c_3.enabled, p_3.enabled_by_default)
  • Buffers: shared hit=57
60. 0.025 0.183 ↓ 3.9 138 1

Nested Loop (cost=45.62..76.34 rows=35 width=395) (actual time=0.087..0.183 rows=138 loops=1)

  • Buffers: shared hit=57
61. 0.013 0.112 ↓ 2.9 23 1

Nested Loop (cost=45.62..66.54 rows=8 width=140) (actual time=0.072..0.112 rows=23 loops=1)

  • Buffers: shared hit=50
62. 0.020 0.099 ↓ 2.9 23 1

Nested Loop (cost=45.62..65.41 rows=8 width=136) (actual time=0.066..0.099 rows=23 loops=1)

  • Buffers: shared hit=49
63. 0.011 0.056 ↓ 1.5 23 1

Hash Join (cost=45.47..61.13 rows=15 width=72) (actual time=0.051..0.056 rows=23 loops=1)

  • Buffers: shared hit=3
64. 0.003 0.003 ↑ 400.0 1 1

Seq Scan on agent_server_binding b_2 (cost=0..14 rows=400 width=8) (actual time=0.002..0.003 rows=1 loops=1)

  • Buffers: shared hit=1
65. 0.006 0.042 ↓ 2.9 23 1

Hash (cost=45.37..45.37 rows=8 width=72) (actual time=0.042..0.042 rows=23 loops=1)

  • Buffers: shared hit=2
66. 0.022 0.036 ↓ 2.9 23 1

Hash Join (cost=23.47..45.37 rows=8 width=72) (actual time=0.029..0.036 rows=23 loops=1)

  • Buffers: shared hit=2
67. 0.007 0.007 ↑ 33.9 23 1

Seq Scan on oc_schema oc (cost=0..17.8 rows=780 width=68) (actual time=0.005..0.007 rows=23 loops=1)

  • Buffers: shared hit=1
68. 0.003 0.007 ↑ 77.0 5 1

Hash (cost=17.7..17.7 rows=385 width=36) (actual time=0.007..0.007 rows=5 loops=1)

  • Buffers: shared hit=1
69. 0.004 0.004 ↑ 77.0 5 1

Seq Scan on oc_database ocd_1 (cost=0..17.7 rows=385 width=36) (actual time=0.003..0.004 rows=5 loops=1)

  • Filter: ocd_1.connections_allowed
  • Buffers: shared hit=1
70. 0.023 0.023 ↑ 1.0 1 23

Index Scan using agent_pkey on agent a_3 (cost=0.15..0.29 rows=1 width=68) (actual time=0.001..0.001 rows=1 loops=23)

  • Index Cond: (a_3.id = b_2.agent_id)
  • Filter: a_3.active
  • Buffers: shared hit=46
71. 0.000 0.000 ↑ 1.0 1 23

Materialize (cost=0..1.01 rows=1 width=8) (actual time=0..0 rows=1 loops=23)

  • Buffers: shared hit=1
72. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on server_info sd_2 (cost=0..1.01 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1)

  • Buffers: shared hit=1
73. 0.026 0.046 ↑ 1.0 6 23

Materialize (cost=0..7.78 rows=6 width=366) (actual time=0.001..0.002 rows=6 loops=23)

  • Buffers: shared hit=7
74. 0.020 0.020 ↑ 1.0 6 1

Seq Scan on probe p_3 (cost=0..7.75 rows=6 width=366) (actual time=0.009..0.02 rows=6 loops=1)

  • Filter: ((NOT p_3.deleted) AND (p_3.target_type_id = 400))
  • Buffers: shared hit=7
75. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=17.4..17.4 rows=740 width=77) (actual time=0.002..0.002 rows=0 loops=1)

76. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on probe_config_schema c_3 (cost=0..17.4 rows=740 width=77) (actual time=0.002..0.002 rows=0 loops=1)

77. 0.120 0.174 ↓ 1.0 517 1

Hash (cost=19..19 rows=500 width=512) (actual time=0.174..0.174 rows=517 loops=1)

  • Buffers: shared hit=14
78. 0.054 0.054 ↓ 1.0 517 1

Seq Scan on probe_server_version psv_2 (cost=0..19 rows=500 width=512) (actual time=0.003..0.054 rows=517 loops=1)

  • Buffers: shared hit=14
79. 0.001 0.014 ↓ 0.0 0 1

Subquery Scan on *SELECT* 5 (cost=36.87..98.12 rows=2 width=172) (actual time=0.014..0.014 rows=0 loops=1)

  • Buffers: shared hit=7
80. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=36.87..98.1 rows=2 width=225) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (p_4.any_server_version OR (psv_3.probe_id IS NOT NULL))
  • Buffers: shared hit=7
81. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=36.6..81.47 rows=2 width=362) (actual time=0.013..0.013 rows=0 loops=1)

  • Buffers: shared hit=7
82. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=36.48..81.08 rows=2 width=358) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: COALESCE(c_4.enabled, p_4.enabled_by_default)
  • Buffers: shared hit=7
83. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=36.33..62.58 rows=4 width=355) (actual time=0.013..0.013 rows=0 loops=1)

  • Buffers: shared hit=7
84. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on probe p_4 (cost=0..7.75 rows=1 width=366) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: ((NOT p_4.deleted) AND (p_4.target_type_id = 500))
  • Buffers: shared hit=7
85. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=36.33..54.63 rows=5 width=100) (never executed)

86. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=36.18..51.78 rows=10 width=36) (never executed)

87. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on agent_server_binding b_3 (cost=0..14 rows=400 width=8) (never executed)

88. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=36.12..36.12 rows=5 width=36) (never executed)

89. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=23.47..36.12 rows=5 width=36) (never executed)

90. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on oc_table oc_1 (cost=0..10.01 rows=501 width=32) (never executed)

91. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=17.7..17.7 rows=385 width=36) (never executed)

92. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on oc_database ocd_2 (cost=0..17.7 rows=385 width=36) (never executed)

  • Filter: ocd_2.connections_allowed
93. 0.000 0.000 ↓ 0.0 0 0

Index Scan using agent_pkey on agent a_4 (cost=0.15..0.29 rows=1 width=68) (never executed)

  • Index Cond: (a_4.id = b_3.agent_id)
  • Filter: a_4.active
94. 0.000 0.000 ↓ 0.0 0 0

Index Scan using probe_config_table_pkey on probe_config_table c_4 (cost=0.15..4.56 rows=3 width=109) (never executed)

  • Index Cond: (b_3.server_id = c_4.server_id)
95. 0.000 0.000 ↓ 0.0 0 0

Index Scan using server_info_pkey on server_info sd_3 (cost=0.12..0.17 rows=1 width=8) (never executed)

  • Index Cond: (b_3.server_id = sd_3.server_id)
96. 0.000 0.000 ↓ 0.0 0 0

Index Scan using probe_server_version_unique on probe_server_version psv_3 (cost=0.27..8.29 rows=1 width=512) (never executed)

  • Index Cond: ((p_4.id = psv_3.probe_id) AND (sd_3.server_version_id = psv_3.server_version_id))
97. 0.001 0.023 ↓ 0.0 0 1

Subquery Scan on *SELECT* 6 (cost=109.19..139.4 rows=4 width=173) (actual time=0.023..0.023 rows=0 loops=1)

  • Buffers: shared hit=7
98. 0.000 0.022 ↓ 0.0 0 1

Hash Join (cost=109.19..139.36 rows=4 width=226) (actual time=0.022..0.022 rows=0 loops=1)

  • Filter: (p_5.any_server_version OR (psv_4.probe_id IS NOT NULL))
  • Buffers: shared hit=7
99. 0.001 0.022 ↓ 0.0 0 1

Nested Loop (cost=82.69..112.8 rows=4 width=373) (actual time=0.022..0.022 rows=0 loops=1)

  • Buffers: shared hit=7
100. 0.000 0.021 ↓ 0.0 0 1

Nested Loop (cost=82.57..112.07 rows=4 width=369) (actual time=0.021..0.021 rows=0 loops=1)

  • Buffers: shared hit=7
101. 0.009 0.021 ↓ 0.0 0 1

Hash Join (cost=82.42..108.82 rows=10 width=416) (actual time=0.021..0.021 rows=0 loops=1)

  • Filter: COALESCE(c_5.enabled, p_5.enabled_by_default)
  • Buffers: shared hit=7
102. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on probe_config_index c_5 (cost=0..15.7 rows=570 width=109) (never executed)

103. 0.000 0.012 ↓ 0.0 0 1

Hash (cost=81.95..81.95 rows=21 width=413) (actual time=0.012..0.012 rows=0 loops=1)

  • Buffers: shared hit=7
104. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=58.27..81.95 rows=21 width=413) (actual time=0.012..0.012 rows=0 loops=1)

  • Buffers: shared hit=7
105. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on probe p_5 (cost=0..7.75 rows=1 width=366) (actual time=0.011..0.012 rows=0 loops=1)

  • Filter: ((NOT p_5.deleted) AND (p_5.target_type_id = 600))
  • Buffers: shared hit=7
106. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=58.27..73.99 rows=21 width=47) (never executed)

107. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on agent_server_binding b_4 (cost=0..14 rows=400 width=8) (never executed)

108. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=58.13..58.13 rows=11 width=47) (never executed)

109. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=23.47..58.13 rows=11 width=47) (never executed)

110. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on oc_index oc_2 (cost=0..28.92 rows=1,092 width=43) (never executed)

111. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=17.7..17.7 rows=385 width=36) (never executed)

112. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on oc_database ocd_3 (cost=0..17.7 rows=385 width=36) (never executed)

  • Filter: ocd_3.connections_allowed
113. 0.000 0.000 ↓ 0.0 0 0

Index Scan using agent_pkey on agent a_5 (cost=0.15..0.29 rows=1 width=68) (never executed)

  • Index Cond: (a_5.id = b_4.agent_id)
  • Filter: a_5.active
114. 0.000 0.000 ↓ 0.0 0 0

Index Scan using server_info_pkey on server_info sd_4 (cost=0.12..0.17 rows=1 width=8) (never executed)

  • Index Cond: (b_4.server_id = sd_4.server_id)
115. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=19..19 rows=500 width=512) (never executed)

116. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on probe_server_version psv_4 (cost=0..19 rows=500 width=512) (never executed)

117. 0.000 0.766 ↓ 0.0 0 1

Subquery Scan on *SELECT* 7 (cost=24.32..49.85 rows=1 width=172) (actual time=0.766..0.766 rows=0 loops=1)

  • Buffers: shared hit=662
118. 0.001 0.766 ↓ 0.0 0 1

Nested Loop (cost=24.32..49.84 rows=1 width=225) (actual time=0.766..0.766 rows=0 loops=1)

  • Filter: COALESCE(c_6.enabled, p_6.enabled_by_default)
  • Buffers: shared hit=662
119. 0.000 0.765 ↓ 0.0 0 1

Nested Loop (cost=24.17..45.21 rows=1 width=858) (actual time=0.765..0.765 rows=0 loops=1)

  • Filter: (p_6.any_server_version OR (psv_5.probe_id IS NOT NULL))
  • Buffers: shared hit=662
120. 0.000 0.765 ↓ 0.0 0 1

Nested Loop (cost=23.89..36.91 rows=1 width=359) (actual time=0.765..0.765 rows=0 loops=1)

  • Buffers: shared hit=662
121. 0.033 0.765 ↓ 0.0 0 1

Nested Loop (cost=23.77..36.69 rows=1 width=355) (actual time=0.765..0.765 rows=0 loops=1)

  • Buffers: shared hit=662
122. 0.003 0.192 ↓ 60.0 60 1

Nested Loop (cost=23.77..28.9 rows=1 width=100) (actual time=0.057..0.192 rows=60 loops=1)

  • Buffers: shared hit=242
123. 0.014 0.129 ↓ 60.0 60 1

Nested Loop (cost=23.62..28.61 rows=1 width=36) (actual time=0.049..0.129 rows=60 loops=1)

  • Buffers: shared hit=122
124. 0.033 0.055 ↓ 60.0 60 1

Hash Join (cost=23.47..25.3 rows=1 width=36) (actual time=0.031..0.055 rows=60 loops=1)

  • Buffers: shared hit=2
125. 0.012 0.012 ↓ 1.1 60 1

Seq Scan on oc_sequence oc_3 (cost=0..1.54 rows=54 width=32) (actual time=0.008..0.012 rows=60 loops=1)

  • Buffers: shared hit=1
126. 0.006 0.010 ↑ 77.0 5 1

Hash (cost=17.7..17.7 rows=385 width=36) (actual time=0.01..0.01 rows=5 loops=1)

  • Buffers: shared hit=1
127. 0.004 0.004 ↑ 77.0 5 1

Seq Scan on oc_database ocd_4 (cost=0..17.7 rows=385 width=36) (actual time=0.003..0.004 rows=5 loops=1)

  • Filter: ocd_4.connections_allowed
  • Buffers: shared hit=1
128. 0.060 0.060 ↑ 2.0 1 60

Index Only Scan using agent_server_binding_pkey on agent_server_binding b_5 (cost=0.15..3.29 rows=2 width=8) (actual time=0.001..0.001 rows=1 loops=60)

  • Index Cond: (b_5.server_id = ocd_4.server_id)
  • Heap Fetches: 60
  • Buffers: shared hit=120
129. 0.060 0.060 ↑ 1.0 1 60

Index Scan using agent_pkey on agent a_6 (cost=0.15..0.29 rows=1 width=68) (actual time=0.001..0.001 rows=1 loops=60)

  • Index Cond: (a_6.id = b_5.agent_id)
  • Filter: a_6.active
  • Buffers: shared hit=120
130. 0.540 0.540 ↓ 0.0 0 60

Seq Scan on probe p_6 (cost=0..7.75 rows=1 width=366) (actual time=0.009..0.009 rows=0 loops=60)

  • Filter: ((NOT p_6.deleted) AND (p_6.target_type_id = 700))
  • Buffers: shared hit=420
131. 0.000 0.000 ↓ 0.0 0 0

Index Scan using server_info_pkey on server_info sd_5 (cost=0.12..0.17 rows=1 width=8) (never executed)

  • Index Cond: (b_5.server_id = sd_5.server_id)
132. 0.000 0.000 ↓ 0.0 0 0

Index Scan using probe_server_version_unique on probe_server_version psv_5 (cost=0.27..8.29 rows=1 width=512) (never executed)

  • Index Cond: ((p_6.id = psv_5.probe_id) AND (sd_5.server_version_id = psv_5.server_version_id))
133. 0.000 0.000 ↓ 0.0 0 0

Index Scan using probe_config_sequence_pkey on probe_config_sequence c_6 (cost=0.15..4.56 rows=3 width=109) (never executed)

  • Index Cond: (b_5.server_id = c_6.server_id)
134. 0.000 0.011 ↓ 0.0 0 1

Subquery Scan on *SELECT* 8 (cost=111.42..739.53 rows=73 width=174) (actual time=0.011..0.011 rows=0 loops=1)

  • Buffers: shared hit=7
135. 0.000 0.011 ↓ 0.0 0 1

Hash Join (cost=111.42..738.8 rows=73 width=227) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (p_7.any_server_version OR (psv_6.probe_id IS NOT NULL))
  • Buffers: shared hit=7
136. 0.001 0.011 ↓ 0.0 0 1

Nested Loop (cost=84.92..711.19 rows=73 width=363) (actual time=0.011..0.011 rows=0 loops=1)

  • Buffers: shared hit=7
137. 0.000 0.010 ↓ 0.0 0 1

Hash Join (cost=84.92..709.08 rows=73 width=359) (actual time=0.01..0.01 rows=0 loops=1)

  • Filter: COALESCE(c_7.enabled, p_7.enabled_by_default)
  • Buffers: shared hit=7
138. 0.000 0.010 ↓ 0.0 0 1

Nested Loop (cost=56.4..678.64 rows=146 width=356) (actual time=0.01..0.01 rows=0 loops=1)

  • Buffers: shared hit=7
139. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on probe p_7 (cost=0..7.75 rows=1 width=366) (actual time=0.01..0.01 rows=0 loops=1)

  • Filter: ((NOT p_7.deleted) AND (p_7.target_type_id = 800))
  • Buffers: shared hit=7
140. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=56.4..663.29 rows=190 width=101) (never executed)

141. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=23.47..623.24 rows=190 width=37) (never executed)

142. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on oc_function oc_4 (cost=0..495.88 rows=19,788 width=33) (never executed)

143. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=17.7..17.7 rows=385 width=36) (never executed)

144. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on oc_database ocd_5 (cost=0..17.7 rows=385 width=36) (never executed)

  • Filter: ocd_5.connections_allowed
145. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=30.42..30.42 rows=200 width=72) (never executed)

146. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=15.36..30.42 rows=200 width=72) (never executed)

147. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on agent_server_binding b_6 (cost=0..14 rows=400 width=8) (never executed)

148. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=13.3..13.3 rows=165 width=68) (never executed)

149. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on agent a_7 (cost=0..13.3 rows=165 width=68) (never executed)

  • Filter: a_7.active
150. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=15.7..15.7 rows=570 width=109) (never executed)

151. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on probe_config_function c_7 (cost=0..15.7 rows=570 width=109) (never executed)

152. 0.000 0.000 ↓ 0.0 0 0

Materialize (cost=0..1.01 rows=1 width=8) (never executed)

153. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on server_info sd_6 (cost=0..1.01 rows=1 width=8) (never executed)

154. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=19..19 rows=500 width=512) (never executed)

155. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on probe_server_version psv_6 (cost=0..19 rows=500 width=512) (never executed)

156. 0.000 0.026 ↓ 0.0 0 1

Subquery Scan on *SELECT* 9 (cost=207.28..237.5 rows=4 width=174) (actual time=0.026..0.026 rows=0 loops=1)

  • Buffers: shared hit=7
157. 0.001 0.026 ↓ 0.0 0 1

Hash Join (cost=207.28..237.46 rows=4 width=227) (actual time=0.026..0.026 rows=0 loops=1)

  • Filter: (p_8.any_server_version OR (psv_7.probe_id IS NOT NULL))
  • Buffers: shared hit=7
158. 0.000 0.025 ↓ 0.0 0 1

Nested Loop (cost=180.78..210.89 rows=4 width=366) (actual time=0.025..0.025 rows=0 loops=1)

  • Buffers: shared hit=7
159. 0.000 0.025 ↓ 0.0 0 1

Nested Loop (cost=180.66..210.16 rows=4 width=362) (actual time=0.025..0.025 rows=0 loops=1)

  • Buffers: shared hit=7
160. 0.013 0.025 ↓ 0.0 0 1

Hash Join (cost=180.51..206.91 rows=10 width=409) (actual time=0.025..0.025 rows=0 loops=1)

  • Filter: COALESCE(c_8.enabled, p_8.enabled_by_default)
  • Buffers: shared hit=7
161. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on probe_config_view c_8 (cost=0..15.7 rows=570 width=109) (never executed)

162. 0.001 0.012 ↓ 0.0 0 1

Hash (cost=180.04..180.04 rows=21 width=406) (actual time=0.012..0.012 rows=0 loops=1)

  • Buffers: shared hit=7
163. 0.000 0.011 ↓ 0.0 0 1

Nested Loop (cost=156.36..180.04 rows=21 width=406) (actual time=0.011..0.011 rows=0 loops=1)

  • Buffers: shared hit=7
164. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on probe p_8 (cost=0..7.75 rows=1 width=366) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: ((NOT p_8.deleted) AND (p_8.target_type_id = 900))
  • Buffers: shared hit=7
165. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=156.36..172.08 rows=21 width=40) (never executed)

166. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on agent_server_binding b_7 (cost=0..14 rows=400 width=8) (never executed)

167. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=156.22..156.22 rows=11 width=40) (never executed)

168. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=23.47..156.22 rows=11 width=40) (never executed)

169. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on oc_views oc_5 (cost=0..126.98 rows=1,098 width=36) (never executed)

170. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=17.7..17.7 rows=385 width=36) (never executed)

171. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on oc_database ocd_6 (cost=0..17.7 rows=385 width=36) (never executed)

  • Filter: ocd_6.connections_allowed
172. 0.000 0.000 ↓ 0.0 0 0

Index Scan using agent_pkey on agent a_8 (cost=0.15..0.29 rows=1 width=68) (never executed)

  • Index Cond: (a_8.id = b_7.agent_id)
  • Filter: a_8.active
173. 0.000 0.000 ↓ 0.0 0 0

Index Scan using server_info_pkey on server_info sd_7 (cost=0.12..0.17 rows=1 width=8) (never executed)

  • Index Cond: (b_7.server_id = sd_7.server_id)
174. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=19..19 rows=500 width=512) (never executed)

175. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on probe_server_version psv_7 (cost=0..19 rows=500 width=512) (never executed)

176. 0.074 0.149 ↑ 1.0 234 1

Hash (cost=8.34..8.34 rows=234 width=65) (actual time=0.149..0.149 rows=234 loops=1)

  • Buffers: shared hit=6
177. 0.075 0.075 ↑ 1.0 234 1

Seq Scan on probe_schedule s (cost=0..8.34 rows=234 width=65) (actual time=0.011..0.075 rows=234 loops=1)

  • Buffers: shared hit=6
Planning time : 25.432 ms
Execution time : 4.886 ms