explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xP5Q

Settings
# exclusive inclusive rows x rows loops node
1. 3.802 27,371.228 ↑ 1.0 1 1

Aggregate (cost=1,302,917.16..1,302,917.17 rows=1 width=80) (actual time=27,371.227..27,371.228 rows=1 loops=1)

2.          

CTE pg_source

3. 0.034 13,759.357 ↑ 1.0 100 1

Limit (cost=651,093.88..651,154.49 rows=100 width=1,352) (actual time=13,748.542..13,759.357 rows=100 loops=1)

4. 14.118 13,759.323 ↑ 117.3 100 1

Subquery Scan on volume_list_cma_view (cost=651,093.88..658,205.69 rows=11,733 width=1,352) (actual time=13,748.539..13,759.323 rows=100 loops=1)

5. 0.132 13,745.205 ↑ 117.3 100 1

Hash Left Join (cost=651,093.88..655,155.11 rows=11,733 width=1,890) (actual time=13,743.754..13,745.205 rows=100 loops=1)

  • Hash Cond: (internal_volume_1.id = mapped_host_info.lun_id)
6.          

CTE smvt

7. 528.650 11,759.217 ↑ 2.8 24,008 1

GroupAggregate (cost=445,912.00..468,365.95 rows=67,626 width=63) (actual time=10,258.983..11,759.217 rows=24,008 loops=1)

  • Group Key: space_metrics_by_volume.appliance_id, space_metrics_by_volume.datapath_vol_id
8. 10,635.215 11,230.567 ↑ 1.0 2,177,769 1

Sort (cost=445,912.00..451,356.42 rows=2,177,769 width=63) (actual time=10,258.886..11,230.567 rows=2,177,769 loops=1)

  • Sort Key: space_metrics_by_volume.appliance_id, space_metrics_by_volume.datapath_vol_id
  • Sort Method: external merge Disk: 157760kB
9. 595.352 595.352 ↑ 1.0 2,177,769 1

Seq Scan on space_metrics_by_volume (cost=0.00..52,888.69 rows=2,177,769 width=63) (actual time=0.019..595.352 rows=2,177,769 loops=1)

10.          

CTE smv

11. 409.138 13,531.229 ↓ 147.3 24,008 1

Hash Join (cost=120,774.65..166,716.98 rows=163 width=83) (actual time=11,614.533..13,531.229 rows=24,008 loops=1)

  • 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"))
12. 11,779.485 11,779.485 ↑ 2.8 24,008 1

CTE Scan on smvt (cost=0.00..1,352.52 rows=67,626 width=798) (actual time=10,260.451..11,779.485 rows=24,008 loops=1)

13. 941.116 1,342.606 ↑ 1.0 2,177,769 1

Hash (cost=52,888.69..52,888.69 rows=2,177,769 width=83) (actual time=1,342.606..1,342.606 rows=2,177,769 loops=1)

  • Buckets: 32768 Batches: 128 Memory Usage: 2205kB
14. 401.490 401.490 ↑ 1.0 2,177,769 1

Seq Scan on space_metrics_by_volume ismv (cost=0.00..52,888.69 rows=2,177,769 width=83) (actual time=0.016..401.490 rows=2,177,769 loops=1)

15.          

CTE smvft

16. 110.386 158.763 ↑ 7,974.0 1 1

HashAggregate (cost=9,323.31..9,403.05 rows=7,974 width=27) (actual time=158.763..158.763 rows=1 loops=1)

  • Group Key: space_metrics_by_volume_family.appliance_id, space_metrics_by_volume_family.datapath_snap_group_id
17. 48.377 48.377 ↑ 1.0 347,275 1

Seq Scan on space_metrics_by_volume_family (cost=0.00..6,718.75 rows=347,275 width=27) (actual time=0.045..48.377 rows=347,275 loops=1)

18.          

CTE smvf

19. 0.010 160.230 ↓ 0.0 0 1

Nested Loop (cost=1,934.87..2,186.81 rows=1 width=208) (actual time=160.230..160.230 rows=0 loops=1)

  • Join Filter: ((volaggr.datapath_family_id = smvf.datapath_snap_group_id) AND ((volaggr.appliance_id)::text = (smvf.appliance_id)::text) AND (volaggr."timestamp" = smvf."timestamp"))
20. 0.045 160.220 ↓ 0.0 0 1

Hash Join (cost=1,934.45..2,183.65 rows=1 width=752) (actual time=160.220..160.220 rows=0 loops=1)

  • Hash Cond: ((smvft.datapath_snap_group_id = volaggr.datapath_family_id) AND ((smvft.appliance_id)::text = (volaggr.appliance_id)::text) AND (smvft."timestamp" = volaggr."timestamp"))
21. 158.779 158.779 ↑ 7,974.0 1 1

CTE Scan on smvft (cost=0.00..159.48 rows=7,974 width=528) (actual time=158.779..158.779 rows=1 loops=1)

22. 0.001 1.396 ↓ 0.0 0 1

Hash (cost=1,934.43..1,934.43 rows=1 width=224) (actual time=1.396..1.396 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
23. 0.004 1.395 ↓ 0.0 0 1

Subquery Scan on volaggr (cost=1,934.36..1,934.43 rows=1 width=224) (actual time=1.395..1.395 rows=0 loops=1)

24. 0.004 1.391 ↓ 0.0 0 1

GroupAggregate (cost=1,934.36..1,934.42 rows=1 width=224) (actual time=1.391..1.391 rows=0 loops=1)

  • Group Key: internal_volume.datapath_family_id, internal_volume.family_id, smv.appliance_id, smv."timestamp
25. 1.322 1.387 ↓ 0.0 0 1

Sort (cost=1,934.36..1,934.37 rows=1 width=88) (actual time=1.387..1.387 rows=0 loops=1)

  • Sort Key: internal_volume.datapath_family_id, internal_volume.family_id, smv.appliance_id, smv."timestamp
  • Sort Method: quicksort Memory: 25kB
26. 0.022 0.065 ↓ 0.0 0 1

Hash Join (cost=6.34..1,934.35 rows=1 width=88) (actual time=0.065..0.065 rows=0 loops=1)

  • Hash Cond: ((internal_volume.appliance_id = (smv.appliance_id)::text) AND (internal_volume.datapath_vol_id = (smv.datapath_vol_id)::text))
27. 0.020 0.020 ↑ 24,000.0 1 1

Seq Scan on internal_volume (cost=0.00..1,748.00 rows=24,000 width=104) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (storage_type = 'BLOCK'::text)
28. 0.000 0.023 ↓ 0.0 0 1

Hash (cost=6.33..6.33 rows=1 width=79) (actual time=0.023..0.023 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
29. 0.023 0.023 ↓ 0.0 0 1

Index Scan using space_metrics_by_volume_pkey on space_metrics_by_volume smv (cost=0.56..6.33 rows=1 width=79) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: ("timestamp" >= (now() - '01:00:00'::interval))
30. 0.000 0.000 ↓ 0.0 0

Index Scan using space_metrics_by_volume_family_pkey on space_metrics_by_volume_family smvf (cost=0.42..3.13 rows=1 width=43) (never executed)

  • Index Cond: (("timestamp" = smvft."timestamp") AND ((appliance_id)::text = (smvft.appliance_id)::text) AND (datapath_snap_group_id = smvft.datapath_snap_group_id))
31.          

CTE pmvt

32. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=11.80..13.00 rows=120 width=282) (never executed)

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

Seq Scan on performance_metrics_by_volume (cost=0.00..11.20 rows=120 width=282) (never executed)

34.          

CTE perfmetrics

35. 0.001 0.002 ↓ 0.0 0 1

Hash Join (cost=4.20..16.31 rows=1 width=604) (actual time=0.002..0.002 rows=0 loops=1)

  • Hash Cond: (((ipmv.name)::text = (pmvt.name)::text) AND (ipmv."timestamp" = pmvt."timestamp"))
36. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on performance_metrics_by_volume ipmv (cost=0.00..11.20 rows=120 width=604) (actual time=0.001..0.001 rows=0 loops=1)

37. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.40..2.40 rows=120 width=282) (never executed)

38. 0.000 0.000 ↓ 0.0 0

CTE Scan on pmvt (cost=0.00..2.40 rows=120 width=282) (never executed)

39. 0.138 13,745.052 ↑ 117.3 100 1

Hash Left Join (cost=4,369.27..8,223.71 rows=11,733 width=1,890) (actual time=13,743.696..13,745.052 rows=100 loops=1)

  • Hash Cond: (internal_volume_1.id = snap_count_info.source_id)
40. 0.080 13,716.866 ↑ 117.3 100 1

Hash Left Join (cost=2,230.89..5,937.20 rows=11,733 width=1,882) (actual time=13,715.614..13,716.866 rows=100 loops=1)

  • Hash Cond: (internal_volume_1.protection_policy_id = policy_replication_rule.policy_id)
41. 0.087 13,716.779 ↑ 80.0 100 1

Hash Left Join (cost=2,201.09..4,890.07 rows=8,000 width=1,850) (actual time=13,715.594..13,716.779 rows=100 loops=1)

  • Hash Cond: (internal_volume_1.performance_policy_id = performance_rule.id)
42. 0.079 13,716.681 ↑ 80.0 100 1

Hash Left Join (cost=2,200.02..4,788.00 rows=8,000 width=1,754) (actual time=13,715.563..13,716.681 rows=100 loops=1)

  • Hash Cond: (app_group.protection_policy_id = app_group_policy.id)
43. 0.074 13,716.596 ↑ 80.0 100 1

Hash Left Join (cost=2,198.93..4,685.91 rows=8,000 width=1,721) (actual time=13,715.540..13,716.596 rows=100 loops=1)

  • Hash Cond: (internal_volume_1.performance_policy_id = performance_policy.id)
44. 0.105 13,716.513 ↑ 80.0 100 1

Hash Left Join (cost=2,197.84..4,583.82 rows=8,000 width=1,689) (actual time=13,715.518..13,716.513 rows=100 loops=1)

  • Hash Cond: (internal_volume_1.protection_policy_id = protection_policy.id)
45. 0.109 13,716.393 ↑ 80.0 100 1

Hash Left Join (cost=2,196.75..4,487.65 rows=8,000 width=1,656) (actual time=13,715.486..13,716.393 rows=100 loops=1)

  • Hash Cond: ((internal_volume_1.id = (smv_last_72hours.volume_id)::text) AND (internal_volume_1.appliance_id = (smv_last_72hours.appliance_id)::text))
46. 0.158 13,716.166 ↑ 80.0 100 1

Hash Left Join (cost=231.65..2,462.55 rows=8,000 width=1,640) (actual time=13,715.340..13,716.166 rows=100 loops=1)

  • Hash Cond: ((internal_volume_1.family_id = smvf_1.family_id) AND (internal_volume_1.appliance_id = (smvf_1.appliance_id)::text))
47. 0.209 13,555.769 ↑ 80.0 100 1

Hash Left Join (cost=231.62..2,402.50 rows=8,000 width=1,568) (actual time=13,555.019..13,555.769 rows=100 loops=1)

  • Hash Cond: ((internal_volume_1.datapath_vol_id = (smv_1.datapath_vol_id)::text) AND (internal_volume_1.appliance_id = (smv_1.appliance_id)::text))
48. 0.086 1.864 ↑ 80.0 100 1

Hash Left Join (cost=225.91..2,336.79 rows=8,000 width=1,548) (actual time=1.286..1.864 rows=100 loops=1)

  • Hash Cond: (internal_volume_1.datapath_vol_id = (perfmetrics_last_72hours.name)::text)
49. 0.093 1.772 ↑ 80.0 100 1

Hash Left Join (cost=198.84..2,279.58 rows=8,000 width=1,532) (actual time=1.271..1.772 rows=100 loops=1)

  • Hash Cond: (internal_volume_1.datapath_vol_id = (perfmetrics.name)::text)
50. 0.067 1.676 ↑ 80.0 100 1

Hash Left Join (cost=198.80..2,249.53 rows=8,000 width=1,512) (actual time=1.261..1.676 rows=100 loops=1)

  • Hash Cond: ((internal_volume_1.migration_session_id)::text = (migration_session.id)::text)
51. 0.127 1.607 ↑ 80.0 100 1

Hash Left Join (cost=188.35..2,138.09 rows=8,000 width=1,238) (actual time=1.252..1.607 rows=100 loops=1)

  • Hash Cond: (internal_volume_1.appliance_id = appliance.serial_number)
52. 0.114 1.464 ↑ 80.0 100 1

Hash Left Join (cost=187.26..2,026.99 rows=8,000 width=1,028) (actual time=1.224..1.464 rows=100 loops=1)

  • Hash Cond: (internal_volume_1.id = app_group_membership.volume_id)
53. 1.346 1.346 ↑ 80.0 100 1

Seq Scan on internal_volume internal_volume_1 (cost=0.00..1,808.00 rows=8,000 width=918) (actual time=1.201..1.346 rows=100 loops=1)

  • Filter: ((NOT is_internal) AND (type <> ALL ('{SNAPSHOT,Snapshot}'::text[])) AND (storage_type = 'BLOCK'::text))
54. 0.000 0.004 ↓ 0.0 0 1

Hash (cost=180.76..180.76 rows=520 width=142) (actual time=0.004..0.004 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
55. 0.002 0.004 ↓ 0.0 0 1

Hash Left Join (cost=159.00..180.76 rows=520 width=142) (actual time=0.004..0.004 rows=0 loops=1)

  • Hash Cond: (app_group_membership.app_group_id = app_group.id)
56. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on app_group_membership (cost=0.00..15.20 rows=520 width=96) (actual time=0.002..0.002 rows=0 loops=1)

57. 0.000 0.000 ↓ 0.0 0

Hash (cost=109.00..109.00 rows=4,000 width=83) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Seq Scan on app_group (cost=0.00..109.00 rows=4,000 width=83) (never executed)

59. 0.007 0.016 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=210) (actual time=0.016..0.016 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
60. 0.009 0.009 ↑ 1.0 4 1

Seq Scan on appliance (cost=0.00..1.04 rows=4 width=210) (actual time=0.007..0.009 rows=4 loops=1)

61. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=10.20..10.20 rows=20 width=548) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
62. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on migration_session (cost=0.00..10.20 rows=20 width=548) (actual time=0.002..0.002 rows=0 loops=1)

63. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=0.02..0.02 rows=1 width=294) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
64. 0.003 0.003 ↓ 0.0 0 1

CTE Scan on perfmetrics (cost=0.00..0.02 rows=1 width=294) (actual time=0.003..0.003 rows=0 loops=1)

65. 0.000 0.006 ↓ 0.0 0 1

Hash (cost=26.58..26.58 rows=40 width=532) (actual time=0.006..0.006 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
66. 0.001 0.006 ↓ 0.0 0 1

Subquery Scan on perfmetrics_last_72hours (cost=12.68..26.58 rows=40 width=532) (actual time=0.006..0.006 rows=0 loops=1)

67. 0.000 0.005 ↓ 0.0 0 1

Append (cost=12.68..26.18 rows=40 width=532) (actual time=0.005..0.005 rows=0 loops=1)

68.          

CTE cte

69. 0.001 0.002 ↓ 0.0 0 1

HashAggregate (cost=12.08..12.68 rows=27 width=532) (actual time=0.002..0.002 rows=0 loops=1)

  • Group Key: p30.name
70. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on performance_metrics_by_volume_rollup_thirty_mins p30 (cost=0.00..11.40 rows=27 width=528) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ("timestamp" >= (now() - '3 days'::interval))
71. 0.003 0.003 ↓ 0.0 0 1

CTE Scan on cte cte_1 (cost=0.00..0.54 rows=27 width=532) (actual time=0.003..0.003 rows=0 loops=1)

72. 0.000 0.002 ↓ 0.0 0 1

HashAggregate (cost=12.53..12.83 rows=13 width=532) (actual time=0.002..0.002 rows=0 loops=1)

  • Group Key: p5.name
73. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on performance_metrics_by_volume_rollup_five_mins p5 (cost=0.61..12.21 rows=13 width=528) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((NOT (hashed SubPlan 8)) AND ("timestamp" >= (now() - '00:30:00'::interval)))
74.          

SubPlan (forSeq Scan)

75. 0.000 0.000 ↓ 0.0 0

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

76. 9.431 13,553.696 ↓ 147.3 24,008 1

Hash (cost=3.26..3.26 rows=163 width=810) (actual time=13,553.696..13,553.696 rows=24,008 loops=1)

  • Buckets: 32768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 2765kB
77. 13,544.265 13,544.265 ↓ 147.3 24,008 1

CTE Scan on smv smv_1 (cost=0.00..3.26 rows=163 width=810) (actual time=11,614.541..13,544.265 rows=24,008 loops=1)

78. 0.001 160.239 ↓ 0.0 0 1

Hash (cost=0.02..0.02 rows=1 width=620) (actual time=160.239..160.239 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
79. 160.238 160.238 ↓ 0.0 0 1

CTE Scan on smvf smvf_1 (cost=0.00..0.02 rows=1 width=620) (actual time=160.238..160.238 rows=0 loops=1)

80. 0.001 0.118 ↓ 0.0 0 1

Hash (cost=1,964.63..1,964.63 rows=31 width=564) (actual time=0.118..0.118 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
81. 0.001 0.117 ↓ 0.0 0 1

Subquery Scan on smv_last_72hours (cost=12.48..1,964.63 rows=31 width=564) (actual time=0.117..0.117 rows=0 loops=1)

82. 0.004 0.116 ↓ 0.0 0 1

Append (cost=12.48..1,964.32 rows=31 width=564) (actual time=0.116..0.116 rows=0 loops=1)

83.          

CTE cte

84. 0.006 0.019 ↓ 0.0 0 1

HashAggregate (cost=11.88..12.48 rows=30 width=806) (actual time=0.019..0.019 rows=0 loops=1)

  • Group Key: s1h.volume_id, s1h.appliance_id
85. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on space_metrics_by_volume_rollup_one_hour s1h (cost=0.00..11.57 rows=30 width=806) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: ("timestamp" >= (now() - '3 days'::interval))
86. 0.025 0.025 ↓ 0.0 0 1

CTE Scan on cte cte_2 (cost=0.00..0.60 rows=30 width=806) (actual time=0.025..0.025 rows=0 loops=1)

87. 0.002 0.087 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=1,950.66..1,950.95 rows=1 width=63) (actual time=0.087..0.087 rows=0 loops=1)

88. 0.006 0.085 ↓ 0.0 0 1

GroupAggregate (cost=1,950.66..1,950.94 rows=1 width=65) (actual time=0.085..0.085 rows=0 loops=1)

  • Group Key: "*SELECT* 1".volume_id, "*SELECT* 1".appliance_id
89. 0.003 0.079 ↓ 0.0 0 1

Merge Anti Join (cost=1,950.66..1,950.91 rows=1 width=65) (actual time=0.079..0.079 rows=0 loops=1)

  • Merge Cond: (("*SELECT* 1".volume_id = (cte_3.volume_id)::text) AND (("*SELECT* 1".appliance_id)::text = (cte_3.appliance_id)::text))
90. 0.017 0.076 ↓ 0.0 0 1

Sort (cost=1,949.32..1,949.33 rows=2 width=66) (actual time=0.076..0.076 rows=0 loops=1)

  • Sort Key: "*SELECT* 1".volume_id, "*SELECT* 1".appliance_id
  • Sort Method: quicksort Memory: 25kB
91. 0.002 0.059 ↓ 0.0 0 1

Append (cost=0.70..1,949.31 rows=2 width=66) (actual time=0.059..0.059 rows=0 loops=1)

92. 0.002 0.020 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=0.70..14.95 rows=1 width=63) (actual time=0.020..0.020 rows=0 loops=1)

93. 0.003 0.018 ↓ 0.0 0 1

Nested Loop (cost=0.70..14.94 rows=1 width=75) (actual time=0.018..0.018 rows=0 loops=1)

94. 0.015 0.015 ↓ 0.0 0 1

Index Scan using space_metrics_by_volume_pkey on space_metrics_by_volume smv_2 (cost=0.56..6.33 rows=1 width=71) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ("timestamp" >= (now() - '01:00:00'::interval))
95. 0.000 0.000 ↓ 0.0 0

Index Scan using multi_index on virtual_volume vvol (cost=0.14..8.60 rows=1 width=96) (never executed)

  • Index Cond: (appliance_id = (smv_2.appliance_id)::text)
  • Filter: ((smv_2.datapath_vol_id)::text = datapath_id)
96. 0.002 0.037 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_1 (cost=6.34..1,934.36 rows=1 width=68) (actual time=0.037..0.037 rows=0 loops=1)

97. 0.017 0.035 ↓ 0.0 0 1

Hash Join (cost=6.34..1,934.35 rows=1 width=80) (actual time=0.035..0.035 rows=0 loops=1)

  • Hash Cond: ((internal_volume_2.datapath_vol_id = (smv_3.datapath_vol_id)::text) AND (internal_volume_2.appliance_id = (smv_3.appliance_id)::text))
98. 0.010 0.010 ↑ 24,000.0 1 1

Seq Scan on internal_volume internal_volume_2 (cost=0.00..1,748.00 rows=24,000 width=92) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (storage_type = 'BLOCK'::text)
99. 0.000 0.008 ↓ 0.0 0 1

Hash (cost=6.33..6.33 rows=1 width=71) (actual time=0.008..0.008 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
100. 0.008 0.008 ↓ 0.0 0 1

Index Scan using space_metrics_by_volume_pkey on space_metrics_by_volume smv_3 (cost=0.56..6.33 rows=1 width=71) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ("timestamp" >= (now() - '01:00:00'::interval))
101. 0.000 0.000 ↓ 0.0 0

Sort (cost=1.34..1.41 rows=30 width=790) (never executed)

  • Sort Key: cte_3.volume_id, cte_3.appliance_id
102. 0.000 0.000 ↓ 0.0 0

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

103. 0.004 0.015 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=65) (actual time=0.015..0.015 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
104. 0.011 0.011 ↑ 1.0 4 1

Seq Scan on policy protection_policy (cost=0.00..1.04 rows=4 width=65) (actual time=0.009..0.011 rows=4 loops=1)

105. 0.006 0.009 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=64) (actual time=0.009..0.009 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
106. 0.003 0.003 ↑ 1.0 4 1

Seq Scan on policy performance_policy (cost=0.00..1.04 rows=4 width=64) (actual time=0.002..0.003 rows=4 loops=1)

107. 0.003 0.006 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=65) (actual time=0.006..0.006 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
108. 0.003 0.003 ↑ 1.0 4 1

Seq Scan on policy app_group_policy (cost=0.00..1.04 rows=4 width=65) (actual time=0.002..0.003 rows=4 loops=1)

109. 0.002 0.011 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=96) (actual time=0.011..0.011 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
110. 0.009 0.009 ↑ 1.0 3 1

Seq Scan on performance_rule (cost=0.00..1.03 rows=3 width=96) (actual time=0.008..0.009 rows=3 loops=1)

111. 0.001 0.007 ↓ 0.0 0 1

Hash (cost=18.80..18.80 rows=880 width=64) (actual time=0.007..0.007 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
112. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on policy_replication_rule (cost=0.00..18.80 rows=880 width=64) (actual time=0.006..0.006 rows=0 loops=1)

113. 2.048 28.048 ↓ 1.0 8,000 1

Hash (cost=2,042.08..2,042.08 rows=7,704 width=45) (actual time=28.048..28.048 rows=8,000 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 666kB
114. 1.051 26.000 ↓ 1.0 8,000 1

Subquery Scan on snap_count_info (cost=1,888.00..2,042.08 rows=7,704 width=45) (actual time=23.482..26.000 rows=8,000 loops=1)

115. 7.551 24.949 ↓ 1.0 8,000 1

HashAggregate (cost=1,888.00..1,965.04 rows=7,704 width=45) (actual time=23.481..24.949 rows=8,000 loops=1)

  • Group Key: internal_volume_3.source_id
116. 17.398 17.398 ↑ 1.0 16,000 1

Seq Scan on internal_volume internal_volume_3 (cost=0.00..1,808.00 rows=16,000 width=37) (actual time=4.341..17.398 rows=16,000 loops=1)

  • Filter: ((NOT is_internal) AND (storage_type = 'BLOCK'::text) AND (type = 'SNAPSHOT'::text))
  • Rows Removed by Filter: 8000
117. 0.002 0.021 ↓ 0.0 0 1

Hash (cost=20.00..20.00 rows=200 width=40) (actual time=0.021..0.021 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
118. 0.005 0.019 ↓ 0.0 0 1

Subquery Scan on mapped_host_info (cost=16.00..20.00 rows=200 width=40) (actual time=0.019..0.019 rows=0 loops=1)

119. 0.007 0.014 ↓ 0.0 0 1

HashAggregate (cost=16.00..18.00 rows=200 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Group Key: lunmap.lun_id
120. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on lunmap (cost=0.00..14.00 rows=400 width=32) (actual time=0.007..0.007 rows=0 loops=1)

121.          

Initplan (forAggregate)

122. 0.707 13,607.724 ↑ 1.0 1 1

Aggregate (cost=651,760.15..651,760.16 rows=1 width=8) (actual time=13,607.724..13,607.724 rows=1 loops=1)

123. 3.181 13,607.017 ↑ 1.5 8,000 1

Merge Right Join (cost=651,378.10..651,613.49 rows=11,733 width=1,999) (actual time=13,603.349..13,607.017 rows=8,000 loops=1)

  • Merge Cond: (policy_replication_rule_1.policy_id = internal_volume_5.protection_policy_id)
124.          

CTE smvt

125. 565.064 11,671.902 ↑ 2.8 24,008 1

GroupAggregate (cost=445,912.00..468,365.95 rows=67,626 width=63) (actual time=10,072.590..11,671.902 rows=24,008 loops=1)

  • Group Key: space_metrics_by_volume_1.appliance_id, space_metrics_by_volume_1.datapath_vol_id
126. 10,547.655 11,106.838 ↑ 1.0 2,177,769 1

Sort (cost=445,912.00..451,356.42 rows=2,177,769 width=63) (actual time=10,072.486..11,106.838 rows=2,177,769 loops=1)

  • Sort Key: space_metrics_by_volume_1.appliance_id, space_metrics_by_volume_1.datapath_vol_id
  • Sort Method: external merge Disk: 157760kB
127. 559.183 559.183 ↑ 1.0 2,177,769 1

Seq Scan on space_metrics_by_volume space_metrics_by_volume_1 (cost=0.00..52,888.69 rows=2,177,769 width=63) (actual time=0.008..559.183 rows=2,177,769 loops=1)

128.          

CTE smv

129. 363.126 13,314.295 ↓ 147.3 24,008 1

Hash Join (cost=120,774.65..166,716.98 rows=163 width=83) (actual time=11,334.056..13,314.295 rows=24,008 loops=1)

  • Hash Cond: (((smvt_1.appliance_id)::text = (ismv_1.appliance_id)::text) AND ((smvt_1.datapath_vol_id)::text = (ismv_1.datapath_vol_id)::text) AND (smvt_1."timestamp" = ismv_1."timestamp"))
130. 11,696.942 11,696.942 ↑ 2.8 24,008 1

CTE Scan on smvt smvt_1 (cost=0.00..1,352.52 rows=67,626 width=798) (actual time=10,072.606..11,696.942 rows=24,008 loops=1)

131. 869.664 1,254.227 ↑ 1.0 2,177,769 1

Hash (cost=52,888.69..52,888.69 rows=2,177,769 width=83) (actual time=1,254.227..1,254.227 rows=2,177,769 loops=1)

  • Buckets: 32768 Batches: 128 Memory Usage: 2205kB
132. 384.563 384.563 ↑ 1.0 2,177,769 1

Seq Scan on space_metrics_by_volume ismv_1 (cost=0.00..52,888.69 rows=2,177,769 width=83) (actual time=1.842..384.563 rows=2,177,769 loops=1)

133.          

CTE smvft

134. 136.468 207.221 ↑ 7,974.0 1 1

HashAggregate (cost=9,323.31..9,403.05 rows=7,974 width=27) (actual time=207.221..207.221 rows=1 loops=1)

  • Group Key: space_metrics_by_volume_family_1.appliance_id, space_metrics_by_volume_family_1.datapath_snap_group_id
135. 70.753 70.753 ↑ 1.0 347,275 1

Seq Scan on space_metrics_by_volume_family space_metrics_by_volume_family_1 (cost=0.00..6,718.75 rows=347,275 width=27) (actual time=1.755..70.753 rows=347,275 loops=1)

136.          

CTE smvf

137. 0.008 210.887 ↓ 0.0 0 1

Nested Loop (cost=1,934.87..2,186.81 rows=1 width=208) (actual time=210.887..210.887 rows=0 loops=1)

  • Join Filter: ((volaggr_1.datapath_family_id = smvf_2.datapath_snap_group_id) AND ((volaggr_1.appliance_id)::text = (smvf_2.appliance_id)::text) AND (volaggr_1."timestamp" = smvf_2."timestamp"))
138. 0.075 210.879 ↓ 0.0 0 1

Hash Join (cost=1,934.45..2,183.65 rows=1 width=752) (actual time=210.879..210.879 rows=0 loops=1)

  • Hash Cond: ((smvft_1.datapath_snap_group_id = volaggr_1.datapath_family_id) AND ((smvft_1.appliance_id)::text = (volaggr_1.appliance_id)::text) AND (smvft_1."timestamp" = volaggr_1."timestamp"))
139. 207.232 207.232 ↑ 7,974.0 1 1

CTE Scan on smvft smvft_1 (cost=0.00..159.48 rows=7,974 width=528) (actual time=207.232..207.232 rows=1 loops=1)

140. 0.001 3.572 ↓ 0.0 0 1

Hash (cost=1,934.43..1,934.43 rows=1 width=224) (actual time=3.572..3.572 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
141. 0.004 3.571 ↓ 0.0 0 1

Subquery Scan on volaggr_1 (cost=1,934.36..1,934.43 rows=1 width=224) (actual time=3.571..3.571 rows=0 loops=1)

142. 0.004 3.567 ↓ 0.0 0 1

GroupAggregate (cost=1,934.36..1,934.42 rows=1 width=224) (actual time=3.567..3.567 rows=0 loops=1)

  • Group Key: internal_volume_4.datapath_family_id, internal_volume_4.family_id, smv_4.appliance_id, smv_4."timestamp
143. 0.030 3.563 ↓ 0.0 0 1

Sort (cost=1,934.36..1,934.37 rows=1 width=88) (actual time=3.563..3.563 rows=0 loops=1)

  • Sort Key: internal_volume_4.datapath_family_id, internal_volume_4.family_id, smv_4.appliance_id, smv_4."timestamp
  • Sort Method: quicksort Memory: 25kB
144. 0.031 3.533 ↓ 0.0 0 1

Hash Join (cost=6.34..1,934.35 rows=1 width=88) (actual time=3.533..3.533 rows=0 loops=1)

  • Hash Cond: ((internal_volume_4.appliance_id = (smv_4.appliance_id)::text) AND (internal_volume_4.datapath_vol_id = (smv_4.datapath_vol_id)::text))
145. 0.025 0.025 ↑ 24,000.0 1 1

Seq Scan on internal_volume internal_volume_4 (cost=0.00..1,748.00 rows=24,000 width=104) (actual time=0.025..0.025 rows=1 loops=1)

  • Filter: (storage_type = 'BLOCK'::text)
146. 0.002 3.477 ↓ 0.0 0 1

Hash (cost=6.33..6.33 rows=1 width=79) (actual time=3.477..3.477 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
147. 3.475 3.475 ↓ 0.0 0 1

Index Scan using space_metrics_by_volume_pkey on space_metrics_by_volume smv_4 (cost=0.56..6.33 rows=1 width=79) (actual time=3.475..3.475 rows=0 loops=1)

  • Index Cond: ("timestamp" >= (now() - '01:00:00'::interval))
148. 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.42..3.13 rows=1 width=43) (never executed)

  • Index Cond: (("timestamp" = smvft_1."timestamp") AND ((appliance_id)::text = (smvft_1.appliance_id)::text) AND (datapath_snap_group_id = smvft_1.datapath_snap_group_id))
149.          

CTE pmvt

150. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=11.80..13.00 rows=120 width=282) (never executed)

  • Group Key: performance_metrics_by_volume_1.name
151. 0.000 0.000 ↓ 0.0 0

Seq Scan on performance_metrics_by_volume performance_metrics_by_volume_1 (cost=0.00..11.20 rows=120 width=282) (never executed)

152.          

CTE perfmetrics

153. 0.007 0.011 ↓ 0.0 0 1

Hash Join (cost=4.20..16.31 rows=1 width=604) (actual time=0.011..0.011 rows=0 loops=1)

  • Hash Cond: (((ipmv_1.name)::text = (pmvt_1.name)::text) AND (ipmv_1."timestamp" = pmvt_1."timestamp"))
154. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on performance_metrics_by_volume ipmv_1 (cost=0.00..11.20 rows=120 width=604) (actual time=0.004..0.004 rows=0 loops=1)

155. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.40..2.40 rows=120 width=282) (never executed)

156. 0.000 0.000 ↓ 0.0 0

CTE Scan on pmvt pmvt_1 (cost=0.00..2.40 rows=120 width=282) (never executed)

157. 0.012 0.012 ↓ 0.0 0 1

Index Only Scan using policy_replication_rule_pkey on policy_replication_rule policy_replication_rule_1 (cost=0.15..57.35 rows=880 width=32) (actual time=0.012..0.012 rows=0 loops=1)

  • Heap Fetches: 0
158. 2.699 13,603.824 ↑ 1.0 8,000 1

Sort (cost=4,675.84..4,695.84 rows=8,000 width=37) (actual time=13,603.303..13,603.824 rows=8,000 loops=1)

  • Sort Key: internal_volume_5.protection_policy_id
  • Sort Method: quicksort Memory: 818kB
159. 2.672 13,601.125 ↑ 1.0 8,000 1

Hash Left Join (cost=1,999.04..4,157.21 rows=8,000 width=37) (actual time=13,544.287..13,601.125 rows=8,000 loops=1)

  • Hash Cond: ((internal_volume_5.id = (smv_last_72hours_1.volume_id)::text) AND (internal_volume_5.appliance_id = (smv_last_72hours_1.appliance_id)::text))
160. 2.551 13,598.242 ↑ 1.0 8,000 1

Hash Left Join (cost=33.94..2,132.10 rows=8,000 width=89) (actual time=13,544.016..13,598.242 rows=8,000 loops=1)

  • Hash Cond: ((internal_volume_5.family_id = smvf_3.family_id) AND (internal_volume_5.appliance_id = (smvf_3.appliance_id)::text))
161. 6.934 13,384.789 ↑ 1.0 8,000 1

Hash Left Join (cost=33.91..2,072.06 rows=8,000 width=126) (actual time=13,333.056..13,384.789 rows=8,000 loops=1)

  • Hash Cond: ((internal_volume_5.datapath_vol_id = (smv_5.datapath_vol_id)::text) AND (internal_volume_5.appliance_id = (smv_5.appliance_id)::text))
162. 1.941 44.945 ↑ 1.0 8,000 1

Hash Left Join (cost=28.20..2,006.34 rows=8,000 width=166) (actual time=0.113..44.945 rows=8,000 loops=1)

  • Hash Cond: (internal_volume_5.datapath_vol_id = (perfmetrics_last_72hours_1.name)::text)
163. 1.977 42.971 ↑ 1.0 8,000 1

Hash Left Join (cost=1.12..1,949.13 rows=8,000 width=166) (actual time=0.064..42.971 rows=8,000 loops=1)

  • Hash Cond: (internal_volume_5.datapath_vol_id = (perfmetrics_1.name)::text)
164. 2.840 40.979 ↑ 1.0 8,000 1

Hash Left Join (cost=1.09..1,919.09 rows=8,000 width=166) (actual time=0.033..40.979 rows=8,000 loops=1)

  • Hash Cond: (internal_volume_5.appliance_id = appliance_1.serial_number)
165. 38.128 38.128 ↑ 1.0 8,000 1

Seq Scan on internal_volume internal_volume_5 (cost=0.00..1,808.00 rows=8,000 width=472) (actual time=0.012..38.128 rows=8,000 loops=1)

  • Filter: ((NOT is_internal) AND (type <> ALL ('{SNAPSHOT,Snapshot}'::text[])) AND (storage_type = 'BLOCK'::text))
  • Rows Removed by Filter: 16000
166. 0.004 0.011 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=32) (actual time=0.011..0.011 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
167. 0.007 0.007 ↑ 1.0 4 1

Seq Scan on appliance appliance_1 (cost=0.00..1.04 rows=4 width=32) (actual time=0.006..0.007 rows=4 loops=1)

168. 0.000 0.015 ↓ 0.0 0 1

Hash (cost=0.02..0.02 rows=1 width=274) (actual time=0.015..0.015 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
169. 0.015 0.015 ↓ 0.0 0 1

CTE Scan on perfmetrics perfmetrics_1 (cost=0.00..0.02 rows=1 width=274) (actual time=0.015..0.015 rows=0 loops=1)

170. 0.000 0.033 ↓ 0.0 0 1

Hash (cost=26.58..26.58 rows=40 width=516) (actual time=0.033..0.033 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
171. 0.003 0.033 ↓ 0.0 0 1

Subquery Scan on perfmetrics_last_72hours_1 (cost=12.68..26.58 rows=40 width=516) (actual time=0.033..0.033 rows=0 loops=1)

172. 0.002 0.030 ↓ 0.0 0 1

Append (cost=12.68..26.18 rows=40 width=532) (actual time=0.030..0.030 rows=0 loops=1)

173.          

CTE cte

174. 0.005 0.013 ↓ 0.0 0 1

HashAggregate (cost=12.08..12.68 rows=27 width=532) (actual time=0.013..0.013 rows=0 loops=1)

  • Group Key: p30_1.name
175. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on performance_metrics_by_volume_rollup_thirty_mins p30_1 (cost=0.00..11.40 rows=27 width=528) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: ("timestamp" >= (now() - '3 days'::interval))
176. 0.018 0.018 ↓ 0.0 0 1

CTE Scan on cte cte_5 (cost=0.00..0.54 rows=27 width=532) (actual time=0.018..0.018 rows=0 loops=1)

177. 0.005 0.010 ↓ 0.0 0 1

HashAggregate (cost=12.53..12.83 rows=13 width=532) (actual time=0.010..0.010 rows=0 loops=1)

  • Group Key: p5_1.name
178. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on performance_metrics_by_volume_rollup_five_mins p5_1 (cost=0.61..12.21 rows=13 width=528) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: ((NOT (hashed SubPlan 18)) AND ("timestamp" >= (now() - '00:30:00'::interval)))
179.          

SubPlan (forSeq Scan)

180. 0.000 0.000 ↓ 0.0 0

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

181. 7.269 13,332.910 ↓ 147.3 24,008 1

Hash (cost=3.26..3.26 rows=163 width=790) (actual time=13,332.910..13,332.910 rows=24,008 loops=1)

  • Buckets: 32768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 2296kB
182. 13,325.641 13,325.641 ↓ 147.3 24,008 1

CTE Scan on smv smv_5 (cost=0.00..3.26 rows=163 width=790) (actual time=11,334.067..13,325.641 rows=24,008 loops=1)

183. 0.004 210.902 ↓ 0.0 0 1

Hash (cost=0.02..0.02 rows=1 width=548) (actual time=210.902..210.902 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
184. 210.898 210.898 ↓ 0.0 0 1

CTE Scan on smvf smvf_3 (cost=0.00..0.02 rows=1 width=548) (actual time=210.898..210.898 rows=0 loops=1)

185. 0.003 0.211 ↓ 0.0 0 1

Hash (cost=1,964.63..1,964.63 rows=31 width=548) (actual time=0.211..0.211 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
186. 0.006 0.208 ↓ 0.0 0 1

Subquery Scan on smv_last_72hours_1 (cost=12.48..1,964.63 rows=31 width=548) (actual time=0.208..0.208 rows=0 loops=1)

187. 0.006 0.202 ↓ 0.0 0 1

Append (cost=12.48..1,964.32 rows=31 width=564) (actual time=0.202..0.202 rows=0 loops=1)

188.          

CTE cte

189. 0.014 0.036 ↓ 0.0 0 1

HashAggregate (cost=11.88..12.48 rows=30 width=806) (actual time=0.036..0.036 rows=0 loops=1)

  • Group Key: s1h_1.volume_id, s1h_1.appliance_id
190. 0.022 0.022 ↓ 0.0 0 1

Seq Scan on space_metrics_by_volume_rollup_one_hour s1h_1 (cost=0.00..11.57 rows=30 width=806) (actual time=0.022..0.022 rows=0 loops=1)

  • Filter: ("timestamp" >= (now() - '3 days'::interval))
191. 0.042 0.042 ↓ 0.0 0 1

CTE Scan on cte cte_6 (cost=0.00..0.60 rows=30 width=806) (actual time=0.042..0.042 rows=0 loops=1)

192. 0.001 0.154 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_2 (cost=1,950.66..1,950.95 rows=1 width=63) (actual time=0.154..0.154 rows=0 loops=1)

193. 0.005 0.153 ↓ 0.0 0 1

GroupAggregate (cost=1,950.66..1,950.94 rows=1 width=65) (actual time=0.153..0.153 rows=0 loops=1)

  • Group Key: "*SELECT* 1_1".volume_id, "*SELECT* 1_1".appliance_id
194. 0.004 0.148 ↓ 0.0 0 1

Merge Anti Join (cost=1,950.66..1,950.91 rows=1 width=65) (actual time=0.148..0.148 rows=0 loops=1)

  • Merge Cond: (("*SELECT* 1_1".volume_id = (cte_7.volume_id)::text) AND (("*SELECT* 1_1".appliance_id)::text = (cte_7.appliance_id)::text))
195. 0.031 0.144 ↓ 0.0 0 1

Sort (cost=1,949.32..1,949.33 rows=2 width=66) (actual time=0.144..0.144 rows=0 loops=1)

  • Sort Key: "*SELECT* 1_1".volume_id, "*SELECT* 1_1".appliance_id
  • Sort Method: quicksort Memory: 25kB
196. 0.007 0.113 ↓ 0.0 0 1

Append (cost=0.70..1,949.31 rows=2 width=66) (actual time=0.113..0.113 rows=0 loops=1)

197. 0.001 0.028 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_1 (cost=0.70..14.95 rows=1 width=63) (actual time=0.028..0.028 rows=0 loops=1)

198. 0.003 0.027 ↓ 0.0 0 1

Nested Loop (cost=0.70..14.94 rows=1 width=75) (actual time=0.027..0.027 rows=0 loops=1)

199. 0.024 0.024 ↓ 0.0 0 1

Index Scan using space_metrics_by_volume_pkey on space_metrics_by_volume smv_6 (cost=0.56..6.33 rows=1 width=71) (actual time=0.024..0.024 rows=0 loops=1)

  • Index Cond: ("timestamp" >= (now() - '01:00:00'::interval))
200. 0.000 0.000 ↓ 0.0 0

Index Scan using multi_index on virtual_volume vvol_1 (cost=0.14..8.60 rows=1 width=96) (never executed)

  • Index Cond: (appliance_id = (smv_6.appliance_id)::text)
  • Filter: ((smv_6.datapath_vol_id)::text = datapath_id)
201. 0.007 0.078 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_3 (cost=6.34..1,934.36 rows=1 width=68) (actual time=0.078..0.078 rows=0 loops=1)

202. 0.034 0.071 ↓ 0.0 0 1

Hash Join (cost=6.34..1,934.35 rows=1 width=80) (actual time=0.071..0.071 rows=0 loops=1)

  • Hash Cond: ((internal_volume_6.datapath_vol_id = (smv_7.datapath_vol_id)::text) AND (internal_volume_6.appliance_id = (smv_7.appliance_id)::text))
203. 0.016 0.016 ↑ 24,000.0 1 1

Seq Scan on internal_volume internal_volume_6 (cost=0.00..1,748.00 rows=24,000 width=92) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (storage_type = 'BLOCK'::text)
204. 0.000 0.021 ↓ 0.0 0 1

Hash (cost=6.33..6.33 rows=1 width=71) (actual time=0.021..0.021 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
205. 0.021 0.021 ↓ 0.0 0 1

Index Scan using space_metrics_by_volume_pkey on space_metrics_by_volume smv_7 (cost=0.56..6.33 rows=1 width=71) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: ("timestamp" >= (now() - '01:00:00'::interval))
206. 0.000 0.000 ↓ 0.0 0

Sort (cost=1.34..1.41 rows=30 width=790) (never executed)

  • Sort Key: cte_7.volume_id, cte_7.appliance_id
207. 0.000 0.000 ↓ 0.0 0

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

208. 13,759.702 13,759.702 ↑ 1.0 100 1

CTE Scan on pg_source (cost=0.00..2.00 rows=100 width=1,403) (actual time=13,748.555..13,759.702 rows=100 loops=1)