explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lag2

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 166,310.551 ↑ 60.0 1 1

Nested Loop Left Join (cost=5,523.27..156,282.67 rows=60 width=4) (actual time=56,706.695..166,310.551 rows=1 loops=1)

  • Buffers: shared hit=5,298,648 dirtied=2
2. 0.012 166,310.524 ↑ 7.0 1 1

Hash Left Join (cost=3,638.96..135,537.31 rows=7 width=8) (actual time=56,706.670..166,310.524 rows=1 loops=1)

  • Hash Cond: (m.id = mhp.mhp_measure_id)
  • Buffers: shared hit=5,298,648 dirtied=2
3. 112.820 166,157.932 ↑ 7.0 1 1

Nested Loop Left Join (cost=3,616.21..135,513.66 rows=7 width=12) (actual time=56,554.078..166,157.932 rows=1 loops=1)

  • Filter: ((COALESCE(snmpt_1.if_id, hd_1.interface_id)) = 333,801)
  • Rows Removed by Filter: 164,106
  • Buffers: shared hit=5,297,275 dirtied=2
4. 37.375 297.042 ↓ 351.4 164,107 1

Hash Left Join (cost=2,659.62..8,551.13 rows=467 width=12) (actual time=34.752..297.042 rows=164,107 loops=1)

  • Hash Cond: (m.pilot_agent_id = h_1.id)
  • Buffers: shared hit=3,945
5. 56.734 242.425 ↓ 1,032.1 164,107 1

Hash Left Join (cost=1,318.00..7,208.51 rows=159 width=16) (actual time=17.501..242.425 rows=164,107 loops=1)

  • Hash Cond: (h.view_id = v.id)
  • Buffers: shared hit=3,751
6. 118.446 168.292 ↓ 3,039.0 164,107 1

Hash Join (cost=14.48..5,826.58 rows=54 width=20) (actual time=0.063..168.292 rows=164,107 loops=1)

  • Hash Cond: (m.agent_id = h.id)
  • Buffers: shared hit=3,572
7. 49.802 49.802 ↓ 1.0 164,107 1

Seq Scan on all_measures m (cost=0.00..5,196.68 rows=163,968 width=24) (actual time=0.009..49.802 rows=164,107 loops=1)

  • Buffers: shared hit=3,557
8. 0.001 0.044 ↑ 1.2 13 1

Hash (cost=14.28..14.28 rows=16 width=8) (actual time=0.044..0.044 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=15
9. 0.043 0.043 ↑ 1.2 13 1

Index Scan using host_index_7 on host h (cost=0.29..14.28 rows=16 width=8) (actual time=0.015..0.043 rows=13 loops=1)

  • Index Cond: ((type)::text = 'AGENT'::text)
  • Buffers: shared hit=15
10. 1.007 17.399 ↑ 2.0 5,678 1

Hash (cost=1,161.54..1,161.54 rows=11,358 width=4) (actual time=17.399..17.399 rows=5,678 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 328kB
  • Buffers: shared hit=179
11. 0.814 16.392 ↑ 2.0 5,678 1

Subquery Scan on v (cost=934.38..1,161.54 rows=11,358 width=4) (actual time=14.146..16.392 rows=5,678 loops=1)

  • Buffers: shared hit=179
12. 3.733 15.578 ↑ 2.0 5,678 1

HashAggregate (cost=934.38..1,047.96 rows=11,358 width=18) (actual time=14.146..15.578 rows=5,678 loops=1)

  • Group Key: av.id, av.name, av.nb_position, av.display_sub_entries
  • Buffers: shared hit=179
13. 2.757 11.845 ↑ 2.6 5,717 1

Hash Join (cost=202.57..782.91 rows=15,147 width=18) (actual time=2.164..11.845 rows=5,717 loops=1)

  • Hash Cond: ((fgva.group_name)::text = (alaloop_user_functionnality_group_association.functionnality_group_name)::text)
  • Buffers: shared hit=179
14. 5.696 9.065 ↓ 1.0 15,286 1

Hash Join (cost=197.78..663.52 rows=15,147 width=27) (actual time=2.134..9.065 rows=15,286 loops=1)

  • Hash Cond: (fgva.view_id = av.id)
  • Buffers: shared hit=176
15. 1.270 1.270 ↓ 1.0 15,286 1

Seq Scan on functionnality_group_view_association fgva (cost=0.00..257.47 rows=15,147 width=13) (actual time=0.012..1.270 rows=15,286 loops=1)

  • Buffers: shared hit=106
16. 1.053 2.099 ↑ 1.0 5,679 1

Hash (cost=126.79..126.79 rows=5,679 width=18) (actual time=2.099..2.099 rows=5,679 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 354kB
  • Buffers: shared hit=70
17. 1.046 1.046 ↑ 1.0 5,679 1

Seq Scan on all_views av (cost=0.00..126.79 rows=5,679 width=18) (actual time=0.006..1.046 rows=5,679 loops=1)

  • Buffers: shared hit=70
18. 0.005 0.023 ↑ 1.3 13 1

Hash (cost=4.58..4.58 rows=17 width=18) (actual time=0.023..0.023 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
19. 0.018 0.018 ↑ 1.3 13 1

Index Only Scan using alaloop_user_functionnality_group_association_pkey on alaloop_user_functionnality_group_association (cost=0.28..4.58 rows=17 width=18) (actual time=0.014..0.018 rows=13 loops=1)

  • Index Cond: (login = current_setting('alaloop.javauser'::text))
  • Heap Fetches: 0
  • Buffers: shared hit=3
20. 0.005 17.242 ↑ 3.6 13 1

Hash (cost=1,341.03..1,341.03 rows=47 width=4) (actual time=17.242..17.242 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=194
21. 0.056 17.237 ↑ 3.6 13 1

Hash Left Join (cost=1,303.81..1,341.03 rows=47 width=4) (actual time=17.201..17.237 rows=13 loops=1)

  • Hash Cond: (h_1.view_id = v_1.id)
  • Buffers: shared hit=194
22. 0.032 0.032 ↑ 1.2 13 1

Index Scan using host_index_7 on host h_1 (cost=0.29..14.28 rows=16 width=8) (actual time=0.011..0.032 rows=13 loops=1)

  • Index Cond: ((type)::text = 'AGENT'::text)
  • Buffers: shared hit=15
23. 0.974 17.149 ↑ 2.0 5,678 1

Hash (cost=1,161.54..1,161.54 rows=11,358 width=4) (actual time=17.149..17.149 rows=5,678 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 328kB
  • Buffers: shared hit=179
24. 0.974 16.175 ↑ 2.0 5,678 1

Subquery Scan on v_1 (cost=934.38..1,161.54 rows=11,358 width=4) (actual time=13.740..16.175 rows=5,678 loops=1)

  • Buffers: shared hit=179
25. 3.798 15.201 ↑ 2.0 5,678 1

HashAggregate (cost=934.38..1,047.96 rows=11,358 width=18) (actual time=13.739..15.201 rows=5,678 loops=1)

  • Group Key: av_1.id, av_1.name, av_1.nb_position, av_1.display_sub_entries
  • Buffers: shared hit=179
26. 2.712 11.403 ↑ 2.6 5,717 1

Hash Join (cost=202.57..782.91 rows=15,147 width=18) (actual time=2.122..11.403 rows=5,717 loops=1)

  • Hash Cond: ((fgva_1.group_name)::text = (alaloop_user_functionnality_group_association_1.functionnality_group_name)::text)
  • Buffers: shared hit=179
27. 5.279 8.671 ↓ 1.0 15,286 1

Hash Join (cost=197.78..663.52 rows=15,147 width=27) (actual time=2.093..8.671 rows=15,286 loops=1)

  • Hash Cond: (fgva_1.view_id = av_1.id)
  • Buffers: shared hit=176
28. 1.328 1.328 ↓ 1.0 15,286 1

Seq Scan on functionnality_group_view_association fgva_1 (cost=0.00..257.47 rows=15,147 width=13) (actual time=0.007..1.328 rows=15,286 loops=1)

  • Buffers: shared hit=106
29. 1.113 2.064 ↑ 1.0 5,679 1

Hash (cost=126.79..126.79 rows=5,679 width=18) (actual time=2.064..2.064 rows=5,679 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 354kB
  • Buffers: shared hit=70
30. 0.951 0.951 ↑ 1.0 5,679 1

Seq Scan on all_views av_1 (cost=0.00..126.79 rows=5,679 width=18) (actual time=0.005..0.951 rows=5,679 loops=1)

  • Buffers: shared hit=70
31. 0.003 0.020 ↑ 1.3 13 1

Hash (cost=4.58..4.58 rows=17 width=18) (actual time=0.020..0.020 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
32. 0.017 0.017 ↑ 1.3 13 1

Index Only Scan using alaloop_user_functionnality_group_association_pkey on alaloop_user_functionnality_group_association alaloop_user_functionnality_group_association_1 (cost=0.28..4.58 rows=17 width=18) (actual time=0.014..0.017 rows=13 loops=1)

  • Index Cond: (login = current_setting('alaloop.javauser'::text))
  • Heap Fetches: 0
  • Buffers: shared hit=3
33. 59,287.465 165,748.070 ↑ 3.0 1 164,107

Hash Right Join (cost=956.59..1,226.38 rows=3 width=8) (actual time=0.526..1.010 rows=1 loops=164,107)

  • Hash Cond: (av_2.id = h_4.view_id)
  • Buffers: shared hit=5,293,330 dirtied=2
34. 98,573.700 98,583.469 ↑ 2.0 5,678 132,683

HashAggregate (cost=934.38..1,047.96 rows=11,358 width=18) (actual time=0.000..0.743 rows=5,678 loops=132,683)

  • Group Key: av_2.id, av_2.name, av_2.nb_position, av_2.display_sub_entries
  • Buffers: shared hit=179
35. 2.378 9.769 ↑ 2.6 5,717 1

Hash Join (cost=202.57..782.91 rows=15,147 width=18) (actual time=1.740..9.769 rows=5,717 loops=1)

  • Hash Cond: ((fgva_2.group_name)::text = (alaloop_user_functionnality_group_association_2.functionnality_group_name)::text)
  • Buffers: shared hit=179
36. 4.521 7.364 ↓ 1.0 15,286 1

Hash Join (cost=197.78..663.52 rows=15,147 width=27) (actual time=1.705..7.364 rows=15,286 loops=1)

  • Hash Cond: (fgva_2.view_id = av_2.id)
  • Buffers: shared hit=176
37. 1.161 1.161 ↓ 1.0 15,286 1

Seq Scan on functionnality_group_view_association fgva_2 (cost=0.00..257.47 rows=15,147 width=13) (actual time=0.006..1.161 rows=15,286 loops=1)

  • Buffers: shared hit=106
38. 0.903 1.682 ↑ 1.0 5,679 1

Hash (cost=126.79..126.79 rows=5,679 width=18) (actual time=1.682..1.682 rows=5,679 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 354kB
  • Buffers: shared hit=70
39. 0.779 0.779 ↑ 1.0 5,679 1

Seq Scan on all_views av_2 (cost=0.00..126.79 rows=5,679 width=18) (actual time=0.023..0.779 rows=5,679 loops=1)

  • Buffers: shared hit=70
40. 0.006 0.027 ↑ 1.3 13 1

Hash (cost=4.58..4.58 rows=17 width=18) (actual time=0.027..0.027 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
41. 0.021 0.021 ↑ 1.3 13 1

Index Only Scan using alaloop_user_functionnality_group_association_pkey on alaloop_user_functionnality_group_association alaloop_user_functionnality_group_association_2 (cost=0.28..4.58 rows=17 width=18) (actual time=0.019..0.021 rows=13 loops=1)

  • Index Cond: (login = current_setting('alaloop.javauser'::text))
  • Heap Fetches: 0
  • Buffers: shared hit=3
42. 0.000 7,877.136 ↑ 1.0 1 164,107

Hash (cost=22.20..22.20 rows=1 width=12) (actual time=0.048..0.048 rows=1 loops=164,107)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=5,293,151 dirtied=2
43. 125.696 7,877.136 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=7.47..22.20 rows=1 width=12) (actual time=0.045..0.048 rows=1 loops=164,107)

  • Buffers: shared hit=5,293,151 dirtied=2
44. 164.107 7,220.708 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=7.18..13.88 rows=1 width=64) (actual time=0.041..0.044 rows=1 loops=164,107)

  • Buffers: shared hit=4,898,774 dirtied=2
45. 31.424 7,056.601 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=6.89..9.23 rows=1 width=68) (actual time=0.041..0.043 rows=1 loops=164,107)

  • Buffers: shared hit=4,898,749 dirtied=2
46. 31.424 6,892.494 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=6.74..9.06 rows=1 width=68) (actual time=0.040..0.042 rows=1 loops=164,107)

  • Buffers: shared hit=4,766,066 dirtied=2
47. 31.424 6,728.387 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=6.61..8.90 rows=1 width=64) (actual time=0.039..0.041 rows=1 loops=164,107)

  • Buffers: shared hit=4,633,371 dirtied=2
48. 164.107 6,564.280 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=6.46..8.72 rows=1 width=60) (actual time=0.038..0.040 rows=1 loops=164,107)

  • Buffers: shared hit=4,500,688 dirtied=2
49. 31.424 6,400.173 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=6.31..8.54 rows=1 width=56) (actual time=0.037..0.039 rows=1 loops=164,107)

  • Buffers: shared hit=4,368,005 dirtied=2
50. 62.848 6,236.066 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=6.18..8.38 rows=1 width=56) (actual time=0.036..0.038 rows=1 loops=164,107)

  • Buffers: shared hit=4,235,322 dirtied=2
51. 31.424 5,907.852 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=5.89..8.07 rows=1 width=52) (actual time=0.034..0.036 rows=1 loops=164,107)

  • Buffers: shared hit=3,963,071 dirtied=2
52. 31.424 5,743.745 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=5.75..7.90 rows=1 width=52) (actual time=0.033..0.035 rows=1 loops=164,107)

  • Buffers: shared hit=3,830,387 dirtied=2
53. 195.531 5,579.638 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=5.62..7.74 rows=1 width=52) (actual time=0.032..0.034 rows=1 loops=164,107)

  • Buffers: shared hit=3,697,703 dirtied=2
54. 31.424 5,251.424 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=5.48..7.58 rows=1 width=52) (actual time=0.031..0.032 rows=1 loops=164,107)

  • Buffers: shared hit=3,565,019 dirtied=2
55. 164.107 5,087.317 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=5.20..7.26 rows=1 width=52) (actual time=0.029..0.031 rows=1 loops=164,107)

  • Buffers: shared hit=3,299,482 dirtied=2
56. 31.424 4,923.210 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=4.92..6.91 rows=1 width=52) (actual time=0.028..0.030 rows=1 loops=164,107)

  • Buffers: shared hit=3,298,152 dirtied=2
57. 164.107 4,759.103 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=4.65..6.61 rows=1 width=48) (actual time=0.027..0.029 rows=1 loops=164,107)

  • Buffers: shared hit=3,032,342 dirtied=2
58. 31.424 4,594.996 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=4.50..5.39 rows=1 width=52) (actual time=0.026..0.028 rows=1 loops=164,107)

  • Buffers: shared hit=3,032,342 dirtied=2
59. 226.955 4,430.889 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=4.36..5.22 rows=1 width=48) (actual time=0.025..0.027 rows=1 loops=164,107)

  • Buffers: shared hit=2,899,659 dirtied=2
60. 0.000 3,938.568 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=4.07..4.90 rows=1 width=44) (actual time=0.023..0.024 rows=1 loops=164,107)

  • Buffers: shared hit=2,608,812 dirtied=2
61. 31.424 3,938.568 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=3.93..4.71 rows=1 width=44) (actual time=0.022..0.024 rows=1 loops=164,107)

  • Buffers: shared hit=2,608,812 dirtied=2
62. 31.424 3,774.461 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=3.77..4.53 rows=1 width=40) (actual time=0.022..0.023 rows=1 loops=164,107)

  • Buffers: shared hit=2,476,129 dirtied=2
63. 164.107 3,610.354 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=3.64..4.36 rows=1 width=40) (actual time=0.021..0.022 rows=1 loops=164,107)

  • Buffers: shared hit=2,343,446 dirtied=2
64. 195.531 3,446.247 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=3.36..3.96 rows=1 width=40) (actual time=0.020..0.021 rows=1 loops=164,107)

  • Buffers: shared hit=2,338,987 dirtied=2
65. 31.424 3,118.033 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=3.08..3.65 rows=1 width=36) (actual time=0.018..0.019 rows=1 loops=164,107)

  • Buffers: shared hit=2,072,127 dirtied=2
66. 164.107 2,953.926 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=2.94..3.48 rows=1 width=32) (actual time=0.017..0.018 rows=1 loops=164,107)

  • Buffers: shared hit=1,939,430 dirtied=2
67. 31.424 2,789.819 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=2.52..3.00 rows=1 width=36) (actual time=0.016..0.017 rows=1 loops=164,107)

  • Buffers: shared hit=1,908,461 dirtied=2
68. 31.424 2,625.712 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=2.10..2.53 rows=1 width=32) (actual time=0.015..0.016 rows=1 loops=164,107)

  • Buffers: shared hit=1,869,906
69. 94.272 2,461.605 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=1.68..2.01 rows=1 width=28) (actual time=0.014..0.015 rows=1 loops=164,107)

  • Buffers: shared hit=1,797,565
70. 195.531 1,969.284 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=1.26..1.55 rows=1 width=20) (actual time=0.011..0.012 rows=1 loops=164,107)

  • Buffers: shared hit=1,349,938
71. 62.848 1,641.070 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=1.13..1.39 rows=1 width=20) (actual time=0.010..0.010 rows=1 loops=164,107)

  • Buffers: shared hit=1,217,255
72. 31.424 1,312.856 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=0.84..1.07 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=164,107)

  • Buffers: shared hit=929,833
73. 226.955 1,148.749 ↑ 1.0 1 164,107

Nested Loop Left Join (cost=0.71..0.91 rows=1 width=12) (actual time=0.007..0.007 rows=1 loops=164,107)

  • Buffers: shared hit=797,143
74. 656.428 656.428 ↑ 1.0 1 164,107

Index Scan using target_pkey on target t_1 (cost=0.42..0.59 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=164,107)

  • Index Cond: (id = m.target_id)
  • Buffers: shared hit=531,474
75. 265.366 265.366 ↓ 0.0 0 132,683

Index Scan using service_target_pkey on target_service st_1 (cost=0.29..0.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=132,683)

  • Index Cond: (t_1.id = target_id)
  • Buffers: shared hit=265,669
76. 132.683 132.683 ↓ 0.0 0 132,683

Index Scan using target_monitor_list_pkey on target_monitor_list tml_1 (cost=0.13..0.15 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (t_1.id = target_id)
  • Buffers: shared hit=132,690
77. 265.366 265.366 ↓ 0.0 0 132,683

Index Only Scan using unique_host_target on target_host ht_1 (cost=0.29..0.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Heap Fetches: 21,746
  • Buffers: shared hit=287,422
78. 132.683 132.683 ↓ 0.0 0 132,683

Index Only Scan using web_target_pkey on target_web wt (cost=0.13..0.15 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Heap Fetches: 0
  • Buffers: shared hit=132,683
79. 398.049 398.049 ↓ 0.0 0 132,683

Index Scan using snmp_target_pkey on target_snmp snmpt_1 (cost=0.42..0.45 rows=1 width=12) (actual time=0.003..0.003 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Buffers: shared hit=447,627
80. 132.683 132.683 ↓ 0.0 0 132,683

Index Scan using interface_pkey on interface ifc_1 (cost=0.42..0.51 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (id = snmpt_1.if_id)
  • Buffers: shared hit=72,341
81. 132.683 132.683 ↓ 0.0 0 132,683

Index Scan using host_detail_pkey on host_detail hd_1 (cost=0.42..0.46 rows=1 width=12) (actual time=0.000..0.001 rows=0 loops=132,683)

  • Index Cond: (id = t_1.host_detail_id)
  • Buffers: shared hit=38,555 dirtied=2
82. 0.000 0.000 ↓ 0.0 0 132,683

Index Only Scan using interface_pkey on interface ifchd (cost=0.42..0.47 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=132,683)

  • Index Cond: (id = hd_1.interface_id)
  • Heap Fetches: 2,027
  • Buffers: shared hit=30,969
83. 132.683 132.683 ↓ 0.0 0 132,683

Index Scan using target_jvm_pkey on target_jvm tj_1 (cost=0.14..0.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Buffers: shared hit=132,697
84. 132.683 132.683 ↓ 0.0 0 132,683

Index Scan using target_storage_pkey on target_storage tst_1 (cost=0.28..0.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Buffers: shared hit=266,860
85. 0.000 0.000 ↓ 0.0 0 132,683

Index Scan using storage_pkey on host_storage stg_1 (cost=0.28..0.40 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=132,683)

  • Index Cond: (id = tst_1.storage_id)
  • Buffers: shared hit=4,459
86. 132.683 132.683 ↓ 0.0 0 132,683

Index Only Scan using target_nam_sca_pkey on target_nam tnam (cost=0.14..0.16 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Heap Fetches: 0
  • Buffers: shared hit=132,683
87. 132.683 132.683 ↓ 0.0 0 132,683

Index Scan using target_packeteer_pkey on target_packeteer tpt_1 (cost=0.15..0.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Buffers: shared hit=132,683
88. 0.000 0.000 ↓ 0.0 0 132,683

Index Scan using packeteer_link_pkey on host_packeteer_link pl_1 (cost=0.14..0.18 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=132,683)

  • Index Cond: (id = tpt_1.link_id)
89. 265.366 265.366 ↓ 0.0 0 132,683

Index Scan using target_wmi_pkey on target_auth tauth_1 (cost=0.29..0.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Buffers: shared hit=290,847
90. 132.683 132.683 ↓ 0.0 0 132,683

Index Scan using target_app_pkey on target_app tapp (cost=0.14..0.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Buffers: shared hit=132,683
91. 0.000 0.000 ↓ 0.0 0 132,683

Index Only Scan using applications_pkey on applications apps (cost=0.14..1.21 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=132,683)

  • Index Cond: (id_application = tapp.id_application)
  • Heap Fetches: 0
92. 132.683 132.683 ↓ 0.0 0 132,683

Index Scan using target_pabx4400_pkey on target_pabx4400 tp4400_1 (cost=0.28..0.29 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Buffers: shared hit=265,810
93. 0.000 0.000 ↓ 0.0 0 132,683

Index Scan using pabx4400_pkey on host_pabx4400 p4400_1 (cost=0.28..0.34 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=132,683)

  • Index Cond: (id = tp4400_1.pabx4400_id)
  • Buffers: shared hit=1,330
94. 132.683 132.683 ↓ 0.0 0 132,683

Index Only Scan using target_kpi_pkey on target_kpi tk (cost=0.29..0.30 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Heap Fetches: 0
  • Buffers: shared hit=265,537
95. 132.683 132.683 ↓ 0.0 0 132,683

Index Only Scan using target_dns_pkey on target_dns tdns (cost=0.14..0.16 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Heap Fetches: 0
  • Buffers: shared hit=132,684
96. 132.683 132.683 ↓ 0.0 0 132,683

Index Only Scan using target_oid_pkey on target_oid toid (cost=0.13..0.15 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Heap Fetches: 0
  • Buffers: shared hit=132,684
97. 132.683 132.683 ↓ 0.0 0 132,683

Index Only Scan using target_api_pkey on target_api tapi (cost=0.14..0.16 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Heap Fetches: 0
  • Buffers: shared hit=132,684
98. 265.366 265.366 ↓ 0.0 0 132,683

Index Scan using target_host_status_pkey on target_host_status ths_1 (cost=0.28..0.30 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Buffers: shared hit=272,251
99. 132.683 132.683 ↓ 0.0 0 132,683

Index Only Scan using target_minimal_pkey on target_minimal tmin (cost=0.14..0.15 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Heap Fetches: 0
  • Buffers: shared hit=132,683
100. 0.000 0.000 ↓ 0.0 0 132,683

Index Scan using target_sip_dial_peer_pkey on target_sip_dial_peer tsdp_1 (cost=0.15..0.17 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Buffers: shared hit=132,683
101. 132.683 132.683 ↓ 0.0 0 132,683

Index Scan using target_file_pkey on target_file tf_1 (cost=0.14..0.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Buffers: shared hit=132,683
102. 132.683 132.683 ↓ 0.0 0 132,683

Index Scan using target_dns_host_pkey on target_dns_host tdhost (cost=0.14..0.15 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Buffers: shared hit=132,695
103. 132.683 132.683 ↓ 0.0 0 132,683

Index Only Scan using target_intercloud_pk on target_intercloud tic (cost=0.14..0.16 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=132,683)

  • Index Cond: (target_id = t_1.id)
  • Heap Fetches: 0
  • Buffers: shared hit=132,683
104. 0.000 0.000 ↓ 0.0 0 132,683

Index Only Scan using host_pkey on host tdh (cost=0.29..4.64 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=132,683)

  • Index Cond: (id = tdhost.host_id)
  • Heap Fetches: 0
  • Buffers: shared hit=25
105. 530.732 530.732 ↑ 1.0 1 132,683

Index Scan using host_pkey on host h_4 (cost=0.29..8.31 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=132,683)

  • Index Cond: (id = COALESCE(st_1.host_id, tml_1.host_id, ht_1.host_id, snmpt_1.host_id, ifc_1.host_id, hd_1.host_id, tj_1.host_id, stg_1.host_id, tauth_1.host_id, p4400_1.host_id, pl_1.host_id, ths_1.host_id, tsdp_1.host_id, tf_1.host_id))
  • Buffers: shared hit=394,377
106. 18.786 152.580 ↓ 154.2 154,242 1

Hash (cost=10.25..10.25 rows=1,000 width=4) (actual time=152.580..152.580 rows=154,242 loops=1)

  • Buckets: 262,144 (originally 1024) Batches: 1 (originally 1) Memory Usage: 7,471kB
  • Buffers: shared hit=1,373
107. 133.794 133.794 ↓ 154.2 154,242 1

Function Scan on measure_has_parent mhp (cost=0.25..10.25 rows=1,000 width=4) (actual time=120.186..133.794 rows=154,242 loops=1)

  • Buffers: shared hit=1,373
108. 0.001 0.019 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,884.31..2,963.53 rows=9 width=4) (actual time=0.019..0.019 rows=0 loops=1)

109. 0.012 0.018 ↓ 0.0 0 1

Hash Right Join (cost=935.22..1,205.01 rows=3 width=8) (actual time=0.018..0.018 rows=0 loops=1)

  • Hash Cond: (av_3.id = h_2.view_id)
110. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=934.38..1,047.96 rows=11,358 width=18) (never executed)

  • Group Key: av_3.id, av_3.name, av_3.nb_position, av_3.display_sub_entries
111. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=202.57..782.91 rows=15,147 width=18) (never executed)

  • Hash Cond: ((fgva_3.group_name)::text = (alaloop_user_functionnality_group_association_3.functionnality_group_name)::text)
112. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=197.78..663.52 rows=15,147 width=27) (never executed)

  • Hash Cond: (fgva_3.view_id = av_3.id)
113. 0.000 0.000 ↓ 0.0 0

Seq Scan on functionnality_group_view_association fgva_3 (cost=0.00..257.47 rows=15,147 width=13) (never executed)

114. 0.000 0.000 ↓ 0.0 0

Hash (cost=126.79..126.79 rows=5,679 width=18) (never executed)

115. 0.000 0.000 ↓ 0.0 0

Seq Scan on all_views av_3 (cost=0.00..126.79 rows=5,679 width=18) (never executed)

116. 0.000 0.000 ↓ 0.0 0

Hash (cost=4.58..4.58 rows=17 width=18) (never executed)

117. 0.000 0.000 ↓ 0.0 0

Index Only Scan using alaloop_user_functionnality_group_association_pkey on alaloop_user_functionnality_group_association alaloop_user_functionnality_group_association_3 (cost=0.28..4.58 rows=17 width=18) (never executed)

  • Index Cond: (login = current_setting('alaloop.javauser'::text))
  • Heap Fetches: 0
118. 0.001 0.006 ↓ 0.0 0 1

Hash (cost=0.83..0.83 rows=1 width=12) (actual time=0.006..0.006 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
119. 0.003 0.005 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.58..0.83 rows=1 width=12) (actual time=0.005..0.005 rows=0 loops=1)

120. 0.002 0.002 ↓ 0.0 0 1

Index Scan using ipsla_instance_pkey on ipsla_instance ii (cost=0.29..0.33 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (id = m.ipsla_instance_id)
121. 0.000 0.000 ↓ 0.0 0

Index Scan using host_pkey on host h_2 (cost=0.29..0.49 rows=1 width=8) (never executed)

  • Index Cond: (id = ii.cisco_device_id)
  • Filter: ((type)::text = 'CISCODEVICE'::text)
122. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=949.09..1,218.87 rows=3 width=4) (never executed)

  • Hash Cond: (av_4.id = h_3.view_id)
123. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=934.38..1,047.96 rows=11,358 width=18) (never executed)

  • Group Key: av_4.id, av_4.name, av_4.nb_position, av_4.display_sub_entries
124. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=202.57..782.91 rows=15,147 width=18) (never executed)

  • Hash Cond: ((fgva_4.group_name)::text = (alaloop_user_functionnality_group_association_4.functionnality_group_name)::text)
125. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=197.78..663.52 rows=15,147 width=27) (never executed)

  • Hash Cond: (fgva_4.view_id = av_4.id)
126. 0.000 0.000 ↓ 0.0 0

Seq Scan on functionnality_group_view_association fgva_4 (cost=0.00..257.47 rows=15,147 width=13) (never executed)

127. 0.000 0.000 ↓ 0.0 0

Hash (cost=126.79..126.79 rows=5,679 width=18) (never executed)

128. 0.000 0.000 ↓ 0.0 0

Seq Scan on all_views av_4 (cost=0.00..126.79 rows=5,679 width=18) (never executed)

129. 0.000 0.000 ↓ 0.0 0

Hash (cost=4.58..4.58 rows=17 width=18) (never executed)

130. 0.000 0.000 ↓ 0.0 0

Index Only Scan using alaloop_user_functionnality_group_association_pkey on alaloop_user_functionnality_group_association alaloop_user_functionnality_group_association_4 (cost=0.28..4.58 rows=17 width=18) (never executed)

  • Index Cond: (login = current_setting('alaloop.javauser'::text))
  • Heap Fetches: 0
131. 0.000 0.000 ↓ 0.0 0

Hash (cost=14.69..14.69 rows=1 width=8) (never executed)

132. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=5.10..14.69 rows=1 width=8) (never executed)

133. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=4.81..6.38 rows=1 width=60) (never executed)

134. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=4.66..6.20 rows=1 width=56) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=4.51..6.02 rows=1 width=52) (never executed)

136. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=4.23..5.71 rows=1 width=48) (never executed)

137. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=3.95..5.36 rows=1 width=48) (never executed)

138. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=3.68..5.06 rows=1 width=44) (never executed)

139. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=3.39..4.74 rows=1 width=40) (never executed)

140. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=3.24..4.54 rows=1 width=40) (never executed)

141. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=3.09..4.36 rows=1 width=36) (never executed)

142. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=2.81..3.96 rows=1 width=36) (never executed)

143. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=2.53..3.65 rows=1 width=32) (never executed)

144. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=2.39..3.48 rows=1 width=28) (never executed)

145. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.97..3.01 rows=1 width=28) (never executed)

146. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.55..2.49 rows=1 width=28) (never executed)

147. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.03 rows=1 width=20) (never executed)

148. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.84..1.71 rows=1 width=16) (never executed)

149. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.55 rows=1 width=12) (never executed)

150. 0.000 0.000 ↓ 0.0 0

Index Scan using target_pkey on target t (cost=0.42..1.23 rows=1 width=8) (never executed)

  • Index Cond: (id = ii.target_id)
151. 0.000 0.000 ↓ 0.0 0

Index Scan using service_target_pkey on target_service st (cost=0.29..0.31 rows=1 width=8) (never executed)

  • Index Cond: (t.id = target_id)
152. 0.000 0.000 ↓ 0.0 0

Index Scan using target_monitor_list_pkey on target_monitor_list tml (cost=0.13..0.15 rows=1 width=8) (never executed)

  • Index Cond: (t.id = target_id)
153. 0.000 0.000 ↓ 0.0 0

Index Only Scan using unique_host_target on target_host ht (cost=0.29..0.31 rows=1 width=8) (never executed)

  • Index Cond: (target_id = t.id)
  • Heap Fetches: 0
154. 0.000 0.000 ↓ 0.0 0

Index Scan using snmp_target_pkey on target_snmp snmpt (cost=0.42..0.45 rows=1 width=12) (never executed)

  • Index Cond: (target_id = t.id)
155. 0.000 0.000 ↓ 0.0 0

Index Scan using interface_pkey on interface ifc (cost=0.42..0.51 rows=1 width=8) (never executed)

  • Index Cond: (id = snmpt.if_id)
156. 0.000 0.000 ↓ 0.0 0

Index Scan using host_detail_pkey on host_detail hd (cost=0.42..0.46 rows=1 width=12) (never executed)

  • Index Cond: (id = t.host_detail_id)
157. 0.000 0.000 ↓ 0.0 0

Index Scan using target_jvm_pkey on target_jvm tj (cost=0.14..0.16 rows=1 width=8) (never executed)

  • Index Cond: (target_id = t.id)
158. 0.000 0.000 ↓ 0.0 0

Index Scan using target_storage_pkey on target_storage tst (cost=0.28..0.30 rows=1 width=8) (never executed)

  • Index Cond: (target_id = t.id)
159. 0.000 0.000 ↓ 0.0 0

Index Scan using storage_pkey on host_storage stg (cost=0.28..0.40 rows=1 width=8) (never executed)

  • Index Cond: (id = tst.storage_id)
160. 0.000 0.000 ↓ 0.0 0

Index Scan using target_packeteer_pkey on target_packeteer tpt (cost=0.15..0.17 rows=1 width=8) (never executed)

  • Index Cond: (target_id = t.id)
161. 0.000 0.000 ↓ 0.0 0

Index Scan using packeteer_link_pkey on host_packeteer_link pl (cost=0.14..0.18 rows=1 width=8) (never executed)

  • Index Cond: (id = tpt.link_id)
162. 0.000 0.000 ↓ 0.0 0

Index Scan using target_wmi_pkey on target_auth tauth (cost=0.29..0.31 rows=1 width=8) (never executed)

  • Index Cond: (target_id = t.id)
163. 0.000 0.000 ↓ 0.0 0

Index Scan using target_pabx4400_pkey on target_pabx4400 tp4400 (cost=0.28..0.29 rows=1 width=8) (never executed)

  • Index Cond: (target_id = t.id)
164. 0.000 0.000 ↓ 0.0 0

Index Scan using pabx4400_pkey on host_pabx4400 p4400 (cost=0.28..0.34 rows=1 width=8) (never executed)

  • Index Cond: (id = tp4400.pabx4400_id)
165. 0.000 0.000 ↓ 0.0 0

Index Scan using target_host_status_pkey on target_host_status ths (cost=0.28..0.30 rows=1 width=8) (never executed)

  • Index Cond: (target_id = t.id)
166. 0.000 0.000 ↓ 0.0 0

Index Scan using target_sip_dial_peer_pkey on target_sip_dial_peer tsdp (cost=0.15..0.17 rows=1 width=8) (never executed)

  • Index Cond: (target_id = t.id)
167. 0.000 0.000 ↓ 0.0 0

Index Scan using target_file_pkey on target_file tf (cost=0.14..0.16 rows=1 width=8) (never executed)

  • Index Cond: (target_id = t.id)
168. 0.000 0.000 ↓ 0.0 0

Index Scan using host_pkey on host h_3 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Index Cond: (id = COALESCE(st.host_id, tml.host_id, ht.host_id, snmpt.host_id, ifc.host_id, hd.host_id, tj.host_id, stg.host_id, tauth.host_id, p4400.host_id, pl.host_id, ths.host_id, tsdp.host_id, tf.host_id))
Planning time : 53.501 ms
Execution time : 166,312.981 ms