explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CIDw

Settings
# exclusive inclusive rows x rows loops node
1. 0.670 20,569.499 ↑ 1.0 1,000 1

Limit (cost=37,261.26..5,107,013.07 rows=1,000 width=503) (actual time=22.356..20,569.499 rows=1,000 loops=1)

2. 547.106 20,568.829 ↑ 1,774.0 1,000 1

Nested Loop Left Join (cost=37,261.26..8,993,776,964.20 rows=1,774,000 width=503) (actual time=22.355..20,568.829 rows=1,000 loops=1)

3. 5.063 20.723 ↑ 1.8 1,000 1

Nested Loop (cost=37,261.01..64,167.54 rows=1,774 width=133) (actual time=0.669..20.723 rows=1,000 loops=1)

  • Join Filter: (devicevalues.zone_id = zn.id)
  • Rows Removed by Join Filter: 24,981
4. 3.383 12.660 ↑ 2.6 1,000 1

Merge Join (cost=9.67..11,588.27 rows=2,571 width=99) (actual time=0.255..12.660 rows=1,000 loops=1)

  • Merge Cond: (devicevalues.device_id = device.id)
  • Join Filter: (device.zone_id = devicevalues.zone_id)
5. 0.671 3.209 ↑ 9.7 1,000 1

Merge Append (cost=4.85..1,266.66 rows=9,711 width=12) (actual time=0.144..3.209 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.466 1.466 ↑ 1.0 584 1

Index Scan using idx_device_values_devid on device_values devicevalues_2 (cost=0.28..37.15 rows=584 width=12) (actual time=0.023..1.466 rows=584 loops=1)

9. 0.016 0.016 ↑ 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.005..0.016 rows=5 loops=1)

10. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

11. 0.014 0.014 ↑ 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.004..0.014 rows=5 loops=1)

12. 0.007 0.007 ↑ 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.004..0.007 rows=2 loops=1)

13. 0.861 0.861 ↑ 1.4 360 1

Index Scan using idx_device_values_devid on device_values devicevalues_7 (cost=0.27..37.56 rows=486 width=12) (actual time=0.008..0.861 rows=360 loops=1)

14. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

15. 0.022 0.022 ↑ 36.0 10 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.003..0.022 rows=10 loops=1)

16. 0.009 0.009 ↑ 120.0 3 1

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

17. 0.007 0.007 ↑ 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.004..0.007 rows=2 loops=1)

18. 0.008 0.008 ↑ 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.004..0.008 rows=2 loops=1)

19. 0.025 0.025 ↑ 30.0 12 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.005..0.025 rows=12 loops=1)

20. 0.012 0.012 ↑ 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.008..0.012 rows=2 loops=1)

21. 0.008 0.008 ↑ 180.0 2 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.004..0.008 rows=2 loops=1)

22. 0.013 0.013 ↑ 72.0 5 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.003..0.013 rows=5 loops=1)

23. 0.008 0.008 ↑ 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.004..0.008 rows=4 loops=1)

24. 0.021 0.021 ↑ 90.0 4 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.012..0.021 rows=4 loops=1)

25. 0.005 0.005 ↑ 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.005..0.005 rows=1 loops=1)

26. 0.004 0.004 ↑ 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.004..0.004 rows=1 loops=1)

27. 0.003 0.003 ↑ 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.003..0.003 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.004 0.004 ↑ 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.004..0.004 rows=1 loops=1)

30. 0.003 0.003 ↑ 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.003..0.003 rows=1 loops=1)

31. 0.002 0.002 ↓ 0.0 0 1

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

32. 0.003 0.003 ↑ 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.003..0.003 rows=1 loops=1)

33. 1.397 6.068 ↑ 10.6 1,000 1

Materialize (cost=4.82..1,327.05 rows=10,588 width=91) (actual time=0.103..6.068 rows=1,000 loops=1)

34. 1.468 4.671 ↑ 10.6 1,000 1

Merge Append (cost=4.82..1,300.58 rows=10,588 width=91) (actual time=0.099..4.671 rows=1,000 loops=1)

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

Index Scan using pk_device on device (cost=0.12..4.14 rows=1 width=95) (actual time=0.002..0.002 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.946 1.946 ↑ 1.0 584 1

Index Scan using pk_device on device device_2 (cost=0.28..54.43 rows=584 width=59) (actual time=0.008..1.946 rows=584 loops=1)

38. 0.018 0.018 ↑ 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.004..0.018 rows=5 loops=1)

39. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

40. 0.019 0.019 ↑ 90.0 5 1

Index Scan using pk_device on device device_5 (cost=0.15..30.90 rows=450 width=95) (actual time=0.003..0.019 rows=5 loops=1)

41. 0.008 0.008 ↑ 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.004..0.008 rows=2 loops=1)

42. 0.974 0.974 ↑ 1.4 360 1

Index Scan using pk_device on device device_7 (cost=0.27..49.42 rows=490 width=59) (actual time=0.009..0.974 rows=360 loops=1)

43. 0.002 0.002 ↓ 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.001..0.002 rows=0 loops=1)

44. 0.033 0.033 ↑ 45.0 10 1

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

45. 0.014 0.014 ↑ 15.3 3 1

Index Scan using pk_device on device device_10 (cost=0.14..8.67 rows=46 width=65) (actual time=0.004..0.014 rows=3 loops=1)

46. 0.015 0.015 ↑ 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.003..0.015 rows=2 loops=1)

47. 0.008 0.008 ↑ 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.003..0.008 rows=2 loops=1)

48. 0.034 0.034 ↑ 1.0 12 1

Index Scan using pk_device on device device_13 (cost=0.14..6.31 rows=12 width=61) (actual time=0.004..0.034 rows=12 loops=1)

49. 0.011 0.011 ↑ 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.005..0.011 rows=2 loops=1)

50. 0.007 0.007 ↑ 225.0 2 1

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

51. 0.055 0.055 ↑ 1.0 5 1

Index Scan using pk_device on device device_16 (cost=0.13..6.21 rows=5 width=61) (actual time=0.004..0.055 rows=5 loops=1)

52. 0.012 0.012 ↑ 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.003..0.012 rows=4 loops=1)

53. 0.015 0.015 ↑ 112.5 4 1

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

54. 0.004 0.004 ↑ 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.004..0.004 rows=1 loops=1)

55. 0.003 0.003 ↑ 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.003..0.003 rows=1 loops=1)

56. 0.004 0.004 ↑ 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.004..0.004 rows=1 loops=1)

57. 0.003 0.003 ↑ 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.003..0.003 rows=1 loops=1)

58. 0.003 0.003 ↑ 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.003..0.003 rows=1 loops=1)

59. 0.004 0.004 ↑ 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.004..0.004 rows=1 loops=1)

60. 0.002 0.002 ↓ 0.0 0 1

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

61. 0.003 0.003 ↑ 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.003..0.003 rows=1 loops=1)

62. 2.520 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.028 0.480 ↑ 5.3 26 1

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

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

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

65. 0.016 0.432 ↑ 2,123.2 130 1

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

  • Sort Key: u.id, z.id
66. 0.019 0.289 ↑ 32.1 52 1

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

  • Group Key: u.id, z.id
67. 0.075 0.270 ↑ 16.0 104 1

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

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

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

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

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

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

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

71. 0.018 0.093 ↑ 8.5 104 1

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

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

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

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

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

74. 0.010 0.040 ↑ 22.7 26 1

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

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

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

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

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

77. 0.001 0.006 ↑ 800.0 1 1

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

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

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

79. 0.004 0.017 ↑ 155.0 4 1

Hash (cost=16.20..16.20 rows=620 width=36) (actual time=0.017..0.017 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.012..0.013 rows=4 loops=1)

81. 0.038 0.127 ↑ 3,517.3 78 1

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

  • Group Key: u_1.id, z_1.id
82. 0.043 0.089 ↑ 3,517.3 78 1

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

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

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

84. 0.009 0.009 ↑ 22.7 26 1

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

85. 0.000 0.000 ↑ 155.0 3 26

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

86. 0.005 0.005 ↑ 155.0 3 1

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

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

Function Scan on ports (cost=0.25..10.25 rows=1,000 width=0) (actual time=3.125..3.126 rows=1 loops=1,000)

88.          

SubPlan (for Nested Loop Left Join)

89. 4.000 2,345.000 ↑ 1.0 1 1,000

Aggregate (cost=315.03..315.04 rows=1 width=32) (actual time=2.345..2.345 rows=1 loops=1,000)

90. 1.000 2,341.000 ↑ 10.0 1 1,000

Subquery Scan on attribute (cost=314.81..315.00 rows=10 width=60) (actual time=2.340..2.341 rows=1 loops=1,000)

91. 2.000 2,340.000 ↑ 10.0 1 1,000

Unique (cost=314.81..314.90 rows=10 width=44) (actual time=2.340..2.340 rows=1 loops=1,000)

92. 7.000 2,338.000 ↑ 17.0 1 1,000

Sort (cost=314.81..314.86 rows=17 width=44) (actual time=2.338..2.338 rows=1 loops=1,000)

  • Sort Key: att.type, dattr.last_update DESC
  • Sort Method: quicksort Memory: 25kB
93. 3.270 2,331.000 ↑ 17.0 1 1,000

Nested Loop (cost=18.48..314.47 rows=17 width=44) (actual time=2.296..2.331 rows=1 loops=1,000)

94. 20.420 2,306.000 ↑ 9.0 1 1,000

Hash Join (cost=18.48..257.24 rows=9 width=24) (actual time=2.293..2.306 rows=1 loops=1,000)

  • Hash Cond: (dattr.device_id = device_children.id)
95. 54.957 288.000 ↓ 7.8 140 1,000

Hash Join (cost=1.23..239.74 rows=18 width=24) (actual time=0.055..0.288 rows=140 loops=1,000)

  • Hash Cond: (dattr.attributetype_id = att.id)
96. 89.000 233.000 ↑ 2.6 140 1,000

Append (cost=0.00..236.97 rows=365 width=20) (actual time=0.051..0.233 rows=140 loops=1,000)

97. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_attribute dattr (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)
98. 1.000 5.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.005..0.005 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. 57.000 57.000 ↑ 1.3 134 1,000

Seq Scan on device_attribute dattr_2 (cost=0.00..4.25 rows=180 width=20) (actual time=0.019..0.057 rows=134 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 95
101. 2.000 5.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.005..0.005 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. 7.000 7.000 ↑ 2.7 6 1,000

Seq Scan on device_attribute dattr_7 (cost=0.00..1.20 rows=16 width=20) (actual time=0.005..0.007 rows=6 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 10
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. 1.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. 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)
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. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=12
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 3.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.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
123. 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)
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)
  • Heap Blocks: exact=2
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)
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. 1.000 3.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.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=3
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. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
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. 1.000 3.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.003..0.003 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. 1.000 3.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.003..0.003 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. 1.000 3.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.003..0.003 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. 1.000 3.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.003..0.003 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. 1.000 3.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.003..0.003 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.015 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.028 0.028 ↓ 5.2 52 1

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

150. 2.955 1,997.580 ↑ 200.0 1 985

Hash (cost=14.75..14.75 rows=200 width=4) (actual time=2.028..2.028 rows=1 loops=985)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
151. 3.940 1,994.625 ↑ 200.0 1 985

HashAggregate (cost=12.75..14.75 rows=200 width=4) (actual time=2.024..2.025 rows=1 loops=985)

  • Group Key: device_children.id
152. 1,990.685 1,990.685 ↑ 1,000.0 1 985

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

153. 5.830 21.730 ↑ 27.0 1 530

Append (cost=0.00..6.09 rows=27 width=28) (actual time=0.012..0.041 rows=1 loops=530)

154. 0.000 0.000 ↓ 0.0 0 530

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

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

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

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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

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

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

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

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

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

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

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

Aggregate (cost=315.03..315.04 rows=1 width=32) (actual time=2.356..2.357 rows=1 loops=1,000)

182. 1.000 2,353.000 ↑ 10.0 1 1,000

Subquery Scan on attribute_1 (cost=314.81..315.00 rows=10 width=60) (actual time=2.352..2.353 rows=1 loops=1,000)

183. 2.000 2,352.000 ↑ 10.0 1 1,000

Unique (cost=314.81..314.90 rows=10 width=44) (actual time=2.351..2.352 rows=1 loops=1,000)

184. 9.000 2,350.000 ↑ 17.0 1 1,000

Sort (cost=314.81..314.86 rows=17 width=44) (actual time=2.350..2.350 rows=1 loops=1,000)

  • Sort Key: att_1.type, dattr_27.last_update DESC
  • Sort Method: quicksort Memory: 25kB
185. 3.330 2,341.000 ↑ 17.0 1 1,000

Nested Loop (cost=18.48..314.47 rows=17 width=44) (actual time=2.307..2.341 rows=1 loops=1,000)

186. 20.570 2,317.000 ↑ 9.0 1 1,000

Hash Join (cost=18.48..257.24 rows=9 width=24) (actual time=2.303..2.317 rows=1 loops=1,000)

  • Hash Cond: (dattr_27.device_id = device_children_1.id)
187. 54.971 289.000 ↓ 7.8 140 1,000

Hash Join (cost=1.23..239.74 rows=18 width=24) (actual time=0.056..0.289 rows=140 loops=1,000)

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

Append (cost=0.00..236.97 rows=365 width=20) (actual time=0.050..0.234 rows=140 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. 2.000 6.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.006..0.006 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. 56.000 56.000 ↑ 1.3 134 1,000

Seq Scan on device_attribute dattr_29 (cost=0.00..4.25 rows=180 width=20) (actual time=0.018..0.056 rows=134 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 95
193. 2.000 5.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.005..0.005 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. 6.000 6.000 ↑ 2.7 6 1,000

Seq Scan on device_attribute dattr_34 (cost=0.00..1.20 rows=16 width=20) (actual time=0.005..0.006 rows=6 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 10
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)
  • Heap Blocks: exact=12
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)
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)
  • Heap Blocks: exact=2
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)
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=3
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. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
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.014 0.029 ↓ 5.2 52 1

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

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

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

242. 3.940 2,007.430 ↑ 200.0 1 985

Hash (cost=14.75..14.75 rows=200 width=4) (actual time=2.038..2.038 rows=1 loops=985)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
243. 3.940 2,003.490 ↑ 200.0 1 985

HashAggregate (cost=12.75..14.75 rows=200 width=4) (actual time=2.034..2.034 rows=1 loops=985)

  • Group Key: device_children_1.id
244. 1,999.550 1,999.550 ↑ 1,000.0 1 985

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

245. 5.300 20.670 ↑ 27.0 1 530

Append (cost=0.00..6.09 rows=27 width=28) (actual time=0.012..0.039 rows=1 loops=530)

246. 0.000 0.000 ↓ 0.0 0 530

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

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

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=530)

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

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

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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

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

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

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

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

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

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

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

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=530)

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

Aggregate (cost=345.68..345.69 rows=1 width=32) (actual time=0.200..0.200 rows=1 loops=1,000)

274. 2.312 186.000 ↑ 14.5 2 1,000

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

275. 7.656 177.000 ↑ 14.5 2 1,000

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

276. 80.000 166.000 ↑ 14.5 2 1,000

Append (cost=0.00..241.40 rows=29 width=16) (actual time=0.046..0.166 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. 6.000 6.000 ↑ 2.0 1 1,000

Index Scan using idx_device_match_device_id on device_match dm_2 (cost=0.28..4.38 rows=2 width=16) (actual time=0.005..0.006 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. 2.000 4.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.004..0.004 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. 2.000 4.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.004..0.004 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. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=9
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)
  • Heap Blocks: exact=1
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 3.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.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
311. 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)
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.344 3.344 ↑ 1.0 1 1,672

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,672)

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

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

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

Aggregate (cost=345.68..345.69 rows=1 width=32) (actual time=0.194..0.194 rows=1 loops=1,000)

331. 1.984 180.000 ↑ 14.5 2 1,000

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

332. 6.656 173.000 ↑ 14.5 2 1,000

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

333. 78.000 163.000 ↑ 14.5 2 1,000

Append (cost=0.00..241.40 rows=29 width=16) (actual time=0.046..0.163 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. 1.000 5.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.005..0.005 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.38 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)
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. 2.000 4.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.004..0.004 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=9
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)
  • Heap Blocks: exact=1
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.344 3.344 ↑ 1.0 1 1,672

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,672)

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

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,672)

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

Aggregate (cost=345.68..345.69 rows=1 width=32) (actual time=0.193..0.193 rows=1 loops=1,000)

388. 1.984 179.000 ↑ 14.5 2 1,000

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

389. 6.656 172.000 ↑ 14.5 2 1,000

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

390. 74.000 162.000 ↑ 14.5 2 1,000

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

391. 1.000 1.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.001..0.001 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.38 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)
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. 2.000 4.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.004 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. 2.000 4.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.004..0.004 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. 1.000 3.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.003..0.003 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. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=9
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)
  • Heap Blocks: exact=1
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. 2.000 4.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.004..0.004 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.344 3.344 ↑ 1.0 1 1,672

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,672)

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

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,672)

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

Aggregate (cost=345.68..345.69 rows=1 width=32) (actual time=0.193..0.193 rows=1 loops=1,000)

445. 1.984 179.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.43..345.61 rows=29 width=54) (actual time=0.057..0.179 rows=2 loops=1,000)

446. 6.656 172.000 ↑ 14.5 2 1,000

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

447. 75.000 162.000 ↑ 14.5 2 1,000

Append (cost=0.00..241.40 rows=29 width=16) (actual time=0.046..0.162 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.38 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)
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. 2.000 4.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.004..0.004 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. 2.000 4.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.004..0.004 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=9
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. 2.000 4.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.004..0.004 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)
  • Heap Blocks: exact=1
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.344 3.344 ↑ 1.0 1 1,672

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,672)

  • Index Cond: (id = dm_81.type_id)
500. 5.016 5.016 ↑ 1.0 1 1,672

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,672)

  • Index Cond: (id = dm_81.attribute_id)
501. 4.000 2,364.000 ↑ 1.0 1 1,000

Aggregate (cost=315.03..315.04 rows=1 width=32) (actual time=2.364..2.364 rows=1 loops=1,000)

502. 1.000 2,360.000 ↑ 10.0 1 1,000

Subquery Scan on attribute_2 (cost=314.81..315.00 rows=10 width=60) (actual time=2.360..2.360 rows=1 loops=1,000)

503. 2.000 2,359.000 ↑ 10.0 1 1,000

Unique (cost=314.81..314.90 rows=10 width=44) (actual time=2.359..2.359 rows=1 loops=1,000)

504. 9.000 2,357.000 ↑ 17.0 1 1,000

Sort (cost=314.81..314.86 rows=17 width=44) (actual time=2.357..2.357 rows=1 loops=1,000)

  • Sort Key: att_2.type, dattr_54.last_update DESC
  • Sort Method: quicksort Memory: 25kB
505. 2.800 2,348.000 ↑ 17.0 1 1,000

Nested Loop (cost=18.48..314.47 rows=17 width=44) (actual time=2.314..2.348 rows=1 loops=1,000)

506. 21.660 2,324.000 ↑ 9.0 1 1,000

Hash Join (cost=18.48..257.24 rows=9 width=24) (actual time=2.310..2.324 rows=1 loops=1,000)

  • Hash Cond: (dattr_54.device_id = device_children_2.id)
507. 54.970 289.000 ↓ 7.8 140 1,000

Hash Join (cost=1.23..239.74 rows=18 width=24) (actual time=0.056..0.289 rows=140 loops=1,000)

  • Hash Cond: (dattr_54.attributetype_id = att_2.id)
508. 93.000 234.000 ↑ 2.6 140 1,000

Append (cost=0.00..236.97 rows=365 width=20) (actual time=0.050..0.234 rows=140 loops=1,000)

509. 1.000 1.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.001..0.001 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. 56.000 56.000 ↑ 1.3 134 1,000

Seq Scan on device_attribute dattr_56 (cost=0.00..4.25 rows=180 width=20) (actual time=0.018..0.056 rows=134 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 95
513. 2.000 5.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.005..0.005 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. 6.000 6.000 ↑ 2.7 6 1,000

Seq Scan on device_attribute dattr_61 (cost=0.00..1.20 rows=16 width=20) (actual time=0.005..0.006 rows=6 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 10
522. 2.000 4.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.004..0.004 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)
  • Heap Blocks: exact=12
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)
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)
  • Heap Blocks: exact=2
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)
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=3
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)
  • Heap Blocks: exact=4
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. 2.000 4.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.004..0.004 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.014 0.030 ↓ 5.2 52 1

Hash (cost=1.10..1.10 rows=10 width=12) (actual time=0.030..0.030 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.008..0.016 rows=52 loops=1)

562. 4.925 2,013.340 ↑ 200.0 1 985

Hash (cost=14.75..14.75 rows=200 width=4) (actual time=2.044..2.044 rows=1 loops=985)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
563. 4.925 2,008.415 ↑ 200.0 1 985

HashAggregate (cost=12.75..14.75 rows=200 width=4) (actual time=2.039..2.039 rows=1 loops=985)

  • Group Key: device_children_2.id
564. 2,003.490 2,003.490 ↑ 1,000.0 1 985

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

565. 5.830 21.200 ↑ 27.0 1 530

Append (cost=0.00..6.09 rows=27 width=28) (actual time=0.012..0.040 rows=1 loops=530)

566. 0.000 0.000 ↓ 0.0 0 530

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

  • Filter: ((zone_id = device.zone_id) AND (dattr_54.attribute_id = id))
567. 1.060 1.060 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
568. 1.590 1.590 ↑ 1.0 1 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
569. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
570. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
571. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
572. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
573. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
574. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
575. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
576. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
577. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
578. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
579. 0.530 0.530 ↓ 0.0 0 530

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

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
580. 0.530 0.530 ↓ 0.0 0 530

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

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
581. 0.530 0.530 ↓ 0.0 0 530

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

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
582. 0.530 0.530 ↓ 0.0 0 530

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

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
583. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
584. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
585. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
586. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
587. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
588. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
589. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
590. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
591. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
592. 0.530 0.530 ↓ 0.0 0 530

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=530)

  • Index Cond: (id = dattr_54.attribute_id)
  • Filter: (zone_id = device.zone_id)
593. 5.000 2,253.000 ↑ 1.0 1 1,000

Aggregate (cost=255.10..255.11 rows=1 width=32) (actual time=2.253..2.253 rows=1 loops=1,000)

594. 0.436 2,248.000 ↓ 0.0 0 1,000

Nested Loop (cost=17.55..254.97 rows=52 width=136) (actual time=2.234..2.248 rows=0 loops=1,000)

595. 2.436 2,247.000 ↓ 0.0 0 1,000

Nested Loop (cost=17.40..233.61 rows=52 width=100) (actual time=2.233..2.247 rows=0 loops=1,000)

596. 18.000 2,244.000 ↓ 0.0 0 1,000

Hash Join (cost=17.25..212.25 rows=52 width=64) (actual time=2.230..2.244 rows=0 loops=1,000)

  • Hash Cond: (deviceresponse.device_id = device_children_3.id)
597. 90.000 197.000 ↑ 2.7 38 1,000

Append (cost=0.00..193.57 rows=104 width=64) (actual time=0.044..0.197 rows=38 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. 8.000 14.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.011..0.014 rows=36 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=584
602. 6.000 6.000 ↓ 9.0 36 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.006..0.006 rows=36 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. 2.000 4.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.004..0.004 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. 3.000 6.000 ↑ 2.0 2 1,000

Bitmap Heap Scan on device_response deviceresponse_7 (cost=2.18..7.70 rows=4 width=64) (actual time=0.005..0.006 rows=2 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=360
612. 3.000 3.000 ↑ 2.0 2 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=2 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=10
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. 1.000 3.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.003..0.003 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=12
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. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_15 (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
628. 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)
629. 7.000 7.000 ↓ 0.0 0 1,000

Seq Scan on device_response deviceresponse_16 (cost=0.00..1.04 rows=3 width=64) (actual time=0.007..0.007 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 3
630. 1.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=3
631. 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)
632. 1.000 3.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.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
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. 1.000 3.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.003..0.003 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. 2.000 4.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.004..0.004 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. 2.000 4.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.004..0.004 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 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
649. 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)
650. 4.000 2,029.000 ↑ 200.0 1 1,000

Hash (cost=14.75..14.75 rows=200 width=4) (actual time=2.029..2.029 rows=1 loops=1,000)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
651. 5.000 2,025.000 ↑ 200.0 1 1,000

HashAggregate (cost=12.75..14.75 rows=200 width=4) (actual time=2.025..2.025 rows=1 loops=1,000)

  • Group Key: device_children_3.id
652. 2,020.000 2,020.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=2.020..2.020 rows=1 loops=1,000)

653. 0.564 0.564 ↑ 1.0 1 188

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=188)

  • Index Cond: (id = deviceresponse.scantype_id)
654. 0.564 0.564 ↑ 1.0 1 188

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=188)

  • Index Cond: (id = deviceresponse.protocol_id)
655. 2.000 2,090.000 ↑ 1.0 1 1,000

Aggregate (cost=1,627.69..1,627.70 rows=1 width=32) (actual time=2.090..2.090 rows=1 loops=1,000)

656. 1.888 2,088.000 ↓ 0.0 0 1,000

Nested Loop (cost=17.25..1,603.23 rows=9,782 width=36) (actual time=2.085..2.088 rows=0 loops=1,000)

657. 11.930 2,084.000 ↓ 0.0 0 1,000

Hash Join (cost=17.25..832.62 rows=104 width=8) (actual time=2.082..2.084 rows=0 loops=1,000)

  • Hash Cond: (dsa.device_id = device_children_4.id)
658. 82.000 105.000 ↑ 29.9 7 1,000

Append (cost=0.00..812.50 rows=209 width=8) (actual time=0.029..0.105 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. 4.000 4.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.004..0.004 rows=1 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 2
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. 4.000 4.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.004..0.004 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 6
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. 0.000 0.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.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
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.907 1,967.070 ↑ 200.0 1 969

Hash (cost=14.75..14.75 rows=200 width=4) (actual time=2.030..2.030 rows=1 loops=969)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
687. 4.845 1,964.163 ↑ 200.0