explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xAXlb

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=37,261.25..12,485,658.89 rows=1,000 width=471) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=37,261.25..106,657,787.02 rows=8,565 width=471) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=37,261.00..63,638.55 rows=1,713 width=133) (actual rows= loops=)

  • Join Filter: (devicevalues.zone_id = zn.id)
4. 0.000 0.000 ↓ 0.0

Merge Join (cost=9.66..11,243.51 rows=2,482 width=99) (actual rows= loops=)

  • Merge Cond: (devicevalues.device_id = device.id)
  • Join Filter: (device.zone_id = devicevalues.zone_id)
5. 0.000 0.000 ↓ 0.0

Merge Append (cost=4.85..1,229.58 rows=9,389 width=12) (actual rows= loops=)

  • Sort Key: devicevalues.device_id
6. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues (cost=0.12..4.14 rows=1 width=12) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_1 (cost=0.15..27.55 rows=360 width=12) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_2 (cost=0.28..36.99 rows=581 width=12) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_3 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_4 (cost=0.15..27.55 rows=360 width=12) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_5 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_6 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_7 (cost=0.27..37.48 rows=481 width=12) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_8 (cost=0.15..27.55 rows=360 width=12) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_9 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_10 (cost=0.14..6.83 rows=46 width=12) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_11 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_12 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_13 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_14 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_15 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_16 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_17 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_18 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_19 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_20 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_21 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_22 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_23 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_24 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_25 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_values_devid on device_values devicevalues_26 (cost=0.15..29.55 rows=360 width=12) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Materialize (cost=4.82..1,329.14 rows=10,575 width=91) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Merge Append (cost=4.82..1,302.70 rows=10,575 width=91) (actual rows= loops=)

  • Sort Key: device.id
35. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device (cost=0.12..4.14 rows=1 width=95) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_1 (cost=0.15..28.90 rows=450 width=95) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_2 (cost=0.28..55.48 rows=581 width=59) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_3 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_4 (cost=0.15..28.90 rows=450 width=95) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_5 (cost=0.13..6.21 rows=5 width=63) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_6 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_7 (cost=0.27..49.08 rows=487 width=59) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_8 (cost=0.15..28.90 rows=450 width=95) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_9 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_10 (cost=0.14..8.83 rows=46 width=65) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_11 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_12 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_13 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_14 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_15 (cost=0.13..6.21 rows=5 width=61) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_16 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_17 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_18 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_19 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_20 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_21 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_22 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_23 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_24 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_25 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device device_26 (cost=0.15..30.90 rows=450 width=95) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Materialize (cost=37,251.34..47,257.65 rows=138 width=42) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Subquery Scan on zn (cost=37,251.34..47,256.96 rows=138 width=42) (actual rows= loops=)

  • Filter: (zn.username = 'admin'::text)
64. 0.000 0.000 ↓ 0.0

Unique (cost=37,251.34..46,911.94 rows=27,602 width=78) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Merge Append (cost=37,251.34..45,531.85 rows=276,017 width=78) (actual rows= loops=)

  • Sort Key: u.id, z.id
66. 0.000 0.000 ↓ 0.0

Group (cost=299.63..312.13 rows=1,667 width=78) (actual rows= loops=)

  • Group Key: u.id, z.id
67. 0.000 0.000 ↓ 0.0

Sort (cost=299.63..303.79 rows=1,667 width=78) (actual rows= loops=)

  • Sort Key: u.id, z.id
68. 0.000 0.000 ↓ 0.0

Hash Join (cost=129.75..210.42 rows=1,667 width=78) (actual rows= loops=)

  • Hash Cond: (ur.user_id = u.id)
69. 0.000 0.000 ↓ 0.0

Hash Join (cost=105.80..163.55 rows=1,667 width=46) (actual rows= loops=)

  • Hash Cond: (ur.role_id = r.id)
70. 0.000 0.000 ↓ 0.0

Seq Scan on user_role ur (cost=0.00..32.60 rows=2,260 width=8) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Hash (cost=94.74..94.74 rows=885 width=46) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Hash Join (cost=59.39..94.74 rows=885 width=46) (actual rows= loops=)

  • Hash Cond: (r.organization_id = o.id)
73. 0.000 0.000 ↓ 0.0

Seq Scan on role r (cost=0.00..22.00 rows=1,200 width=8) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Hash (cost=52.01..52.01 rows=590 width=50) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Hash Join (cost=28.00..52.01 rows=590 width=50) (actual rows= loops=)

  • Hash Cond: (z.organization_id = o.id)
76. 0.000 0.000 ↓ 0.0

Seq Scan on zone z (cost=0.00..15.90 rows=590 width=46) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Hash (cost=18.00..18.00 rows=800 width=4) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Seq Scan on organization o (cost=0.00..18.00 rows=800 width=4) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Hash (cost=16.20..16.20 rows=620 width=36) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Seq Scan on "user" u (cost=0.00..16.20 rows=620 width=36) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Group (cost=36,951.70..39,009.33 rows=274,350 width=78) (actual rows= loops=)

  • Group Key: u_1.id, z_1.id
82. 0.000 0.000 ↓ 0.0

Sort (cost=36,951.70..37,637.58 rows=274,350 width=78) (actual rows= loops=)

  • Sort Key: u_1.id, z_1.id
83. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..3,462.64 rows=274,350 width=78) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Seq Scan on zone z_1 (cost=0.00..15.90 rows=590 width=42) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..18.52 rows=465 width=36) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Seq Scan on "user" u_1 (cost=0.00..16.20 rows=465 width=36) (actual rows= loops=)

  • Filter: (superuser OR hidden)
87. 0.000 0.000 ↓ 0.0

Function Scan on ports (cost=0.25..12.75 rows=5 width=4) (actual rows= loops=)

  • Filter: (rid = device.id)
88.          

SubPlan (for Nested Loop Left Join)

89. 0.000 0.000 ↓ 0.0

Aggregate (cost=4,159.08..4,159.09 rows=1 width=32) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Subquery Scan on attribute (cost=4,156.65..4,159.05 rows=10 width=60) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Unique (cost=4,156.65..4,158.95 rows=10 width=44) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Sort (cost=4,156.65..4,157.80 rows=461 width=44) (actual rows= loops=)

  • Sort Key: att.type, dattr.last_update DESC
93. 0.000 0.000 ↓ 0.0

Hash Join (cost=613.79..4,136.25 rows=461 width=44) (actual rows= loops=)

  • Hash Cond: (dattr.attribute_id = a.id)
94. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.23..3,507.04 rows=247 width=28) (actual rows= loops=)

  • Join Filter: (SubPlan 1)
95. 0.000 0.000 ↓ 0.0

Append (cost=0.00..100.95 rows=27 width=8) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Seq Scan on device d (cost=0.00..0.00 rows=1 width=8) (actual rows= loops=)

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
97. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_1 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
98. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_2 (cost=0.28..4.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
99. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_3 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
100. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_4 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
101. 0.000 0.000 ↓ 0.0

Seq Scan on device d_5 (cost=0.00..1.07 rows=1 width=8) (actual rows= loops=)

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
102. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_6 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
103. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_7 (cost=0.27..4.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
104. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_8 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
105. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_9 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
106. 0.000 0.000 ↓ 0.0

Seq Scan on device d_10 (cost=0.00..2.69 rows=1 width=8) (actual rows= loops=)

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
107. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_11 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
108. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_12 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
109. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_13 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
110. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_14 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
111. 0.000 0.000 ↓ 0.0

Seq Scan on device d_15 (cost=0.00..1.07 rows=1 width=8) (actual rows= loops=)

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
112. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_16 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
113. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_17 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
114. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_18 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
115. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_19 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
116. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_20 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
117. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_21 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
118. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_22 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
119. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_23 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
120. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_24 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
121. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_25 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
122. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_26 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
123. 0.000 0.000 ↓ 0.0

Materialize (cost=1.23..239.85 rows=18 width=28) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.23..239.76 rows=18 width=28) (actual rows= loops=)

  • Hash Cond: (dattr.attributetype_id = att.id)
125. 0.000 0.000 ↓ 0.0

Append (cost=0.00..236.98 rows=366 width=24) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Seq Scan on device_attribute dattr (cost=0.00..0.00 rows=1 width=24) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
127. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_1 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
128. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
129. 0.000 0.000 ↓ 0.0

Seq Scan on device_attribute dattr_2 (cost=0.00..4.26 rows=181 width=24) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
130. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_3 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
131. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
132. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_4 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
133. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
134. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_5 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
135. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
136. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_6 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
137. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
138. 0.000 0.000 ↓ 0.0

Seq Scan on device_attribute dattr_7 (cost=0.00..1.20 rows=16 width=24) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
139. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_8 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
140. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
141. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_9 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
142. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
143. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_10 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
144. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
145. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_11 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
146. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
147. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_12 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
148. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
149. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_13 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
150. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
151. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_14 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
152. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
153. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_15 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
154. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
155. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_16 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
156. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
157. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_17 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
158. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
159. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_18 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
160. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
161. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_19 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
162. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
163. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_20 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
164. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
165. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_21 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
166. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
167. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_22 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
168. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
169. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_23 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
170. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
171. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_24 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
172. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
173. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_25 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
174. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
175. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_26 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
176. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
177. 0.000 0.000 ↓ 0.0

Hash (cost=1.10..1.10 rows=10 width=12) (actual rows= loops=)

178. 0.000 0.000 ↓ 0.0

Seq Scan on attributetype att (cost=0.00..1.10 rows=10 width=12) (actual rows= loops=)

179.          

SubPlan (for Nested Loop)

180. 0.000 0.000 ↓ 0.0

Function Scan on device_children (cost=0.25..10.25 rows=1,000 width=4) (actual rows= loops=)

181. 0.000 0.000 ↓ 0.0

Hash (cost=607.90..607.90 rows=373 width=32) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

Append (cost=0.00..607.90 rows=373 width=32) (actual rows= loops=)

183. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a (cost=0.00..0.00 rows=1 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
184. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_1 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
185. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_2 (cost=0.00..4.78 rows=222 width=26) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
186. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_3 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
187. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_4 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
188. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_5 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
189. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_6 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
190. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_7 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
191. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_8 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
192. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_9 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
193. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_10 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
194. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_11 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
195. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_12 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
196. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_13 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
197. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_14 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
198. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_15 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
199. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_16 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
200. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_17 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
201. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_18 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
202. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_19 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
203. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_20 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
204. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_21 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
205. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_22 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
206. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_23 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
207. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_24 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
208. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_25 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
209. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_26 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
210. 0.000 0.000 ↓ 0.0

Aggregate (cost=4,159.08..4,159.09 rows=1 width=32) (actual rows= loops=)

211. 0.000 0.000 ↓ 0.0

Subquery Scan on attribute_1 (cost=4,156.65..4,159.05 rows=10 width=60) (actual rows= loops=)

212. 0.000 0.000 ↓ 0.0

Unique (cost=4,156.65..4,158.95 rows=10 width=44) (actual rows= loops=)

213. 0.000 0.000 ↓ 0.0

Sort (cost=4,156.65..4,157.80 rows=461 width=44) (actual rows= loops=)

  • Sort Key: att_1.type, dattr_27.last_update DESC
214. 0.000 0.000 ↓ 0.0

Hash Join (cost=613.79..4,136.25 rows=461 width=44) (actual rows= loops=)

  • Hash Cond: (dattr_27.attribute_id = a_27.id)
215. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.23..3,507.04 rows=247 width=28) (actual rows= loops=)

  • Join Filter: (SubPlan 3)
216. 0.000 0.000 ↓ 0.0

Append (cost=0.00..100.95 rows=27 width=8) (actual rows= loops=)

217. 0.000 0.000 ↓ 0.0

Seq Scan on device d_27 (cost=0.00..0.00 rows=1 width=8) (actual rows= loops=)

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
218. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_28 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
219. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_29 (cost=0.28..4.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
220. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_30 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
221. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_31 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
222. 0.000 0.000 ↓ 0.0

Seq Scan on device d_32 (cost=0.00..1.07 rows=1 width=8) (actual rows= loops=)

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
223. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_33 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
224. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_34 (cost=0.27..4.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
225. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_35 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
226. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_36 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
227. 0.000 0.000 ↓ 0.0

Seq Scan on device d_37 (cost=0.00..2.69 rows=1 width=8) (actual rows= loops=)

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
228. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_38 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
229. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_39 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
230. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_40 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
231. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_41 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
232. 0.000 0.000 ↓ 0.0

Seq Scan on device d_42 (cost=0.00..1.07 rows=1 width=8) (actual rows= loops=)

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
233. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_43 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
234. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_44 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
235. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_45 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
236. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_46 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
237. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_47 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
238. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_48 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
239. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_49 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
240. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_50 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
241. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_51 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
242. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_52 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
243. 0.000 0.000 ↓ 0.0

Index Scan using pk_device on device d_53 (cost=0.15..4.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
244. 0.000 0.000 ↓ 0.0

Materialize (cost=1.23..239.85 rows=18 width=28) (actual rows= loops=)

245. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.23..239.76 rows=18 width=28) (actual rows= loops=)

  • Hash Cond: (dattr_27.attributetype_id = att_1.id)
246. 0.000 0.000 ↓ 0.0

Append (cost=0.00..236.98 rows=366 width=24) (actual rows= loops=)

247. 0.000 0.000 ↓ 0.0

Seq Scan on device_attribute dattr_27 (cost=0.00..0.00 rows=1 width=24) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
248. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_28 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
249. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
250. 0.000 0.000 ↓ 0.0

Seq Scan on device_attribute dattr_29 (cost=0.00..4.26 rows=181 width=24) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
251. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_30 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
252. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
253. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_31 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
254. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
255. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_32 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
256. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
257. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_33 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
258. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
259. 0.000 0.000 ↓ 0.0

Seq Scan on device_attribute dattr_34 (cost=0.00..1.20 rows=16 width=24) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
260. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_35 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
261. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
262. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_36 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
263. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
264. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_37 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
265. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
266. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_38 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
267. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
268. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_39 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
269. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
270. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_40 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
271. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
272. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_41 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
273. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
274. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_42 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
275. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
276. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_43 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
277. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
278. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_44 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
279. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
280. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_45 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
281. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
282. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_46 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
283. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
284. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_47 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
285. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
286. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_48 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
287. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
288. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_49 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
289. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
290. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_50 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
291. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
292. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_51 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
293. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
294. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_52 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
295. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
296. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_attribute dattr_53 (cost=2.21..9.65 rows=7 width=24) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
297. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
298. 0.000 0.000 ↓ 0.0

Hash (cost=1.10..1.10 rows=10 width=12) (actual rows= loops=)

299. 0.000 0.000 ↓ 0.0

Seq Scan on attributetype att_1 (cost=0.00..1.10 rows=10 width=12) (actual rows= loops=)

300.          

SubPlan (for Nested Loop)

301. 0.000 0.000 ↓ 0.0

Function Scan on device_children device_children_1 (cost=0.25..10.25 rows=1,000 width=4) (actual rows= loops=)

302. 0.000 0.000 ↓ 0.0

Hash (cost=607.90..607.90 rows=373 width=32) (actual rows= loops=)

303. 0.000 0.000 ↓ 0.0

Append (cost=0.00..607.90 rows=373 width=32) (actual rows= loops=)

304. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_27 (cost=0.00..0.00 rows=1 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
305. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_28 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
306. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_29 (cost=0.00..4.78 rows=222 width=26) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
307. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_30 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
308. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_31 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
309. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_32 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
310. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_33 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
311. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_34 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
312. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_35 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
313. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_36 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
314. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_37 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
315. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_38 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
316. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_39 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
317. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_40 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
318. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_41 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
319. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_42 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
320. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_43 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
321. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_44 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
322. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_45 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
323. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_46 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
324. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_47 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
325. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_48 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
326. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_49 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
327. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_50 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
328. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_51 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
329. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_52 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
330. 0.000 0.000 ↓ 0.0

Seq Scan on attribute a_53 (cost=0.00..24.12 rows=6 width=40) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
331. 0.000 0.000 ↓ 0.0

Aggregate (cost=345.69..345.70 rows=1 width=32) (actual rows= loops=)

332. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..345.61 rows=29 width=54) (actual rows= loops=)

333. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.15..270.62 rows=29 width=44) (actual rows= loops=)

334. 0.000 0.000 ↓ 0.0

Append (cost=0.00..241.40 rows=29 width=16) (actual rows= loops=)

335. 0.000 0.000 ↓ 0.0

Seq Scan on device_match dm (cost=0.00..0.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((zone_id = device.zone_id) AND (device_id = device.id))
336. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_1 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
337. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
338. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_match_device_id on device_match dm_2 (cost=0.28..4.38 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
339. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_3 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
340. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
341. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_4 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
342. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
343. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_5 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
344. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
345. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_6 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
346. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
347. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_match_device_id on device_match dm_7 (cost=0.28..4.58 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
348. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_8 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
349. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
350. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_9 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
351. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
352. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_10 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
353. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
354. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_11 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
355. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
356. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_12 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
357. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
358. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_13 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
359. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
360. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_14 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
361. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
362. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_15 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
363. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
364. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_16 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
365. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
366. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_17 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
367. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
368. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_18 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
369. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
370. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_19 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
371. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
372. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_20 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
373. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
374. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_21 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
375. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
376. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_22 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
377. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
378. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_23 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
379. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
380. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_24 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
381. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
382. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_25 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
383. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
384. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_26 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
385. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
386. 0.000 0.000 ↓ 0.0

Index Scan using pk_p_type on type pt (cost=0.15..1.00 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dm.type_id)
387. 0.000 0.000 ↓ 0.0

Index Scan using pk_p_attribute on attribute pa (cost=0.28..2.58 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (id = dm.attribute_id)
388. 0.000 0.000 ↓ 0.0

Aggregate (cost=345.69..345.70 rows=1 width=32) (actual rows= loops=)

389. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..345.61 rows=29 width=54) (actual rows= loops=)

390. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.15..270.62 rows=29 width=44) (actual rows= loops=)

391. 0.000 0.000 ↓ 0.0

Append (cost=0.00..241.40 rows=29 width=16) (actual rows= loops=)

392. 0.000 0.000 ↓ 0.0

Seq Scan on device_match dm_27 (cost=0.00..0.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((zone_id = device.zone_id) AND (device_id = device.id))
393. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_28 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
394. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
395. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_match_device_id on device_match dm_29 (cost=0.28..4.38 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
396. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_30 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
397. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
398. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_31 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
399. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
400. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_32 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
401. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
402. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_33 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
403. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
404. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_match_device_id on device_match dm_34 (cost=0.28..4.58 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
405. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_35 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
406. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
407. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_36 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
408. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
409. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_37 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
410. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
411. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_38 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
412. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
413. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_39 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
414. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
415. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_40 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
416. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
417. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_41 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
418. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
419. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_42 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
420. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
421. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_43 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
422. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
423. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_44 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
424. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
425. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_45 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
426. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
427. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_46 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
428. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
429. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_47 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
430. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
431. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_48 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
432. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
433. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_49 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
434. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
435. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_50 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
436. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
437. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_51 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
438. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
439. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_52 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
440. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
441. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_53 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
442. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
443. 0.000 0.000 ↓ 0.0

Index Scan using pk_p_type on type pt_1 (cost=0.15..1.00 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dm_27.type_id)
444. 0.000 0.000 ↓ 0.0

Index Scan using pk_p_attribute on attribute pa_1 (cost=0.28..2.58 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (id = dm_27.attribute_id)
445. 0.000 0.000 ↓ 0.0

Aggregate (cost=345.69..345.70 rows=1 width=32) (actual rows= loops=)

446. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..345.61 rows=29 width=54) (actual rows= loops=)

447. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.15..270.62 rows=29 width=44) (actual rows= loops=)

448. 0.000 0.000 ↓ 0.0

Append (cost=0.00..241.40 rows=29 width=16) (actual rows= loops=)

449. 0.000 0.000 ↓ 0.0

Seq Scan on device_match dm_54 (cost=0.00..0.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((zone_id = device.zone_id) AND (device_id = device.id))
450. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_55 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
451. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
452. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_match_device_id on device_match dm_56 (cost=0.28..4.38 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
453. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_57 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
454. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
455. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_58 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
456. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
457. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_59 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
458. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
459. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_60 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
460. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
461. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_match_device_id on device_match dm_61 (cost=0.28..4.58 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
462. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_62 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
463. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
464. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_63 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
465. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
466. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_64 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
467. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
468. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_65 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
469. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
470. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_66 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
471. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
472. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_67 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
473. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
474. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_68 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
475. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
476. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_69 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
477. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
478. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_70 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
479. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
480. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_71 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
481. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
482. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_72 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
483. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
484. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_73 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
485. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
486. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_74 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
487. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
488. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_75 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
489. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
490. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_76 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
491. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
492. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_77 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
493. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
494. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_78 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
495. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
496. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_79 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
497. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
498. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_80 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
499. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
500. 0.000 0.000 ↓ 0.0

Index Scan using pk_p_type on type pt_2 (cost=0.15..1.00 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dm_54.type_id)
501. 0.000 0.000 ↓ 0.0

Index Scan using pk_p_attribute on attribute pa_2 (cost=0.28..2.58 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (id = dm_54.attribute_id)
502. 0.000 0.000 ↓ 0.0

Aggregate (cost=345.69..345.70 rows=1 width=32) (actual rows= loops=)

503. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..345.61 rows=29 width=54) (actual rows= loops=)

504. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.15..270.62 rows=29 width=44) (actual rows= loops=)

505. 0.000 0.000 ↓ 0.0

Append (cost=0.00..241.40 rows=29 width=16) (actual rows= loops=)

506. 0.000 0.000 ↓ 0.0

Seq Scan on device_match dm_81 (cost=0.00..0.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((zone_id = device.zone_id) AND (device_id = device.id))
507. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_82 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
508. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
509. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_match_device_id on device_match dm_83 (cost=0.28..4.38 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
510. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_84 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
511. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
512. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_85 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
513. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
514. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_86 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
515. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
516. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_87 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
517. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
518. 0.000 0.000 ↓ 0.0

Index Scan using idx_device_match_device_id on device_match dm_88 (cost=0.28..4.58 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
519. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_89 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
520. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
521. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_90 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
522. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
523. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_91 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
524. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
525. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_92 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
526. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
527. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_93 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
528. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
529. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_94 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
530. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
531. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_95 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
532. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
533. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_96 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
534. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
535. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_97 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
536. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
537. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_98 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
538. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
539. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_99 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
540. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
541. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_100 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
542. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
543. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_101 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
544. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
545. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_102 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
546. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
547. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_103 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
548. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
549. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_104 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
550. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
551. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_105 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
552. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
553. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_106 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
554. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
555. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_match dm_107 (cost=2.21..9.69 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
556. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (device_id = device.id)
557. 0.000 0.000 ↓ 0.0

Index Scan using pk_p_type on type pt_3 (cost=0.15..1.00 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dm_81.type_id)
558. 0.000 0.000 ↓ 0.0

Index Scan using pk_p_attribute on attribute pa_3 (cost=0.28..2.58 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (id = dm_81.attribute_id)
559. 0.000 0.000 ↓ 0.0

Aggregate (cost=255.10..255.11 rows=1 width=32) (actual rows= loops=)

560. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.55..254.97 rows=52 width=136) (actual rows= loops=)

561. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.40..233.61 rows=52 width=100) (actual rows= loops=)

562. 0.000 0.000 ↓ 0.0

Hash Join (cost=17.25..212.25 rows=52 width=64) (actual rows= loops=)

  • Hash Cond: (deviceresponse.device_id = device_children_2.id)
563. 0.000 0.000 ↓ 0.0

Append (cost=0.00..193.57 rows=104 width=64) (actual rows= loops=)

564. 0.000 0.000 ↓ 0.0

Seq Scan on device_response deviceresponse (cost=0.00..0.00 rows=1 width=64) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
565. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_1 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
566. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
567. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_2 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
568. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
569. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_3 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
570. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
571. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_4 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
572. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
573. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_5 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
574. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
575. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_6 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
576. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
577. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_7 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
578. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
579. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_8 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
580. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
581. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_9 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
582. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
583. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_10 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
584. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
585. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_11 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
586. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
587. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_12 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
588. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
589. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_13 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
590. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
591. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_14 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
592. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
593. 0.000 0.000 ↓ 0.0

Seq Scan on device_response deviceresponse_15 (cost=0.00..1.04 rows=3 width=64) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
594. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_16 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
595. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
596. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_17 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
597. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
598. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_18 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
599. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
600. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_19 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
601. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
602. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_20 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
603. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
604. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_21 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
605. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
606. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_22 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
607. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
608. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_23 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
609. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
610. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_24 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
611. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
612. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_25 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
613. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
614. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_26 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
615. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
616. 0.000 0.000 ↓ 0.0

Hash (cost=14.75..14.75 rows=200 width=4) (actual rows= loops=)

617. 0.000 0.000 ↓ 0.0

HashAggregate (cost=12.75..14.75 rows=200 width=4) (actual rows= loops=)

  • Group Key: device_children_2.id
618. 0.000 0.000 ↓ 0.0

Function Scan on device_children device_children_2 (cost=0.25..10.25 rows=1,000 width=4) (actual rows= loops=)

619. 0.000 0.000 ↓ 0.0

Index Scan using pk_scantype on scantype (cost=0.15..0.40 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = deviceresponse.scantype_id)
620. 0.000 0.000 ↓ 0.0

Index Scan using pk_protocol on protocol (cost=0.15..0.40 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = deviceresponse.protocol_id)
621. 0.000 0.000 ↓ 0.0

Aggregate (cost=1,627.69..1,627.70 rows=1 width=32) (actual rows= loops=)

622. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.25..1,603.23 rows=9,782 width=36) (actual rows= loops=)

623. 0.000 0.000 ↓ 0.0

Hash Join (cost=17.25..832.62 rows=104 width=8) (actual rows= loops=)

  • Hash Cond: (dsa.device_id = device_children_3.id)
624. 0.000 0.000 ↓ 0.0

Append (cost=0.00..812.50 rows=209 width=8) (actual rows= loops=)

625. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa (cost=0.00..0.00 rows=1 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
626. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_1 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
627. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_2 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
628. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_3 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
629. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_4 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
630. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_5 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
631. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_6 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
632. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_7 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
633. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_8 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
634. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_9 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
635. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_10 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
636. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_11 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
637. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_12 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
638. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_13 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
639. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_14 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
640. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_15 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
641. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_16 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
642. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_17 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
643. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_18 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
644. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_19 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
645. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_20 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
646. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_21 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
647. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_22 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
648. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_23 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
649. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_24 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
650. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_25 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
651. 0.000 0.000 ↓ 0.0

Seq Scan on device_snmpalias dsa_26 (cost=0.00..31.25 rows=8 width=8) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
652. 0.000 0.000 ↓ 0.0

Hash (cost=14.75..14.75 rows=200 width=4) (actual rows= loops=)

653. 0.000 0.000 ↓ 0.0

HashAggregate (cost=12.75..14.75 rows=200 width=4) (actual rows= loops=)

  • Group Key: device_children_3.id
654. 0.000 0.000 ↓ 0.0

Function Scan on device_children device_children_3 (cost=0.25..10.25 rows=1,000 width=4) (actual rows= loops=)

655. 0.000 0.000 ↓ 0.0

Append (cost=0.00..7.14 rows=27 width=36) (actual rows= loops=)

656. 0.000 0.000 ↓ 0.0

Seq Scan on snmpalias sa (cost=0.00..0.00 rows=1 width=36) (actual rows= loops=)

  • Filter: (dsa.snmpalias_id = id)
657. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_1 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
658. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_2 (cost=0.15..0.28 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
659. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_3 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
660. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_4 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
661. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_5 (cost=0.15..0.28 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
662. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_6 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
663. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_7 (cost=0.15..0.28 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
664. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_8 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
665. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_9 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
666. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_10 (cost=0.15..0.28 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
667. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_11 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
668. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_12 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
669. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_13 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
670. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_14 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
671. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_15 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
672. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_16 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
673. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_17 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
674. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_18 (cost=0.15..0.28 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
675. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_19 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
676. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_20 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
677. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_21 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
678. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_22 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
679. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_23 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
680. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_24 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
681. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_25 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
682. 0.000 0.000 ↓ 0.0

Index Scan using pk_snmpalias on snmpalias sa_26 (cost=0.15..0.27 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = dsa.snmpalias_id)
683. 0.000 0.000 ↓ 0.0

Aggregate (cost=255.10..255.11 rows=1 width=32) (actual rows= loops=)

684. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.55..254.97 rows=52 width=136) (actual rows= loops=)

685. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.40..233.61 rows=52 width=100) (actual rows= loops=)

686. 0.000 0.000 ↓ 0.0

Hash Join (cost=17.25..212.25 rows=52 width=64) (actual rows= loops=)

  • Hash Cond: (deviceresponse_27.device_id = device_children_4.id)
687. 0.000 0.000 ↓ 0.0

Append (cost=0.00..193.57 rows=104 width=64) (actual rows= loops=)

688. 0.000 0.000 ↓ 0.0

Seq Scan on device_response deviceresponse_27 (cost=0.00..0.00 rows=1 width=64) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
689. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_28 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
690. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
691. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_29 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
692. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
693. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_30 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
694. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
695. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_31 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
696. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
697. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_32 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
698. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
699. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_33 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
700. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
701. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_34 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
702. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
703. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_35 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
704. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
705. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_36 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
706. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
707. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_37 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
708. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
709. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_38 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
710. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
711. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_39 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
712. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
713. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_40 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
714. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
715. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_41 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
716. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
717. 0.000 0.000 ↓ 0.0

Seq Scan on device_response deviceresponse_42 (cost=0.00..1.04 rows=3 width=64) (actual rows= loops=)

  • Filter: (zone_id = device.zone_id)
718. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on device_response deviceresponse_43 (cost=2.18..7.70 rows=4 width=64) (actual rows= loops=)

  • Recheck Cond: (zone_id = device.zone_id)
719. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (zone_id = device.zone_id)
720. 0.000 0.000 ↓ 0.0