explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SHXd : test1

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.061 ↓ 0.0 0 1

Hash Left Join (cost=440.67..479.58 rows=624 width=1,725) (actual time=0.061..0.061 rows=0 loops=1)

  • Hash Cond: (volume.id = mapped_host_info.lun_id)
2.          

CTE smvt

3. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=11.57..12.48 rows=90 width=798) (never executed)

  • Group Key: space_metrics_by_volume.appliance_id, space_metrics_by_volume.datapath_vol_id
4. 0.000 0.000 ↓ 0.0 0

Seq Scan on space_metrics_by_volume (cost=0.00..10.90 rows=90 width=798) (never executed)

5.          

CTE smv

6. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=12.48..14.98 rows=1 width=818) (never executed)

  • Hash Cond: (((smvt.appliance_id)::text = (ismv.appliance_id)::text) AND ((smvt.datapath_vol_id)::text = (ismv.datapath_vol_id)::text) AND (smvt."timestamp" = ismv."timestamp"))
7. 0.000 0.000 ↓ 0.0 0

CTE Scan on smvt (cost=0.00..1.80 rows=90 width=798) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.90..10.90 rows=90 width=818) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Seq Scan on space_metrics_by_volume ismv (cost=0.00..10.90 rows=90 width=818) (never executed)

10.          

CTE smvft

11. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=58.94..58.96 rows=1 width=556) (never executed)

  • Group Key: smvf_1.appliance_id, "*SELECT* 1_1".family_id
12. 0.000 0.000 ↓ 0.0 0

Sort (cost=58.94..58.95 rows=1 width=556) (never executed)

  • Sort Key: smvf_1.appliance_id, "*SELECT* 1_1".family_id
13. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=23.24..58.93 rows=1 width=556) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Append (cost=23.10..46.51 rows=2 width=560) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_1 (cost=23.10..23.13 rows=1 width=560) (never executed)

16. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=23.10..23.12 rows=1 width=720) (never executed)

  • Group Key: vv.datapath_family_id, vv.family_id, smv_3.appliance_id, smv_3."timestamp
17. 0.000 0.000 ↓ 0.0 0

Sort (cost=23.10..23.10 rows=1 width=560) (never executed)

  • Sort Key: vv.datapath_family_id, vv.family_id, smv_3.appliance_id, smv_3."timestamp
18. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=11.50..23.09 rows=1 width=560) (never executed)

  • Hash Cond: (((smv_3.appliance_id)::text = vv.appliance_id) AND ((smv_3.datapath_vol_id)::text = vv.datapath_id))
19. 0.000 0.000 ↓ 0.0 0

Seq Scan on space_metrics_by_volume smv_3 (cost=0.00..10.90 rows=90 width=798) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.60..10.60 rows=60 width=100) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Seq Scan on virtual_volume vv (cost=0.00..10.60 rows=60 width=100) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_2 (cost=23.35..23.38 rows=1 width=560) (never executed)

23. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=23.35..23.37 rows=1 width=720) (never executed)

  • Group Key: v_1.datapath_family_id, v_1.family_id, smv_4.appliance_id, smv_4."timestamp
24. 0.000 0.000 ↓ 0.0 0

Sort (cost=23.35..23.35 rows=1 width=560) (never executed)

  • Sort Key: v_1.datapath_family_id, v_1.family_id, smv_4.appliance_id, smv_4."timestamp
25. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=11.75..23.34 rows=1 width=560) (never executed)

  • Hash Cond: (((smv_4.appliance_id)::text = v_1.appliance_id) AND ((smv_4.datapath_vol_id)::text = v_1.datapath_vol_id))
26. 0.000 0.000 ↓ 0.0 0

Seq Scan on space_metrics_by_volume smv_4 (cost=0.00..10.90 rows=90 width=798) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.70..10.70 rows=70 width=100) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Seq Scan on volume v_1 (cost=0.00..10.70 rows=70 width=100) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Index Only Scan using space_metrics_by_volume_family_pkey on space_metrics_by_volume_family smvf_1 (cost=0.14..6.17 rows=1 width=528) (never executed)

  • Index Cond: (("timestamp" = "*SELECT* 1_1"."timestamp") AND (appliance_id = ("*SELECT* 1_1".appliance_id)::text) AND (datapath_snap_group_id = "*SELECT* 1_1".datapath_family_id))
  • Heap Fetches: 0
30.          

CTE smvf

31. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=23.24..52.90 rows=1 width=700) (never executed)

32. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=23.10..46.63 rows=1 width=1,244) (never executed)

  • Join Filter: ((("*SELECT* 1_2".appliance_id)::text = (smvft.appliance_id)::text) AND ("*SELECT* 1_2"."timestamp" = smvft."timestamp") AND ("*SELECT* 1_2".family_id = smvft.family_id))
33. 0.000 0.000 ↓ 0.0 0

CTE Scan on smvft (cost=0.00..0.02 rows=1 width=556) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Append (cost=23.10..46.58 rows=2 width=720) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_2 (cost=23.10..23.17 rows=1 width=720) (never executed)

36. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=23.10..23.16 rows=1 width=720) (never executed)

  • Group Key: vv_1.datapath_family_id, vv_1.family_id, smv_5.appliance_id, smv_5."timestamp
37. 0.000 0.000 ↓ 0.0 0

Sort (cost=23.10..23.10 rows=1 width=608) (never executed)

  • Sort Key: vv_1.datapath_family_id, vv_1.family_id, smv_5.appliance_id, smv_5."timestamp
38. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=11.50..23.09 rows=1 width=608) (never executed)

  • Hash Cond: (((smv_5.appliance_id)::text = vv_1.appliance_id) AND ((smv_5.datapath_vol_id)::text = vv_1.datapath_id))
39. 0.000 0.000 ↓ 0.0 0

Seq Scan on space_metrics_by_volume smv_5 (cost=0.00..10.90 rows=90 width=814) (never executed)

40. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.60..10.60 rows=60 width=132) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Seq Scan on virtual_volume vv_1 (cost=0.00..10.60 rows=60 width=132) (never executed)

42. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_3 (cost=23.35..23.41 rows=1 width=720) (never executed)

43. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=23.35..23.40 rows=1 width=720) (never executed)

  • Group Key: v_2.datapath_family_id, v_2.family_id, smv_6.appliance_id, smv_6."timestamp
44. 0.000 0.000 ↓ 0.0 0

Sort (cost=23.35..23.35 rows=1 width=608) (never executed)

  • Sort Key: v_2.datapath_family_id, v_2.family_id, smv_6.appliance_id, smv_6."timestamp
45. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=11.75..23.34 rows=1 width=608) (never executed)

  • Hash Cond: (((smv_6.appliance_id)::text = v_2.appliance_id) AND ((smv_6.datapath_vol_id)::text = v_2.datapath_vol_id))
46. 0.000 0.000 ↓ 0.0 0

Seq Scan on space_metrics_by_volume smv_6 (cost=0.00..10.90 rows=90 width=814) (never executed)

47. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.70..10.70 rows=70 width=132) (never executed)

48. 0.000 0.000 ↓ 0.0 0

Seq Scan on volume v_2 (cost=0.00..10.70 rows=70 width=132) (never executed)

49. 0.000 0.000 ↓ 0.0 0

Index Scan using space_metrics_by_volume_family_pkey on space_metrics_by_volume_family smvf_2 (cost=0.14..6.17 rows=1 width=544) (never executed)

  • Index Cond: (("timestamp" = "*SELECT* 1_2"."timestamp") AND ((appliance_id)::text = ("*SELECT* 1_2".appliance_id)::text) AND (datapath_snap_group_id = "*SELECT* 1_2".datapath_family_id))
50.          

CTE pmvt

51. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=11.95..13.25 rows=130 width=282) (never executed)

  • Group Key: performance_metrics_by_volume.name
52. 0.000 0.000 ↓ 0.0 0

Seq Scan on performance_metrics_by_volume (cost=0.00..11.30 rows=130 width=282) (never executed)

53.          

CTE perfmetrics

54. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=13.25..16.53 rows=1 width=600) (never executed)

  • Hash Cond: (((pmvt.name)::text = (ipmv.name)::text) AND (pmvt."timestamp" = ipmv."timestamp"))
55. 0.000 0.000 ↓ 0.0 0

CTE Scan on pmvt (cost=0.00..2.60 rows=130 width=282) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Hash (cost=11.30..11.30 rows=130 width=600) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Seq Scan on performance_metrics_by_volume ipmv (cost=0.00..11.30 rows=130 width=600) (never executed)

58. 0.001 0.061 ↓ 0.0 0 1

Hash Left Join (cost=249.06..283.19 rows=624 width=1,725) (actual time=0.061..0.061 rows=0 loops=1)

  • Hash Cond: (volume.id = snap_count_info.source_id)
59. 0.000 0.060 ↓ 0.0 0 1

Hash Left Join (cost=238.13..270.52 rows=624 width=1,717) (actual time=0.060..0.060 rows=0 loops=1)

  • Hash Cond: (volume.performance_policy_id = performance_rule.id)
60. 0.000 0.060 ↓ 0.0 0 1

Hash Left Join (cost=213.51..244.25 rows=624 width=1,621) (actual time=0.060..0.060 rows=0 loops=1)

  • Hash Cond: (volume.created_by_rule_id = replication_rule.id)
61. 0.001 0.060 ↓ 0.0 0 1

Hash Left Join (cost=194.73..223.81 rows=624 width=1,589) (actual time=0.060..0.060 rows=0 loops=1)

  • Hash Cond: (app_group.protection_policy_id = app_group_policy.id)
62. 0.000 0.059 ↓ 0.0 0 1

Hash Left Join (cost=175.51..202.93 rows=624 width=1,556) (actual time=0.059..0.059 rows=0 loops=1)

  • Hash Cond: (volume.performance_policy_id = performance_policy.id)
63. 0.000 0.059 ↓ 0.0 0 1

Hash Left Join (cost=156.28..182.04 rows=624 width=1,524) (actual time=0.059..0.059 rows=0 loops=1)

  • Hash Cond: (volume.protection_policy_id = protection_policy.id)
64. 0.000 0.059 ↓ 0.0 0 1

Hash Left Join (cost=137.06..161.16 rows=624 width=1,491) (actual time=0.059..0.059 rows=0 loops=1)

  • Hash Cond: ((volume.id = (smv_last_72hours.volume_id)::text) AND (volume.appliance_id = (smv_last_72hours.appliance_id)::text))
65. 0.010 0.059 ↓ 0.0 0 1

Hash Right Join (cost=75.35..94.73 rows=624 width=1,475) (actual time=0.059..0.059 rows=0 loops=1)

  • Hash Cond: (app_group_membership.volume_id = volume.id)
66. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=16.98..33.56 rows=520 width=160) (never executed)

  • Hash Cond: (app_group_membership.app_group_id = app_group.id)
67. 0.000 0.000 ↓ 0.0 0

Seq Scan on app_group_membership (cost=0.00..15.20 rows=520 width=96) (never executed)

68. 0.000 0.000 ↓ 0.0 0

Hash (cost=13.10..13.10 rows=310 width=96) (never executed)

69. 0.000 0.000 ↓ 0.0 0

Seq Scan on app_group (cost=0.00..13.10 rows=310 width=96) (never executed)

70. 0.000 0.049 ↓ 0.0 0 1

Hash (cost=57.32..57.32 rows=84 width=1,347) (actual time=0.049..0.049 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
71. 0.000 0.049 ↓ 0.0 0 1

Hash Left Join (cost=39.55..57.32 rows=84 width=1,347) (actual time=0.049..0.049 rows=0 loops=1)

  • Hash Cond: ((volume.id = smvf.family_id) AND (volume.appliance_id = (smvf.appliance_id)::text))
72. 0.001 0.049 ↓ 0.0 0 1

Hash Left Join (cost=39.52..56.65 rows=84 width=1,275) (actual time=0.049..0.049 rows=0 loops=1)

  • Hash Cond: ((volume.datapath_vol_id = (smv.datapath_vol_id)::text) AND (volume.appliance_id = (smv.appliance_id)::text))
73. 0.001 0.048 ↓ 0.0 0 1

Hash Left Join (cost=39.48..55.97 rows=84 width=1,255) (actual time=0.048..0.048 rows=0 loops=1)

  • Hash Cond: (volume.datapath_vol_id = (perfmetrics.name)::text)
74. 0.005 0.047 ↓ 0.0 0 1

Hash Right Join (cost=39.45..55.62 rows=84 width=1,235) (actual time=0.047..0.047 rows=0 loops=1)

  • Hash Cond: ((cte.name)::text = volume.datapath_vol_id)
75. 0.000 0.000 ↓ 0.0 0

Append (cost=12.68..27.13 rows=67 width=532) (never executed)

76.          

CTE cte

77. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=12.08..12.68 rows=27 width=532) (never executed)

  • Group Key: p30.name
78. 0.000 0.000 ↓ 0.0 0

Seq Scan on performance_metrics_by_volume_rollup_thirty_mins p30 (cost=0.00..11.40 rows=27 width=528) (never executed)

  • Filter: ("timestamp" >= (now() - '3 days'::interval))
79. 0.000 0.000 ↓ 0.0 0

CTE Scan on cte (cost=0.00..0.54 rows=27 width=532) (never executed)

80. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=12.61..13.51 rows=40 width=532) (never executed)

  • Group Key: p5.name
81. 0.000 0.000 ↓ 0.0 0

Seq Scan on performance_metrics_by_volume_rollup_five_mins p5 (cost=0.61..11.61 rows=40 width=528) (never executed)

  • Filter: (NOT (hashed SubPlan 8))
82.          

SubPlan (forSeq Scan)

83. 0.000 0.000 ↓ 0.0 0

CTE Scan on cte cte_3 (cost=0.00..0.54 rows=27 width=516) (never executed)

84. 0.001 0.042 ↓ 0.0 0 1

Hash (cost=25.72..25.72 rows=84 width=1,219) (actual time=0.042..0.042 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
85. 0.005 0.041 ↓ 0.0 0 1

Hash Right Join (cost=11.57..25.72 rows=84 width=1,219) (actual time=0.041..0.041 rows=0 loops=1)

  • Hash Cond: (appliance.serial_number = volume.appliance_id)
86. 0.000 0.000 ↓ 0.0 0

Seq Scan on appliance (cost=0.00..12.40 rows=240 width=210) (never executed)

87. 0.002 0.036 ↓ 0.0 0 1

Hash (cost=10.70..10.70 rows=70 width=1,009) (actual time=0.036..0.036 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
88. 0.034 0.034 ↓ 0.0 0 1

Seq Scan on volume (cost=0.00..10.70 rows=70 width=1,009) (actual time=0.034..0.034 rows=0 loops=1)

89. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=294) (never executed)

90. 0.000 0.000 ↓ 0.0 0

CTE Scan on perfmetrics (cost=0.00..0.02 rows=1 width=294) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=810) (never executed)

92. 0.000 0.000 ↓ 0.0 0

CTE Scan on smv (cost=0.00..0.02 rows=1 width=810) (never executed)

93. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=620) (never executed)

94. 0.000 0.000 ↓ 0.0 0

CTE Scan on smvf (cost=0.00..0.02 rows=1 width=620) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Hash (cost=61.25..61.25 rows=31 width=564) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Subquery Scan on smv_last_72hours (cost=12.48..61.25 rows=31 width=564) (never executed)

97. 0.000 0.000 ↓ 0.0 0

Append (cost=12.48..60.94 rows=31 width=564) (never executed)

98.          

CTE cte

99. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=11.88..12.48 rows=30 width=806) (never executed)

  • Group Key: s1h.volume_id, s1h.appliance_id
100. 0.000 0.000 ↓ 0.0 0

Seq Scan on space_metrics_by_volume_rollup_one_hour s1h (cost=0.00..11.57 rows=30 width=806) (never executed)

  • Filter: ("timestamp" >= (now() - '3 days'::interval))
101. 0.000 0.000 ↓ 0.0 0

CTE Scan on cte cte_1 (cost=0.00..0.60 rows=30 width=806) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2 (cost=47.52..47.56 rows=1 width=564) (never executed)

103. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=47.52..47.55 rows=1 width=564) (never executed)

  • Group Key: "*SELECT* 1".volume_id, "*SELECT* 1".appliance_id
104. 0.000 0.000 ↓ 0.0 0

Sort (cost=47.52..47.52 rows=1 width=564) (never executed)

  • Sort Key: "*SELECT* 1".volume_id, "*SELECT* 1".appliance_id
105. 0.000 0.000 ↓ 0.0 0

Hash Anti Join (cost=12.55..47.51 rows=1 width=564) (never executed)

  • Hash Cond: (("*SELECT* 1".volume_id = (cte_2.volume_id)::text) AND (("*SELECT* 1".appliance_id)::text = (cte_2.appliance_id)::text))
106. 0.000 0.000 ↓ 0.0 0

Append (cost=11.50..46.44 rows=2 width=564) (never executed)

107. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1 (cost=11.50..23.10 rows=1 width=564) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=11.50..23.09 rows=1 width=576) (never executed)

  • Hash Cond: (((smv_1.datapath_vol_id)::text = vvol.datapath_id) AND ((smv_1.appliance_id)::text = vvol.appliance_id))
109. 0.000 0.000 ↓ 0.0 0

Seq Scan on space_metrics_by_volume smv_1 (cost=0.00..10.90 rows=90 width=806) (never executed)

110. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.60..10.60 rows=60 width=96) (never executed)

111. 0.000 0.000 ↓ 0.0 0

Seq Scan on virtual_volume vvol (cost=0.00..10.60 rows=60 width=96) (never executed)

112. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_1 (cost=11.75..23.35 rows=1 width=564) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=11.75..23.34 rows=1 width=576) (never executed)

  • Hash Cond: (((smv_2.datapath_vol_id)::text = v.datapath_vol_id) AND ((smv_2.appliance_id)::text = v.appliance_id))
114. 0.000 0.000 ↓ 0.0 0

Seq Scan on space_metrics_by_volume smv_2 (cost=0.00..10.90 rows=90 width=806) (never executed)

115. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.70..10.70 rows=70 width=96) (never executed)

116. 0.000 0.000 ↓ 0.0 0

Seq Scan on volume v (cost=0.00..10.70 rows=70 width=96) (never executed)

117. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.60..0.60 rows=30 width=790) (never executed)

118. 0.000 0.000 ↓ 0.0 0

CTE Scan on cte cte_2 (cost=0.00..0.60 rows=30 width=790) (never executed)

119. 0.000 0.000 ↓ 0.0 0

Hash (cost=14.10..14.10 rows=410 width=65) (never executed)

120. 0.000 0.000 ↓ 0.0 0

Seq Scan on policy protection_policy (cost=0.00..14.10 rows=410 width=65) (never executed)

121. 0.000 0.000 ↓ 0.0 0

Hash (cost=14.10..14.10 rows=410 width=64) (never executed)

122. 0.000 0.000 ↓ 0.0 0

Seq Scan on policy performance_policy (cost=0.00..14.10 rows=410 width=64) (never executed)

123. 0.000 0.000 ↓ 0.0 0

Hash (cost=14.10..14.10 rows=410 width=65) (never executed)

124. 0.000 0.000 ↓ 0.0 0

Seq Scan on policy app_group_policy (cost=0.00..14.10 rows=410 width=65) (never executed)

125. 0.000 0.000 ↓ 0.0 0

Hash (cost=13.90..13.90 rows=390 width=32) (never executed)

126. 0.000 0.000 ↓ 0.0 0

Seq Scan on replication_rule (cost=0.00..13.90 rows=390 width=32) (never executed)

127. 0.000 0.000 ↓ 0.0 0

Hash (cost=16.50..16.50 rows=650 width=96) (never executed)

128. 0.000 0.000 ↓ 0.0 0

Seq Scan on performance_rule (cost=0.00..16.50 rows=650 width=96) (never executed)

129. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.91..10.91 rows=1 width=40) (never executed)

130. 0.000 0.000 ↓ 0.0 0

Subquery Scan on snap_count_info (cost=10.89..10.91 rows=1 width=40) (never executed)

131. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=10.89..10.90 rows=1 width=40) (never executed)

  • Group Key: volume1.source_id
132. 0.000 0.000 ↓ 0.0 0

Sort (cost=10.89..10.89 rows=1 width=32) (never executed)

  • Sort Key: volume1.source_id
133. 0.000 0.000 ↓ 0.0 0

Seq Scan on volume volume1 (cost=0.00..10.88 rows=1 width=32) (never executed)

  • Filter: (type = 'SNAPSHOT'::text)
134. 0.000 0.000 ↓ 0.0 0

Hash (cost=20.00..20.00 rows=200 width=40) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Subquery Scan on mapped_host_info (cost=16.00..20.00 rows=200 width=40) (never executed)

136. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=16.00..18.00 rows=200 width=40) (never executed)

  • Group Key: lunmap.lun_id
137. 0.000 0.000 ↓ 0.0 0

Seq Scan on lunmap (cost=0.00..14.00 rows=400 width=32) (never executed)