explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uGfm

Settings
# exclusive inclusive rows x rows loops node
1. 0.524 20,191.400 ↑ 1.0 1,000 1

Limit (cost=37,261.25..5,132,602.81 rows=1,000 width=503) (actual time=31.576..20,191.400 rows=1,000 loops=1)

2. 552.427 20,190.876 ↑ 8.6 1,000 1

Nested Loop Left Join (cost=37,261.25..43,729,815.13 rows=8,575 width=503) (actual time=31.574..20,190.876 rows=1,000 loops=1)

3. 5.232 21.449 ↑ 1.7 1,000 1

Nested Loop (cost=37,261.00..63,646.01 rows=1,715 width=133) (actual time=1.297..21.449 rows=1,000 loops=1)

  • Join Filter: (devicevalues.zone_id = zn.id)
  • Rows Removed by Join Filter: 24,981
4. 3.310 13.217 ↑ 2.5 1,000 1

Merge Join (cost=9.66..11,242.69 rows=2,486 width=99) (actual time=0.613..13.217 rows=1,000 loops=1)

  • Merge Cond: (devicevalues.device_id = device.id)
  • Join Filter: (device.zone_id = devicevalues.zone_id)
5. 0.722 3.991 ↑ 9.4 1,000 1

Merge Append (cost=4.85..1,234.80 rows=9,397 width=12) (actual time=0.285..3.991 rows=1,000 loops=1)

  • Sort Key: devicevalues.device_id
6. 0.009 0.009 ↓ 0.0 0 1

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

7. 0.002 0.002 ↓ 0.0 0 1

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

8. 1.936 1.936 ↑ 1.0 585 1

Index Scan using idx_device_values_devid on device_values devicevalues_2 (cost=0.28..41.74 rows=585 width=12) (actual time=0.042..1.936 rows=585 loops=1)

9. 0.022 0.022 ↑ 72.0 5 1

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

10. 0.001 0.001 ↓ 0.0 0 1

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

11. 0.021 0.021 ↑ 72.0 5 1

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

12. 0.013 0.013 ↑ 180.0 2 1

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

13. 1.041 1.041 ↑ 1.3 370 1

Index Scan using idx_device_values_devid on device_values devicevalues_7 (cost=0.27..37.54 rows=485 width=12) (actual time=0.027..1.041 rows=370 loops=1)

14. 0.002 0.002 ↓ 0.0 0 1

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

15. 0.016 0.016 ↑ 32.7 11 1

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

16. 0.021 0.021 ↑ 15.3 3 1

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

17. 0.013 0.013 ↑ 180.0 2 1

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

18. 0.014 0.014 ↑ 180.0 2 1

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

19. 0.014 0.014 ↑ 180.0 2 1

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

20. 0.020 0.020 ↑ 180.0 2 1

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

21. 0.020 0.020 ↑ 72.0 5 1

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

22. 0.020 0.020 ↑ 90.0 4 1

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

23. 0.020 0.020 ↑ 90.0 4 1

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

24. 0.009 0.009 ↑ 360.0 1 1

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

25. 0.008 0.008 ↑ 360.0 1 1

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

26. 0.007 0.007 ↑ 360.0 1 1

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

27. 0.005 0.005 ↑ 360.0 1 1

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

28. 0.003 0.003 ↑ 360.0 1 1

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

29. 0.007 0.007 ↑ 360.0 1 1

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

30. 0.004 0.004 ↑ 360.0 1 1

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

31. 0.012 0.012 ↑ 360.0 1 1

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

32. 0.009 0.009 ↑ 360.0 1 1

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

33. 1.268 5.916 ↑ 10.6 1,000 1

Materialize (cost=4.82..1,310.76 rows=10,581 width=91) (actual time=0.313..5.916 rows=1,000 loops=1)

34. 1.188 4.648 ↑ 10.6 1,000 1

Merge Append (cost=4.82..1,284.31 rows=10,581 width=91) (actual time=0.301..4.648 rows=1,000 loops=1)

  • Sort Key: device.id
35. 0.004 0.004 ↓ 0.0 0 1

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

36. 0.002 0.002 ↓ 0.0 0 1

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

37. 1.647 1.647 ↑ 1.0 585 1

Index Scan using pk_device on device device_2 (cost=0.28..41.45 rows=585 width=59) (actual time=0.021..1.647 rows=585 loops=1)

38. 0.084 0.084 ↑ 90.0 5 1

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

39. 0.003 0.003 ↓ 0.0 0 1

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

40. 0.025 0.025 ↑ 1.0 5 1

Index Scan using pk_device on device device_5 (cost=0.13..6.21 rows=5 width=61) (actual time=0.011..0.025 rows=5 loops=1)

41. 0.015 0.015 ↑ 225.0 2 1

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

42. 1.365 1.365 ↑ 1.3 370 1

Index Scan using pk_device on device device_7 (cost=0.27..44.45 rows=489 width=59) (actual time=0.027..1.365 rows=370 loops=1)

43. 0.003 0.003 ↓ 0.0 0 1

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

44. 0.046 0.046 ↑ 40.9 11 1

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

45. 0.023 0.023 ↑ 15.3 3 1

Index Scan using pk_device on device device_10 (cost=0.14..8.79 rows=46 width=65) (actual time=0.015..0.023 rows=3 loops=1)

46. 0.021 0.021 ↑ 225.0 2 1

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

47. 0.017 0.017 ↑ 225.0 2 1

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

48. 0.018 0.018 ↑ 225.0 2 1

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

49. 0.015 0.015 ↑ 225.0 2 1

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

50. 0.030 0.030 ↑ 1.0 5 1

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

51. 0.027 0.027 ↑ 112.5 4 1

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

52. 0.023 0.023 ↑ 112.5 4 1

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

53. 0.012 0.012 ↑ 450.0 1 1

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

54. 0.012 0.012 ↑ 450.0 1 1

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

55. 0.007 0.007 ↑ 450.0 1 1

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

56. 0.008 0.008 ↑ 450.0 1 1

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

57. 0.011 0.011 ↑ 450.0 1 1

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

58. 0.009 0.009 ↑ 450.0 1 1

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

59. 0.008 0.008 ↑ 450.0 1 1

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

60. 0.005 0.005 ↑ 450.0 1 1

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

61. 0.020 0.020 ↑ 450.0 1 1

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

62. 2.273 3.000 ↑ 5.3 26 1,000

Materialize (cost=37,251.34..47,257.65 rows=138 width=42) (actual time=0.001..0.003 rows=26 loops=1,000)

63. 0.035 0.727 ↑ 5.3 26 1

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

  • Filter: (zn.username = 'admin'::text)
  • Rows Removed by Filter: 78
64. 0.034 0.692 ↑ 265.4 104 1

Unique (cost=37,251.34..46,911.94 rows=27,602 width=78) (actual time=0.564..0.692 rows=104 loops=1)

65. 0.016 0.658 ↑ 2,123.2 130 1

Merge Append (cost=37,251.34..45,531.85 rows=276,017 width=78) (actual time=0.562..0.658 rows=130 loops=1)

  • Sort Key: u.id, z.id
66. 0.026 0.470 ↑ 32.1 52 1

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

  • Group Key: u.id, z.id
67. 0.096 0.444 ↑ 16.0 104 1

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

  • Sort Key: u.id, z.id
  • Sort Method: quicksort Memory: 33kB
68. 0.055 0.348 ↑ 16.0 104 1

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

  • Hash Cond: (ur.user_id = u.id)
69. 0.051 0.272 ↑ 16.0 104 1

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

  • Hash Cond: (ur.role_id = r.id)
70. 0.009 0.009 ↑ 565.0 4 1

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

71. 0.041 0.212 ↑ 8.5 104 1

Hash (cost=94.74..94.74 rows=885 width=46) (actual time=0.212..0.212 rows=104 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
72. 0.060 0.171 ↑ 8.5 104 1

Hash Join (cost=59.39..94.74 rows=885 width=46) (actual time=0.150..0.171 rows=104 loops=1)

  • Hash Cond: (r.organization_id = o.id)
73. 0.009 0.009 ↑ 300.0 4 1

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

74. 0.017 0.102 ↑ 22.7 26 1

Hash (cost=52.01..52.01 rows=590 width=50) (actual time=0.102..0.102 rows=26 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
75. 0.053 0.085 ↑ 22.7 26 1

Hash Join (cost=28.00..52.01 rows=590 width=50) (actual time=0.070..0.085 rows=26 loops=1)

  • Hash Cond: (z.organization_id = o.id)
76. 0.015 0.015 ↑ 22.7 26 1

Seq Scan on zone z (cost=0.00..15.90 rows=590 width=46) (actual time=0.013..0.015 rows=26 loops=1)

77. 0.008 0.017 ↑ 800.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
78. 0.009 0.009 ↑ 800.0 1 1

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

79. 0.008 0.021 ↑ 155.0 4 1

Hash (cost=16.20..16.20 rows=620 width=36) (actual time=0.021..0.021 rows=4 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
80. 0.013 0.013 ↑ 155.0 4 1

Seq Scan on "user" u (cost=0.00..16.20 rows=620 width=36) (actual time=0.011..0.013 rows=4 loops=1)

81. 0.024 0.172 ↑ 3,517.3 78 1

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

  • Group Key: u_1.id, z_1.id
82. 0.091 0.148 ↑ 3,517.3 78 1

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

  • Sort Key: u_1.id, z_1.id
  • Sort Method: quicksort Memory: 31kB
83. 0.018 0.057 ↑ 3,517.3 78 1

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

84. 0.013 0.013 ↑ 22.7 26 1

Seq Scan on zone z_1 (cost=0.00..15.90 rows=590 width=42) (actual time=0.008..0.013 rows=26 loops=1)

85. 0.017 0.026 ↑ 155.0 3 26

Materialize (cost=0.00..18.52 rows=465 width=36) (actual time=0.001..0.001 rows=3 loops=26)

86. 0.009 0.009 ↑ 155.0 3 1

Seq Scan on "user" u_1 (cost=0.00..16.20 rows=465 width=36) (actual time=0.006..0.009 rows=3 loops=1)

  • Filter: (superuser OR hidden)
  • Rows Removed by Filter: 1
87. 3,082.000 3,082.000 ↑ 5.0 1 1,000

Function Scan on ports (cost=0.25..12.75 rows=5 width=4) (actual time=3.082..3.082 rows=1 loops=1,000)

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

SubPlan (for Nested Loop Left Join)

89. 5.000 2,326.000 ↑ 1.0 1 1,000

Aggregate (cost=321.18..321.19 rows=1 width=32) (actual time=2.325..2.326 rows=1 loops=1,000)

90. 1.000 2,321.000 ↓ 0.0 0 1,000

Subquery Scan on attribute (cost=320.96..321.15 rows=10 width=60) (actual time=2.321..2.321 rows=0 loops=1,000)

91. 1.000 2,320.000 ↓ 0.0 0 1,000

Unique (cost=320.96..321.05 rows=10 width=44) (actual time=2.320..2.320 rows=0 loops=1,000)

92. 9.000 2,319.000 ↓ 0.0 0 1,000

Sort (cost=320.96..321.00 rows=18 width=44) (actual time=2.319..2.319 rows=0 loops=1,000)

  • Sort Key: att.type, dattr.last_update DESC
  • Sort Method: quicksort Memory: 25kB
93. 2.635 2,310.000 ↓ 0.0 0 1,000

Nested Loop (cost=18.48..320.58 rows=18 width=44) (actual time=2.272..2.310 rows=0 loops=1,000)

94. 20.085 2,285.000 ↓ 0.0 0 1,000

Hash Join (cost=18.48..257.43 rows=10 width=24) (actual time=2.269..2.285 rows=0 loops=1,000)

  • Hash Cond: (dattr.device_id = device_children.id)
95. 52.957 294.000 ↓ 7.6 144 1,000

Hash Join (cost=1.23..239.92 rows=19 width=24) (actual time=0.060..0.294 rows=144 loops=1,000)

  • Hash Cond: (dattr.attributetype_id = att.id)
96. 92.000 241.000 ↑ 2.6 144 1,000

Append (cost=0.00..237.10 rows=375 width=20) (actual time=0.054..0.241 rows=144 loops=1,000)

97. 1.000 1.000 ↓ 0.0 0 1,000

Seq Scan on device_attribute dattr (cost=0.00..0.00 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
98. 2.000 6.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_1 (cost=2.21..9.65 rows=7 width=20) (actual time=0.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
99. 4.000 4.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
100. 55.000 55.000 ↑ 1.4 136 1,000

Seq Scan on device_attribute dattr_2 (cost=0.00..4.30 rows=184 width=20) (actual time=0.020..0.055 rows=136 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 96
101. 1.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_3 (cost=2.21..9.65 rows=7 width=20) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
102. 3.000 3.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
103. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_4 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
104. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
105. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_5 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
106. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
107. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_6 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
108. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
109. 8.000 8.000 ↑ 2.8 8 1,000

Seq Scan on device_attribute dattr_7 (cost=0.00..1.27 rows=22 width=20) (actual time=0.006..0.008 rows=8 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 14
110. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_8 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
111. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
112. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_9 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
113. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
114. 2.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_10 (cost=2.21..9.65 rows=7 width=20) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
115. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
116. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_11 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
117. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
118. 2.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_12 (cost=2.21..9.65 rows=7 width=20) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
119. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
120. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_13 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
121. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
122. 1.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_14 (cost=2.21..9.65 rows=7 width=20) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
123. 3.000 3.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
124. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_15 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
125. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
126. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_16 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=3
127. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
128. 2.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_17 (cost=2.21..9.65 rows=7 width=20) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
129. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
130. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_18 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
131. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
132. 2.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_19 (cost=2.21..9.65 rows=7 width=20) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
133. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
134. 2.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_20 (cost=2.21..9.65 rows=7 width=20) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
135. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
136. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_21 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
137. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
138. 2.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_22 (cost=2.21..9.65 rows=7 width=20) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
139. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
140. 2.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_23 (cost=2.21..9.65 rows=7 width=20) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
141. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
142. 2.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_24 (cost=2.21..9.65 rows=7 width=20) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
143. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
144. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_25 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
145. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
146. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_26 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
147. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
148. 0.016 0.043 ↓ 5.2 52 1

Hash (cost=1.10..1.10 rows=10 width=12) (actual time=0.043..0.043 rows=52 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
149. 0.027 0.027 ↓ 5.2 52 1

Seq Scan on attributetype att (cost=0.00..1.10 rows=10 width=12) (actual time=0.020..0.027 rows=52 loops=1)

150. 2.949 1,970.915 ↑ 200.0 1 983

Hash (cost=14.75..14.75 rows=200 width=4) (actual time=2.005..2.005 rows=1 loops=983)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
151. 4.915 1,967.966 ↑ 200.0 1 983

HashAggregate (cost=12.75..14.75 rows=200 width=4) (actual time=2.001..2.002 rows=1 loops=983)

  • Group Key: device_children.id
152. 1,963.051 1,963.051 ↑ 1,000.0 1 983

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

153. 6.958 22.365 ↑ 27.0 1 497

Append (cost=0.00..6.05 rows=27 width=28) (actual time=0.013..0.045 rows=1 loops=497)

154. 0.000 0.000 ↓ 0.0 0 497

Seq Scan on attribute a (cost=0.00..0.00 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=497)

  • Filter: ((zone_id = device.zone_id) AND (dattr.attribute_id = id))
155. 1.491 1.491 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_1 (cost=0.15..0.23 rows=1 width=36) (actual time=0.003..0.003 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
156. 1.988 1.988 ↑ 1.0 1 497

Index Scan using pk_attr on attribute a_2 (cost=0.14..0.19 rows=1 width=22) (actual time=0.003..0.004 rows=1 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
157. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_3 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
158. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_4 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
159. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_5 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
160. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_6 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
161. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_7 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
162. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_8 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
163. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_9 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
164. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_10 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
165. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_11 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
166. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_12 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
167. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_13 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
168. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_14 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
169. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_15 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
170. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_16 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
171. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_17 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
172. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_18 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
173. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_19 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
174. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_20 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
175. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_21 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
176. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_22 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
177. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_23 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
178. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_24 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
179. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_25 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
180. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_26 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
181. 4.000 2,307.000 ↑ 1.0 1 1,000

Aggregate (cost=321.18..321.19 rows=1 width=32) (actual time=2.307..2.307 rows=1 loops=1,000)

182. 1.000 2,303.000 ↓ 0.0 0 1,000

Subquery Scan on attribute_1 (cost=320.96..321.15 rows=10 width=60) (actual time=2.303..2.303 rows=0 loops=1,000)

183. 1.000 2,302.000 ↓ 0.0 0 1,000

Unique (cost=320.96..321.05 rows=10 width=44) (actual time=2.302..2.302 rows=0 loops=1,000)

184. 9.000 2,301.000 ↓ 0.0 0 1,000

Sort (cost=320.96..321.00 rows=18 width=44) (actual time=2.300..2.301 rows=0 loops=1,000)

  • Sort Key: att_1.type, dattr_27.last_update DESC
  • Sort Method: quicksort Memory: 25kB
185. 3.126 2,292.000 ↓ 0.0 0 1,000

Nested Loop (cost=18.48..320.58 rows=18 width=44) (actual time=2.256..2.292 rows=0 loops=1,000)

186. 20.000 2,268.000 ↓ 0.0 0 1,000

Hash Join (cost=18.48..257.43 rows=10 width=24) (actual time=2.253..2.268 rows=0 loops=1,000)

  • Hash Cond: (dattr_27.device_id = device_children_1.id)
187. 51.969 282.000 ↓ 7.6 144 1,000

Hash Join (cost=1.23..239.92 rows=19 width=24) (actual time=0.058..0.282 rows=144 loops=1,000)

  • Hash Cond: (dattr_27.attributetype_id = att_1.id)
188. 94.000 230.000 ↑ 2.6 144 1,000

Append (cost=0.00..237.10 rows=375 width=20) (actual time=0.052..0.230 rows=144 loops=1,000)

189. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_attribute dattr_27 (cost=0.00..0.00 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
190. 1.000 5.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_28 (cost=2.21..9.65 rows=7 width=20) (actual time=0.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
191. 4.000 4.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
192. 53.000 53.000 ↑ 1.4 136 1,000

Seq Scan on device_attribute dattr_29 (cost=0.00..4.30 rows=184 width=20) (actual time=0.019..0.053 rows=136 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 96
193. 1.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_30 (cost=2.21..9.65 rows=7 width=20) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
194. 3.000 3.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
195. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_31 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
196. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
197. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_32 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
198. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
199. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_33 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
200. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
201. 8.000 8.000 ↑ 2.8 8 1,000

Seq Scan on device_attribute dattr_34 (cost=0.00..1.27 rows=22 width=20) (actual time=0.006..0.008 rows=8 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 14
202. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_35 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
203. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
204. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_36 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
205. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
206. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_37 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
207. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
208. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_38 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
209. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
210. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_39 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
211. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
212. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_40 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
213. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
214. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_41 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
215. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
216. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_42 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
217. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
218. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_43 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=3
219. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
220. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_44 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
221. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
222. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_45 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
223. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
224. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_46 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
225. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
226. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_47 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
227. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
228. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_48 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
229. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
230. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_49 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
231. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
232. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_50 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
233. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
234. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_51 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
235. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
236. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_52 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
237. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
238. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_53 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
239. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
240. 0.017 0.031 ↓ 5.2 52 1

Hash (cost=1.10..1.10 rows=10 width=12) (actual time=0.031..0.031 rows=52 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
241. 0.014 0.014 ↓ 5.2 52 1

Seq Scan on attributetype att_1 (cost=0.00..1.10 rows=10 width=12) (actual time=0.008..0.014 rows=52 loops=1)

242. 2.949 1,966.000 ↑ 200.0 1 983

Hash (cost=14.75..14.75 rows=200 width=4) (actual time=2.000..2.000 rows=1 loops=983)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
243. 4.915 1,963.051 ↑ 200.0 1 983

HashAggregate (cost=12.75..14.75 rows=200 width=4) (actual time=1.996..1.997 rows=1 loops=983)

  • Group Key: device_children_1.id
244. 1,958.136 1,958.136 ↑ 1,000.0 1 983

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

245. 5.964 20.874 ↑ 27.0 1 497

Append (cost=0.00..6.05 rows=27 width=28) (actual time=0.012..0.042 rows=1 loops=497)

246. 0.000 0.000 ↓ 0.0 0 497

Seq Scan on attribute a_27 (cost=0.00..0.00 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=497)

  • Filter: ((zone_id = device.zone_id) AND (dattr_27.attribute_id = id))
247. 0.994 0.994 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_28 (cost=0.15..0.23 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
248. 1.988 1.988 ↑ 1.0 1 497

Index Scan using pk_attr on attribute a_29 (cost=0.14..0.19 rows=1 width=22) (actual time=0.003..0.004 rows=1 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
249. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_30 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
250. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_31 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
251. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_32 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
252. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_33 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
253. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_34 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
254. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_35 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
255. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_36 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
256. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_37 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
257. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_38 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
258. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_39 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
259. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_40 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
260. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_41 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
261. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_42 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
262. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_43 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
263. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_44 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
264. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_45 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
265. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_46 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
266. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_47 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
267. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_48 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
268. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_49 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
269. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_50 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
270. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_51 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
271. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_52 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
272. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_53 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_27.attribute_id)
  • Filter: (zone_id = device.zone_id)
273. 15.000 192.000 ↑ 1.0 1 1,000

Aggregate (cost=345.75..345.76 rows=1 width=32) (actual time=0.192..0.192 rows=1 loops=1,000)

274. 3.044 177.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.43..345.68 rows=29 width=54) (actual time=0.058..0.177 rows=2 loops=1,000)

275. 5.696 169.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.15..270.69 rows=29 width=44) (actual time=0.053..0.169 rows=2 loops=1,000)

276. 77.000 160.000 ↑ 14.5 2 1,000

Append (cost=0.00..241.47 rows=29 width=16) (actual time=0.047..0.160 rows=2 loops=1,000)

277. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_match dm (cost=0.00..0.00 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: ((zone_id = device.zone_id) AND (device_id = device.id))
278. 1.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_1 (cost=2.21..9.69 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
279. 3.000 3.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
280. 5.000 5.000 ↑ 2.0 1 1,000

Index Scan using idx_device_match_device_id on device_match dm_2 (cost=0.28..4.45 rows=2 width=16) (actual time=0.005..0.005 rows=1 loops=1,000)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
281. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_3 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
282. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
283. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_4 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
284. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
285. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_5 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
286. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
287. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_6 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
288. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
289. 4.000 4.000 ↑ 2.0 1 1,000

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

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
290. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_8 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
291. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
292. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_9 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
293. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
294. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_10 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
295. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
296. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_11 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
297. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
298. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_12 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
299. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
300. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_13 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
301. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
302. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_14 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
303. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
304. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_15 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
305. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
306. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_16 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
307. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
308. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_17 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
309. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
310. 1.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_18 (cost=2.21..9.69 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
311. 3.000 3.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
312. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_19 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
313. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
314. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_20 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
315. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
316. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_21 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
317. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
318. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_22 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
319. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
320. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_23 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
321. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
322. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_24 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
323. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
324. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_25 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
325. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
326. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_26 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
327. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
328. 3.304 3.304 ↑ 1.0 1 1,652

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

  • Index Cond: (id = dm.type_id)
329. 4.956 4.956 ↑ 1.0 1 1,652

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

  • Index Cond: (id = dm.attribute_id)
330. 13.000 191.000 ↑ 1.0 1 1,000

Aggregate (cost=345.75..345.76 rows=1 width=32) (actual time=0.191..0.191 rows=1 loops=1,000)

331. 2.044 178.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.43..345.68 rows=29 width=54) (actual time=0.059..0.178 rows=2 loops=1,000)

332. 6.696 171.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.15..270.69 rows=29 width=44) (actual time=0.055..0.171 rows=2 loops=1,000)

333. 76.000 161.000 ↑ 14.5 2 1,000

Append (cost=0.00..241.47 rows=29 width=16) (actual time=0.048..0.161 rows=2 loops=1,000)

334. 1.000 1.000 ↓ 0.0 0 1,000

Seq Scan on device_match dm_27 (cost=0.00..0.00 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,000)

  • Filter: ((zone_id = device.zone_id) AND (device_id = device.id))
335. 2.000 6.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_28 (cost=2.21..9.69 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
336. 4.000 4.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
337. 5.000 5.000 ↑ 2.0 1 1,000

Index Scan using idx_device_match_device_id on device_match dm_29 (cost=0.28..4.45 rows=2 width=16) (actual time=0.004..0.005 rows=1 loops=1,000)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
338. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_30 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
339. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
340. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_31 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
341. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
342. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_32 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
343. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
344. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_33 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
345. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
346. 4.000 4.000 ↑ 2.0 1 1,000

Index Scan using idx_device_match_device_id on device_match dm_34 (cost=0.28..4.58 rows=2 width=16) (actual time=0.003..0.004 rows=1 loops=1,000)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
347. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_35 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
348. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
349. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_36 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
350. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
351. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_37 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
352. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
353. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_38 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
354. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
355. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_39 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
356. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
357. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_40 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
358. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
359. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_41 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
360. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
361. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_42 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
362. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
363. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_43 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
364. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
365. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_44 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
366. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
367. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_45 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
368. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
369. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_46 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
370. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
371. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_47 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
372. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
373. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_48 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
374. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
375. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_49 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
376. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
377. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_50 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
378. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
379. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_51 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
380. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
381. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_52 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
382. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
383. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_53 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
384. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
385. 3.304 3.304 ↑ 1.0 1 1,652

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

  • Index Cond: (id = dm_27.type_id)
386. 4.956 4.956 ↑ 1.0 1 1,652

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

  • Index Cond: (id = dm_27.attribute_id)
387. 13.000 189.000 ↑ 1.0 1 1,000

Aggregate (cost=345.75..345.76 rows=1 width=32) (actual time=0.189..0.189 rows=1 loops=1,000)

388. 2.044 176.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.43..345.68 rows=29 width=54) (actual time=0.058..0.176 rows=2 loops=1,000)

389. 5.696 169.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.15..270.69 rows=29 width=44) (actual time=0.054..0.169 rows=2 loops=1,000)

390. 76.000 160.000 ↑ 14.5 2 1,000

Append (cost=0.00..241.47 rows=29 width=16) (actual time=0.047..0.160 rows=2 loops=1,000)

391. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_match dm_54 (cost=0.00..0.00 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: ((zone_id = device.zone_id) AND (device_id = device.id))
392. 1.000 5.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_55 (cost=2.21..9.69 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
393. 4.000 4.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
394. 5.000 5.000 ↑ 2.0 1 1,000

Index Scan using idx_device_match_device_id on device_match dm_56 (cost=0.28..4.45 rows=2 width=16) (actual time=0.004..0.005 rows=1 loops=1,000)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
395. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_57 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
396. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
397. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_58 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
398. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
399. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_59 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
400. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
401. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_60 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
402. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
403. 4.000 4.000 ↑ 2.0 1 1,000

Index Scan using idx_device_match_device_id on device_match dm_61 (cost=0.28..4.58 rows=2 width=16) (actual time=0.003..0.004 rows=1 loops=1,000)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
404. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_62 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
405. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
406. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_63 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
407. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
408. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_64 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
409. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
410. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_65 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
411. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
412. 2.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_66 (cost=2.21..9.69 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
413. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
414. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_67 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
415. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
416. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_68 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
417. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
418. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_69 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
419. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
420. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_70 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
421. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
422. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_71 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
423. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
424. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_72 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
425. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
426. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_73 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
427. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
428. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_74 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
429. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
430. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_75 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
431. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
432. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_76 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
433. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
434. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_77 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
435. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
436. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_78 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
437. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
438. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_79 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
439. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
440. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_80 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
441. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
442. 3.304 3.304 ↑ 1.0 1 1,652

Index Scan using pk_p_type on type pt_2 (cost=0.15..1.00 rows=1 width=36) (actual time=0.002..0.002 rows=1 loops=1,652)

  • Index Cond: (id = dm_54.type_id)
443. 4.956 4.956 ↑ 1.0 1 1,652

Index Scan using pk_p_attribute on attribute pa_2 (cost=0.28..2.58 rows=1 width=18) (actual time=0.003..0.003 rows=1 loops=1,652)

  • Index Cond: (id = dm_54.attribute_id)
444. 13.000 186.000 ↑ 1.0 1 1,000

Aggregate (cost=345.75..345.76 rows=1 width=32) (actual time=0.186..0.186 rows=1 loops=1,000)

445. 2.044 173.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.43..345.68 rows=29 width=54) (actual time=0.057..0.173 rows=2 loops=1,000)

446. 6.696 166.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.15..270.69 rows=29 width=44) (actual time=0.053..0.166 rows=2 loops=1,000)

447. 72.000 156.000 ↑ 14.5 2 1,000

Append (cost=0.00..241.47 rows=29 width=16) (actual time=0.046..0.156 rows=2 loops=1,000)

448. 1.000 1.000 ↓ 0.0 0 1,000

Seq Scan on device_match dm_81 (cost=0.00..0.00 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,000)

  • Filter: ((zone_id = device.zone_id) AND (device_id = device.id))
449. 1.000 5.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_82 (cost=2.21..9.69 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
450. 4.000 4.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
451. 5.000 5.000 ↑ 2.0 1 1,000

Index Scan using idx_device_match_device_id on device_match dm_83 (cost=0.28..4.45 rows=2 width=16) (actual time=0.004..0.005 rows=1 loops=1,000)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
452. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_84 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
453. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
454. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_85 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
455. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
456. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_86 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
457. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
458. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_87 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
459. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
460. 4.000 4.000 ↑ 2.0 1 1,000

Index Scan using idx_device_match_device_id on device_match dm_88 (cost=0.28..4.58 rows=2 width=16) (actual time=0.003..0.004 rows=1 loops=1,000)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
461. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_89 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
462. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
463. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_90 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
464. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
465. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_91 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
466. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
467. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_92 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
468. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
469. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_93 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
470. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
471. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_94 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
472. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
473. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_95 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
474. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
475. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_96 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
476. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
477. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_97 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
478. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
479. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_98 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
480. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
481. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_99 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
482. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
483. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_100 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
484. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
485. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_101 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
486. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
487. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_102 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
488. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
489. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_103 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
490. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
491. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_104 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
492. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
493. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_105 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
494. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
495. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_106 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
496. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
497. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_107 (cost=2.21..9.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
498. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on idx_device_match_device_id (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (device_id = device.id)
499. 3.304 3.304 ↑ 1.0 1 1,652

Index Scan using pk_p_type on type pt_3 (cost=0.15..1.00 rows=1 width=36) (actual time=0.002..0.002 rows=1 loops=1,652)

  • Index Cond: (id = dm_81.type_id)
500. 4.956 4.956 ↑ 1.0 1 1,652

Index Scan using pk_p_attribute on attribute pa_3 (cost=0.28..2.58 rows=1 width=18) (actual time=0.003..0.003 rows=1 loops=1,652)

  • Index Cond: (id = dm_81.attribute_id)
501. 5.000 2,304.000 ↑ 1.0 1 1,000

Aggregate (cost=321.18..321.19 rows=1 width=32) (actual time=2.303..2.304 rows=1 loops=1,000)

502. 1.000 2,299.000 ↓ 0.0 0 1,000

Subquery Scan on attribute_2 (cost=320.96..321.15 rows=10 width=60) (actual time=2.299..2.299 rows=0 loops=1,000)

503. 1.000 2,298.000 ↓ 0.0 0 1,000

Unique (cost=320.96..321.05 rows=10 width=44) (actual time=2.298..2.298 rows=0 loops=1,000)

504. 9.000 2,297.000 ↓ 0.0 0 1,000

Sort (cost=320.96..321.00 rows=18 width=44) (actual time=2.297..2.297 rows=0 loops=1,000)

  • Sort Key: att_2.type, dattr_54.last_update DESC
  • Sort Method: quicksort Memory: 25kB
505. 3.126 2,288.000 ↓ 0.0 0 1,000

Nested Loop (cost=18.48..320.58 rows=18 width=44) (actual time=2.252..2.288 rows=0 loops=1,000)

506. 19.932 2,264.000 ↓ 0.0 0 1,000

Hash Join (cost=18.48..257.43 rows=10 width=24) (actual time=2.249..2.264 rows=0 loops=1,000)

  • Hash Cond: (dattr_54.device_id = device_children_2.id)
507. 50.968 282.000 ↓ 7.6 144 1,000

Hash Join (cost=1.23..239.92 rows=19 width=24) (actual time=0.057..0.282 rows=144 loops=1,000)

  • Hash Cond: (dattr_54.attributetype_id = att_2.id)
508. 95.000 231.000 ↑ 2.6 144 1,000

Append (cost=0.00..237.10 rows=375 width=20) (actual time=0.051..0.231 rows=144 loops=1,000)

509. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_attribute dattr_54 (cost=0.00..0.00 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
510. 1.000 5.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_55 (cost=2.21..9.65 rows=7 width=20) (actual time=0.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
511. 4.000 4.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
512. 53.000 53.000 ↑ 1.4 136 1,000

Seq Scan on device_attribute dattr_56 (cost=0.00..4.30 rows=184 width=20) (actual time=0.019..0.053 rows=136 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 96
513. 1.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_57 (cost=2.21..9.65 rows=7 width=20) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
514. 3.000 3.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
515. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_58 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
516. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
517. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_59 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
518. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
519. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_60 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
520. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
521. 8.000 8.000 ↑ 2.8 8 1,000

Seq Scan on device_attribute dattr_61 (cost=0.00..1.27 rows=22 width=20) (actual time=0.006..0.008 rows=8 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 14
522. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_62 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
523. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
524. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_63 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
525. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
526. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_64 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
527. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
528. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_65 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
529. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
530. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_66 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
531. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
532. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_67 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
533. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
534. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_68 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
535. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
536. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_69 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
537. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
538. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_70 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=3
539. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
540. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_71 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
541. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
542. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_72 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
543. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
544. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_73 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
545. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
546. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_74 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
547. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
548. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_75 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
549. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
550. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_76 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
551. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
552. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_77 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
553. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
554. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_78 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
555. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
556. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_79 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
557. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
558. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_attribute dattr_80 (cost=2.21..9.65 rows=7 width=20) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
559. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_devattr (cost=0.00..2.21 rows=7 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
560. 0.016 0.032 ↓ 5.2 52 1

Hash (cost=1.10..1.10 rows=10 width=12) (actual time=0.032..0.032 rows=52 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
561. 0.016 0.016 ↓ 5.2 52 1

Seq Scan on attributetype att_2 (cost=0.00..1.10 rows=10 width=12) (actual time=0.009..0.016 rows=52 loops=1)

562. 3.932 1,962.068 ↑ 200.0 1 983

Hash (cost=14.75..14.75 rows=200 width=4) (actual time=1.996..1.996 rows=1 loops=983)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
563. 3.932 1,958.136 ↑ 200.0 1 983

HashAggregate (cost=12.75..14.75 rows=200 width=4) (actual time=1.992..1.992 rows=1 loops=983)

  • Group Key: device_children_2.id
564. 1,954.204 1,954.204 ↑ 1,000.0 1 983

Function Scan on device_children device_children_2 (cost=0.25..10.25 rows=1,000 width=4) (actual time=1.987..1.988 rows=1 loops=983)

565. 6.461 20.874 ↑ 27.0 1 497

Append (cost=0.00..6.05 rows=27 width=28) (actual time=0.012..0.042 rows=1 loops=497)

566. 0.000 0.000 ↓ 0.0 0 497

Seq Scan on attribute a_54 (cost=0.00..0.00 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=497)

  • Filter: ((zone_id = device.zone_id) AND (dattr_54.attribute_id = id))
567. 0.994 0.994 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_55 (cost=0.15..0.23 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
568. 1.491 1.491 ↑ 1.0 1 497

Index Scan using pk_attr on attribute a_56 (cost=0.14..0.19 rows=1 width=22) (actual time=0.003..0.003 rows=1 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
569. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_57 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
570. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_58 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
571. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_59 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
572. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_60 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
573. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_61 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
574. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_62 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
575. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_63 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
576. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_64 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
577. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_65 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
578. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_66 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
579. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_67 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
580. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_68 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
581. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_69 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
582. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_70 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
583. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_71 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
584. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_72 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
585. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_73 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
586. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_74 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
587. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_75 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
588. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_76 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
589. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_77 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
590. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_78 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
591. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_79 (cost=0.15..0.23 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
592. 0.497 0.497 ↓ 0.0 0 497

Index Scan using pk_attr on attribute a_80 (cost=0.15..0.24 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=497)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
593. 5.000 2,203.000 ↑ 1.0 1 1,000

Aggregate (cost=255.51..255.52 rows=1 width=32) (actual time=2.203..2.203 rows=1 loops=1,000)

594. 0.496 2,198.000 ↓ 0.0 0 1,000

Nested Loop (cost=17.55..255.38 rows=53 width=136) (actual time=2.184..2.198 rows=0 loops=1,000)

595. 2.496 2,197.000 ↓ 0.0 0 1,000

Nested Loop (cost=17.40..233.84 rows=53 width=100) (actual time=2.183..2.197 rows=0 loops=1,000)

596. 17.000 2,194.000 ↓ 0.0 0 1,000

Hash Join (cost=17.25..212.30 rows=53 width=64) (actual time=2.181..2.194 rows=0 loops=1,000)

  • Hash Cond: (deviceresponse.device_id = device_children_3.id)
597. 87.000 191.000 ↑ 2.7 39 1,000

Append (cost=0.00..193.59 rows=106 width=64) (actual time=0.043..0.191 rows=39 loops=1,000)

598. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_response deviceresponse (cost=0.00..0.00 rows=1 width=64) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
599. 1.000 5.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_1 (cost=2.18..7.70 rows=4 width=64) (actual time=0.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
600. 4.000 4.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
601. 7.000 12.000 ↓ 9.0 36 1,000

Bitmap Heap Scan on device_response deviceresponse_2 (cost=2.18..7.70 rows=4 width=64) (actual time=0.009..0.012 rows=36 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=585
602. 5.000 5.000 ↓ 9.2 37 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.005..0.005 rows=37 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
603. 1.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_3 (cost=2.18..7.70 rows=4 width=64) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
604. 3.000 3.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
605. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_4 (cost=2.18..7.70 rows=4 width=64) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
606. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
607. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_5 (cost=2.18..7.70 rows=4 width=64) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
608. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
609. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_6 (cost=2.18..7.70 rows=4 width=64) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
610. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
611. 4.000 7.000 ↑ 1.3 3 1,000

Bitmap Heap Scan on device_response deviceresponse_7 (cost=2.18..7.70 rows=4 width=64) (actual time=0.007..0.007 rows=3 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=370
612. 3.000 3.000 ↑ 1.3 3 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.003..0.003 rows=3 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
613. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_8 (cost=2.18..7.70 rows=4 width=64) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
614. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
615. 2.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_9 (cost=2.18..7.70 rows=4 width=64) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=11
616. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
617. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_10 (cost=2.18..7.70 rows=4 width=64) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
618. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
619. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_11 (cost=2.18..7.70 rows=4 width=64) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
620. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
621. 2.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_12 (cost=2.18..7.70 rows=4 width=64) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
622. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
623. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_13 (cost=2.18..7.70 rows=4 width=64) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
624. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
625. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_14 (cost=2.18..7.70 rows=4 width=64) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
626. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
627. 6.000 6.000 ↓ 0.0 0 1,000

Seq Scan on device_response deviceresponse_15 (cost=0.00..1.06 rows=5 width=57) (actual time=0.006..0.006 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 5
628. 1.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_16 (cost=2.18..7.70 rows=4 width=64) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=3
629. 3.000 3.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
630. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_17 (cost=2.18..7.70 rows=4 width=64) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
631. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
632. 2.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_18 (cost=2.18..7.70 rows=4 width=64) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
633. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
634. 2.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_19 (cost=2.18..7.70 rows=4 width=64) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
635. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
636. 2.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_20 (cost=2.18..7.70 rows=4 width=64) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
637. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
638. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_21 (cost=2.18..7.70 rows=4 width=64) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
639. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
640. 1.000 4.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_22 (cost=2.18..7.70 rows=4 width=64) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
641. 3.000 3.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
642. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_23 (cost=2.18..7.70 rows=4 width=64) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
643. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
644. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_24 (cost=2.18..7.70 rows=4 width=64) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
645. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
646. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_25 (cost=2.18..7.70 rows=4 width=64) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
647. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
648. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_26 (cost=2.18..7.70 rows=4 width=64) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
649. 2.000 2.000 ↓ 0.0 0 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
650. 4.000 1,986.000 ↑ 200.0 1 1,000

Hash (cost=14.75..14.75 rows=200 width=4) (actual time=1.986..1.986 rows=1 loops=1,000)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
651. 4.000 1,982.000 ↑ 200.0 1 1,000

HashAggregate (cost=12.75..14.75 rows=200 width=4) (actual time=1.982..1.982 rows=1 loops=1,000)

  • Group Key: device_children_3.id
652. 1,978.000 1,978.000 ↑ 1,000.0 1 1,000

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

653. 0.504 0.504 ↑ 1.0 1 168

Index Scan using pk_scantype on scantype (cost=0.15..0.40 rows=1 width=36) (actual time=0.003..0.003 rows=1 loops=168)

  • Index Cond: (id = deviceresponse.scantype_id)
654. 0.504 0.504 ↑ 1.0 1 168

Index Scan using pk_protocol on protocol (cost=0.15..0.40 rows=1 width=36) (actual time=0.002..0.003 rows=1 loops=168)

  • Index Cond: (id = deviceresponse.protocol_id)
655. 3.000 2,047.000 ↑ 1.0 1 1,000

Aggregate (cost=1,627.69..1,627.70 rows=1 width=32) (actual time=2.046..2.047 rows=1 loops=1,000)

656. 2.252 2,044.000 ↓ 0.0 0 1,000

Nested Loop (cost=17.25..1,603.23 rows=9,782 width=36) (actual time=2.041..2.044 rows=0 loops=1,000)

657. 11.744 2,040.000 ↓ 0.0 0 1,000

Hash Join (cost=17.25..832.62 rows=104 width=8) (actual time=2.039..2.040 rows=0 loops=1,000)

  • Hash Cond: (dsa.device_id = device_children_4.id)
658. 77.000 100.000 ↑ 29.9 7 1,000

Append (cost=0.00..812.50 rows=209 width=8) (actual time=0.028..0.100 rows=7 loops=1,000)

659. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa (cost=0.00..0.00 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
660. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_1 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
661. 7.000 7.000 ↑ 1.3 6 1,000

Seq Scan on device_snmpalias dsa_2 (cost=0.00..31.25 rows=8 width=8) (actual time=0.006..0.007 rows=6 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 4
662. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_3 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
663. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_4 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
664. 4.000 4.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_5 (cost=0.00..31.25 rows=8 width=8) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 2
665. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_6 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
666. 5.000 5.000 ↑ 8.0 1 1,000

Seq Scan on device_snmpalias dsa_7 (cost=0.00..31.25 rows=8 width=8) (actual time=0.005..0.005 rows=1 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 3
667. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_8 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
668. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_9 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
669. 4.000 4.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_10 (cost=0.00..31.25 rows=8 width=8) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 2
670. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_11 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
671. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_12 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
672. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_13 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
673. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_14 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
674. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_15 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
675. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_16 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
676. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_17 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
677. 3.000 3.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_18 (cost=0.00..31.25 rows=8 width=8) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 4
678. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_19 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
679. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_20 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
680. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_21 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
681. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_22 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
682. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_23 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
683. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_24 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
684. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_25 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
685. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_26 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
686. 2.904 1,928.256 ↑ 200.0 1 968

Hash (cost=14.75..14.75 rows=200 width=4) (actual time=1.992..1.992 rows=1 loops=968)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
687. 3.872 1,925.352 ↑ 200.0 1 968