explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lXPI

Settings
# exclusive inclusive rows x rows loops node
1. 0.476 14,824.243 ↑ 1.0 1,000 1

Limit (cost=37,576.27..4,162,516.28 rows=1,000 width=503) (actual time=19.058..14,824.243 rows=1,000 loops=1)

2. 514.323 14,823.767 ↑ 1,644.0 1,000 1

Nested Loop Left Join (cost=37,576.27..6,781,438,950.09 rows=1,644,000 width=503) (actual time=19.056..14,823.767 rows=1,000 loops=1)

3. 1.630 2,235.444 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=37,576.02..581,004.15 rows=1,644 width=165) (actual time=3.834..2,235.444 rows=1,000 loops=1)

4. 4.535 18.814 ↑ 1.6 1,000 1

Nested Loop (cost=37,260.99..63,041.57 rows=1,644 width=133) (actual time=0.698..18.814 rows=1,000 loops=1)

  • Join Filter: (devicevalues.zone_id = zn.id)
  • Rows Removed by Join Filter: 24,981
5. 3.148 11.279 ↑ 2.4 1,000 1

Merge Join (cost=9.65..10,851.46 rows=2,383 width=99) (actual time=0.276..11.279 rows=1,000 loops=1)

  • Merge Cond: (devicevalues.device_id = device.id)
  • Join Filter: (device.zone_id = devicevalues.zone_id)
6. 0.558 2.647 ↑ 9.4 1,000 1

Merge Append (cost=4.85..1,230.23 rows=9,397 width=12) (actual time=0.156..2.647 rows=1,000 loops=1)

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

8. 0.002 0.002 ↓ 0.0 0 1

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

9. 1.145 1.145 ↑ 1.0 584 1

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

10. 0.012 0.012 ↑ 72.0 5 1

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

11. 0.002 0.002 ↓ 0.0 0 1

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

12. 0.013 0.013 ↑ 72.0 5 1

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

13. 0.007 0.007 ↑ 180.0 2 1

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

14. 0.728 0.728 ↑ 1.4 360 1

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

15. 0.001 0.001 ↓ 0.0 0 1

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

16. 0.015 0.015 ↑ 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.004..0.015 rows=10 loops=1)

17. 0.012 0.012 ↑ 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.005..0.012 rows=3 loops=1)

18. 0.008 0.008 ↑ 180.0 2 1

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

19. 0.025 0.025 ↑ 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.021..0.025 rows=2 loops=1)

20. 0.025 0.025 ↑ 30.0 12 1

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

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

22. 0.008 0.008 ↑ 180.0 2 1

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

23. 0.011 0.011 ↑ 72.0 5 1

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

24. 0.008 0.008 ↑ 90.0 4 1

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

25. 0.010 0.010 ↑ 90.0 4 1

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

26. 0.009 0.009 ↑ 360.0 1 1

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

27. 0.007 0.007 ↑ 360.0 1 1

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

28. 0.005 0.005 ↑ 360.0 1 1

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

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

30. 0.004 0.004 ↑ 360.0 1 1

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

31. 0.003 0.003 ↑ 360.0 1 1

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

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

33. 0.003 0.003 ↑ 360.0 1 1

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

34. 1.224 5.484 ↑ 10.1 1,000 1

Materialize (cost=4.80..1,282.32 rows=10,144 width=91) (actual time=0.112..5.484 rows=1,000 loops=1)

35. 1.209 4.260 ↑ 10.1 1,000 1

Merge Append (cost=4.80..1,256.96 rows=10,144 width=91) (actual time=0.107..4.260 rows=1,000 loops=1)

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

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

37. 0.002 0.002 ↓ 0.0 0 1

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

38. 1.780 1.780 ↑ 1.0 584 1

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

39. 0.018 0.018 ↑ 90.0 5 1

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

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

41. 0.011 0.011 ↑ 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.003..0.011 rows=5 loops=1)

42. 0.009 0.009 ↑ 225.0 2 1

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

43. 1.032 1.032 ↑ 1.4 360 1

Index Scan using pk_device on device device_7 (cost=0.27..50.71 rows=491 width=59) (actual time=0.008..1.032 rows=360 loops=1)

44. 0.002 0.002 ↓ 0.0 0 1

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

45. 0.031 0.031 ↑ 45.0 10 1

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

46. 0.017 0.017 ↑ 15.3 3 1

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

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

48. 0.007 0.007 ↑ 225.0 2 1

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

49. 0.038 0.038 ↑ 1.0 12 1

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

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

51. 0.007 0.007 ↑ 225.0 2 1

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

52. 0.021 0.021 ↑ 1.0 5 1

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

53. 0.012 0.012 ↑ 112.5 4 1

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

54. 0.014 0.014 ↑ 112.5 4 1

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

55. 0.004 0.004 ↑ 450.0 1 1

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

56. 0.003 0.003 ↑ 450.0 1 1

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

57. 0.004 0.004 ↑ 450.0 1 1

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

58. 0.003 0.003 ↑ 450.0 1 1

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

59. 0.003 0.003 ↑ 450.0 1 1

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

60. 0.004 0.004 ↑ 450.0 1 1

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

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

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

63. 2.526 3.000 ↑ 5.3 26 1,000

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

64. 0.029 0.474 ↑ 5.3 26 1

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

  • Filter: (zn.username = 'admin'::text)
  • Rows Removed by Filter: 78
65. 0.028 0.445 ↑ 265.4 104 1

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

66. 0.016 0.417 ↑ 2,123.2 130 1

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

  • Sort Key: u.id, z.id
67. 0.024 0.271 ↑ 32.1 52 1

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

  • Group Key: u.id, z.id
68. 0.057 0.247 ↑ 16.0 104 1

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

  • Sort Key: u.id, z.id
  • Sort Method: quicksort Memory: 33kB
69. 0.037 0.190 ↑ 16.0 104 1

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

  • Hash Cond: (ur.user_id = u.id)
70. 0.026 0.137 ↑ 16.0 104 1

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

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

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

72. 0.021 0.105 ↑ 8.5 104 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
73. 0.027 0.084 ↑ 8.5 104 1

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

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

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

75. 0.006 0.051 ↑ 22.7 26 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
76. 0.017 0.045 ↑ 22.7 26 1

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

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

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

78. 0.002 0.008 ↑ 800.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
79. 0.006 0.006 ↑ 800.0 1 1

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

80. 0.003 0.016 ↑ 155.0 4 1

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

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

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

82. 0.023 0.130 ↑ 3,517.3 78 1

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

  • Group Key: u_1.id, z_1.id
83. 0.049 0.107 ↑ 3,517.3 78 1

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

  • Sort Key: u_1.id, z_1.id
  • Sort Method: quicksort Memory: 31kB
84. 0.026 0.058 ↑ 3,517.3 78 1

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

85. 0.006 0.006 ↑ 22.7 26 1

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

86. 0.020 0.026 ↑ 155.0 3 26

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

87. 0.006 0.006 ↑ 155.0 3 1

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

  • Filter: (superuser OR hidden)
  • Rows Removed by Filter: 1
88. 6.000 2,215.000 ↑ 1.0 1 1,000

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

89. 1.000 2,209.000 ↑ 10.0 1 1,000

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

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

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

91. 9.000 2,207.000 ↑ 17.0 1 1,000

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

  • Sort Key: att.type, dattr.last_update DESC
  • Sort Method: quicksort Memory: 25kB
92. 2.330 2,198.000 ↑ 17.0 1 1,000

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

93. 20.545 2,175.000 ↑ 9.0 1 1,000

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

  • Hash Cond: (dattr.device_id = device_children.id)
94. 51.967 280.000 ↓ 7.8 140 1,000

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

  • Hash Cond: (dattr.attributetype_id = att.id)
95. 87.000 228.000 ↑ 2.6 140 1,000

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

96. 0.000 0.000 ↓ 0.0 0 1,000

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

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

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

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

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

  • Index Cond: (zone_id = device.zone_id)
99. 55.000 55.000 ↑ 1.3 134 1,000

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (zone_id = device.zone_id)
108. 8.000 8.000 ↑ 2.7 6 1,000

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (zone_id = device.zone_id)
147. 0.014 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
148. 0.019 0.019 ↓ 5.2 52 1

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

149. 2.955 1,874.455 ↑ 200.0 1 985

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

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

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

  • Group Key: device_children.id
151. 1,867.560 1,867.560 ↑ 1,000.0 1 985

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

152. 5.300 20.670 ↑ 27.0 1 530

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

153. 0.000 0.000 ↓ 0.0 0 530

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
180. 2,925.000 2,925.000 ↑ 1,000.0 1 1,000

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

181.          

SubPlan (for Nested Loop Left Join)

182. 14.000 180.000 ↑ 1.0 1 1,000

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

183. 1.984 166.000 ↑ 14.5 2 1,000

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

184. 5.656 159.000 ↑ 14.5 2 1,000

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

185. 65.000 150.000 ↑ 14.5 2 1,000

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

186. 0.000 0.000 ↓ 0.0 0 1,000

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

  • Filter: ((zone_id = device.zone_id) AND (device_id = device.id))
187. 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)
188. 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)
189. 6.000 6.000 ↑ 2.0 1 1,000

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

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

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
191. 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)
192. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
193. 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)
194. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
195. 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)
196. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
197. 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)
198. 4.000 4.000 ↑ 2.0 1 1,000

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

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

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
200. 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)
201. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
202. 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)
203. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
204. 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)
205. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
206. 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)
207. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
208. 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)
209. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=9
210. 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)
211. 0.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
212. 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)
213. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
214. 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)
215. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
216. 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)
217. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
218. 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)
219. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
220. 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)
221. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
222. 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)
223. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
224. 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)
225. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
226. 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)
227. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
228. 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)
229. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
230. 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)
231. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
232. 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)
233. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
234. 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)
235. 1.000 3.000 ↓ 0.0 0 1,000

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

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

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

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

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

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

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

240. 1.984 161.000 ↑ 14.5 2 1,000

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

241. 5.656 154.000 ↑ 14.5 2 1,000

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

242. 67.000 145.000 ↑ 14.5 2 1,000

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

243. 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))
244. 1.000 5.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
245. 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)
246. 5.000 5.000 ↑ 2.0 1 1,000

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

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

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
248. 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)
249. 0.000 2.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.002..0.002 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
250. 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)
251. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
252. 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)
253. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
254. 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)
255. 4.000 4.000 ↑ 2.0 1 1,000

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

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

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
257. 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)
258. 0.000 2.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.002..0.002 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
259. 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)
260. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
261. 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)
262. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
263. 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)
264. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
265. 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)
266. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=9
267. 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)
268. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
269. 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)
270. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
271. 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)
272. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
273. 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)
274. 0.000 2.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.002..0.002 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
275. 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)
276. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
277. 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)
278. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
279. 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)
280. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
281. 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)
282. 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)
283. 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)
284. 0.000 2.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.002..0.002 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
285. 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)
286. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
287. 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)
288. 0.000 2.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.002..0.002 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
289. 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)
290. 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)
291. 2.000 2.000 ↓ 0.0 0 1,000

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

  • Index Cond: (device_id = device.id)
292. 0.000 2.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.002..0.002 rows=0 loops=1,000)

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

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

  • Index Cond: (device_id = device.id)
294. 3.344 3.344 ↑ 1.0 1 1,672

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

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

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

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

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

297. 1.984 163.000 ↑ 14.5 2 1,000

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

298. 5.656 156.000 ↑ 14.5 2 1,000

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

299. 64.000 147.000 ↑ 14.5 2 1,000

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

300. 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))
301. 1.000 5.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
302. 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)
303. 5.000 5.000 ↑ 2.0 1 1,000

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

  • Index Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
304. 1.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)
305. 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)
306. 1.000 3.000 ↓ 0.0 0 1,000

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
314. 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)
315. 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)
316. 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)
317. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
318. 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)
319. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
320. 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)
321. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
322. 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)
323. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=9
324. 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)
325. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
326. 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)
327. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
328. 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)
329. 0.000 2.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.002..0.002 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
330. 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)
331. 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)
332. 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)
333. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
334. 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)
335. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
336. 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)
337. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
338. 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)
339. 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)
340. 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)
341. 0.000 2.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.002..0.002 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
342. 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)
343. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
344. 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)
345. 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)
346. 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)
347. 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)
348. 2.000 2.000 ↓ 0.0 0 1,000

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

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

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

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

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

  • Index Cond: (device_id = device.id)
351. 3.344 3.344 ↑ 1.0 1 1,672

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

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

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

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

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

354. 1.984 158.000 ↑ 14.5 2 1,000

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

355. 4.656 151.000 ↑ 14.5 2 1,000

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

356. 64.000 143.000 ↑ 14.5 2 1,000

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

357. 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))
358. 1.000 5.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
359. 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)
360. 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.004..0.005 rows=1 loops=1,000)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
371. 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)
372. 1.000 2.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.002..0.002 rows=0 loops=1,000)

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

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

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

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
375. 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)
376. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
377. 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)
378. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
379. 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)
380. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=9
381. 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)
382. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
383. 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)
384. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
385. 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)
386. 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)
387. 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)
388. 1.000 2.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.002..0.002 rows=0 loops=1,000)

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

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

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

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
391. 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)
392. 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)
393. 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)
394. 0.000 2.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.002..0.002 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
395. 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)
396. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
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. 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)
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. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
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. 0.000 2.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.002..0.002 rows=0 loops=1,000)

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
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. 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)
405. 2.000 2.000 ↓ 0.0 0 1,000

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

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

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

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

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

  • Index Cond: (device_id = device.id)
408. 3.344 3.344 ↑ 1.0 1 1,672

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

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

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

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

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

411. 0.436 2,107.000 ↓ 0.0 0 1,000

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

412. 2.436 2,106.000 ↓ 0.0 0 1,000

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

413. 16.000 2,103.000 ↓ 0.0 0 1,000

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

  • Hash Cond: (deviceresponse.device_id = device_children_1.id)
414. 76.000 171.000 ↑ 2.7 38 1,000

Append (cost=0.00..193.57 rows=104 width=64) (actual time=0.040..0.171 rows=38 loops=1,000)

415. 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)
416. 1.000 5.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (zone_id = device.zone_id)
417. 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)
418. 7.000 12.000 ↓ 9.0 36 1,000

Bitmap Heap Scan on device_response deviceresponse_2 (cost=2.18..7.70 rows=4 width=64) (actual time=0.009..0.012 rows=36 loops=1,000)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (zone_id = device.zone_id)
428. 4.000 6.000 ↑ 2.0 2 1,000

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=360
429. 2.000 2.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.002..0.002 rows=2 loops=1,000)

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

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

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

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

  • Index Cond: (zone_id = device.zone_id)
432. 1.000 3.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.003..0.003 rows=0 loops=1,000)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (zone_id = device.zone_id)
446. 5.000 5.000 ↓ 0.0 0 1,000

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (zone_id = device.zone_id)
453. 1.000 3.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.003..0.003 rows=0 loops=1,000)

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

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

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

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

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

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

  • Index Cond: (zone_id = device.zone_id)
457. 1.000 3.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.003..0.003 rows=0 loops=1,000)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (zone_id = device.zone_id)
467. 3.000 1,916.000 ↑ 200.0 1 1,000

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
468. 4.000 1,913.000 ↑ 200.0 1 1,000

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

  • Group Key: device_children_1.id
469. 1,909.000 1,909.000 ↑ 1,000.0 1 1,000

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

470. 0.564 0.564 ↑ 1.0 1 188

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

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

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

  • Index Cond: (id = deviceresponse.protocol_id)
472. 2.000 1,952.000 ↑ 1.0 1 1,000

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

473. 1.920 1,950.000 ↓ 0.0 0 1,000

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

474. 11.024 1,946.000 ↓ 0.0 0 1,000

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

  • Hash Cond: (dsa.device_id = device_children_2.id)
475. 68.000 90.000 ↑ 29.9 7 1,000

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

476. 0.000 0.000 ↓ 0.0 0 1,000

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

  • Filter: (zone_id = device.zone_id)
477. 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)
478. 7.000 7.000 ↑ 1.3 6 1,000

Seq Scan on device_snmpalias dsa_2 (cost=0.00..31.25 rows=8 width=8) (actual time=0.006..0.007 rows=6 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 4
479. 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)
480. 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)
481. 4.000 4.000 ↓ 0.0 0 1,000

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 2
482. 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)
483. 5.000 5.000 ↑ 8.0 1 1,000

Seq Scan on device_snmpalias dsa_7 (cost=0.00..31.25 rows=8 width=8) (actual time=0.004..0.005 rows=1 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 2
484. 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)
485. 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)
486. 3.000 3.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.003..0.003 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 2
487. 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)
488. 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)
489. 3.000 3.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.003..0.003 rows=0 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 6
490. 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)
491. 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)
492. 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)
493. 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)
494. 0.000 0.000 ↓ 0.0 0 1,000

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

  • Filter: (zone_id = device.zone_id)
495. 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)
496. 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)
497. 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)
498. 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)
499. 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)
500. 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)
501. 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)
502. 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)
503. 2.907 1,844.976 ↑ 200.0 1 969

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
504. 3.876 1,842.069 ↑ 200.0 1 969

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

  • Group Key: device_children_2.id
505. 1,838.193 1,838.193 ↑ 1,000.0 1 969

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

506. 0.768 2.080 ↑ 27.0 1 32

Append (cost=0.00..7.14 rows=27 width=36) (actual time=0.022..0.065 rows=1 loops=32)

507. 0.032 0.032 ↓ 0.0 0 32

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

  • Filter: (dsa.snmpalias_id = id)
508. 0.128 0.128 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
509. 0.128 0.128 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
510. 0.064 0.064 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
511. 0.032 0.032 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
512. 0.064 0.064 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
513. 0.032 0.032 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
514. 0.064 0.064 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
515. 0.032 0.032 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
516. 0.032 0.032 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
517. 0.064 0.064 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
518. 0.064 0.064 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
519. 0.032 0.032 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
520. 0.064 0.064 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
521. 0.032 0.032 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
522. 0.032 0.032 ↓ 0.0 0 32

Index Scan using pk_snmpalias on snmpalias sa_15 (cost=0.15..0.27 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=32)

  • Index Cond: (id = dsa.snmpalias_id)
523. 0.032 0.032 ↓ 0.0 0 32

Index Scan using pk_snmpalias on snmpalias sa_16 (cost=0.15..0.27 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=32)

  • Index Cond: (id = dsa.snmpalias_id)
524. 0.032 0.032 ↓ 0.0 0 32

Index Scan using pk_snmpalias on snmpalias sa_17 (cost=0.15..0.27 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=32)

  • Index Cond: (id = dsa.snmpalias_id)
525. 0.032 0.032 ↓ 0.0 0 32

Index Scan using pk_snmpalias on snmpalias sa_18 (cost=0.15..0.27 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=32)

  • Index Cond: (id = dsa.snmpalias_id)
526. 0.032 0.032 ↓ 0.0 0 32

Index Scan using pk_snmpalias on snmpalias sa_19 (cost=0.15..0.27 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=32)

  • Index Cond: (id = dsa.snmpalias_id)
527. 0.032 0.032 ↓ 0.0 0 32

Index Scan using pk_snmpalias on snmpalias sa_20 (cost=0.15..0.27 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=32)

  • Index Cond: (id = dsa.snmpalias_id)
528. 0.032 0.032 ↓ 0.0 0 32

Index Scan using pk_snmpalias on snmpalias sa_21 (cost=0.15..0.27 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=32)

  • Index Cond: (id = dsa.snmpalias_id)
529. 0.064 0.064 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
530. 0.032 0.032 ↓ 0.0 0 32

Index Scan using pk_snmpalias on snmpalias sa_23 (cost=0.15..0.27 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=32)

  • Index Cond: (id = dsa.snmpalias_id)
531. 0.064 0.064 ↓ 0.0 0 32

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

  • Index Cond: (id = dsa.snmpalias_id)
532. 0.032 0.032 ↓ 0.0 0 32

Index Scan using pk_snmpalias on snmpalias sa_25 (cost=0.15..0.27 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=32)

  • Index Cond: (id = dsa.snmpalias_id)
533. 0.032 0.032 ↓ 0.0 0 32

Index Scan using pk_snmpalias on snmpalias sa_26 (cost=0.15..0.27 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=32)

  • Index Cond: (id = dsa.snmpalias_id)
534. 4.000 2,090.000 ↑ 1.0 1 1,000

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

535. 0.624 2,086.000 ↓ 0.0 0 1,000

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

536. 2.436 2,085.000 ↓ 0.0 0 1,000

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

537. 15.000 2,082.000 ↓ 0.0 0 1,000

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

  • Hash Cond: (deviceresponse_27.device_id = device_children_3.id)
538. 71.000 163.000 ↑ 2.7 38 1,000

Append (cost=0.00..193.57 rows=104 width=64) (actual time=0.038..0.163 rows=38 loops=1,000)

539. 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)
540. 2.000 5.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.005..0.005 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
541. 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)
542. 7.000 12.000 ↓ 9.0 36 1,000

Bitmap Heap Scan on device_response deviceresponse_29 (cost=2.18..7.70 rows=4 width=64) (actual time=0.009..0.012 rows=36 loops=1,000)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (zone_id = device.zone_id)
552. 3.000 5.000 ↑ 2.0 2 1,000

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=360
553. 2.000 2.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.002..0.002 rows=2 loops=1,000)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (zone_id = device.zone_id)
591. 3.000 1,904.000 ↑ 200.0 1 1,000

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
592. 4.000 1,901.000 ↑ 200.0 1 1,000

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

  • Group Key: device_children_3.id
593. 1,897.000 1,897.000 ↑ 1,000.0 1 1,000

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

594. 0.564 0.564 ↑ 1.0 1 188

Index Scan using pk_scantype on scantype scantype_1 (cost=0.15..0.40 rows=1 width=36) (actual time=0.002..0.003 rows=1 loops=188)

  • Index Cond: (id = deviceresponse_27.scantype_id)
595. 0.376 0.376 ↑ 1.0 1 188

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

  • Index Cond: (id = deviceresponse_27.protocol_id)
596. 13.000 169.000 ↑ 1.0 1 1,000

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

597. 2.984 156.000 ↑ 14.5 2 1,000

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

598. 4.656 148.000 ↑ 14.5 2 1,000

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

599. 62.000 140.000 ↑ 14.5 2 1,000

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

600. 0.000 0.000 ↓ 0.0 0 1,000

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

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

Bitmap Heap Scan on device_match dm_109 (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)
602. 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)
603. 5.000 5.000 ↑ 2.0 1 1,000

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

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

Bitmap Heap Scan on device_match dm_111 (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)
605. 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)
606. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_112 (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)
607. 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)
608. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=4
609. 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)
610. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
611. 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)
612. 4.000 4.000 ↑ 2.0 1 1,000

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

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

Bitmap Heap Scan on device_match dm_116 (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)
614. 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)
615. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_117 (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)
616. 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)
617. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
618. 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)
619. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
620. 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)
621. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
622. 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)
623. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=9
624. 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)
625. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
626. 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)
627. 1.000 3.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
  • Heap Blocks: exact=1
628. 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)
629. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_124 (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)
630. 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)
631. 0.000 2.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
632. 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)
633. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_126 (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)
634. 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)
635. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_127 (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)
636. 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)
637. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_128 (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)
638. 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)
639. 0.000 2.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
640. 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)
641. 0.000 2.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
642. 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)
643. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_131 (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)
644. 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)
645. 0.000 2.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
646. 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)
647. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_133 (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)
648. 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)
649. 1.000 3.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_match dm_134 (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)
650. 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)
651. 3.344 3.344 ↑ 1.0 1 1,672

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

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

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

  • Index Cond: (id = dm_108.attribute_id)
653. 5.000 2,125.000 ↑ 1.0 1 1,000

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

654. 0.624 2,120.000 ↓ 0.0 0 1,000

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

655. 1.436 2,119.000 ↓ 0.0 0 1,000

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

656. 15.000 2,117.000 ↓ 0.0 0 1,000

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

  • Hash Cond: (deviceresponse_54.device_id = device_children_4.id)
657. 71.000 162.000 ↑ 2.7 38 1,000

Append (cost=0.00..193.57 rows=104 width=64) (actual time=0.038..0.162 rows=38 loops=1,000)

658. 0.000 0.000 ↓ 0.0 0 1,000

Seq Scan on device_response deviceresponse_54 (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)
659. 2.000 5.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on device_response deviceresponse_55 (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)
660. 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)
661. 7.000 12.000 ↓ 9.0 36 1,000

Bitmap Heap Scan on device_response deviceresponse_56 (cost=2.18..7.70 rows=4 width=64) (actual time=0.009..0.012 rows=36 loops=1,000)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (zone_id = device.zone_id)
671. 3.000 5.000 ↑ 2.0 2 1,000

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=360
672. 2.000 2.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.002..0.002 rows=2 loops=1,000)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (zone_id = device.zone_id)
687. 1.000 3.000 ↓ 0.0