explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yvff

Settings
# exclusive inclusive rows x rows loops node
1. 0.713 11,040.571 ↑ 1.0 1,000 1

Limit (cost=39,799.93..46,600.71 rows=1,000 width=503) (actual time=26.196..11,040.571 rows=1,000 loops=1)

2. 404.435 11,039.858 ↑ 1,644.0 1,000 1

Nested Loop Left Join (cost=39,799.93..11,220,270.98 rows=1,644,000 width=503) (actual time=26.194..11,039.858 rows=1,000 loops=1)

3. 6.339 7,396.423 ↑ 1.6 1,000 1

Nested Loop (cost=39,799.68..6,160,860.73 rows=1,644 width=261) (actual time=17.405..7,396.423 rows=1,000 loops=1)

  • Join Filter: (devicevalues.zone_id = zn.id)
  • Rows Removed by Join Filter: 24,981
4. 1.868 7,387.084 ↑ 2.4 1,000 1

Nested Loop Left Join (cost=2,548.34..6,108,670.62 rows=2,383 width=227) (actual time=16.647..7,387.084 rows=1,000 loops=1)

5. 2.588 5,149.216 ↑ 2.4 1,000 1

Nested Loop Left Join (cost=920.66..2,229,804.55 rows=2,383 width=195) (actual time=12.897..5,149.216 rows=1,000 loops=1)

6. 2.337 4,940.628 ↑ 2.4 1,000 1

Nested Loop Left Join (cost=574.97..1,405,961.08 rows=2,383 width=163) (actual time=12.281..4,940.628 rows=1,000 loops=1)

7. 2.032 2,593.291 ↑ 2.4 1,000 1

Nested Loop Left Join (cost=319.87..797,975.69 rows=2,383 width=131) (actual time=8.591..2,593.291 rows=1,000 loops=1)

8. 4.108 74.259 ↑ 2.4 1,000 1

Nested Loop (cost=4.85..47,182.00 rows=2,383 width=99) (actual time=0.208..74.259 rows=1,000 loops=1)

9. 1.159 4.151 ↑ 9.4 1,000 1

Merge Append (cost=4.85..1,223.99 rows=9,397 width=12) (actual time=0.141..4.151 rows=1,000 loops=1)

  • Sort Key: devicevalues.zone_id, devicevalues.device_id
10. 0.008 0.008 ↓ 0.0 0 1

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

11. 0.002 0.002 ↓ 0.0 0 1

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

12. 1.597 1.597 ↑ 1.0 584 1

Index Scan using uk_devval on device_values devicevalues_2 (cost=0.28..35.97 rows=584 width=12) (actual time=0.016..1.597 rows=584 loops=1)

13. 0.016 0.016 ↑ 72.0 5 1

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

14. 0.002 0.002 ↓ 0.0 0 1

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

15. 0.016 0.016 ↑ 72.0 5 1

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

16. 0.008 0.008 ↑ 180.0 2 1

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

17. 1.262 1.262 ↑ 1.2 404 1

Index Scan using uk_devval on device_values devicevalues_7 (cost=0.27..32.50 rows=486 width=12) (actual time=0.011..1.262 rows=404 loops=1)

18. 0.001 0.001 ↓ 0.0 0 1

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

19. 0.003 0.003 ↑ 360.0 1 1

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

20. 0.004 0.004 ↑ 46.0 1 1

Index Scan using uk_devval on device_values devicevalues_10 (cost=0.14..6.83 rows=46 width=12) (actual time=0.004..0.004 rows=1 loops=1)

21. 0.004 0.004 ↑ 360.0 1 1

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

22. 0.006 0.006 ↑ 360.0 1 1

Index Scan using uk_devval on device_values devicevalues_12 (cost=0.15..29.55 rows=360 width=12) (actual time=0.006..0.006 rows=1 loops=1)

23. 0.004 0.004 ↑ 360.0 1 1

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

24. 0.004 0.004 ↑ 360.0 1 1

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

25. 0.005 0.005 ↑ 360.0 1 1

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

26. 0.004 0.004 ↑ 360.0 1 1

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

27. 0.005 0.005 ↑ 360.0 1 1

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

28. 0.005 0.005 ↑ 360.0 1 1

Index Scan using uk_devval on device_values devicevalues_18 (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 uk_devval on device_values devicevalues_19 (cost=0.15..29.55 rows=360 width=12) (actual time=0.004..0.004 rows=1 loops=1)

30. 0.005 0.005 ↑ 360.0 1 1

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

31. 0.004 0.004 ↑ 360.0 1 1

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

32. 0.004 0.004 ↑ 360.0 1 1

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

33. 0.005 0.005 ↑ 360.0 1 1

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

34. 0.005 0.005 ↑ 360.0 1 1

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

35. 0.004 0.004 ↑ 360.0 1 1

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

36. 0.005 0.005 ↑ 360.0 1 1

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

37. 22.023 66.000 ↑ 27.0 1 1,000

Append (cost=0.00..4.62 rows=27 width=91) (actual time=0.020..0.066 rows=1 loops=1,000)

38. 1.000 1.000 ↓ 0.0 0 1,000

Seq Scan on device (cost=0.00..0.00 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=1,000)

  • Filter: ((devicevalues.device_id = id) AND (devicevalues.zone_id = zone_id))
39. 3.000 3.000 ↓ 0.0 0 1,000

Index Scan using pk_device on device device_1 (cost=0.15..0.17 rows=1 width=95) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
40. 6.000 6.000 ↑ 1.0 1 1,000

Index Scan using pk_device on device device_2 (cost=0.28..0.30 rows=1 width=59) (actual time=0.004..0.006 rows=1 loops=1,000)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
41. 3.000 3.000 ↓ 0.0 0 1,000

Index Scan using pk_device on device device_3 (cost=0.15..0.17 rows=1 width=95) (actual time=0.003..0.003 rows=0 loops=1,000)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
42. 1.000 1.000 ↓ 0.0 0 1,000

Index Scan using pk_device on device device_4 (cost=0.15..0.17 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=1,000)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
43. 2.000 2.000 ↓ 0.0 0 1,000

Index Scan using pk_device on device device_5 (cost=0.13..0.15 rows=1 width=63) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
44. 1.000 1.000 ↓ 0.0 0 1,000

Index Scan using pk_device on device device_6 (cost=0.15..0.17 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=1,000)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
45. 4.000 4.000 ↓ 0.0 0 1,000

Index Scan using pk_device on device device_7 (cost=0.27..0.30 rows=1 width=59) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
46. 1.998 1.998 ↓ 0.0 0 999

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

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
47. 1.998 1.998 ↓ 0.0 0 999

Index Scan using pk_device on device device_9 (cost=0.15..0.17 rows=1 width=95) (actual time=0.002..0.002 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
48. 1.998 1.998 ↓ 0.0 0 999

Index Scan using pk_device on device device_10 (cost=0.14..0.16 rows=1 width=65) (actual time=0.002..0.002 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
49. 0.999 0.999 ↓ 0.0 0 999

Index Scan using pk_device on device device_11 (cost=0.15..0.17 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
50. 0.999 0.999 ↓ 0.0 0 999

Index Scan using pk_device on device device_12 (cost=0.15..0.17 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
51. 0.999 0.999 ↓ 0.0 0 999

Index Scan using pk_device on device device_13 (cost=0.14..0.16 rows=1 width=61) (actual time=0.001..0.001 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
52. 0.999 0.999 ↓ 0.0 0 999

Index Scan using pk_device on device device_14 (cost=0.15..0.17 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
53. 0.999 0.999 ↓ 0.0 0 999

Index Scan using pk_device on device device_15 (cost=0.15..0.17 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
54. 0.999 0.999 ↓ 0.0 0 999

Index Scan using pk_device on device device_16 (cost=0.13..0.15 rows=1 width=61) (actual time=0.001..0.001 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
55. 0.999 0.999 ↓ 0.0 0 999

Index Scan using pk_device on device device_17 (cost=0.15..0.17 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
56. 0.999 0.999 ↓ 0.0 0 999

Index Scan using pk_device on device device_18 (cost=0.15..0.17 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
57. 0.999 0.999 ↓ 0.0 0 999

Index Scan using pk_device on device device_19 (cost=0.15..0.17 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
58. 0.999 0.999 ↓ 0.0 0 999

Index Scan using pk_device on device device_20 (cost=0.15..0.17 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
59. 0.999 0.999 ↓ 0.0 0 999

Index Scan using pk_device on device device_21 (cost=0.15..0.17 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
60. 0.999 0.999 ↓ 0.0 0 999

Index Scan using pk_device on device device_22 (cost=0.15..0.17 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
61. 1.998 1.998 ↓ 0.0 0 999

Index Scan using pk_device on device device_23 (cost=0.15..0.17 rows=1 width=95) (actual time=0.002..0.002 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
62. 0.999 0.999 ↓ 0.0 0 999

Index Scan using pk_device on device device_24 (cost=0.15..0.17 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
63. 0.999 0.999 ↓ 0.0 0 999

Index Scan using pk_device on device device_25 (cost=0.15..0.17 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
64. 0.999 0.999 ↓ 0.0 0 999

Index Scan using pk_device on device device_26 (cost=0.15..0.17 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=999)

  • Index Cond: (id = devicevalues.device_id)
  • Filter: (devicevalues.zone_id = zone_id)
65. 6.000 2,517.000 ↑ 1.0 1 1,000

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

66. 1.000 2,511.000 ↓ 0.0 0 1,000

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

67. 2.000 2,510.000 ↓ 0.0 0 1,000

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

68. 10.000 2,508.000 ↓ 0.0 0 1,000

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

  • Sort Key: att.type, dattr.last_update DESC
  • Sort Method: quicksort Memory: 25kB
69. 3.056 2,498.000 ↓ 0.0 0 1,000

Nested Loop (cost=18.48..314.47 rows=17 width=44) (actual time=2.459..2.498 rows=0 loops=1,000)

70. 21.146 2,472.000 ↓ 0.0 0 1,000

Hash Join (cost=18.48..257.24 rows=9 width=24) (actual time=2.456..2.472 rows=0 loops=1,000)

  • Hash Cond: (dattr.device_id = device_children.id)
71. 57.948 307.000 ↓ 7.8 140 1,000

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

  • Hash Cond: (dattr.attributetype_id = att.id)
72. 98.000 249.000 ↑ 2.6 140 1,000

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

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

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

  • Recheck Cond: (zone_id = device.zone_id)
75. 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)
76. 59.000 59.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.020..0.059 rows=134 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 95
77. 2.000 5.000 ↓ 0.0 0 1,000

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

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

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

  • Recheck Cond: (zone_id = device.zone_id)
84. 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)
85. 10.000 10.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.008..0.010 rows=6 loops=1,000)

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 10
86. 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)
87. 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)
88. 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)
89. 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)
90. 1.000 4.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (zone_id = device.zone_id)
91. 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)
92. 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)
93. 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)
94. 1.000 3.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.003..0.003 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
95. 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)
96. 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)
97. 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)
98. 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)
99. 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)
100. 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)
101. 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)
102. 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)
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_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)
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. 2.000 4.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (zone_id = device.zone_id)
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. 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)
109. 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)
110. 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)
111. 2.000 2.000 ↓ 0.0 0 1,000

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

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

Bitmap Heap Scan on device_attribute dattr_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)
113. 2.000 2.000 ↓ 0.0 0 1,000

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

  • Index Cond: (zone_id = device.zone_id)
114. 1.000 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)
115. 2.000 2.000 ↓ 0.0 0 1,000

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

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

Bitmap Heap Scan on device_attribute dattr_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)
117. 2.000 2.000 ↓ 0.0 0 1,000

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

  • Index Cond: (zone_id = device.zone_id)
118. 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)
119. 2.000 2.000 ↓ 0.0 0 1,000

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

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

Bitmap Heap Scan on device_attribute dattr_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)
121. 2.000 2.000 ↓ 0.0 0 1,000

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

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

Bitmap Heap Scan on device_attribute dattr_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)
123. 2.000 2.000 ↓ 0.0 0 1,000

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

  • Index Cond: (zone_id = device.zone_id)
124. 0.023 0.052 ↓ 5.2 52 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
125. 0.029 0.029 ↓ 5.2 52 1

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

126. 2.997 2,143.854 ↑ 200.0 1 999

Hash (cost=14.75..14.75 rows=200 width=4) (actual time=2.146..2.146 rows=1 loops=999)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
127. 4.995 2,140.857 ↑ 200.0 1 999

HashAggregate (cost=12.75..14.75 rows=200 width=4) (actual time=2.142..2.143 rows=1 loops=999)

  • Group Key: device_children.id
128. 2,135.862 2,135.862 ↑ 1,000.0 1 999

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

129. 7.648 22.944 ↑ 27.0 1 478

Append (cost=0.00..6.09 rows=27 width=28) (actual time=0.013..0.048 rows=1 loops=478)

130. 0.000 0.000 ↓ 0.0 0 478

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

  • Filter: ((zone_id = device.zone_id) AND (dattr.attribute_id = id))
131. 1.434 1.434 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
132. 1.912 1.912 ↑ 1.0 1 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
133. 0.956 0.956 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
134. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
135. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
136. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
137. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
138. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
139. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
140. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
141. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
142. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
143. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
144. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
145. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
146. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
147. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
148. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
149. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
150. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
151. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
152. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
153. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
154. 0.478 0.478 ↓ 0.0 0 478

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
155. 0.478 0.478 ↓ 0.0 0 478

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

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

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

  • Index Cond: (id = dattr.attribute_id)
  • Filter: (zone_id = device.zone_id)
157. 6.000 2,345.000 ↑ 1.0 1 1,000

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

158. 0.726 2,339.000 ↓ 0.0 0 1,000

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

159. 1.452 2,338.000 ↓ 0.0 0 1,000

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

160. 17.000 2,336.000 ↓ 0.0 0 1,000

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

  • Hash Cond: (deviceresponse.device_id = device_children_1.id)
161. 91.000 196.000 ↑ 2.7 38 1,000

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

162. 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)
163. 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)
164. 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)
165. 8.000 13.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.010..0.013 rows=36 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=584
166. 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)
167. 1.000 4.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
168. 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)
169. 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)
170. 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)
171. 2.000 4.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=5
172. 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)
173. 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
174. 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)
175. 3.000 6.000 ↑ 2.0 2 1,000

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

  • Recheck Cond: (zone_id = device.zone_id)
  • Heap Blocks: exact=404
176. 3.000 3.000 ↑ 2.0 2 1,000

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

  • Index Cond: (zone_id = device.zone_id)
177. 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)
178. 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)
179. 2.000 4.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (zone_id = device.zone_id)
180. 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)
181. 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)
182. 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)
183. 2.000 4.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.004..0.004 rows=0 loops=1,000)

  • Recheck Cond: (zone_id = device.zone_id)
184. 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)
185. 2.000 4.000 ↓ 0.0 0 1,000

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

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

  • Recheck Cond: (zone_id = device.zone_id)
188. 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)
189. 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)
190. 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)
191. 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)
192. 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)
193. 6.000 6.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.006..0.006 rows=0 loops=1,000)

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

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

  • Recheck Cond: (zone_id = device.zone_id)
195. 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)
196. 1.000 4.000 ↓ 0.0 0 1,000

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

  • Recheck Cond: (zone_id = device.zone_id)
197. 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)
198. 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)
199. 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)
200. 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)
201. 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)
202. 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)
203. 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)
204. 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)
205. 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)
206. 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)
207. 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)
208. 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)
209. 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)
210. 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)
211. 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)
212. 2.000 4.000 ↓ 0.0 0 1,000

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

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

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
215. 4.000 2,119.000 ↑ 200.0 1 1,000

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

  • Group Key: device_children_1.id
216. 2,115.000 2,115.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=2.114..2.115 rows=1 loops=1,000)

217. 0.548 0.548 ↑ 1.0 1 137

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

  • Index Cond: (id = deviceresponse.scantype_id)
218. 0.274 0.274 ↑ 1.0 1 137

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

  • Index Cond: (id = deviceresponse.protocol_id)
219. 25.000 206.000 ↑ 1.0 1 1,000

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

220. 1.184 181.000 ↑ 14.5 2 1,000

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

221. 6.592 173.000 ↑ 14.5 2 1,000

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

222. 76.000 163.000 ↑ 14.5 2 1,000

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

223. 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))
224. 2.000 4.000 ↓ 0.0 0 1,000

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

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

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

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

Index Scan using idx_device_match_device_id on device_match dm_2 (cost=0.28..4.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)
227. 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)
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. 2.000 4.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.004..0.004 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. 2.000 4.000 ↓ 0.0 0 1,000

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

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

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

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

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

  • Index Cond: (device_id = device.id)
238. 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)
239. 2.000 2.000 ↓ 0.0 0 1,000

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

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

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

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

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

  • Index Cond: (device_id = device.id)
244. 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)
245. 2.000 2.000 ↓ 0.0 0 1,000

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

  • Index Cond: (device_id = device.id)
246. 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)
247. 2.000 2.000 ↓ 0.0 0 1,000

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

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

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

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

  • Index Cond: (device_id = device.id)
250. 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)
251. 2.000 2.000 ↓ 0.0 0 1,000

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

  • Index Cond: (device_id = device.id)
252. 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)
253. 2.000 2.000 ↓ 0.0 0 1,000

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

  • Index Cond: (device_id = device.id)
254. 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)
255. 2.000 2.000 ↓ 0.0 0 1,000

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

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

  • Recheck Cond: (device_id = device.id)
  • Filter: (zone_id = device.zone_id)
267. 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)
268. 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)
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_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)
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_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)
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. 3.408 3.408 ↑ 1.0 1 1,704

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

  • Index Cond: (id = dm.type_id)
275. 6.816 6.816 ↑ 1.0 1 1,704

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

  • Index Cond: (id = dm.attribute_id)
276. 3.000 2,236.000 ↑ 1.0 1 1,000

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

277. 2.680 2,233.000 ↓ 0.0 0 1,000

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

278. 10.630 2,229.000 ↓ 0.0 0 1,000

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

  • Hash Cond: (dsa.device_id = device_children_2.id)
279. 80.000 103.000 ↑ 29.9 7 1,000

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

280. 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)
281. 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)
282. 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
283. 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)
284. 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)
285. 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
286. 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)
287. 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
288. 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)
289. 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)
290. 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
291. 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)
292. 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)
293. 4.000 4.000 ↓ 0.0 0 1,000

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

  • Filter: (zone_id = device.zone_id)
  • Rows Removed by Filter: 6
294. 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)
295. 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)
296. 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)
297. 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)
298. 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)
299. 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)
300. 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)
301. 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)
302. 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)
303. 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)
304. 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)
305. 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)
306. 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)
307. 3.980 2,115.370 ↑ 200.0 1 995

Hash (cost=14.75..14.75 rows=200 width=4) (actual time=2.126..2.126 rows=1 loops=995)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
308. 4.975 2,111.390 ↑ 200.0 1 995

HashAggregate (cost=12.75..14.75 rows=200 width=4) (actual time=2.121..2.122 rows=1 loops=995)

  • Group Key: device_children_2.id
309. 2,106.415 2,106.415 ↑ 1,000.0 1 995

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

310. 0.462 1.320 ↑ 27.0 1 22

Append (cost=0.00..7.14 rows=27 width=36) (actual time=0.015..0.060 rows=1 loops=22)

311. 0.022 0.022 ↓ 0.0 0 22

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

  • Filter: (dsa.snmpalias_id = id)
312. 0.066 0.066 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
313. 0.088 0.088 ↑ 1.0 1 22

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

  • Index Cond: (id = dsa.snmpalias_id)
314. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
315. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
316. 0.044 0.044 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
317. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
318. 0.066 0.066 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
319. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
320. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
321. 0.044 0.044 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
322. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
323. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
324. 0.044 0.044 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
325. 0.044 0.044 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
326. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
327. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
328. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
329. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
330. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
331. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
332. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
333. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
334. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
335. 0.044 0.044 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
336. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
337. 0.022 0.022 ↓ 0.0 0 22

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

  • Index Cond: (id = dsa.snmpalias_id)
338. 2.121 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)

339. 0.069 0.879 ↑ 5.3 26 1

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

  • Filter: (zn.username = 'admin'::text)
  • Rows Removed by Filter: 78
340. 0.053 0.810 ↑ 265.4 104 1

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

341. 0.041 0.757 ↑ 2,123.2 130 1

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

  • Sort Key: u.id, z.id
342. 0.055 0.492 ↑ 32.1 52 1

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

  • Group Key: u.id, z.id
343. 0.109 0.437 ↑ 16.0 104 1

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

  • Sort Key: u.id, z.id
  • Sort Method: quicksort Memory: 33kB
344. 0.053 0.328 ↑ 16.0 104 1

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

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

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

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

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

347. 0.032 0.182 ↑ 8.5 104 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
348. 0.039 0.150 ↑ 8.5 104 1

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

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

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

350. 0.012 0.090 ↑ 22.7 26 1

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

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

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

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

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

353. 0.002 0.024 ↑ 800.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
354. 0.022 0.022 ↑ 800.0 1 1

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

355. 0.013 0.044 ↑ 155.0 4 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
356. 0.031 0.031 ↑ 155.0 4 1

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

357. 0.061 0.224 ↑ 3,517.3 78 1

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

  • Group Key: u_1.id, z_1.id
358. 0.078 0.163 ↑ 3,517.3 78 1

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

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

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

360. 0.013 0.013 ↑ 22.7 26 1

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

361. 0.016 0.026 ↑ 155.0 3 26

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

362. 0.010 0.010 ↑ 155.0 3 1

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

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

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

Planning time : 97.423 ms
Execution time : 11,044.408 ms