explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y3EC

Settings
# exclusive inclusive rows x rows loops node
1. 1.264 618,782.135 ↑ 1.0 1,000 1

Limit (cost=37,261.25..12,487,839.40 rows=1,000 width=471) (actual time=1,009.686..618,782.135 rows=1,000 loops=1)

2. 883.945 618,780.871 ↑ 8.6 1,000 1

Nested Loop Left Join (cost=37,261.25..106,614,210.15 rows=8,560 width=471) (actual time=1,009.684..618,780.871 rows=1,000 loops=1)

3. 6.824 31.926 ↑ 1.7 1,000 1

Nested Loop (cost=37,261.00..63,634.19 rows=1,712 width=133) (actual time=1.358..31.926 rows=1,000 loops=1)

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

Merge Join (cost=9.66..11,241.22 rows=2,481 width=99) (actual time=0.721..21.102 rows=1,000 loops=1)

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

Merge Append (cost=4.85..1,229.55 rows=9,388 width=12) (actual time=0.336..6.225 rows=1,000 loops=1)

  • Sort Key: devicevalues.device_id
6. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

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

8. 2.539 2.539 ↑ 1.0 580 1

Index Scan using idx_device_values_devid on device_values devicevalues_2 (cost=0.28..37.04 rows=580 width=12) (actual time=0.031..2.539 rows=580 loops=1)

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

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

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

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

13. 1.633 1.633 ↑ 1.3 374 1

Index Scan using idx_device_values_devid on device_values devicevalues_7 (cost=0.27..37.45 rows=481 width=12) (actual time=0.027..1.633 rows=374 loops=1)

14. 0.002 0.002 ↓ 0.0 0 1

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

15. 0.054 0.054 ↑ 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.011..0.054 rows=10 loops=1)

16. 0.037 0.037 ↑ 15.3 3 1

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

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

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

19. 0.025 0.025 ↑ 180.0 2 1

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

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

21. 0.038 0.038 ↑ 72.0 5 1

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

22. 0.033 0.033 ↑ 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.013..0.033 rows=5 loops=1)

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

24. 0.013 0.013 ↑ 360.0 1 1

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

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

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

27. 0.010 0.010 ↑ 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.010..0.010 rows=1 loops=1)

28. 0.010 0.010 ↑ 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.010..0.010 rows=1 loops=1)

29. 0.009 0.009 ↑ 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.009..0.009 rows=1 loops=1)

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

31. 0.014 0.014 ↑ 360.0 1 1

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

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

33. 1.643 9.043 ↑ 10.6 1,000 1

Materialize (cost=4.82..1,329.43 rows=10,573 width=91) (actual time=0.372..9.043 rows=1,000 loops=1)

34. 2.359 7.400 ↑ 10.6 1,000 1

Merge Append (cost=4.82..1,303.00 rows=10,573 width=91) (actual time=0.364..7.400 rows=1,000 loops=1)

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

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

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

37. 2.279 2.279 ↑ 1.0 580 1

Index Scan using pk_device on device device_2 (cost=0.28..53.66 rows=580 width=59) (actual time=0.025..2.279 rows=580 loops=1)

38. 0.044 0.044 ↑ 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.014..0.044 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.029 0.029 ↑ 1.0 5 1

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

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

42. 2.215 2.215 ↑ 1.3 374 1

Index Scan using pk_device on device device_7 (cost=0.27..51.39 rows=486 width=59) (actual time=0.030..2.215 rows=374 loops=1)

43. 0.003 0.003 ↓ 0.0 0 1

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

44. 0.061 0.061 ↑ 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.013..0.061 rows=10 loops=1)

45. 0.037 0.037 ↑ 15.3 3 1

Index Scan using pk_device on device device_10 (cost=0.14..8.74 rows=46 width=65) (actual time=0.016..0.037 rows=3 loops=1)

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

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

48. 0.019 0.019 ↑ 225.0 2 1

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

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

50. 0.035 0.035 ↑ 1.0 5 1

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

51. 0.061 0.061 ↑ 90.0 5 1

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

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

53. 0.016 0.016 ↑ 450.0 1 1

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

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

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

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

57. 0.011 0.011 ↑ 450.0 1 1

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

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

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

60. 0.013 0.013 ↑ 450.0 1 1

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

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

62. 3.329 4.000 ↑ 5.3 26 1,000

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

63. 0.027 0.671 ↑ 5.3 26 1

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

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

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

65. 0.021 0.609 ↑ 2,123.2 130 1

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

  • Sort Key: u.id, z.id
66. 0.020 0.440 ↑ 32.1 52 1

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

  • Group Key: u.id, z.id
67. 0.102 0.420 ↑ 16.0 104 1

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

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

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

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

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

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

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

71. 0.032 0.177 ↑ 8.5 104 1

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

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

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

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

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

74. 0.014 0.091 ↑ 22.7 26 1

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

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

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

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

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

77. 0.008 0.020 ↑ 800.0 1 1

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

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

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

79. 0.007 0.022 ↑ 155.0 4 1

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

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

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

81. 0.022 0.148 ↑ 3,517.3 78 1

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

  • Group Key: u_1.id, z_1.id
82. 0.078 0.126 ↑ 3,517.3 78 1

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

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

Nested Loop (cost=0.00..3,462.64 rows=274,350 width=78) (actual time=0.021..0.048 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.008..0.009 rows=26 loops=1)

85. 0.018 0.026 ↑ 155.0 3 26

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

86. 0.008 0.008 ↑ 155.0 3 1

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

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

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

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

SubPlan (for Nested Loop Left Join)

89. 7.000 301,315.000 ↑ 1.0 1 1,000

Aggregate (cost=4,160.03..4,160.04 rows=1 width=32) (actual time=301.315..301.315 rows=1 loops=1,000)

90. 1.000 301,308.000 ↓ 0.0 0 1,000

Subquery Scan on attribute (cost=4,157.56..4,160.00 rows=10 width=60) (actual time=301.308..301.308 rows=0 loops=1,000)

91. 3.000 301,307.000 ↓ 0.0 0 1,000

Unique (cost=4,157.56..4,159.90 rows=10 width=44) (actual time=301.306..301.307 rows=0 loops=1,000)

92. 14.000 301,304.000 ↑ 468.0 1 1,000

Sort (cost=4,157.56..4,158.73 rows=468 width=44) (actual time=301.304..301.304 rows=1 loops=1,000)

  • Sort Key: att.type, dattr.last_update DESC
  • Sort Method: quicksort Memory: 25kB
93. 4.325 301,290.000 ↑ 468.0 1 1,000

Hash Join (cost=613.89..4,136.81 rows=468 width=44) (actual time=285.074..301.290 rows=1 loops=1,000)

  • Hash Cond: (dattr.attribute_id = a.id)
94. 458.298 301,257.880 ↑ 248.0 1 980

Nested Loop (cost=1.23..3,507.07 rows=248 width=28) (actual time=290.860..307.406 rows=1 loops=980)

  • Join Filter: (SubPlan 1)
  • Rows Removed by Join Filter: 144
95. 42.140 133.280 ↑ 27.0 1 980

Append (cost=0.00..100.95 rows=27 width=8) (actual time=0.031..0.136 rows=1 loops=980)

96. 0.980 0.980 ↓ 0.0 0 980

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

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
97. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
98. 6.860 6.860 ↑ 1.0 1 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
99. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
100. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
101. 6.860 6.860 ↓ 0.0 0 980

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

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
  • Rows Removed by Filter: 5
102. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
103. 4.900 4.900 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
104. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
105. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
106. 15.680 15.680 ↓ 0.0 0 980

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

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
  • Rows Removed by Filter: 46
107. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
108. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
109. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
110. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
111. 6.860 6.860 ↓ 0.0 0 980

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

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
  • Rows Removed by Filter: 5
112. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
113. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
114. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
115. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
116. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
117. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
118. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
119. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
120. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
121. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
122. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
123. 155.820 974.120 ↓ 8.0 144 980

Materialize (cost=1.23..239.88 rows=18 width=28) (actual time=0.079..0.994 rows=144 loops=980)

124. 269.444 818.300 ↓ 8.0 144 980

Hash Join (cost=1.23..239.79 rows=18 width=28) (actual time=0.076..0.835 rows=144 loops=980)

  • Hash Cond: (dattr.attributetype_id = att.id)
125. 164.640 548.800 ↑ 2.6 144 980

Append (cost=0.00..237.01 rows=368 width=24) (actual time=0.064..0.560 rows=144 loops=980)

126. 0.980 0.980 ↓ 0.0 0 980

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

  • Filter: (zone_id = device.zone_id)
127. 2.940 6.860 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
128. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
129. 226.380 226.380 ↑ 1.3 138 980

Seq Scan on device_attribute dattr_2 (cost=0.00..4.29 rows=183 width=24) (actual time=0.021..0.231 rows=138 loops=980)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 95
130. 2.940 8.820 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
131. 5.880 5.880 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
132. 1.960 4.900 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
133. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
134. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
135. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
136. 1.960 4.900 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
137. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
138. 18.620 18.620 ↑ 2.7 6 980

Seq Scan on device_attribute dattr_7 (cost=0.00..1.20 rows=16 width=24) (actual time=0.010..0.019 rows=6 loops=980)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 10
139. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
140. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
141. 1.960 4.900 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
142. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
143. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
144. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
145. 1.960 4.900 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
146. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
147. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
148. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
149. 1.960 4.900 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
150. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
151. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
152. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
153. 1.960 4.900 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
154. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
155. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
156. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
157. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
158. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
159. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
160. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
161. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
162. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
163. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
164. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
165. 2.940 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
166. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
167. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
168. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
169. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
170. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
171. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
172. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
173. 1.960 4.900 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
174. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
175. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
176. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
177. 0.022 0.056 ↓ 5.2 52 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
178. 0.034 0.034 ↓ 5.2 52 1

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

179.          

SubPlan (for Nested Loop)

180. 299,692.182 299,692.182 ↑ 1,000.0 1 141,231

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

181. 3.270 27.795 ↑ 4.5 84 109

Hash (cost=607.95..607.95 rows=377 width=32) (actual time=0.255..0.255 rows=84 loops=109)

  • Buckets: 1 (originally 672154472) Batches: 0 (originally 0) Memory Usage: 9kB
182. 10.900 24.525 ↑ 4.5 84 109

Append (cost=0.00..607.95 rows=377 width=32) (actual time=0.074..0.225 rows=84 loops=109)

183. 0.109 0.109 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
184. 0.109 0.109 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
185. 4.360 4.360 ↑ 2.7 83 109

Seq Scan on attribute a_2 (cost=0.00..4.83 rows=226 width=26) (actual time=0.019..0.040 rows=83 loops=109)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 63
186. 0.545 0.545 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 1
187. 0.109 0.109 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
188. 0.545 0.545 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 5
189. 0.109 0.109 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
190. 0.654 0.654 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 9
191. 0.109 0.109 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
192. 0.109 0.109 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
193. 0.654 0.654 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 9
194. 0.000 0.000 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
195. 0.545 0.545 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 6
196. 0.109 0.109 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
197. 0.436 0.436 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 1
198. 0.109 0.109 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
199. 0.436 0.436 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 1
200. 0.436 0.436 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 1
201. 0.763 0.763 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 18
202. 0.654 0.654 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 7
203. 0.545 0.545 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 2
204. 0.000 0.000 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
205. 0.545 0.545 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 1
206. 0.545 0.545 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 2
207. 0.545 0.545 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 2
208. 0.000 0.000 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
209. 0.545 0.545 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 4
210. 7.000 301,923.000 ↑ 1.0 1 1,000

Aggregate (cost=4,160.03..4,160.04 rows=1 width=32) (actual time=301.923..301.923 rows=1 loops=1,000)

211. 1.000 301,916.000 ↓ 0.0 0 1,000

Subquery Scan on attribute_1 (cost=4,157.56..4,160.00 rows=10 width=60) (actual time=301.916..301.916 rows=0 loops=1,000)

212. 4.000 301,915.000 ↓ 0.0 0 1,000

Unique (cost=4,157.56..4,159.90 rows=10 width=44) (actual time=301.914..301.915 rows=0 loops=1,000)

213. 15.000 301,911.000 ↑ 468.0 1 1,000

Sort (cost=4,157.56..4,158.73 rows=468 width=44) (actual time=301.911..301.911 rows=1 loops=1,000)

  • Sort Key: att_1.type, dattr_27.last_update DESC
  • Sort Method: quicksort Memory: 25kB
214. 3.924 301,896.000 ↑ 468.0 1 1,000

Hash Join (cost=613.89..4,136.81 rows=468 width=44) (actual time=285.909..301.896 rows=1 loops=1,000)

  • Hash Cond: (dattr_27.attribute_id = a_27.id)
215. 528.414 301,865.480 ↑ 248.0 1 980

Nested Loop (cost=1.23..3,507.07 rows=248 width=28) (actual time=291.714..308.026 rows=1 loops=980)

  • Join Filter: (SubPlan 3)
  • Rows Removed by Join Filter: 144
216. 45.080 131.320 ↑ 27.0 1 980

Append (cost=0.00..100.95 rows=27 width=8) (actual time=0.028..0.134 rows=1 loops=980)

217. 0.980 0.980 ↓ 0.0 0 980

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

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
218. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
219. 5.880 5.880 ↑ 1.0 1 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
220. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
221. 0.980 0.980 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
222. 6.860 6.860 ↓ 0.0 0 980

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

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
  • Rows Removed by Filter: 5
223. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
224. 4.900 4.900 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
225. 0.980 0.980 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
226. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
227. 15.680 15.680 ↓ 0.0 0 980

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

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
  • Rows Removed by Filter: 46
228. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
229. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
230. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
231. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
232. 6.860 6.860 ↓ 0.0 0 980

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

  • Filter: ((zone_id = device.zone_id) AND (id = device.id))
  • Rows Removed by Filter: 5
233. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
234. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
235. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
236. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
237. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
238. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
239. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
240. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
241. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
242. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
243. 1.960 1.960 ↓ 0.0 0 980

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

  • Index Cond: (id = device.id)
  • Filter: (zone_id = device.zone_id)
244. 144.060 948.640 ↓ 8.0 144 980

Materialize (cost=1.23..239.88 rows=18 width=28) (actual time=0.076..0.968 rows=144 loops=980)

245. 258.687 804.580 ↓ 8.0 144 980

Hash Join (cost=1.23..239.79 rows=18 width=28) (actual time=0.072..0.821 rows=144 loops=980)

  • Hash Cond: (dattr_27.attributetype_id = att_1.id)
246. 162.680 545.860 ↑ 2.6 144 980

Append (cost=0.00..237.01 rows=368 width=24) (actual time=0.061..0.557 rows=144 loops=980)

247. 0.000 0.000 ↓ 0.0 0 980

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

  • Filter: (zone_id = device.zone_id)
248. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
249. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
250. 227.360 227.360 ↑ 1.3 138 980

Seq Scan on device_attribute dattr_29 (cost=0.00..4.29 rows=183 width=24) (actual time=0.020..0.232 rows=138 loops=980)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 95
251. 2.940 7.840 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
252. 4.900 4.900 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
253. 2.940 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
254. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
255. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
256. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
257. 1.960 4.900 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
258. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
259. 19.600 19.600 ↑ 2.7 6 980

Seq Scan on device_attribute dattr_34 (cost=0.00..1.20 rows=16 width=24) (actual time=0.010..0.020 rows=6 loops=980)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 10
260. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
261. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
262. 1.960 4.900 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
263. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
264. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
265. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
266. 1.960 4.900 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
267. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
268. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
269. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
270. 1.960 4.900 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
271. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
272. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
273. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
274. 1.960 4.900 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
275. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
276. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
277. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
278. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
279. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
280. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
281. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
282. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
283. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
284. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
285. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
286. 1.960 4.900 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
287. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
288. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
289. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
290. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
291. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
292. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
293. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
294. 1.960 4.900 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
295. 2.940 2.940 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
296. 1.960 5.880 ↓ 0.0 0 980

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

  • Recheck Cond: (zone_id = device.zone_id)
297. 3.920 3.920 ↓ 0.0 0 980

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

  • Index Cond: (zone_id = device.zone_id)
298. 0.012 0.033 ↓ 5.2 52 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
299. 0.021 0.021 ↓ 5.2 52 1

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

300.          

SubPlan (for Nested Loop)

301. 300,257.106 300,257.106 ↑ 1,000.0 1 141,231

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

302. 3.270 26.596 ↑ 4.5 84 109

Hash (cost=607.95..607.95 rows=377 width=32) (actual time=0.244..0.244 rows=84 loops=109)

  • Buckets: 1 (originally 672038152) Batches: 0 (originally 0) Memory Usage: 9kB
303. 10.791 23.326 ↑ 4.5 84 109

Append (cost=0.00..607.95 rows=377 width=32) (actual time=0.065..0.214 rows=84 loops=109)

304. 0.109 0.109 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
305. 0.109 0.109 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
306. 4.251 4.251 ↑ 2.7 83 109

Seq Scan on attribute a_29 (cost=0.00..4.83 rows=226 width=26) (actual time=0.018..0.039 rows=83 loops=109)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 63
307. 0.545 0.545 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 1
308. 0.000 0.000 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
309. 0.763 0.763 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 5
310. 0.000 0.000 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
311. 0.654 0.654 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 9
312. 0.000 0.000 ↓ 0.0 0 109

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

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

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

  • Filter: (zone_id = device.zone_id)
314. 0.545 0.545 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 9
315. 0.000 0.000 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
316. 0.545 0.545 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 6
317. 0.000 0.000 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
318. 0.436 0.436 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 1
319. 0.000 0.000 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
320. 0.436 0.436 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 1
321. 0.654 0.654 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 1
322. 0.654 0.654 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 18
323. 0.545 0.545 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 7
324. 0.436 0.436 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 2
325. 0.000 0.000 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
326. 0.436 0.436 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 1
327. 0.436 0.436 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 2
328. 0.436 0.436 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 2
329. 0.000 0.000 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
330. 0.545 0.545 ↓ 0.0 0 109

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 4
331. 20.000 308.000 ↑ 1.0 1 1,000

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

332. 3.160 288.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.43..345.62 rows=29 width=54) (actual time=0.098..0.288 rows=2 loops=1,000)

333. 12.440 275.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.15..270.63 rows=29 width=44) (actual time=0.088..0.275 rows=2 loops=1,000)

334. 113.000 256.000 ↑ 14.5 2 1,000

Append (cost=0.00..241.41 rows=29 width=16) (actual time=0.073..0.256 rows=2 loops=1,000)

335. 1.000 1.000 ↓ 0.0 0 1,000

Seq Scan on device_match dm (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))
336. 2.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
337. 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)
338. 8.000 8.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.008..0.008 rows=1 loops=1,000)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
339. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
340. 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)
341. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
342. 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)
343. 3.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
344. 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)
345. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
346. 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)
347. 7.000 7.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.006..0.007 rows=1 loops=1,000)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
348. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
349. 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)
350. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
351. 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)
352. 2.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
353. 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)
354. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
355. 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)
356. 2.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
357. 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)
358. 3.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
359. 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)
360. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
361. 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)
362. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
363. 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)
364. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
365. 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)
366. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
367. 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)
368. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
369. 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)
370. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
371. 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)
372. 3.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
373. 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)
374. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
375. 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)
376. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
377. 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)
378. 2.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
379. 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)
380. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
381. 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)
382. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
383. 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)
384. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
385. 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)
386. 6.560 6.560 ↑ 1.0 1 1,640

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

  • Index Cond: (id = dm.type_id)
387. 9.840 9.840 ↑ 1.0 1 1,640

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

  • Index Cond: (id = dm.attribute_id)
388. 16.000 240.000 ↑ 1.0 1 1,000

Aggregate (cost=345.69..345.70 rows=1 width=32) (actual time=0.239..0.240 rows=1 loops=1,000)

389. 4.440 224.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.43..345.62 rows=29 width=54) (actual time=0.076..0.224 rows=2 loops=1,000)

390. 11.720 213.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.15..270.63 rows=29 width=44) (actual time=0.070..0.213 rows=2 loops=1,000)

391. 93.000 198.000 ↑ 14.5 2 1,000

Append (cost=0.00..241.41 rows=29 width=16) (actual time=0.057..0.198 rows=2 loops=1,000)

392. 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))
393. 2.000 6.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
394. 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)
395. 6.000 6.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.006 rows=1 loops=1,000)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
396. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
397. 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)
398. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
399. 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)
400. 2.000 4.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.004..0.004 rows=0 loops=1,000)

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
403. 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)
404. 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.004..0.004 rows=1 loops=1,000)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
405. 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)
406. 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)
407. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
408. 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)
409. 2.000 4.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.004..0.004 rows=0 loops=1,000)

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

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

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

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

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
420. 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)
421. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
422. 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)
423. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
424. 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)
425. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
426. 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)
427. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
428. 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)
429. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
430. 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)
431. 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)
432. 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)
433. 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)
434. 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)
435. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
436. 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)
437. 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)
438. 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)
439. 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)
440. 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)
441. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
442. 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)
443. 3.280 3.280 ↑ 1.0 1 1,640

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

  • Index Cond: (id = dm_27.type_id)
444. 6.560 6.560 ↑ 1.0 1 1,640

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

  • Index Cond: (id = dm_27.attribute_id)
445. 16.000 238.000 ↑ 1.0 1 1,000

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

446. 3.080 222.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.43..345.62 rows=29 width=54) (actual time=0.075..0.222 rows=2 loops=1,000)

447. 12.720 214.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.15..270.63 rows=29 width=44) (actual time=0.070..0.214 rows=2 loops=1,000)

448. 93.000 198.000 ↑ 14.5 2 1,000

Append (cost=0.00..241.41 rows=29 width=16) (actual time=0.057..0.198 rows=2 loops=1,000)

449. 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))
450. 2.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
451. 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)
452. 6.000 6.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.006 rows=1 loops=1,000)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
453. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
454. 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)
455. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
456. 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)
457. 2.000 4.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.004..0.004 rows=0 loops=1,000)

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
460. 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)
461. 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.004..0.004 rows=1 loops=1,000)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
462. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
463. 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)
464. 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)
465. 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)
466. 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
467. 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)
468. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
469. 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)
470. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
471. 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)
472. 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=1
473. 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)
474. 2.000 4.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.004..0.004 rows=0 loops=1,000)

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
477. 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)
478. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
479. 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)
480. 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)
481. 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)
482. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
483. 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)
484. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
485. 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)
486. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
487. 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)
488. 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)
489. 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)
490. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
491. 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)
492. 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)
493. 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)
494. 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)
495. 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)
496. 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)
497. 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)
498. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
499. 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)
500. 3.280 3.280 ↑ 1.0 1 1,640

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

  • Index Cond: (id = dm_54.type_id)
501. 4.920 4.920 ↑ 1.0 1 1,640

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

  • Index Cond: (id = dm_54.attribute_id)
502. 15.000 234.000 ↑ 1.0 1 1,000

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

503. 4.080 219.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.43..345.62 rows=29 width=54) (actual time=0.074..0.219 rows=2 loops=1,000)

504. 12.720 210.000 ↑ 14.5 2 1,000

Nested Loop (cost=0.15..270.63 rows=29 width=44) (actual time=0.069..0.210 rows=2 loops=1,000)

505. 91.000 194.000 ↑ 14.5 2 1,000

Append (cost=0.00..241.41 rows=29 width=16) (actual time=0.056..0.194 rows=2 loops=1,000)

506. 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))
507. 2.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
508. 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)
509. 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)
510. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
511. 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)
512. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
513. 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)
514. 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
515. 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)
516. 3.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
517. 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)
518. 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.004..0.004 rows=1 loops=1,000)

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
519. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
520. 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)
521. 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)
522. 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)
523. 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
524. 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)
525. 2.000 4.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.004..0.004 rows=0 loops=1,000)

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

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
530. 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)
531. 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
532. 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)
533. 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)
534. 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)
535. 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)
536. 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)
537. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
538. 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)
539. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
540. 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)
541. 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)
542. 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)
543. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
544. 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)
545. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
546. 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)
547. 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)
548. 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)
549. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
550. 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)
551. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
552. 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)
553. 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)
554. 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)
555. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
556. 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)
557. 3.280 3.280 ↑ 1.0 1 1,640

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

  • Index Cond: (id = dm_81.type_id)
558. 4.920 4.920 ↑ 1.0 1 1,640

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

  • Index Cond: (id = dm_81.attribute_id)
559. 7.000 2,602.000 ↑ 1.0 1 1,000

Aggregate (cost=255.19..255.20 rows=1 width=32) (actual time=2.601..2.602 rows=1 loops=1,000)

560. 1.472 2,595.000 ↓ 0.0 0 1,000

Nested Loop (cost=17.55..255.05 rows=52 width=136) (actual time=2.577..2.595 rows=0 loops=1,000)

561. 4.296 2,593.000 ↓ 0.0 0 1,000

Nested Loop (cost=17.40..233.69 rows=52 width=100) (actual time=2.575..2.593 rows=0 loops=1,000)

562. 27.000 2,588.000 ↓ 0.0 0 1,000

Hash Join (cost=17.25..212.33 rows=52 width=64) (actual time=2.571..2.588 rows=0 loops=1,000)

  • Hash Cond: (deviceresponse.device_id = device_children_2.id)
563. 128.000 290.000 ↑ 2.6 40 1,000

Append (cost=0.00..193.65 rows=104 width=64) (actual time=0.061..0.290 rows=40 loops=1,000)

564. 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)
565. 2.000 7.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.007..0.007 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
566. 5.000 5.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.005..0.005 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
567. 10.000 17.000 ↓ 9.5 38 1,000

Bitmap Heap Scan on device_response deviceresponse_2 (cost=2.18..7.70 rows=4 width=64) (actual time=0.014..0.017 rows=38 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=580
568. 7.000 7.000 ↓ 9.5 38 1,000

Bitmap Index Scan on uk_device_response (cost=0.00..2.18 rows=4 width=0) (actual time=0.007..0.007 rows=38 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
569. 2.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
570. 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)
571. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
572. 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)
573. 2.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
574. 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)
575. 1.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
576. 5.000 5.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.005..0.005 rows=0 loops=1,000)

  • Index Cond: (zone_id = device.zone_id)
577. 5.000 9.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.008..0.009 rows=2 loops=1,000)

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

  • Index Cond: (zone_id = device.zone_id)
579. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
580. 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)
581. 2.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=10
582. 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)
583. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
584. 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)
585. 3.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
586. 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)
587. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
588. 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)
589. 2.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
590. 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)
591. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=2
592. 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)
593. 8.000 8.000 ↓ 0.0 0 1,000

Seq Scan on device_response deviceresponse_15 (cost=0.00..1.12 rows=3 width=64) (actual time=0.008..0.008 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 3
594. 2.000 6.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
595. 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)
596. 2.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
597. 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)
598. 1.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
599. 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)
600. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
601. 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)
602. 2.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
603. 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)
604. 1.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
605. 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)
606. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
607. 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)
608. 3.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
609. 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)
610. 2.000 6.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.006..0.006 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
611. 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)
612. 1.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
613. 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)
614. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
615. 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)
616. 7.000 2,271.000 ↑ 200.0 1 1,000

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
617. 7.000 2,264.000 ↑ 200.0 1 1,000

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

  • Group Key: device_children_2.id
618. 2,257.000 2,257.000 ↑ 1,000.0 1 1,000

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

619. 0.704 0.704 ↑ 1.0 1 176

Index Scan using pk_scantype on scantype (cost=0.15..0.40 rows=1 width=36) (actual time=0.004..0.004 rows=1 loops=176)

  • Index Cond: (id = deviceresponse.scantype_id)
620. 0.528 0.528 ↑ 1.0 1 176

Index Scan using pk_protocol on protocol (cost=0.15..0.40 rows=1 width=36) (actual time=0.003..0.003 rows=1 loops=176)

  • Index Cond: (id = deviceresponse.protocol_id)
621. 4.000 2,254.000 ↑ 1.0 1 1,000

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

622. 3.884 2,250.000 ↓ 0.0 0 1,000

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

623. 17.056 2,244.000 ↓ 0.0 0 1,000

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

  • Hash Cond: (dsa.device_id = device_children_3.id)
624. 106.000 138.000 ↑ 29.9 7 1,000

Append (cost=0.00..812.50 rows=209 width=8) (actual time=0.037..0.138 rows=7 loops=1,000)

625. 1.000 1.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
626. 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)
627. 9.000 9.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.007..0.009 rows=6 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 4
628. 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)
629. 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)
630. 6.000 6.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.006..0.006 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 2
631. 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)
632. 6.000 6.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.006..0.006 rows=1 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 2
633. 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)
634. 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)
635. 5.000 5.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.005..0.005 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 2
636. 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)
637. 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)
638. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_snmpalias dsa_13 (cost=0.00..31.25 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
639. 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)
640. 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)
641. 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)
642. 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)
643. 5.000 5.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.005..0.005 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 4
644. 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)
645. 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)
646. 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)
647. 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)
648. 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)
649. 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)
650. 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)
651. 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)
652. 4.840 2,088.944 ↑ 200.0 1 968

Hash (cost=14.75..14.75 rows=200 width=4) (actual time=2.158..2.158 rows=1 loops=968)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
653. 6.776 2,084.104 ↑ 200.0 1 968

HashAggregate (cost=12.75..14.75 rows=200 width=4) (actual time=2.152..2.153 rows=1 loops=968)

  • Group Key: device_children_3.id
654. 2,077.328 2,077.328 ↑ 1,000.0 1 968

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

655. 0.713 2.116 ↑ 27.0 1 23

Append (cost=0.00..7.14 rows=27 width=36) (actual time=0.026..0.092 rows=1 loops=23)

656. 0.023 0.023 ↓ 0.0 0 23

Seq Scan on snmpalias sa (cost=0.00..0.00 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=23)

  • Filter: (dsa.snmpalias_id = id)
657. 0.092 0.092 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_1 (cost=0.15..0.27 rows=1 width=36) (actual time=0.004..0.004 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
658. 0.115 0.115 ↑ 1.0 1 23

Index Scan using pk_snmpalias on snmpalias sa_2 (cost=0.15..0.28 rows=1 width=36) (actual time=0.005..0.005 rows=1 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
659. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_3 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
660. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_4 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
661. 0.069 0.069 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_5 (cost=0.15..0.28 rows=1 width=36) (actual time=0.003..0.003 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
662. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_6 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
663. 0.069 0.069 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_7 (cost=0.15..0.28 rows=1 width=36) (actual time=0.003..0.003 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
664. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_8 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
665. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_9 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
666. 0.069 0.069 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_10 (cost=0.15..0.28 rows=1 width=36) (actual time=0.003..0.003 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
667. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_11 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
668. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_12 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
669. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_13 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
670. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_14 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
671. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_15 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
672. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_16 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
673. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_17 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
674. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_18 (cost=0.15..0.28 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
675. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_19 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
676. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_20 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
677. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_21 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
678. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_22 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
679. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_23 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
680. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_24 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
681. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_25 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
682. 0.046 0.046 ↓ 0.0 0 23

Index Scan using pk_snmpalias on snmpalias sa_26 (cost=0.15..0.27 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=23)

  • Index Cond: (id = dsa.snmpalias_id)
683. 6.000 2,442.000 ↑ 1.0 1 1,000

Aggregate (cost=255.19..255.20 rows=1 width=32) (actual time=2.442..2.442 rows=1 loops=1,000)

684. 1.472 2,436.000 ↓ 0.0 0 1,000

Nested Loop (cost=17.55..255.05 rows=52 width=136) (actual time=2.419..2.436 rows=0 loops=1,000)

685. 4.296 2,434.000 ↓ 0.0 0 1,000

Nested Loop (cost=17.40..233.69 rows=52 width=100) (actual time=2.418..2.434 rows=0 loops=1,000)

686. 24.000 2,429.000 ↓ 0.0 0 1,000

Hash Join (cost=17.25..212.33 rows=52 width=64) (actual time=2.413..2.429 rows=0 loops=1,000)

  • Hash Cond: (deviceresponse_27.device_id = device_children_4.id)
687. 111.000 249.000 ↑ 2.6 40 1,000

Append (cost=0.00..193.65 rows=104 width=64) (actual time=0.055..0.249 rows=40 loops=1,000)

688. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_response deviceresponse_27 (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)
689. 3.000 7.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_28 (cost=2.18..7.70 rows=4 width=64) (actual time=0.007..0.007 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
690. 4.000 4.000 ↓ 0