explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M9fh

Settings
# exclusive inclusive rows x rows loops node
1. 12.447 805,208.729 ↓ 1.0 9,950 1

GroupAggregate (cost=130,979.47..131,249.41 rows=9,816 width=136) (actual time=805,194.883..805,208.729 rows=9,950 loops=1)

  • Group Key: lr.id
2. 11.974 805,196.282 ↓ 1.9 18,409 1

Sort (cost=130,979.47..131,004.01 rows=9,816 width=136) (actual time=805,194.870..805,196.282 rows=18,409 loops=1)

  • Sort Key: lr.id
  • Sort Method: quicksort Memory: 3056kB
3. 7.300 805,184.308 ↓ 1.9 18,409 1

Hash Right Join (cost=75,569.72..130,328.63 rows=9,816 width=136) (actual time=804,561.832..805,184.308 rows=18,409 loops=1)

  • Hash Cond: ("*SELECT* 1".storage_class_lr_id = lr.id)
4. 1.381 981.900 ↓ 1.9 16,517 1

Append (cost=29,290.51..83,919.87 rows=8,614 width=80) (actual time=366.605..981.900 rows=16,517 loops=1)

5. 1.461 372.114 ↓ 40.2 8,034 1

Subquery Scan on *SELECT* 1 (cost=29,290.51..29,295.51 rows=200 width=80) (actual time=366.604..372.114 rows=8,034 loops=1)

6. 29.548 370.653 ↓ 40.2 8,034 1

HashAggregate (cost=29,290.51..29,293.01 rows=200 width=52) (actual time=366.598..370.653 rows=8,034 loops=1)

  • Group Key: vdc_lr.id
7. 21.747 341.105 ↑ 1.0 53,654 1

Hash Left Join (cost=26,587.71..28,751.30 rows=53,921 width=89) (actual time=278.852..341.105 rows=53,654 loops=1)

  • Hash Cond: (vv.id = vav.id)
8. 30.484 285.003 ↑ 1.0 53,654 1

GroupAggregate (cost=20,796.05..22,278.88 rows=53,921 width=107) (actual time=244.430..285.003 rows=53,654 loops=1)

  • Group Key: vdc_lr.id, vv.id
9. 69.995 254.519 ↑ 1.0 53,654 1

Sort (cost=20,796.05..20,930.85 rows=53,921 width=59) (actual time=244.416..254.519 rows=53,654 loops=1)

  • Sort Key: vdc_lr.id, vv.id
  • Sort Method: external merge Disk: 3344kB
10. 12.402 184.524 ↑ 1.0 53,654 1

Hash Left Join (cost=9,956.51..14,528.25 rows=53,921 width=59) (actual time=97.601..184.524 rows=53,654 loops=1)

  • Hash Cond: ((vdc_lr.fo_id = sf_metrics.sclass_id) AND (vv.svm_id = sf_metrics.vm_id))
11. 36.107 171.794 ↑ 1.0 53,654 1

Hash Join (cost=9,940.05..14,107.37 rows=53,921 width=83) (actual time=97.247..171.794 rows=53,654 loops=1)

  • Hash Cond: (smetrics.vapp_vm_id = vv.id)
12. 27.722 87.900 ↑ 1.0 53,654 1

Hash Join (cost=3,672.40..6,168.16 rows=53,921 width=56) (actual time=48.130..87.900 rows=53,654 loops=1)

  • Hash Cond: (smetrics.storage_class_lr_id = vdc_lr.id)
13. 12.594 12.594 ↑ 1.0 53,654 1

Seq Scan on vapp_vm_sclass_metrics smetrics (cost=0.00..989.21 rows=53,921 width=40) (actual time=0.039..12.594 rows=53,654 loops=1)

14. 26.383 47.584 ↓ 1.0 76,170 1

Hash (cost=2,199.51..2,199.51 rows=76,151 width=32) (actual time=47.584..47.584 rows=76,170 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 2894kB
15. 21.201 21.201 ↓ 1.0 76,170 1

Seq Scan on vdc_logical_resource vdc_lr (cost=0.00..2,199.51 rows=76,151 width=32) (actual time=0.017..21.201 rows=76,170 loops=1)

16. 20.651 47.787 ↑ 1.0 53,654 1

Hash (cost=5,115.18..5,115.18 rows=54,118 width=43) (actual time=47.787..47.787 rows=53,654 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 2488kB
17. 27.136 27.136 ↑ 1.0 53,654 1

Seq Scan on vapp_vm vv (cost=0.00..5,115.18 rows=54,118 width=43) (actual time=0.014..27.136 rows=53,654 loops=1)

18. 0.004 0.328 ↑ 1.0 1 1

Hash (cost=16.45..16.45 rows=1 width=40) (actual time=0.328..0.328 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
19. 0.001 0.324 ↑ 1.0 1 1

Subquery Scan on sf_metrics (cost=16.41..16.45 rows=1 width=40) (actual time=0.323..0.324 rows=1 loops=1)

20. 0.005 0.323 ↑ 1.0 1 1

GroupAggregate (cost=16.41..16.44 rows=1 width=102) (actual time=0.322..0.323 rows=1 loops=1)

  • Group Key: sclass.id, v.id, snap.id
21. 0.070 0.318 ↑ 1.0 1 1

Sort (cost=16.41..16.42 rows=1 width=98) (actual time=0.317..0.318 rows=1 loops=1)

  • Sort Key: sclass.id, v.id, snap.id
  • Sort Method: quicksort Memory: 25kB
22. 0.004 0.248 ↑ 1.0 1 1

Nested Loop (cost=2.61..16.40 rows=1 width=98) (actual time=0.227..0.248 rows=1 loops=1)

23. 0.062 0.222 ↑ 1.0 1 1

Hash Join (cost=2.32..8.09 rows=1 width=82) (actual time=0.201..0.222 rows=1 loops=1)

  • Hash Cond: (sclass.id = sdisk.sclass_id)
24. 0.071 0.071 ↑ 1.0 201 1

Seq Scan on storage_class sclass (cost=0.00..5.01 rows=201 width=46) (actual time=0.032..0.071 rows=201 loops=1)

25. 0.004 0.089 ↑ 1.0 1 1

Hash (cost=2.31..2.31 rows=1 width=52) (actual time=0.088..0.089 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
26. 0.053 0.085 ↑ 1.0 1 1

Hash Join (cost=1.02..2.31 rows=1 width=52) (actual time=0.080..0.085 rows=1 loops=1)

  • Hash Cond: (snap.id = sdisk.vm_snapshot_id)
27. 0.010 0.010 ↑ 1.0 20 1

Seq Scan on vm_snapshot snap (cost=0.00..1.20 rows=20 width=32) (actual time=0.008..0.010 rows=20 loops=1)

28. 0.012 0.022 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=36) (actual time=0.021..0.022 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on vm_snapshot_disk sdisk (cost=0.00..1.01 rows=1 width=36) (actual time=0.010..0.010 rows=1 loops=1)

30. 0.022 0.022 ↑ 1.0 1 1

Index Scan using pk_vm on vm v (cost=0.29..8.31 rows=1 width=32) (actual time=0.021..0.022 rows=1 loops=1)

  • Index Cond: (id = snap.vm_id)
31. 15.226 34.355 ↑ 1.0 53,654 1

Hash (cost=5,115.18..5,115.18 rows=54,118 width=25) (actual time=34.355..34.355 rows=53,654 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3545kB
32. 19.129 19.129 ↑ 1.0 53,654 1

Seq Scan on vapp_vm vav (cost=0.00..5,115.18 rows=54,118 width=25) (actual time=0.013..19.129 rows=53,654 loops=1)

33. 1.527 578.935 ↓ 1.0 7,805 1

Subquery Scan on *SELECT* 2 (cost=53,048.59..53,240.57 rows=7,679 width=80) (actual time=574.072..578.935 rows=7,805 loops=1)

34. 28.345 577.408 ↓ 1.0 7,805 1

HashAggregate (cost=53,048.59..53,144.58 rows=7,679 width=56) (actual time=574.068..577.408 rows=7,805 loops=1)

  • Group Key: vv_1.storage_class_lr_id
35. 33.273 549.063 ↑ 1.0 52,785 1

Hash Join (cost=44,732.57..52,104.98 rows=53,921 width=57) (actual time=468.991..549.063 rows=52,785 loops=1)

  • Hash Cond: (vv_1.svm_id = svm.id)
36. 21.727 74.503 ↑ 1.0 53,654 1

Hash Left Join (cost=2,841.64..8,098.89 rows=54,118 width=36) (actual time=27.274..74.503 rows=53,654 loops=1)

  • Hash Cond: (vv_1.vapp_id = vapp.sg_id)
37. 26.344 26.344 ↑ 1.0 53,654 1

Seq Scan on vapp_vm vv_1 (cost=0.00..5,115.18 rows=54,118 width=48) (actual time=0.016..26.344 rows=53,654 loops=1)

38. 11.276 26.432 ↑ 1.0 53,173 1

Hash (cost=2,170.73..2,170.73 rows=53,673 width=20) (actual time=26.432..26.432 rows=53,173 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3213kB
39. 15.156 15.156 ↑ 1.0 53,173 1

Seq Scan on vm_container vapp (cost=0.00..2,170.73 rows=53,673 width=20) (actual time=0.014..15.156 rows=53,173 loops=1)

40. 13.061 441.287 ↑ 1.0 53,031 1

Hash (cost=40,689.92..40,689.92 rows=53,921 width=53) (actual time=441.287..441.287 rows=53,031 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 1874kB
41. 24.351 428.226 ↑ 1.0 53,031 1

Hash Right Join (cost=38,196.07..40,689.92 rows=53,921 width=53) (actual time=416.124..428.226 rows=53,031 loops=1)

  • Hash Cond: (vv_2.id = svm.id)
42. 26.974 252.766 ↑ 1.0 53,654 1

GroupAggregate (cost=20,610.55..21,823.77 rows=53,921 width=107) (actual time=216.312..252.766 rows=53,654 loops=1)

  • Group Key: vdc_lr_1.id, vv_2.id
43. 63.055 225.792 ↑ 1.0 53,654 1

Sort (cost=20,610.55..20,745.35 rows=53,921 width=51) (actual time=216.296..225.792 rows=53,654 loops=1)

  • Sort Key: vdc_lr_1.id, vv_2.id
  • Sort Method: external merge Disk: 3344kB
44. 11.546 162.737 ↑ 1.0 53,654 1

Hash Left Join (cost=9,956.51..14,528.25 rows=53,921 width=51) (actual time=81.381..162.737 rows=53,654 loops=1)

  • Hash Cond: ((vdc_lr_1.fo_id = sf_metrics_1.sclass_id) AND (vv_2.svm_id = sf_metrics_1.vm_id))
45. 35.001 151.033 ↑ 1.0 53,654 1

Hash Join (cost=9,940.05..14,107.37 rows=53,921 width=83) (actual time=81.200..151.033 rows=53,654 loops=1)

  • Hash Cond: (smetrics_1.vapp_vm_id = vv_2.id)
46. 26.433 73.772 ↑ 1.0 53,654 1

Hash Join (cost=3,672.40..6,168.16 rows=53,921 width=56) (actual time=38.666..73.772 rows=53,654 loops=1)

  • Hash Cond: (smetrics_1.storage_class_lr_id = vdc_lr_1.id)
47. 8.891 8.891 ↑ 1.0 53,654 1

Seq Scan on vapp_vm_sclass_metrics smetrics_1 (cost=0.00..989.21 rows=53,921 width=40) (actual time=0.014..8.891 rows=53,654 loops=1)

48. 21.524 38.448 ↓ 1.0 76,170 1

Hash (cost=2,199.51..2,199.51 rows=76,151 width=32) (actual time=38.448..38.448 rows=76,170 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 2894kB
49. 16.924 16.924 ↓ 1.0 76,170 1

Seq Scan on vdc_logical_resource vdc_lr_1 (cost=0.00..2,199.51 rows=76,151 width=32) (actual time=0.009..16.924 rows=76,170 loops=1)

50. 17.245 42.260 ↑ 1.0 53,654 1

Hash (cost=5,115.18..5,115.18 rows=54,118 width=43) (actual time=42.260..42.260 rows=53,654 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 2488kB
51. 25.015 25.015 ↑ 1.0 53,654 1

Seq Scan on vapp_vm vv_2 (cost=0.00..5,115.18 rows=54,118 width=43) (actual time=0.010..25.015 rows=53,654 loops=1)

52. 0.003 0.158 ↑ 1.0 1 1

Hash (cost=16.44..16.44 rows=1 width=32) (actual time=0.158..0.158 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
53. 0.002 0.155 ↑ 1.0 1 1

Subquery Scan on sf_metrics_1 (cost=16.41..16.44 rows=1 width=32) (actual time=0.154..0.155 rows=1 loops=1)

54. 0.003 0.153 ↑ 1.0 1 1

GroupAggregate (cost=16.41..16.43 rows=1 width=102) (actual time=0.153..0.153 rows=1 loops=1)

  • Group Key: sclass_1.id, v_1.id, snap_1.id
55. 0.015 0.150 ↑ 1.0 1 1

Sort (cost=16.41..16.42 rows=1 width=94) (actual time=0.150..0.150 rows=1 loops=1)

  • Sort Key: sclass_1.id, v_1.id, snap_1.id
  • Sort Method: quicksort Memory: 25kB
56. 0.003 0.135 ↑ 1.0 1 1

Nested Loop (cost=2.61..16.40 rows=1 width=94) (actual time=0.124..0.135 rows=1 loops=1)

57. 0.048 0.113 ↑ 1.0 1 1

Hash Join (cost=2.32..8.09 rows=1 width=78) (actual time=0.102..0.113 rows=1 loops=1)

  • Hash Cond: (sclass_1.id = sdisk_1.sclass_id)
58. 0.030 0.030 ↑ 1.0 201 1

Seq Scan on storage_class sclass_1 (cost=0.00..5.01 rows=201 width=46) (actual time=0.010..0.030 rows=201 loops=1)

59. 0.003 0.035 ↑ 1.0 1 1

Hash (cost=2.31..2.31 rows=1 width=48) (actual time=0.035..0.035 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
60. 0.016 0.032 ↑ 1.0 1 1

Hash Join (cost=1.02..2.31 rows=1 width=48) (actual time=0.027..0.032 rows=1 loops=1)

  • Hash Cond: (snap_1.id = sdisk_1.vm_snapshot_id)
61. 0.007 0.007 ↑ 1.0 20 1

Seq Scan on vm_snapshot snap_1 (cost=0.00..1.20 rows=20 width=32) (actual time=0.005..0.007 rows=20 loops=1)

62. 0.003 0.009 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=32) (actual time=0.009..0.009 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
63. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on vm_snapshot_disk sdisk_1 (cost=0.00..1.01 rows=1 width=32) (actual time=0.005..0.006 rows=1 loops=1)

64. 0.019 0.019 ↑ 1.0 1 1

Index Scan using pk_vm on vm v_1 (cost=0.29..8.31 rows=1 width=32) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (id = snap_1.vm_id)
65. 17.122 151.109 ↑ 1.0 53,031 1

Hash (cost=16,919.40..16,919.40 rows=53,290 width=21) (actual time=151.109..151.109 rows=53,031 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3226kB
66. 38.835 133.987 ↑ 1.0 53,031 1

Hash Left Join (cost=12,704.73..16,919.40 rows=53,290 width=21) (actual time=74.357..133.987 rows=53,031 loops=1)

  • Hash Cond: ((svm.vc_id = vm_inv.vc_id) AND ((svm.moref)::text = (vm_inv.moref)::text))
67. 21.331 21.331 ↑ 1.0 53,031 1

Seq Scan on vm svm (cost=0.00..2,702.90 rows=53,290 width=40) (actual time=0.011..21.331 rows=53,031 loops=1)

68. 21.893 73.821 ↑ 1.0 58,149 1

Hash (cost=11,434.49..11,434.49 rows=58,149 width=29) (actual time=73.821..73.821 rows=58,149 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 2250kB
69. 51.928 51.928 ↑ 1.0 58,149 1

Seq Scan on vm_inv (cost=0.00..11,434.49 rows=58,149 width=29) (actual time=0.012..51.928 rows=58,149 loops=1)

70. 0.131 29.470 ↑ 1.1 678 1

Subquery Scan on *SELECT* 3 (cost=1,365.42..1,383.80 rows=735 width=80) (actual time=29.116..29.470 rows=678 loops=1)

71. 3.189 29.339 ↑ 1.1 678 1

HashAggregate (cost=1,365.42..1,374.61 rows=735 width=52) (actual time=29.112..29.339 rows=678 loops=1)

  • Group Key: ldisk_storage_class_join.storage_class_id
72. 2.588 26.150 ↓ 6.4 4,682 1

Hash Right Join (cost=1,091.28..1,358.07 rows=735 width=24) (actual time=21.683..26.150 rows=4,682 loops=1)

  • Hash Cond: (ldisk_storage_class_join.logical_disk_id = logical_disk.id)
73. 1.947 1.947 ↑ 1.0 12,250 1

Seq Scan on ldisk_storage_class_join (cost=0.00..213.50 rows=12,250 width=32) (actual time=0.029..1.947 rows=12,250 loops=1)

74. 1.247 21.615 ↓ 6.4 4,682 1

Hash (cost=1,082.10..1,082.10 rows=735 width=24) (actual time=21.615..21.615 rows=4,682 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 321kB
75. 4.413 20.368 ↓ 6.4 4,682 1

Hash Right Join (cost=714.90..1,082.10 rows=735 width=24) (actual time=11.022..20.368 rows=4,682 loops=1)

  • Hash Cond: (ldisk_fo_join.logical_disk_id = logical_disk.id)
  • Filter: (((logical_disk.logical_disk_type)::text = ANY ('{CDROM,FLOPPY}'::text[])) OR (((logical_disk.logical_disk_type)::bpchar = 'DISK'::bpchar) AND (vm_disk.id IS NULL)))
  • Rows Removed by Filter: 7568
76. 3.579 9.222 ↑ 1.0 12,244 1

Hash Left Join (cost=249.28..584.32 rows=12,244 width=32) (actual time=4.177..9.222 rows=12,244 loops=1)

  • Hash Cond: (ldisk_fo_join.fo_id = vm_disk.disk_id)
77. 1.649 1.649 ↑ 1.0 12,244 1

Seq Scan on ldisk_fo_join (cost=0.00..213.44 rows=12,244 width=32) (actual time=0.011..1.649 rows=12,244 loops=1)

78. 2.529 3.994 ↑ 1.0 7,568 1

Hash (cost=154.68..154.68 rows=7,568 width=32) (actual time=3.994..3.994 rows=7,568 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 537kB
79. 1.465 1.465 ↑ 1.0 7,568 1

Seq Scan on vm_disk (cost=0.00..154.68 rows=7,568 width=32) (actual time=0.011..1.465 rows=7,568 loops=1)

80. 3.472 6.733 ↑ 1.0 12,250 1

Hash (cost=312.50..312.50 rows=12,250 width=29) (actual time=6.732..6.733 rows=12,250 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 859kB
81. 3.261 3.261 ↑ 1.0 12,250 1

Seq Scan on logical_disk (cost=0.00..312.50 rows=12,250 width=29) (actual time=0.025..3.261 rows=12,250 loops=1)

82. 4.217 804,195.108 ↓ 1.0 9,950 1

Hash (cost=46,156.51..46,156.51 rows=9,816 width=72) (actual time=804,195.108..804,195.108 rows=9,950 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 857kB
83. 4.058 804,190.891 ↓ 1.0 9,950 1

Hash Right Join (cost=45,909.89..46,156.51 rows=9,816 width=72) (actual time=804,180.066..804,190.891 rows=9,950 loops=1)

  • Hash Cond: (ov_sp.id = lr.id)
84. 152.926 804,169.481 ↓ 1.0 9,950 1

HashAggregate (cost=43,793.99..43,916.69 rows=9,816 width=92) (actual time=804,162.619..804,169.481 rows=9,950 loops=1)

  • Group Key: ov_sp.id
85. 73.321 804,016.555 ↓ 6.9 67,271 1

Hash Left Join (cost=38,578.13..43,695.83 rows=9,816 width=100) (actual time=123,546.691..804,016.555 rows=67,271 loops=1)

  • Hash Cond: ((ov_sp.vdc_id = logical_disk_1.org_vdc_id) AND (ov_sp.id = ldisk_storage_class_join_1.storage_class_id) AND ((ov_sp.name)::text = (vdc_logical_resource.name)::text))
86. 303,796.824 803,854.709 ↓ 6.4 62,884 1

Nested Loop Left Join (cost=37,727.88..42,735.14 rows=9,816 width=92) (actual time=123,458.138..803,854.709 rows=62,884 loops=1)

  • Join Filter: ((vm_container.org_vdc_id = ov_sp.vdc_id) AND (("*SELECT* 1_2".name)::text = (ov_sp.name)::text))
  • Rows Removed by Join Filter: 2854705386
87. 70.385 70.385 ↓ 1.0 9,950 1

Seq Scan on vdc_logical_resource ov_sp (cost=0.00..2,389.89 rows=9,816 width=60) (actual time=0.011..70.385 rows=9,950 loops=1)

  • Filter: ((lr_type)::bpchar = 'STORAGE_CLASS'::bpchar)
  • Rows Removed by Filter: 66220
88. 376,702.520 499,987.500 ↓ 286,911.0 286,911 9,950

Materialize (cost=37,727.88..40,173.47 rows=1 width=314) (actual time=0.206..50.250 rows=286,911 loops=9,950)

89. 907.444 123,284.980 ↓ 286,911.0 286,911 1

Nested Loop (cost=37,727.88..40,173.47 rows=1 width=314) (actual time=2,007.327..123,284.980 rows=286,911 loops=1)

  • Join Filter: (("*SELECT* 1_2".name)::text = (pvdc_lr.name)::text)
  • Rows Removed by Join Filter: 5143751
90. 498.448 117,994.516 ↓ 876,604.0 876,604 1

Nested Loop (cost=37,723.56..40,160.63 rows=1 width=330) (actual time=2,007.295..117,994.516 rows=876,604 loops=1)

91. 681.026 115,742.860 ↓ 876,604.0 876,604 1

Nested Loop (cost=37,723.27..40,160.19 rows=1 width=330) (actual time=2,007.272..115,742.860 rows=876,604 loops=1)

92. 51,394.452 113,308.586 ↓ 876,624.0 876,624 1

Nested Loop (cost=37,722.98..40,159.51 rows=1 width=330) (actual time=2,007.229..113,308.586 rows=876,624 loops=1)

  • Join Filter: (("*SELECT* 1_1".vc_id = "*SELECT* 1_2".vc_id) AND (("*SELECT* 1_1".moref)::text = ("*SELECT* 1_2".ds_pod_moref)::text))
  • Rows Removed by Join Filter: 423258605
93. 2.004 42.863 ↓ 2.1 4,067 1

Append (cost=161.97..629.74 rows=1,974 width=296) (actual time=2.365..42.863 rows=4,067 loops=1)

94. 4.046 33.855 ↓ 50.2 3,061 1

Subquery Scan on *SELECT* 1_2 (cost=161.97..469.48 rows=61 width=60) (actual time=2.364..33.855 rows=3,061 loops=1)

95. 13.123 29.809 ↓ 50.2 3,061 1

Hash Join (cost=161.97..468.87 rows=61 width=60) (actual time=2.362..29.809 rows=3,061 loops=1)

  • Hash Cond: ((dprof_inv.vc_id = sprof_inv.vc_id) AND ((dprof_inv.profile_moref)::text = (sprof_inv.moref)::text))
96. 10.179 16.308 ↓ 63.8 3,061 1

Hash Join (cost=138.15..437.59 rows=48 width=83) (actual time=1.921..16.308 rows=3,061 loops=1)

  • Hash Cond: ((ds_inv.vc_id = dprof_inv.vc_id) AND ((ds_inv.moref)::text = (dprof_inv.datastore_or_pod_moref)::text))
97. 0.502 4.252 ↑ 1.9 1,006 1

Append (cost=0.00..160.27 rows=1,913 width=30) (actual time=0.010..4.252 rows=1,006 loops=1)

98. 3.676 3.676 ↑ 1.9 1,000 1

Seq Scan on datastore_inv ds_inv (cost=0.00..138.14 rows=1,868 width=30) (actual time=0.009..3.676 rows=1,000 loops=1)

  • Filter: (parent_type = 1)
  • Rows Removed by Filter: 34
99. 0.074 0.074 ↑ 7.5 6 1

Seq Scan on storage_pod_inv spod_inv_1 (cost=0.00..3.45 rows=45 width=26) (actual time=0.019..0.074 rows=6 loops=1)

100. 0.981 1.877 ↓ 1.0 3,167 1

Hash (cost=90.66..90.66 rows=3,166 width=67) (actual time=1.877..1.877 rows=3,167 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 340kB
101. 0.896 0.896 ↓ 1.0 3,167 1

Seq Scan on datastore_profile_inv dprof_inv (cost=0.00..90.66 rows=3,166 width=67) (actual time=0.012..0.896 rows=3,167 loops=1)

102. 0.206 0.378 ↓ 1.1 586 1

Hash (cost=15.53..15.53 rows=553 width=83) (actual time=0.378..0.378 rows=586 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 75kB
103. 0.172 0.172 ↓ 1.1 586 1

Seq Scan on storage_profile_inv sprof_inv (cost=0.00..15.53 rows=553 width=83) (actual time=0.015..0.172 rows=586 loops=1)

104. 2.027 6.942 ↑ 1.9 1,000 1

Subquery Scan on *SELECT* 1_3 (cost=0.00..156.82 rows=1,868 width=304) (actual time=0.019..6.942 rows=1,000 loops=1)

105. 4.915 4.915 ↑ 1.9 1,000 1

Seq Scan on datastore_inv ds_inv_1 (cost=0.00..138.14 rows=1,868 width=30) (actual time=0.017..4.915 rows=1,000 loops=1)

  • Filter: (parent_type = 1)
  • Rows Removed by Filter: 34
106. 0.062 0.062 ↑ 7.5 6 1

Seq Scan on storage_pod_inv spod_inv (cost=0.00..3.45 rows=45 width=300) (actual time=0.015..0.062 rows=6 loops=1)

107. 61,004.590 61,871.271 ↓ 34,762.3 104,287 4,067

Materialize (cost=37,561.01..39,426.14 rows=3 width=384) (actual time=0.194..15.213 rows=104,287 loops=4,067)

108. 46.828 866.681 ↓ 34,762.3 104,287 1

Merge Join (cost=37,561.01..39,426.12 rows=3 width=384) (actual time=774.160..866.681 rows=104,287 loops=1)

  • Merge Cond: (((COALESCE(sr_union.dstore_moref, v_2.dstore_moref)))::text = ("*SELECT* 1_1".moref)::text)
  • Join Filter: (v_2.vc_id = "*SELECT* 1_1".vc_id)
  • Rows Removed by Join Filter: 83428
109. 24.265 594.544 ↑ 1.1 48,015 1

GroupAggregate (cost=36,904.22..38,097.26 rows=53,024 width=370) (actual time=560.635..594.544 rows=48,015 loops=1)

  • Group Key: (COALESCE(sr_union.dstore_moref, v_2.dstore_moref)), v_2.id
110. 254.285 570.279 ↑ 1.1 48,016 1

Sort (cost=36,904.22..37,036.78 rows=53,024 width=314) (actual time=560.612..570.279 rows=48,016 loops=1)

  • Sort Key: (COALESCE(sr_union.dstore_moref, v_2.dstore_moref)), v_2.id
  • Sort Method: external merge Disk: 3104kB
111. 45.094 315.994 ↑ 1.1 48,016 1

Hash Right Join (cost=21,095.36..24,948.83 rows=53,024 width=314) (actual time=203.841..315.994 rows=48,016 loops=1)

  • Hash Cond: (sr_union.vm_id = v_2.id)
  • Filter: (COALESCE(sr_union.dstore_moref, v_2.dstore_moref) IS NOT NULL)
  • Rows Removed by Filter: 5858
112. 6.927 222.552 ↓ 2.8 47,518 1

Subquery Scan on sr_union (cost=17,257.33..19,224.86 rows=17,123 width=298) (actual time=155.046..222.552 rows=47,518 loops=1)

113. 5.087 215.625 ↓ 2.8 47,518 1

Append (cost=17,257.33..19,053.63 rows=17,123 width=322) (actual time=155.045..215.625 rows=47,518 loops=1)

114. 6.311 210.363 ↓ 2.8 47,517 1

Subquery Scan on *SELECT* 1_4 (cost=17,257.33..19,040.75 rows=17,122 width=62) (actual time=155.043..210.363 rows=47,517 loops=1)

115. 40.345 204.052 ↓ 2.8 47,517 1

Hash Join (cost=17,257.33..18,826.72 rows=17,122 width=58) (actual time=155.041..204.052 rows=47,517 loops=1)

  • Hash Cond: (mi.vm_inv_id = vi.vm_inv_id)
116. 8.857 8.857 ↓ 1.1 58,969 1

Seq Scan on vm_dstore_metrics_inv mi (cost=0.00..1,189.76 rows=55,576 width=42) (actual time=0.019..8.857 rows=58,969 loops=1)

117. 17.505 154.850 ↓ 2.6 46,675 1

Hash (cost=17,033.40..17,033.40 rows=17,915 width=48) (actual time=154.850..154.850 rows=46,675 loops=1)

  • Buckets: 65536 (originally 32768) Batches: 2 (originally 1) Memory Usage: 3585kB
118. 36.854 137.345 ↓ 2.6 46,675 1

Hash Join (cost=12,761.73..17,033.40 rows=17,915 width=48) (actual time=80.456..137.345 rows=46,675 loops=1)

  • Hash Cond: ((v_3.vc_id = vi.vc_id) AND ((v_3.moref)::text = (vi.moref)::text))
119. 20.340 20.340 ↑ 1.0 53,031 1

Seq Scan on vm v_3 (cost=0.00..2,702.90 rows=53,290 width=40) (actual time=0.008..20.340 rows=53,031 loops=1)

120. 23.475 80.151 ↑ 1.0 58,149 1

Hash (cost=11,434.49..11,434.49 rows=58,149 width=40) (actual time=80.151..80.151 rows=58,149 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 2560kB
121. 56.676 56.676 ↑ 1.0 58,149 1

Seq Scan on vm_inv vi (cost=0.00..11,434.49 rows=58,149 width=40) (actual time=0.035..56.676 rows=58,149 loops=1)

122. 0.001 0.175 ↑ 1.0 1 1

Subquery Scan on *SELECT* 2_2 (cost=12.83..12.88 rows=1 width=62) (actual time=0.175..0.175 rows=1 loops=1)

123. 0.001 0.174 ↑ 1.0 1 1

Subquery Scan on vmsn (cost=12.83..12.86 rows=1 width=58) (actual time=0.174..0.174 rows=1 loops=1)

124. 0.007 0.173 ↑ 1.0 1 1

GroupAggregate (cost=12.83..12.85 rows=1 width=86) (actual time=0.173..0.173 rows=1 loops=1)

  • Group Key: ds.moref, v_4.id, snap_2.id
125. 0.023 0.166 ↑ 1.0 1 1

Sort (cost=12.83..12.83 rows=1 width=82) (actual time=0.166..0.166 rows=1 loops=1)

  • Sort Key: ds.moref, v_4.id, snap_2.id
  • Sort Method: quicksort Memory: 25kB
126. 0.005 0.143 ↑ 1.0 1 1

Nested Loop (cost=1.59..12.82 rows=1 width=82) (actual time=0.137..0.143 rows=1 loops=1)

  • Join Filter: ((sdisk_2.dstore_moref)::text = (ds.moref)::text)
  • Rows Removed by Join Filter: 4
127. 0.005 0.091 ↑ 1.0 1 1

Nested Loop (cost=1.31..10.62 rows=1 width=81) (actual time=0.085..0.091 rows=1 loops=1)

128. 0.015 0.059 ↑ 1.0 1 1

Hash Join (cost=1.02..2.31 rows=1 width=49) (actual time=0.054..0.059 rows=1 loops=1)

  • Hash Cond: (snap_2.id = sdisk_2.vm_snapshot_id)
129. 0.024 0.024 ↑ 1.0 20 1

Seq Scan on vm_snapshot snap_2 (cost=0.00..1.20 rows=20 width=32) (actual time=0.021..0.024 rows=20 loops=1)

130. 0.004 0.020 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=33) (actual time=0.020..0.020 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
131. 0.016 0.016 ↑ 1.0 1 1

Seq Scan on vm_snapshot_disk sdisk_2 (cost=0.00..1.01 rows=1 width=33) (actual time=0.016..0.016 rows=1 loops=1)

132. 0.027 0.027 ↑ 1.0 1 1

Index Scan using pk_vm on vm v_4 (cost=0.29..8.31 rows=1 width=48) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: (id = snap_2.vm_id)
133. 0.047 0.047 ↑ 12.8 5 1

Index Only Scan using uq_dsinv_vc_id_moref on datastore_inv ds (cost=0.28..1.40 rows=64 width=30) (actual time=0.043..0.047 rows=5 loops=1)

  • Index Cond: (vc_id = v_4.vc_id)
  • Heap Fetches: 4
134. 17.522 48.348 ↑ 1.0 53,031 1

Hash (cost=2,702.90..2,702.90 rows=53,290 width=46) (actual time=48.348..48.348 rows=53,031 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 2503kB
135. 30.826 30.826 ↑ 1.0 53,031 1

Seq Scan on vm v_2 (cost=0.00..2,702.90 rows=53,290 width=46) (actual time=0.024..30.826 rows=53,031 loops=1)

136. 21.170 225.309 ↓ 94,481.5 188,963 1

Sort (cost=656.79..656.80 rows=2 width=46) (actual time=213.489..225.309 rows=188,963 loops=1)

  • Sort Key: "*SELECT* 1_1".moref
  • Sort Method: quicksort Memory: 194kB
137. 0.155 204.139 ↓ 928.0 1,856 1

Append (cost=396.60..656.78 rows=2 width=46) (actual time=121.635..204.139 rows=1,856 loops=1)

138. 0.201 123.066 ↓ 1,826.0 1,826 1

Subquery Scan on *SELECT* 1_1 (cost=396.60..396.62 rows=1 width=46) (actual time=121.633..123.066 rows=1,826 loops=1)

139. 0.850 122.865 ↓ 1,826.0 1,826 1

Group (cost=396.60..396.61 rows=1 width=62) (actual time=121.632..122.865 rows=1,826 loops=1)

  • Group Key: pvdc_lr_1.prov_vdc_id, ds_1.datastore_id
140. 4.904 122.015 ↓ 6,264.0 6,264 1

Sort (cost=396.60..396.61 rows=1 width=62) (actual time=121.629..122.015 rows=6,264 loops=1)

  • Sort Key: pvdc_lr_1.prov_vdc_id, ds_1.datastore_id
  • Sort Method: quicksort Memory: 1073kB
141. 4.144 117.111 ↓ 6,264.0 6,264 1

Nested Loop (cost=34.86..396.59 rows=1 width=62) (actual time=0.696..117.111 rows=6,264 loops=1)

  • Join Filter: ((rpi.vc_id = dsi.vc_id) AND ((ds_1.moref)::text = (dsi.moref)::text))
142. 4.019 81.647 ↓ 6,264.0 6,264 1

Nested Loop (cost=34.58..396.09 rows=1 width=140) (actual time=0.670..81.647 rows=6,264 loops=1)

  • Join Filter: (pvdc_lr_1.fo_id = chs.id)
143. 2.238 71.364 ↓ 6,264.0 6,264 1

Nested Loop (cost=34.44..395.84 rows=1 width=172) (actual time=0.641..71.364 rows=6,264 loops=1)

  • Join Filter: (rpi.vc_id = ds_1.vc_id)
144. 4.083 25.886 ↓ 508.7 8,648 1

Nested Loop (cost=34.16..389.89 rows=17 width=126) (actual time=0.611..25.886 rows=8,648 loops=1)

  • Join Filter: (rpi.vc_id = msdi.vc_id)
145. 0.615 9.317 ↓ 33.6 2,081 1

Nested Loop (cost=33.88..365.69 rows=62 width=104) (actual time=0.573..9.317 rows=2,081 loops=1)

146. 0.277 4.552 ↓ 20.8 166 1

Nested Loop (cost=33.60..361.30 rows=8 width=91) (actual time=0.536..4.552 rows=166 loops=1)

147. 0.196 0.747 ↓ 4.3 168 1

Hash Join (cost=33.19..40.21 rows=39 width=77) (actual time=0.483..0.747 rows=168 loops=1)

  • Hash Cond: (vc_ch.id = chs_ch.computehub_id)
148. 0.104 0.104 ↑ 1.5 175 1

Seq Scan on vc_computehub vc_ch (cost=0.00..5.64 rows=264 width=45) (actual time=0.024..0.104 rows=175 loops=1)

149. 0.044 0.447 ↓ 4.3 168 1

Hash (cost=32.70..32.70 rows=39 width=64) (actual time=0.447..0.447 rows=168 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
150. 0.076 0.403 ↓ 4.3 168 1

Merge Join (cost=30.91..32.70 rows=39 width=64) (actual time=0.319..0.403 rows=168 loops=1)

  • Merge Cond: (pvdc_lr_1.fo_id = chs_ch.computehub_set_id)
151. 0.050 0.223 ↑ 1.1 105 1

Sort (cost=20.96..21.24 rows=112 width=32) (actual time=0.215..0.223 rows=105 loops=1)

  • Sort Key: pvdc_lr_1.fo_id
  • Sort Method: quicksort Memory: 33kB
152. 0.173 0.173 ↑ 1.1 105 1

Seq Scan on prov_vdc_logical_resource pvdc_lr_1 (cost=0.00..17.15 rows=112 width=32) (actual time=0.012..0.173 rows=105 loops=1)

  • Filter: ((lr_type)::text = 'COMPUTE_HUB_SET'::text)
  • Rows Removed by Filter: 465
153. 0.066 0.104 ↑ 1.0 168 1

Sort (cost=9.94..10.37 rows=169 width=32) (actual time=0.092..0.104 rows=168 loops=1)

  • Sort Key: chs_ch.computehub_set_id
  • Sort Method: quicksort Memory: 38kB
154. 0.038 0.038 ↑ 1.0 168 1

Seq Scan on computehub_set_computehub chs_ch (cost=0.00..3.69 rows=169 width=32) (actual time=0.013..0.038 rows=168 loops=1)

155. 3.528 3.528 ↑ 1.0 1 168

Index Scan using uq_rpinv_vc_id_moref on resource_pool_inv rpi (cost=0.41..8.23 rows=1 width=41) (actual time=0.021..0.021 rows=1 loops=168)

  • Index Cond: ((vc_id = vc_ch.vc_id) AND ((moref)::text = (vc_ch.rp_moref)::text))
156. 4.150 4.150 ↓ 4.3 13 166

Index Scan using ix_ms_inv_vc_id_cr_moref on managed_server_inv msi (cost=0.28..0.52 rows=3 width=35) (actual time=0.007..0.025 rows=13 loops=166)

  • Index Cond: ((vc_id = rpi.vc_id) AND ((cr_moref)::text = (rpi.cr_moref)::text))
157. 12.486 12.486 ↓ 4.0 4 2,081

Index Scan using ix_ms_ds_inv_ms on managed_server_datastore_inv msdi (cost=0.28..0.38 rows=1 width=38) (actual time=0.005..0.006 rows=4 loops=2,081)

  • Index Cond: ((vc_id = msi.vc_id) AND ((host_moref)::text = (msi.moref)::text))
158. 43.240 43.240 ↑ 1.0 1 8,648

Index Scan using ix_datastore_vc_id_moref on datastore ds_1 (cost=0.28..0.34 rows=1 width=46) (actual time=0.004..0.005 rows=1 loops=8,648)

  • Index Cond: ((vc_id = msdi.vc_id) AND ((moref)::text = (msdi.datastore_moref)::text))
159. 6.264 6.264 ↑ 1.0 1 6,264

Index Only Scan using computehub_set_pk on computehub_set chs (cost=0.14..0.23 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=6,264)

  • Index Cond: (id = chs_ch.computehub_set_id)
  • Heap Fetches: 6264
160. 31.320 31.320 ↑ 1.0 1 6,264

Index Scan using uq_dsinv_vc_id_moref on datastore_inv dsi (cost=0.28..0.49 rows=1 width=30) (actual time=0.005..0.005 rows=1 loops=6,264)

  • Index Cond: ((vc_id = msdi.vc_id) AND ((moref)::text = (msdi.datastore_moref)::text))
  • Filter: (parent_type <> 2)
161. 0.005 80.918 ↓ 30.0 30 1

Subquery Scan on *SELECT* 2_1 (cost=260.14..260.16 rows=1 width=46) (actual time=80.513..80.918 rows=30 loops=1)

162. 0.267 80.913 ↓ 30.0 30 1

Group (cost=260.14..260.15 rows=1 width=62) (actual time=80.512..80.913 rows=30 loops=1)

  • Group Key: pvdc_lr_2.prov_vdc_id, ds_2.datastore_id
163. 1.806 80.646 ↓ 2,384.0 2,384 1

Sort (cost=260.14..260.14 rows=1 width=62) (actual time=80.508..80.646 rows=2,384 loops=1)

  • Sort Key: pvdc_lr_2.prov_vdc_id, ds_2.datastore_id
  • Sort Method: quicksort Memory: 432kB
164. 5.777 78.840 ↓ 2,384.0 2,384 1

Nested Loop (cost=228.80..260.13 rows=1 width=62) (actual time=1.722..78.840 rows=2,384 loops=1)

  • Join Filter: ((dsi_1.parent_moref)::text = (ds_2.moref)::text)
  • Rows Removed by Join Filter: 17904
165. 1.576 63.527 ↓ 2,384.0 2,384 1

Nested Loop (cost=228.52..258.52 rows=1 width=105) (actual time=1.698..63.527 rows=2,384 loops=1)

  • Join Filter: (pvdc_lr_2.fo_id = chs_1.id)
166. 4.218 59.567 ↓ 2,384.0 2,384 1

Nested Loop (cost=228.38..258.28 rows=1 width=137) (actual time=1.679..59.567 rows=2,384 loops=1)

  • Join Filter: ((msi_1.cr_moref)::text = (rpi_1.cr_moref)::text)
  • Rows Removed by Join Filter: 1200
167. 0.566 15.925 ↓ 1,792.0 3,584 1

Nested Loop (cost=227.97..241.78 rows=2 width=145) (actual time=1.619..15.925 rows=3,584 loops=1)

168. 1.914 8.191 ↓ 512.0 3,584 1

Nested Loop (cost=227.69..237.16 rows=7 width=113) (actual time=1.593..8.191 rows=3,584 loops=1)

169. 1.083 2.693 ↓ 298.7 3,584 1

Hash Join (cost=227.55..234.49 rows=12 width=113) (actual time=1.575..2.693 rows=3,584 loops=1)

  • Hash Cond: (vc_ch_1.vc_id = msi_1.vc_id)
170. 0.058 0.058 ↑ 1.5 175 1

Seq Scan on vc_computehub vc_ch_1 (cost=0.00..5.64 rows=264 width=45) (actual time=0.012..0.058 rows=175 loops=1)

171. 0.036 1.552 ↓ 32.0 96 1

Hash (cost=227.51..227.51 rows=3 width=68) (actual time=1.552..1.552 rows=96 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
172. 0.099 1.516 ↓ 32.0 96 1

Nested Loop (cost=138.75..227.51 rows=3 width=68) (actual time=0.786..1.516 rows=96 loops=1)

173. 0.487 1.129 ↓ 16.0 96 1

Hash Join (cost=138.47..221.69 rows=6 width=49) (actual time=0.729..1.129 rows=96 loops=1)

  • Hash Cond: ((msdi_1.vc_id = dsi_1.vc_id) AND ((msdi_1.datastore_moref)::text = (dsi_1.moref)::text))
174. 0.343 0.343 ↑ 1.0 2,769 1

Seq Scan on managed_server_datastore_inv msdi_1 (cost=0.00..68.69 rows=2,769 width=38) (actual time=0.006..0.343 rows=2,769 loops=1)

175. 0.007 0.299 ↑ 1.8 12 1

Hash (cost=138.14..138.14 rows=22 width=39) (actual time=0.299..0.299 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
176. 0.292 0.292 ↑ 1.8 12 1

Seq Scan on datastore_inv dsi_1 (cost=0.00..138.14 rows=22 width=39) (actual time=0.018..0.292 rows=12 loops=1)

  • Filter: (parent_type = 2)
  • Rows Removed by Filter: 1022
177. 0.288 0.288 ↑ 1.0 1 96

Index Scan using uq_msinv_vc_id_moref on managed_server_inv msi_1 (cost=0.28..0.97 rows=1 width=35) (actual time=0.003..0.003 rows=1 loops=96)

  • Index Cond: ((vc_id = msdi_1.vc_id) AND ((moref)::text = (msdi_1.host_moref)::text))
178. 3.584 3.584 ↑ 1.0 1 3,584

Index Scan using computehub_unique on computehub_set_computehub chs_ch_1 (cost=0.14..0.22 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=3,584)

  • Index Cond: (computehub_id = vc_ch_1.id)
179. 7.168 7.168 ↑ 1.0 1 3,584

Index Scan using ix_pvdc_lr_foid on prov_vdc_logical_resource pvdc_lr_2 (cost=0.28..0.65 rows=1 width=32) (actual time=0.001..0.002 rows=1 loops=3,584)

  • Index Cond: (fo_id = chs_ch_1.computehub_set_id)
  • Filter: ((lr_type)::text = 'COMPUTE_HUB_SET'::text)
180. 39.424 39.424 ↑ 1.0 1 3,584

Index Scan using uq_rpinv_vc_id_moref on resource_pool_inv rpi_1 (cost=0.41..8.23 rows=1 width=41) (actual time=0.010..0.011 rows=1 loops=3,584)

  • Index Cond: ((vc_id = vc_ch_1.vc_id) AND ((moref)::text = (vc_ch_1.rp_moref)::text))
181. 2.384 2.384 ↑ 1.0 1 2,384

Index Only Scan using computehub_set_pk on computehub_set chs_1 (cost=0.14..0.23 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=2,384)

  • Index Cond: (id = chs_ch_1.computehub_set_id)
  • Heap Fetches: 2384
182. 9.536 9.536 ↑ 4.9 9 2,384

Index Scan using ix_datastore_vc_id_moref on datastore ds_2 (cost=0.28..1.06 rows=44 width=46) (actual time=0.002..0.004 rows=9 loops=2,384)

  • Index Cond: (vc_id = rpi_1.vc_id)
183. 1,753.248 1,753.248 ↑ 1.0 1 876,624

Index Scan using ix_vapp_vm_svm_id on vapp_vm (cost=0.29..0.67 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=876,624)

  • Index Cond: (svm_id = v_2.id)
184. 1,753.208 1,753.208 ↑ 1.0 1 876,604

Index Scan using vm_container_pk on vm_container (cost=0.29..0.44 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=876,604)

  • Index Cond: (sg_id = vapp_vm.vapp_id)
185. 2,629.812 4,383.020 ↓ 2.0 6 876,604

Bitmap Heap Scan on prov_vdc_logical_resource pvdc_lr (cost=4.31..12.80 rows=3 width=43) (actual time=0.003..0.005 rows=6 loops=876,604)

  • Recheck Cond: (prov_vdc_id = "*SELECT* 1_1".prov_vdc_id)
  • Filter: ((lr_type)::text = 'STORAGE_CLASS'::text)
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=1457729
186. 1,753.208 1,753.208 ↓ 1.6 8 876,604

Bitmap Index Scan on ix_pvdc_lr_pvdc (cost=0.00..4.31 rows=5 width=0) (actual time=0.002..0.002 rows=8 loops=876,604)

  • Index Cond: (prov_vdc_id = "*SELECT* 1_1".prov_vdc_id)
187. 1.247 88.525 ↓ 2,273.0 2,273 1

Hash (cost=850.24..850.24 rows=1 width=57) (actual time=88.525..88.525 rows=2,273 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 240kB
188. 0.540 87.278 ↓ 2,273.0 2,273 1

Nested Loop (cost=586.43..850.24 rows=1 width=57) (actual time=8.988..87.278 rows=2,273 loops=1)

189. 0.991 75.373 ↓ 2,273.0 2,273 1

Nested Loop Left Join (cost=586.01..849.24 rows=1 width=40) (actual time=8.927..75.373 rows=2,273 loops=1)

190. 1.288 69.836 ↓ 2,273.0 2,273 1

Nested Loop (cost=585.73..848.78 rows=1 width=56) (actual time=8.915..69.836 rows=2,273 loops=1)

191. 1.306 61.729 ↓ 2,273.0 2,273 1

Nested Loop (cost=585.44..848.39 rows=1 width=56) (actual time=8.896..61.729 rows=2,273 loops=1)

192. 2.856 48.968 ↓ 2,291.0 2,291 1

Nested Loop (cost=585.03..847.88 rows=1 width=64) (actual time=8.869..48.968 rows=2,291 loops=1)

193. 4.691 28.032 ↓ 3,616.0 3,616 1

Nested Loop (cost=584.61..844.24 rows=1 width=72) (actual time=8.812..28.032 rows=3,616 loops=1)

194. 3.556 13.989 ↓ 4,676.0 4,676 1

Hash Join (cost=584.33..843.78 rows=1 width=64) (actual time=8.772..13.989 rows=4,676 loops=1)

  • Hash Cond: (ldisk_storage_class_join_1.logical_disk_id = ldisk_fo_join_1.logical_disk_id)
195. 1.715 1.715 ↑ 1.0 12,250 1

Seq Scan on ldisk_storage_class_join ldisk_storage_class_join_1 (cost=0.00..213.50 rows=12,250 width=32) (actual time=0.024..1.715 rows=12,250 loops=1)

196. 0.966 8.718 ↓ 4,676.0 4,676 1

Hash (cost=584.32..584.32 rows=1 width=32) (actual time=8.718..8.718 rows=4,676 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 357kB
197. 3.217 7.752 ↓ 4,676.0 4,676 1

Hash Left Join (cost=249.28..584.32 rows=1 width=32) (actual time=3.106..7.752 rows=4,676 loops=1)

  • Hash Cond: (ldisk_fo_join_1.fo_id = vm_disk_1.disk_id)
  • Filter: (vm_disk_1.id IS NULL)
  • Rows Removed by Filter: 7568
198. 1.501 1.501 ↑ 1.0 12,244 1

Seq Scan on ldisk_fo_join ldisk_fo_join_1 (cost=0.00..213.44 rows=12,244 width=32) (actual time=0.011..1.501 rows=12,244 loops=1)

199. 1.415 3.034 ↑ 1.0 7,568 1

Hash (cost=154.68..154.68 rows=7,568 width=32) (actual time=3.034..3.034 rows=7,568 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 537kB
200. 1.619 1.619 ↑ 1.0 7,568 1

Seq Scan on vm_disk vm_disk_1 (cost=0.00..154.68 rows=7,568 width=32) (actual time=0.013..1.619 rows=7,568 loops=1)

201. 9.352 9.352 ↑ 1.0 1 4,676

Index Scan using pk_disk on disk (cost=0.29..0.47 rows=1 width=40) (actual time=0.002..0.002 rows=1 loops=4,676)

  • Index Cond: (id = ldisk_fo_join_1.fo_id)
202. 18.080 18.080 ↑ 1.0 1 3,616

Index Scan using uq_c_vminv_vc_id_moref on vm_inv vm_inv_1 (cost=0.41..3.63 rows=1 width=40) (actual time=0.005..0.005 rows=1 loops=3,616)

  • Index Cond: ((vc_id = disk.vc_id) AND ((moref)::text = (disk.shell_vm_moref)::text))
203. 11.455 11.455 ↑ 1.0 1 2,291

Index Scan using ix_vm_dstoremtrcs_1 on vm_dstore_metrics_inv dsm (cost=0.41..0.51 rows=1 width=24) (actual time=0.005..0.005 rows=1 loops=2,291)

  • Index Cond: (vm_inv_id = vm_inv_1.vm_inv_id)
204. 6.819 6.819 ↑ 1.0 1 2,273

Index Scan using logical_disk_pk on logical_disk logical_disk_1 (cost=0.29..0.38 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=2,273)

  • Index Cond: (id = ldisk_storage_class_join_1.logical_disk_id)
  • Filter: ((logical_disk_type)::text = 'DISK'::text)
205. 4.546 4.546 ↓ 0.0 0 2,273

Index Only Scan using ix_catalog_item_entity_id_type on catalog_item (cost=0.29..0.45 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=2,273)

  • Index Cond: (entity_id = logical_disk_1.id)
  • Heap Fetches: 0
206. 11.365 11.365 ↑ 1.0 1 2,273

Index Scan using vdc_logical_resource_pk on vdc_logical_resource (cost=0.42..1.00 rows=1 width=33) (actual time=0.005..0.005 rows=1 loops=2,273)

  • Index Cond: (id = ldisk_storage_class_join_1.storage_class_id)
207. 2.736 17.352 ↓ 1.0 9,950 1

Hash (cost=1,993.19..1,993.19 rows=9,816 width=40) (actual time=17.352..17.352 rows=9,950 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 828kB
208. 12.590 14.616 ↓ 1.0 9,950 1

Bitmap Heap Scan on vdc_logical_resource lr (cost=432.49..1,993.19 rows=9,816 width=40) (actual time=2.187..14.616 rows=9,950 loops=1)

  • Recheck Cond: ((lr_type)::text = 'STORAGE_CLASS'::text)
  • Heap Blocks: exact=1185
209. 2.026 2.026 ↓ 1.0 9,950 1

Bitmap Index Scan on ix_vdc_lr_type_vdc_lr_id (cost=0.00..430.04 rows=9,816 width=0) (actual time=2.026..2.026 rows=9,950 loops=1)

  • Index Cond: ((lr_type)::text = 'STORAGE_CLASS'::text)