explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kdLp

Settings
# exclusive inclusive rows x rows loops node
1. 0.048 4,366.546 ↑ 251.8 21 1

Sort (cost=602,114.68..602,127.90 rows=5,287 width=1,910) (actual time=4,366.542..4,366.546 rows=21 loops=1)

  • Sort Key: cd_cfg_repl_ctxs.system_id, cd_cfg_repl_ctxs.is_src DESC, pv.repl_scheme
  • Sort Method: quicksort Memory: 35kB
2. 0.042 4,366.498 ↑ 251.8 21 1

Unique (cost=597,055.85..597,412.73 rows=5,287 width=1,910) (actual time=4,366.454..4,366.498 rows=21 loops=1)

3. 0.085 4,366.456 ↑ 251.8 21 1

Sort (cost=597,055.85..597,069.07 rows=5,287 width=1,910) (actual time=4,366.453..4,366.456 rows=21 loops=1)

  • Sort Key: pv.pair_id, cd_cfg_repl_ctxs.system_id, cs.name, cs.type, cd_cfg_repl_ctxs.source_host, cd_cfg_repl_ctxs.source_path, cd_cfg_repl_ctxs.dest_host, cd_cfg_repl_ctxs.dest_path, pv.src_tenant_id, pv.src_tenant_name, pv.src_tenant_unit_i (...)
  • Sort Method: quicksort Memory: 35kB
4. 0.007 4,366.371 ↑ 251.8 21 1

Append (cost=455,899.86..592,353.90 rows=5,287 width=1,910) (actual time=3,715.894..4,366.371 rows=21 loops=1)

5. 0.040 3,719.828 ↑ 264.3 20 1

Hash Join (cost=455,899.86..456,098.00 rows=5,286 width=372) (actual time=3,715.893..3,719.828 rows=20 loops=1)

  • Hash Cond: (pv.pair_id = cd_cfg_repl_ctxs.pair_id)
6. 1.045 3,652.603 ↑ 154.3 20 1

Subquery Scan on pv (cost=439,318.48..439,421.33 rows=3,086 width=212) (actual time=3,648.691..3,652.603 rows=20 loops=1)

  • Filter: ((hashed SubPlan 3) OR (hashed SubPlan 4))
  • Rows Removed by Filter: 2,476
7. 17.376 3,622.039 ↑ 1.6 2,496 1

HashAggregate (cost=436,667.96..436,709.10 rows=4,114 width=696) (actual time=3,619.053..3,622.039 rows=2,496 loops=1)

  • Group Key: l.pair_id, l.system_id, l.ctx_id, l.epoch, l.source_host, l.source_path, l.processed_status, l.processed_status_msg, r.system_id, r.ctx_id, r.epoch, l.dest_host, l.dest_path, r.processed_status, r.processed_ (...)
8. 0.633 3,604.663 ↑ 1.6 2,496 1

Append (cost=923.39..436,235.99 rows=4,114 width=696) (actual time=9.975..3,604.663 rows=2,496 loops=1)

9. 2.471 16.967 ↑ 1.2 1,524 1

Hash Join (cost=923.39..1,500.00 rows=1,898 width=2,587) (actual time=9.973..16.967 rows=1,524 loops=1)

  • Hash Cond: (l.pair_id = r.pair_id)
  • Join Filter: (l.id <> r.id)
10. 0.813 6.937 ↑ 1.0 832 1

Hash Left Join (cost=181.97..723.40 rows=832 width=1,437) (actual time=2.389..6.937 rows=832 loops=1)

  • Hash Cond: (cctu1.tenant_id = cct1.id)
11. 1.801 5.653 ↑ 1.0 832 1

Hash Left Join (cost=169.51..703.87 rows=832 width=1,395) (actual time=1.896..5.653 rows=832 loops=1)

  • Hash Cond: (l.tenant_unit_id = cctu1.id)
12. 2.003 2.003 ↑ 1.0 832 1

Seq Scan on cd_cfg_repl_ctxs l (cost=0.00..524.73 rows=832 width=1,343) (actual time=0.009..2.003 rows=832 loops=1)

  • Filter: (is_src = 1)
  • Rows Removed by Filter: 1,066
13. 0.752 1.849 ↑ 1.0 1,060 1

Hash (cost=156.26..156.26 rows=1,060 width=60) (actual time=1.849..1.849 rows=1,060 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 111kB
14. 1.097 1.097 ↑ 1.0 1,060 1

Seq Scan on cd_cfg_tenant_units cctu1 (cost=0.00..156.26 rows=1,060 width=60) (actual time=0.012..1.097 rows=1,060 loops=1)

  • Filter: (id <> 0)
  • Rows Removed by Filter: 1
15. 0.217 0.471 ↓ 1.0 343 1

Hash (cost=8.24..8.24 rows=338 width=50) (actual time=0.471..0.471 rows=343 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
16. 0.254 0.254 ↓ 1.0 343 1

Seq Scan on cd_cfg_tenants cct1 (cost=0.00..8.24 rows=338 width=50) (actual time=0.010..0.254 rows=343 loops=1)

  • Filter: (id <> 0)
  • Rows Removed by Filter: 1
17. 0.949 7.559 ↑ 1.0 1,066 1

Hash (cost=728.09..728.09 rows=1,066 width=1,174) (actual time=7.559..7.559 rows=1,066 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 100kB
18. 0.721 6.610 ↑ 1.0 1,066 1

Hash Left Join (cost=181.97..728.09 rows=1,066 width=1,174) (actual time=2.379..6.610 rows=1,066 loops=1)

  • Hash Cond: (cctu2.tenant_id = cct2.id)
19. 1.755 5.406 ↑ 1.0 1,066 1

Hash Left Join (cost=169.51..706.58 rows=1,066 width=1,132) (actual time=1.871..5.406 rows=1,066 loops=1)

  • Hash Cond: (r.tenant_unit_id = cctu2.id)
20. 1.811 1.811 ↑ 1.0 1,066 1

Seq Scan on cd_cfg_repl_ctxs r (cost=0.00..524.73 rows=1,066 width=1,080) (actual time=0.006..1.811 rows=1,066 loops=1)

  • Filter: (is_src = 0)
  • Rows Removed by Filter: 832
21. 0.739 1.840 ↑ 1.0 1,060 1

Hash (cost=156.26..156.26 rows=1,060 width=60) (actual time=1.840..1.840 rows=1,060 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 111kB
22. 1.101 1.101 ↑ 1.0 1,060 1

Seq Scan on cd_cfg_tenant_units cctu2 (cost=0.00..156.26 rows=1,060 width=60) (actual time=0.009..1.101 rows=1,060 loops=1)

  • Filter: (id <> 0)
  • Rows Removed by Filter: 1
23. 0.221 0.483 ↓ 1.0 343 1

Hash (cost=8.24..8.24 rows=338 width=50) (actual time=0.483..0.483 rows=343 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
24. 0.262 0.262 ↓ 1.0 343 1

Seq Scan on cd_cfg_tenants cct2 (cost=0.00..8.24 rows=338 width=50) (actual time=0.032..0.262 rows=343 loops=1)

  • Filter: (id <> 0)
  • Rows Removed by Filter: 1
25. 1.269 1,945.489 ↑ 2.2 514 1

Subquery Scan on *SELECT* 2_1 (cost=843.40..217,358.51 rows=1,108 width=696) (actual time=20.300..1,945.489 rows=514 loops=1)

26. 17.512 1,944.220 ↑ 2.2 514 1

GroupAggregate (cost=843.40..217,347.43 rows=1,108 width=696) (actual time=20.293..1,944.220 rows=514 loops=1)

  • Group Key: ccrc.pair_id
  • Filter: ((count(*) = 1) AND (sum(ccrc.is_src) = 1))
  • Rows Removed by Filter: 594
27. 5.367 15.142 ↑ 1.0 1,898 1

Sort (cost=843.40..848.14 rows=1,898 width=1,433) (actual time=14.175..15.142 rows=1,898 loops=1)

  • Sort Key: ccrc.pair_id
  • Sort Method: quicksort Memory: 1,027kB
28. 1.683 9.775 ↑ 1.0 1,898 1

Hash Left Join (cost=181.97..740.05 rows=1,898 width=1,433) (actual time=2.520..9.775 rows=1,898 loops=1)

  • Hash Cond: (cctu1_1.tenant_id = cct1_1.id)
29. 4.274 7.611 ↑ 1.0 1,898 1

Hash Left Join (cost=169.51..711.46 rows=1,898 width=1,391) (actual time=2.016..7.611 rows=1,898 loops=1)

  • Hash Cond: (ccrc.tenant_unit_id = cctu1_1.id)
30. 1.355 1.355 ↑ 1.0 1,898 1

Seq Scan on cd_cfg_repl_ctxs ccrc (cost=0.00..519.98 rows=1,898 width=1,339) (actual time=0.007..1.355 rows=1,898 loops=1)

31. 0.774 1.982 ↑ 1.0 1,060 1

Hash (cost=156.26..156.26 rows=1,060 width=60) (actual time=1.982..1.982 rows=1,060 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 111kB
32. 1.208 1.208 ↑ 1.0 1,060 1

Seq Scan on cd_cfg_tenant_units cctu1_1 (cost=0.00..156.26 rows=1,060 width=60) (actual time=0.014..1.208 rows=1,060 loops=1)

  • Filter: (id <> 0)
  • Rows Removed by Filter: 1
33. 0.217 0.481 ↓ 1.0 343 1

Hash (cost=8.24..8.24 rows=338 width=50) (actual time=0.481..0.481 rows=343 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
34. 0.264 0.264 ↓ 1.0 343 1

Seq Scan on cd_cfg_tenants cct1_1 (cost=0.00..8.24 rows=338 width=50) (actual time=0.012..0.264 rows=343 loops=1)

  • Filter: (id <> 0)
  • Rows Removed by Filter: 1
35.          

SubPlan (for GroupAggregate)

36. 1.028 542.270 ↓ 0.0 0 514

Limit (cost=0.00..137.51 rows=1 width=8) (actual time=1.055..1.055 rows=0 loops=514)

37. 541.242 541.242 ↓ 0.0 0 514

Seq Scan on cfg_systems s_13 (cost=0.00..275.01 rows=2 width=8) (actual time=1.053..1.053 rows=0 loops=514)

  • Filter: (((name)::text ~~* min((ccrc.dest_host)::text)) OR ((ip_address)::text ~~* min((ccrc.dest_host)::text)))
  • Rows Removed by Filter: 201
38. 1.028 409.658 ↓ 0.0 0 514

Limit (cost=46.01..46.01 rows=1 width=8) (actual time=0.797..0.797 rows=0 loops=514)

39. 3.084 408.630 ↓ 0.0 0 514

Sort (cost=46.01..46.02 rows=2 width=8) (actual time=0.795..0.795 rows=0 loops=514)

  • Sort Key: i_1.system_id
  • Sort Method: quicksort Memory: 25kB
40. 405.546 405.546 ↓ 0.0 0 514

Seq Scan on cd_hw_net_if i_1 (cost=0.00..46.00 rows=2 width=8) (actual time=0.789..0.789 rows=0 loops=514)

  • Filter: ((ip_address)::text ~~* min((ccrc.dest_host)::text))
  • Rows Removed by Filter: 400
41. 0.514 959.638 ↓ 0.0 0 514

Limit (cost=3.52..11.71 rows=1 width=4) (actual time=1.867..1.867 rows=0 loops=514)

42. 0.514 959.124 ↓ 0.0 0 514

Nested Loop (cost=3.52..200.26 rows=24 width=4) (actual time=1.866..1.866 rows=0 loops=514)

43. 958.610 958.610 ↓ 0.0 0 514

Seq Scan on cd_cfg_tenant_units tu_1 (cost=0.00..156.26 rows=5 width=8) (actual time=1.865..1.865 rows=0 loops=514)

  • Filter: ((hostname)::text ~~* min((ccrc.dest_host)::text))
  • Rows Removed by Filter: 1,061
44. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on cd_cfg_tenants_systems ts_1 (cost=3.52..8.75 rows=5 width=8) (never executed)

  • Recheck Cond: (tenant_id = tu_1.tenant_id)
45. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on cd_cfg_tenants_systems_tenant_id_idx (cost=0.00..3.52 rows=5 width=0) (never executed)

  • Index Cond: (tenant_id = tu_1.tenant_id)
46. 1.002 1,641.574 ↑ 2.4 458 1

Subquery Scan on *SELECT* 3 (cost=843.40..217,358.51 rows=1,108 width=696) (actual time=13.039..1,641.574 rows=458 loops=1)

47. 16.067 1,640.572 ↑ 2.4 458 1

GroupAggregate (cost=843.40..217,347.43 rows=1,108 width=696) (actual time=13.034..1,640.572 rows=458 loops=1)

  • Group Key: ccrc_1.pair_id
  • Filter: ((count(*) = 1) AND (sum(ccrc_1.is_src) = 0))
  • Rows Removed by Filter: 650
48. 3.526 9.597 ↑ 1.0 1,898 1

Sort (cost=843.40..848.14 rows=1,898 width=1,433) (actual time=8.749..9.597 rows=1,898 loops=1)

  • Sort Key: ccrc_1.pair_id
  • Sort Method: quicksort Memory: 1,027kB
49. 1.022 6.071 ↑ 1.0 1,898 1

Hash Left Join (cost=181.97..740.05 rows=1,898 width=1,433) (actual time=1.476..6.071 rows=1,898 loops=1)

  • Hash Cond: (cctu2_1.tenant_id = cct2_1.id)
50. 2.656 4.771 ↑ 1.0 1,898 1

Hash Left Join (cost=169.51..711.46 rows=1,898 width=1,391) (actual time=1.182..4.771 rows=1,898 loops=1)

  • Hash Cond: (ccrc_1.tenant_unit_id = cctu2_1.id)
51. 0.965 0.965 ↑ 1.0 1,898 1

Seq Scan on cd_cfg_repl_ctxs ccrc_1 (cost=0.00..519.98 rows=1,898 width=1,339) (actual time=0.005..0.965 rows=1,898 loops=1)

52. 0.480 1.150 ↑ 1.0 1,060 1

Hash (cost=156.26..156.26 rows=1,060 width=60) (actual time=1.150..1.150 rows=1,060 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 111kB
53. 0.670 0.670 ↑ 1.0 1,060 1

Seq Scan on cd_cfg_tenant_units cctu2_1 (cost=0.00..156.26 rows=1,060 width=60) (actual time=0.011..0.670 rows=1,060 loops=1)

  • Filter: (id <> 0)
  • Rows Removed by Filter: 1
54. 0.122 0.278 ↓ 1.0 343 1

Hash (cost=8.24..8.24 rows=338 width=50) (actual time=0.278..0.278 rows=343 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
55. 0.156 0.156 ↓ 1.0 343 1

Seq Scan on cd_cfg_tenants cct2_1 (cost=0.00..8.24 rows=338 width=50) (actual time=0.008..0.156 rows=343 loops=1)

  • Filter: (id <> 0)
  • Rows Removed by Filter: 1
56.          

SubPlan (for GroupAggregate)

57. 0.916 460.290 ↓ 0.0 0 458

Limit (cost=0.00..137.51 rows=1 width=8) (actual time=1.005..1.005 rows=0 loops=458)

58. 459.374 459.374 ↓ 0.0 0 458

Seq Scan on cfg_systems s_12 (cost=0.00..275.01 rows=2 width=8) (actual time=1.003..1.003 rows=0 loops=458)

  • Filter: (((name)::text ~~* min((ccrc_1.source_host)::text)) OR ((ip_address)::text ~~* min((ccrc_1.source_host)::text)))
  • Rows Removed by Filter: 201
59. 0.458 347.622 ↓ 0.0 0 458

Limit (cost=46.01..46.01 rows=1 width=8) (actual time=0.759..0.759 rows=0 loops=458)

60. 2.748 347.164 ↓ 0.0 0 458

Sort (cost=46.01..46.02 rows=2 width=8) (actual time=0.758..0.758 rows=0 loops=458)

  • Sort Key: i.system_id
  • Sort Method: quicksort Memory: 25kB
61. 344.416 344.416 ↓ 0.0 0 458

Seq Scan on cd_hw_net_if i (cost=0.00..46.00 rows=2 width=8) (actual time=0.752..0.752 rows=0 loops=458)

  • Filter: ((ip_address)::text ~~* min((ccrc_1.source_host)::text))
  • Rows Removed by Filter: 400
62. 0.458 806.996 ↓ 0.0 0 458

Limit (cost=3.52..11.71 rows=1 width=4) (actual time=1.762..1.762 rows=0 loops=458)

63. 0.458 806.538 ↓ 0.0 0 458

Nested Loop (cost=3.52..200.26 rows=24 width=4) (actual time=1.761..1.761 rows=0 loops=458)

64. 806.080 806.080 ↓ 0.0 0 458

Seq Scan on cd_cfg_tenant_units tu (cost=0.00..156.26 rows=5 width=8) (actual time=1.760..1.760 rows=0 loops=458)

  • Filter: ((hostname)::text ~~* min((ccrc_1.source_host)::text))
  • Rows Removed by Filter: 1,061
65. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on cd_cfg_tenants_systems ts (cost=3.52..8.75 rows=5 width=8) (never executed)

  • Recheck Cond: (tenant_id = tu.tenant_id)
66. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on cd_cfg_tenants_systems_tenant_id_idx (cost=0.00..3.52 rows=5 width=0) (never executed)

  • Index Cond: (tenant_id = tu.tenant_id)
67.          

SubPlan (for Subquery Scan)

68. 0.035 14.904 ↑ 10.0 1 1

HashSetOp Intersect (cost=300.46..1,325.24 rows=10 width=12) (actual time=14.904..14.904 rows=1 loops=1)

69. 0.021 14.869 ↑ 6.5 201 1

Append (cost=300.46..1,321.99 rows=1,299 width=12) (actual time=0.842..14.869 rows=201 loops=1)

70. 0.001 0.842 ↑ 10.0 1 1

Subquery Scan on *SELECT* 1_4 (cost=300.46..300.61 rows=10 width=12) (actual time=0.842..0.842 rows=1 loops=1)

71. 0.002 0.841 ↑ 10.0 1 1

Unique (cost=300.46..300.51 rows=10 width=8) (actual time=0.841..0.841 rows=1 loops=1)

72. 0.010 0.839 ↑ 10.0 1 1

Sort (cost=300.46..300.49 rows=10 width=8) (actual time=0.839..0.839 rows=1 loops=1)

  • Sort Key: cfg_system_nodes_view_4.system_id
  • Sort Method: quicksort Memory: 25kB
73. 0.001 0.829 ↑ 10.0 1 1

Subquery Scan on cfg_system_nodes_view_4 (cost=0.57..300.30 rows=10 width=8) (actual time=0.681..0.829 rows=1 loops=1)

74. 0.181 0.828 ↑ 10.0 1 1

Nested Loop Left Join (cost=0.57..300.20 rows=10 width=8,468) (actual time=0.680..0.828 rows=1 loops=1)

75. 0.002 0.644 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.42..297.05 rows=1 width=16) (actual time=0.496..0.644 rows=1 loops=1)

76. 0.037 0.631 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.27..296.84 rows=1 width=16) (actual time=0.484..0.631 rows=1 loops=1)

  • Join Filter: (n_8.system_id = f_8.system_id)
  • Rows Removed by Join Filter: 200
77. 0.004 0.540 ↑ 1.0 1 1

Nested Loop (cost=0.27..283.32 rows=1 width=16) (actual time=0.470..0.540 rows=1 loops=1)

78. 0.520 0.520 ↑ 1.0 1 1

Seq Scan on cfg_systems s_8 (cost=0.00..275.01 rows=1 width=8) (actual time=0.453..0.520 rows=1 loops=1)

  • Filter: (lower((name)::text) = 'ddr-10.213.216.18-1'::text)
  • Rows Removed by Filter: 200
79. 0.016 0.016 ↑ 1.0 1 1

Index Scan using cfg_nodes_system_id_idx on cfg_nodes n_8 (cost=0.27..8.29 rows=1 width=20) (actual time=0.013..0.016 rows=1 loops=1)

  • Index Cond: (system_id = s_8.id)
80. 0.054 0.054 ↑ 1.0 201 1

Seq Scan on cd_cfg_systems_features_status f_8 (cost=0.00..11.01 rows=201 width=8) (actual time=0.005..0.054 rows=201 loops=1)

81. 0.011 0.011 ↑ 1.0 1 1

Index Only Scan using cd_cfg_collections_system_id_idx on cd_cfg_collections l_9 (cost=0.14..0.20 rows=1 width=8) (actual time=0.009..0.011 rows=1 loops=1)

  • Index Cond: (system_id = n_8.system_id)
  • Heap Fetches: 1
82. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using cd_cfg_ha_system_config_sys_status_idx on cd_cfg_ha_system_config sc_8 (cost=0.15..0.55 rows=10 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (system_id = n_8.system_id)
  • Heap Fetches: 0
83. 0.035 14.006 ↑ 6.4 200 1

Subquery Scan on *SELECT* 2_6 (cost=995.59..1,021.37 rows=1,289 width=12) (actual time=13.874..14.006 rows=200 loops=1)

84. 0.389 13.971 ↑ 6.4 200 1

HashAggregate (cost=995.59..1,008.48 rows=1,289 width=8) (actual time=13.873..13.971 rows=200 loops=1)

  • Group Key: n_9.system_id
85. 10.073 13.582 ↑ 6.4 200 1

Hash Right Join (cost=606.29..979.48 rows=1,289 width=8,468) (actual time=3.629..13.582 rows=200 loops=1)

  • Hash Cond: (sc_9.system_id = n_9.system_id)
86. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on cd_cfg_ha_system_config sc_9 (cost=0.00..30.40 rows=2,040 width=8) (actual time=0.002..0.002 rows=0 loops=1)

87. 0.083 3.507 ↓ 1.6 200 1

Hash (cost=604.70..604.70 rows=127 width=16) (actual time=3.507..3.507 rows=200 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 18kB
88. 0.123 3.424 ↓ 1.6 200 1

Hash Left Join (cost=92.97..604.70 rows=127 width=16) (actual time=0.544..3.424 rows=200 loops=1)

  • Hash Cond: (n_9.system_id = l_10.system_id)
89. 0.117 3.136 ↓ 1.6 200 1

Hash Left Join (cost=79.32..589.32 rows=127 width=16) (actual time=0.368..3.136 rows=200 loops=1)

  • Hash Cond: (n_9.system_id = f_9.system_id)
90. 0.113 2.889 ↓ 1.6 200 1

Hash Left Join (cost=65.80..574.05 rows=127 width=16) (actual time=0.225..2.889 rows=200 loops=1)

  • Hash Cond: (n_9.system_id = s_9.id)
91. 2.616 2.616 ↓ 1.6 200 1

Seq Scan on cfg_nodes n_9 (cost=0.00..506.51 rows=127 width=20) (actual time=0.058..2.616 rows=200 loops=1)

  • Filter: ((system_id = 17) OR (system_id = 18) OR (system_id = 19) OR (system_id = 20) OR (system_id = 21) OR (system_id = 22) OR (system_id = 23) OR (system_id = (...)
  • Rows Removed by Filter: 1
92. 0.074 0.160 ↑ 1.0 201 1

Hash (cost=63.29..63.29 rows=201 width=8) (actual time=0.160..0.160 rows=201 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
93. 0.086 0.086 ↑ 1.0 201 1

Index Only Scan using cfg_systems_pkey on cfg_systems s_9 (cost=0.27..63.29 rows=201 width=8) (actual time=0.007..0.086 rows=201 loops=1)

  • Heap Fetches: 24
94. 0.065 0.130 ↑ 1.0 201 1

Hash (cost=11.01..11.01 rows=201 width=8) (actual time=0.130..0.130 rows=201 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
95. 0.065 0.065 ↑ 1.0 201 1

Seq Scan on cd_cfg_systems_features_status f_9 (cost=0.00..11.01 rows=201 width=8) (actual time=0.004..0.065 rows=201 loops=1)

96. 0.060 0.165 ↑ 1.0 200 1

Hash (cost=11.14..11.14 rows=200 width=8) (actual time=0.164..0.165 rows=200 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
97. 0.105 0.105 ↑ 1.0 200 1

Index Only Scan using cd_cfg_collections_system_id_idx on cd_cfg_collections l_10 (cost=0.14..11.14 rows=200 width=8) (actual time=0.010..0.105 rows=200 loops=1)

  • Heap Fetches: 94
98. 0.030 14.615 ↑ 10.0 1 1

HashSetOp Intersect (cost=300.46..1,325.24 rows=10 width=12) (actual time=14.614..14.615 rows=1 loops=1)

99. 0.017 14.585 ↑ 6.5 201 1

Append (cost=300.46..1,321.99 rows=1,299 width=12) (actual time=0.739..14.585 rows=201 loops=1)

100. 0.003 0.740 ↑ 10.0 1 1

Subquery Scan on *SELECT* 1_5 (cost=300.46..300.61 rows=10 width=12) (actual time=0.739..0.740 rows=1 loops=1)

101. 0.001 0.737 ↑ 10.0 1 1

Unique (cost=300.46..300.51 rows=10 width=8) (actual time=0.737..0.737 rows=1 loops=1)

102. 0.007 0.736 ↑ 10.0 1 1

Sort (cost=300.46..300.49 rows=10 width=8) (actual time=0.736..0.736 rows=1 loops=1)

  • Sort Key: cfg_system_nodes_view_5.system_id
  • Sort Method: quicksort Memory: 25kB
103. 0.001 0.729 ↑ 10.0 1 1

Subquery Scan on cfg_system_nodes_view_5 (cost=0.57..300.30 rows=10 width=8) (actual time=0.593..0.729 rows=1 loops=1)

104. 0.097 0.728 ↑ 10.0 1 1

Nested Loop Left Join (cost=0.57..300.20 rows=10 width=8,468) (actual time=0.592..0.728 rows=1 loops=1)

105. 0.007 0.629 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.42..297.05 rows=1 width=16) (actual time=0.493..0.629 rows=1 loops=1)

106. 0.035 0.617 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.27..296.84 rows=1 width=16) (actual time=0.482..0.617 rows=1 loops=1)

  • Join Filter: (n_10.system_id = f_10.system_id)
  • Rows Removed by Join Filter: 200
107. 0.003 0.538 ↑ 1.0 1 1

Nested Loop (cost=0.27..283.32 rows=1 width=16) (actual time=0.472..0.538 rows=1 loops=1)

108. 0.527 0.527 ↑ 1.0 1 1

Seq Scan on cfg_systems s_10 (cost=0.00..275.01 rows=1 width=8) (actual time=0.463..0.527 rows=1 loops=1)

  • Filter: (lower((name)::text) = 'ddr-10.213.216.18-1'::text)
  • Rows Removed by Filter: 200
109. 0.008 0.008 ↑ 1.0 1 1

Index Scan using cfg_nodes_system_id_idx on cfg_nodes n_10 (cost=0.27..8.29 rows=1 width=20) (actual time=0.006..0.008 rows=1 loops=1)

  • Index Cond: (system_id = s_10.id)
110. 0.044 0.044 ↑ 1.0 201 1

Seq Scan on cd_cfg_systems_features_status f_10 (cost=0.00..11.01 rows=201 width=8) (actual time=0.003..0.044 rows=201 loops=1)

111. 0.005 0.005 ↑ 1.0 1 1

Index Only Scan using cd_cfg_collections_system_id_idx on cd_cfg_collections l_11 (cost=0.14..0.20 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (system_id = n_10.system_id)
  • Heap Fetches: 1
112. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using cd_cfg_ha_system_config_sys_status_idx on cd_cfg_ha_system_config sc_10 (cost=0.15..0.55 rows=10 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (system_id = n_10.system_id)
  • Heap Fetches: 0
113. 0.039 13.828 ↑ 6.4 200 1

Subquery Scan on *SELECT* 2_7 (cost=995.59..1,021.37 rows=1,289 width=12) (actual time=13.693..13.828 rows=200 loops=1)

114. 0.387 13.789 ↑ 6.4 200 1

HashAggregate (cost=995.59..1,008.48 rows=1,289 width=8) (actual time=13.692..13.789 rows=200 loops=1)

  • Group Key: n_11.system_id
115. 10.141 13.402 ↑ 6.4 200 1

Hash Right Join (cost=606.29..979.48 rows=1,289 width=8,468) (actual time=3.381..13.402 rows=200 loops=1)

  • Hash Cond: (sc_11.system_id = n_11.system_id)
116. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on cd_cfg_ha_system_config sc_11 (cost=0.00..30.40 rows=2,040 width=8) (actual time=0.002..0.002 rows=0 loops=1)

117. 0.078 3.259 ↓ 1.6 200 1

Hash (cost=604.70..604.70 rows=127 width=16) (actual time=3.259..3.259 rows=200 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 18kB
118. 0.126 3.181 ↓ 1.6 200 1

Hash Left Join (cost=92.97..604.70 rows=127 width=16) (actual time=0.494..3.181 rows=200 loops=1)

  • Hash Cond: (n_11.system_id = l_12.system_id)
119. 0.109 2.907 ↓ 1.6 200 1

Hash Left Join (cost=79.32..589.32 rows=127 width=16) (actual time=0.334..2.907 rows=200 loops=1)

  • Hash Cond: (n_11.system_id = f_11.system_id)
120. 0.120 2.675 ↓ 1.6 200 1

Hash Left Join (cost=65.80..574.05 rows=127 width=16) (actual time=0.197..2.675 rows=200 loops=1)

  • Hash Cond: (n_11.system_id = s_11.id)
121. 2.427 2.427 ↓ 1.6 200 1

Seq Scan on cfg_nodes n_11 (cost=0.00..506.51 rows=127 width=20) (actual time=0.061..2.427 rows=200 loops=1)

  • Filter: ((system_id = 17) OR (system_id = 18) OR (system_id = 19) OR (system_id = 20) OR (system_id = 21) OR (system_id = 22) OR (system_id = 23) OR (system_id = (...)
  • Rows Removed by Filter: 1
122. 0.049 0.128 ↑ 1.0 201 1

Hash (cost=63.29..63.29 rows=201 width=8) (actual time=0.128..0.128 rows=201 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
123. 0.079 0.079 ↑ 1.0 201 1

Index Only Scan using cfg_systems_pkey on cfg_systems s_11 (cost=0.27..63.29 rows=201 width=8) (actual time=0.006..0.079 rows=201 loops=1)

  • Heap Fetches: 24
124. 0.068 0.123 ↑ 1.0 201 1

Hash (cost=11.01..11.01 rows=201 width=8) (actual time=0.123..0.123 rows=201 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
125. 0.055 0.055 ↑ 1.0 201 1

Seq Scan on cd_cfg_systems_features_status f_11 (cost=0.00..11.01 rows=201 width=8) (actual time=0.004..0.055 rows=201 loops=1)

126. 0.055 0.148 ↑ 1.0 200 1

Hash (cost=11.14..11.14 rows=200 width=8) (actual time=0.148..0.148 rows=200 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
127. 0.093 0.093 ↑ 1.0 200 1

Index Only Scan using cd_cfg_collections_system_id_idx on cd_cfg_collections l_12 (cost=0.14..11.14 rows=200 width=8) (actual time=0.009..0.093 rows=200 loops=1)

  • Heap Fetches: 94
128. 2.194 67.185 ↑ 1.0 1,898 1

Hash (cost=16,557.65..16,557.65 rows=1,898 width=168) (actual time=67.185..67.185 rows=1,898 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 369kB
129. 1.340 64.991 ↑ 1.0 1,898 1

Hash Left Join (cost=15,997.23..16,557.65 rows=1,898 width=168) (actual time=59.409..64.991 rows=1,898 loops=1)

  • Hash Cond: ((cd_cfg_repl_ctxs.system_id = hd.system_id) AND (cd_cfg_repl_ctxs.ctx_id = hd.ctx_id))
130. 3.000 4.868 ↑ 1.0 1,898 1

Hash Join (cost=276.52..822.60 rows=1,898 width=152) (actual time=0.612..4.868 rows=1,898 loops=1)

  • Hash Cond: (cd_cfg_repl_ctxs.system_id = cs.id)
131. 1.276 1.276 ↑ 1.0 1,898 1

Seq Scan on cd_cfg_repl_ctxs (cost=0.00..519.98 rows=1,898 width=122) (actual time=0.006..1.276 rows=1,898 loops=1)

132. 0.083 0.592 ↑ 1.0 201 1

Hash (cost=274.01..274.01 rows=201 width=38) (actual time=0.592..0.592 rows=201 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
133. 0.509 0.509 ↑ 1.0 201 1

Seq Scan on cfg_systems cs (cost=0.00..274.01 rows=201 width=38) (actual time=0.004..0.509 rows=201 loops=1)

134. 0.026 58.783 ↑ 3.7 20 1

Hash (cost=15,719.59..15,719.59 rows=74 width=40) (actual time=58.783..58.783 rows=20 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
135. 0.008 58.757 ↑ 3.7 20 1

Subquery Scan on hd (cost=15,713.67..15,719.59 rows=74 width=40) (actual time=58.154..58.757 rows=20 loops=1)

136. 0.046 58.749 ↑ 3.7 20 1

GroupAggregate (cost=15,713.67..15,718.85 rows=74 width=40) (actual time=58.154..58.749 rows=20 loops=1)

  • Group Key: hd_1.system_id, hd_1.ctx_id
137. 0.537 58.703 ↑ 3.7 20 1

GroupAggregate (cost=15,713.67..15,716.26 rows=74 width=40) (actual time=58.114..58.703 rows=20 loops=1)

  • Group Key: hd_1.system_id, hd_1.ctx_id
138. 0.593 58.166 ↓ 6.5 480 1

Sort (cost=15,713.67..15,713.86 rows=74 width=48) (actual time=58.070..58.166 rows=480 loops=1)

  • Sort Key: hd_1.system_id, hd_1.ctx_id
  • Sort Method: quicksort Memory: 62kB
139. 39.741 57.573 ↓ 6.5 480 1

Hash Semi Join (cost=1,325.89..15,711.38 rows=74 width=48) (actual time=18.670..57.573 rows=480 loops=1)

  • Hash Cond: (hd_1.system_id = "ANY_subquery".system_id)
  • -> Index Scan using hd_processed_space_repl_ctxs_epoch_idx on hd_processed_space_repl_ctxs hd_1 (cost=0.43..14381.51 rows=1,365 width=48) (actual time=0.040..35.805 rows=20,160 loops (...)
  • Index Cond: ((epoch >= 1,596,398,819) AND (epoch <= 1,596,485,219))
  • Filter: ((is_active = 1) AND ((interval_mask & 1) > 0))
140. 0.002 17.832 ↑ 10.0 1 1

Hash (cost=1,325.34..1,325.34 rows=10 width=8) (actual time=17.832..17.832 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
141. 0.001 17.830 ↑ 10.0 1 1

Subquery Scan on ANY_subquery (cost=300.46..1,325.34 rows=10 width=8) (actual time=17.829..17.830 rows=1 loops=1)

142. 0.036 17.829 ↑ 10.0 1 1

HashSetOp Intersect (cost=300.46..1,325.24 rows=10 width=12) (actual time=17.828..17.829 rows=1 loops=1)

143. 0.023 17.793 ↑ 6.5 201 1

Append (cost=300.46..1,321.99 rows=1,299 width=12) (actual time=0.803..17.793 rows=201 loops=1)

144. 0.000 0.802 ↑ 10.0 1 1

Subquery Scan on *SELECT* 1 (cost=300.46..300.61 rows=10 width=12) (actual time=0.802..0.802 rows=1 loops=1)

145. 0.001 0.802 ↑ 10.0 1 1

Unique (cost=300.46..300.51 rows=10 width=8) (actual time=0.802..0.802 rows=1 loops=1)

146. 0.008 0.801 ↑ 10.0 1 1

Sort (cost=300.46..300.49 rows=10 width=8) (actual time=0.801..0.801 rows=1 loops=1)

  • Sort Key: cfg_system_nodes_view.system_id
  • Sort Method: quicksort Memory: 25kB
147. 0.001 0.793 ↑ 10.0 1 1

Subquery Scan on cfg_system_nodes_view (cost=0.57..300.30 rows=10 width=8) (actual time=0.654..0.793 rows=1 loops=1)

148. 0.154 0.792 ↑ 10.0 1 1

Nested Loop Left Join (cost=0.57..300.20 rows=10 width=8,468) (actual time=0.654..0.792 rows=1 loops=1)

  • -> Index Only Scan using cd_cfg_ha_system_config_sys_status_idx on cd_cfg_ha_system_config sc (cost=0.15..0.55 rows=10 width=8 (...)
149. 0.010 0.638 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.42..297.05 rows=1 width=16) (actual time=0.500..0.638 rows=1 loops=1)

  • -> Index Only Scan using cd_cfg_collections_system_id_idx on cd_cfg_collections l_1 (cost=0.14..0.20 rows=1 width=8) (ac (...)
  • Index Cond: (system_id = n.system_id)
  • Heap Fetches: 0
150. 0.087 0.628 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.27..296.84 rows=1 width=16) (actual time=0.491..0.628 rows=1 loops=1)

  • Join Filter: (n.system_id = f.system_id)
  • Rows Removed by Join Filter: 200
  • -> Seq Scan on cd_cfg_systems_features_status f (cost=0.00..11.01 rows=201 width=8) (actual time=0.004..0.047 rows (...)
  • Index Cond: (system_id = n.system_id)
  • Heap Fetches: 1
151. 0.013 0.541 ↑ 1.0 1 1

Nested Loop (cost=0.27..283.32 rows=1 width=16) (actual time=0.481..0.541 rows=1 loops=1)

  • -> Index Scan using cfg_nodes_system_id_idx on cfg_nodes n (cost=0.27..8.29 rows=1 width=20) (actual time=0. (...)
152. 0.528 0.528 ↑ 1.0 1 1

Seq Scan on cfg_systems s (cost=0.00..275.01 rows=1 width=8) (actual time=0.471..0.528 rows=1 loops=1)

  • Filter: (lower((name)::text) = 'ddr-10.213.216.18-1'::text)
  • Rows Removed by Filter: 200
  • Index Cond: (system_id = s.id)
153. 0.047 16.968 ↑ 6.4 200 1

Subquery Scan on *SELECT* 2_2 (cost=995.59..1,021.37 rows=1,289 width=12) (actual time=16.820..16.968 rows=200 loops=1)

154. 0.392 16.921 ↑ 6.4 200 1

HashAggregate (cost=995.59..1,008.48 rows=1,289 width=8) (actual time=16.818..16.921 rows=200 loops=1)

  • Group Key: n_1.system_id
155. 13.046 16.529 ↑ 6.4 200 1

Hash Right Join (cost=606.29..979.48 rows=1,289 width=8,468) (actual time=3.595..16.529 rows=200 loops=1)

  • Hash Cond: (sc_1.system_id = n_1.system_id)
156. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on cd_cfg_ha_system_config sc_1 (cost=0.00..30.40 rows=2,040 width=8) (actual time=0.002..0.002 rows=0 loops=1)

157. 0.080 3.481 ↓ 1.6 200 1

Hash (cost=604.70..604.70 rows=127 width=16) (actual time=3.481..3.481 rows=200 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 18kB
158. 0.138 3.401 ↓ 1.6 200 1

Hash Left Join (cost=92.97..604.70 rows=127 width=16) (actual time=0.512..3.401 rows=200 loops=1)

  • Hash Cond: (n_1.system_id = l_2.system_id)
159. 0.109 3.094 ↓ 1.6 200 1

Hash Left Join (cost=79.32..589.32 rows=127 width=16) (actual time=0.329..3.094 rows=200 loops=1)

  • Hash Cond: (n_1.system_id = f_1.system_id)
160. 0.121 2.852 ↓ 1.6 200 1

Hash Left Join (cost=65.80..574.05 rows=127 width=16) (actual time=0.184..2.852 rows=200 loops=1)

  • Hash Cond: (n_1.system_id = s_1.id)
161. 2.590 2.590 ↓ 1.6 200 1

Seq Scan on cfg_nodes n_1 (cost=0.00..506.51 rows=127 width=20) (actual time=0.033..2.590 rows=200 loops=1)

  • Filter: ((system_id = 17) OR (system_id = 18) OR (system_id = 19) OR (system_id = 20) OR (system_id = 21) OR ( (...)
  • Rows Removed by Filter: 1
162. 0.141 0.141 ↑ 1.0 201 1

Hash (cost=63.29..63.29 rows=201 width=8) (actual time=0.141..0.141 rows=201 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
  • -> Index Only Scan using cfg_systems_pkey on cfg_systems s_1 (cost=0.27..63.29 rows=201 width=8) (actual tim (...)
  • Heap Fetches: 25
163. 0.133 0.133 ↑ 1.0 201 1

Hash (cost=11.01..11.01 rows=201 width=8) (actual time=0.133..0.133 rows=201 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
  • -> Seq Scan on cd_cfg_systems_features_status f_1 (cost=0.00..11.01 rows=201 width=8) (actual time=0.004..0.070 ro (...)
164. 0.169 0.169 ↑ 1.0 200 1

Hash (cost=11.14..11.14 rows=200 width=8) (actual time=0.169..0.169 rows=200 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
  • -> Index Only Scan using cd_cfg_collections_system_id_idx on cd_cfg_collections l_2 (cost=0.14..11.14 rows=200 width=8) (...)
  • Heap Fetches: 94
165. 0.006 646.536 ↑ 1.0 1 1

Subquery Scan on *SELECT* 2 (cost=136,153.94..136,203.04 rows=1 width=4,018) (actual time=645.546..646.536 rows=1 loops=1)

166. 0.025 646.530 ↑ 1.0 1 1

Nested Loop Left Join (cost=136,153.94..136,203.02 rows=1 width=4,006) (actual time=645.540..646.530 rows=1 loops=1)

  • Join Filter: (data_output.id = hd_2.path_id)
167. 0.464 355.385 ↑ 1.0 1 1

Subquery Scan on data_output (cost=69,068.68..69,117.67 rows=1 width=170) (actual time=354.396..355.385 rows=1 loops=1)

  • Filter: (CASE (data_output.local_is_registered = 1) WHEN CASE_TEST_EXPR THEN (data_output.local_mtree_id IS NOT NULL) ELSE true END AND CASE (data_output.remote_is_registered = 1) WHEN CASE_TEST_EXPR THEN (data_output. (...)
  • Rows Removed by Filter: 477
168. 1.253 324.263 ↑ 1.0 478 1

WindowAgg (cost=66,418.16..66,456.40 rows=478 width=896) (actual time=322.901..324.263 rows=478 loops=1)

169. 0.947 323.010 ↑ 1.0 478 1

Sort (cost=66,418.16..66,419.35 rows=478 width=246) (actual time=322.882..323.010 rows=478 loops=1)

  • Sort Key: cdp.id, cdp2.id DESC
  • Sort Method: quicksort Memory: 151kB
170. 0.388 322.063 ↑ 1.0 478 1

Hash Left Join (cost=66,035.33..66,396.88 rows=478 width=246) (actual time=257.207..322.063 rows=478 loops=1)

  • Hash Cond: (cdp.id = comp_table.id)
171. 43.090 80.601 ↑ 1.0 478 1

Nested Loop Left Join (cost=1,161.46..1,521.21 rows=478 width=170) (actual time=16.106..80.601 rows=478 loops=1)

  • Join Filter: (measure_table.id = cdp.id)
  • Rows Removed by Join Filter: 228,006
172. 0.470 16.957 ↑ 1.0 478 1

Hash Left Join (cost=1,049.34..1,379.21 rows=478 width=170) (actual time=13.920..16.957 rows=478 loops=1)

  • Hash Cond: ((cdp.local_system_id = cdp2.remote_system_id) AND (cdp.remote_system_id = cdp2.local_system_id) AND (cdp.local_mtree_id = cdp2.remote_mtree_id))
173. 0.270 16.079 ↑ 1.0 478 1

Hash Left Join (cost=1,027.19..1,337.34 rows=478 width=162) (actual time=13.492..16.079 rows=478 loops=1)

  • Hash Cond: (cctu2_2.tenant_id = cct2_2.id)
174. 0.327 15.526 ↑ 1.0 478 1

Hash Left Join (cost=1,014.73..1,320.81 rows=478 width=157) (actual time=13.195..15.526 rows=478 loops=1)

  • Hash Cond: ((cdp.remote_system_id = cctu2_2.system_id) AND (ccm2.tenant_unit_id = cctu2_2.id))
175. 0.595 14.025 ↑ 1.0 478 1

Hash Left Join (cost=842.57..1,145.06 rows=478 width=142) (actual time=11.999..14.025 rows=478 loops=1)

  • Hash Cond: ((cdp.remote_mtree_id = ccm2.mtree_id) AND (cdp.remote_system_id = ccm2.system_id))
176. 0.295 8.889 ↑ 1.0 478 1

Hash Left Join (cost=532.85..818.46 rows=478 width=134) (actual time=7.416..8.889 rows=478 loops=1)

  • Hash Cond: (cctu.tenant_id = cct.id)
177. 0.546 8.317 ↑ 1.0 478 1

Hash Right Join (cost=520.38..801.94 rows=478 width=129) (actual time=7.117..8.317 rows=478 loops=1)

  • Hash Cond: (csl.id = cdp.local_system_id)
178. 0.684 0.684 ↑ 1.0 201 1

Seq Scan on cfg_systems csl (cost=0.00..274.01 rows=201 width=18) (actual time=0.007..0.684 rows=201 loops=1)

179. 0.419 7.087 ↑ 1.0 478 1

Hash (cost=514.41..514.41 rows=478 width=119) (actual time=7.087..7.087 rows=478 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 77kB
180. 0.584 6.668 ↑ 1.0 478 1

Hash Right Join (cost=347.53..514.41 rows=478 width=119) (actual time=6.431..6.668 rows=478 loops=1)

  • Hash Cond: ((cctu.system_id = cdp.local_system_id) AND (cctu.id = ccm.tenant_unit_id))
181. 0.520 0.520 ↑ 1.0 1,060 1

Seq Scan on cd_cfg_tenant_units cctu (cost=0.00..156.26 rows=1,060 width=31) (actual time=0.012..0.520 rows=1,060 loops=1)

  • Filter: (id <> 0)
  • Rows Removed by Filter: 1
182. 0.347 5.564 ↑ 1.0 478 1

Hash (cost=340.36..340.36 rows=478 width=104) (actual time=5.564..5.564 rows=478 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 77kB
183. 0.512 5.217 ↑ 1.0 478 1

Hash Left Join (cost=309.72..340.36 rows=478 width=104) (actual time=4.677..5.217 rows=478 loops=1)

  • Hash Cond: ((cdp.local_mtree_id = ccm.mtree_id) AND (cdp.local_system_id = ccm.system_id))
184. 0.074 0.074 ↑ 1.0 478 1

Seq Scan on cfg_ddboost_path cdp (cost=0.00..13.78 rows=478 width=96) (actual time=0.007..0.074 rows=478 loops=1)

185. 1.944 4.631 ↑ 1.0 4,989 1

Hash (cost=234.89..234.89 rows=4,989 width=24) (actual time=4.631..4.631 rows=4,989 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 302kB
186. 2.687 2.687 ↑ 1.0 4,989 1

Seq Scan on cd_cfg_mtrees ccm (cost=0.00..234.89 rows=4,989 width=24) (actual time=0.006..2.687 rows=4,989 loops=1)

187. 0.118 0.277 ↓ 1.0 343 1

Hash (cost=8.24..8.24 rows=338 width=13) (actual time=0.277..0.277 rows=343 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
188. 0.159 0.159 ↓ 1.0 343 1

Seq Scan on cd_cfg_tenants cct (cost=0.00..8.24 rows=338 width=13) (actual time=0.008..0.159 rows=343 loops=1)

  • Filter: (id <> 0)
  • Rows Removed by Filter: 1
189. 1.924 4.541 ↑ 1.0 4,989 1

Hash (cost=234.89..234.89 rows=4,989 width=24) (actual time=4.541..4.541 rows=4,989 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 302kB
190. 2.617 2.617 ↑ 1.0 4,989 1

Seq Scan on cd_cfg_mtrees ccm2 (cost=0.00..234.89 rows=4,989 width=24) (actual time=0.013..2.617 rows=4,989 loops=1)

191. 0.463 1.174 ↑ 1.0 1,060 1

Hash (cost=156.26..156.26 rows=1,060 width=31) (actual time=1.174..1.174 rows=1,060 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 82kB
192. 0.711 0.711 ↑ 1.0 1,060 1

Seq Scan on cd_cfg_tenant_units cctu2_2 (cost=0.00..156.26 rows=1,060 width=31) (actual time=0.010..0.711 rows=1,060 loops=1)

  • Filter: (id <> 0)
  • Rows Removed by Filter: 1
193. 0.120 0.283 ↓ 1.0 343 1

Hash (cost=8.24..8.24 rows=338 width=13) (actual time=0.283..0.283 rows=343 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
194. 0.163 0.163 ↓ 1.0 343 1

Seq Scan on cd_cfg_tenants cct2_2 (cost=0.00..8.24 rows=338 width=13) (actual time=0.007..0.163 rows=343 loops=1)

  • Filter: (id <> 0)
  • Rows Removed by Filter: 1
195. 0.231 0.408 ↑ 1.0 478 1

Hash (cost=13.78..13.78 rows=478 width=32) (actual time=0.408..0.408 rows=478 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 38kB
196. 0.177 0.177 ↑ 1.0 478 1

Seq Scan on cfg_ddboost_path cdp2 (cost=0.00..13.78 rows=478 width=32) (actual time=0.005..0.177 rows=478 loops=1)

197. 18.330 20.554 ↓ 239.0 478 478

Materialize (cost=112.12..127.67 rows=2 width=4) (actual time=0.003..0.043 rows=478 loops=478)

198. 0.113 2.224 ↓ 239.0 478 1

Subquery Scan on measure_table (cost=112.12..127.66 rows=2 width=4) (actual time=1.399..2.224 rows=478 loops=1)

  • Filter: (measure_table.rnk_num_files_remaining_bytes = 1)
199. 0.623 2.111 ↑ 1.0 478 1

WindowAgg (cost=112.12..121.68 rows=478 width=56) (actual time=1.396..2.111 rows=478 loops=1)

200. 0.275 1.488 ↑ 1.0 478 1

Sort (cost=112.12..113.32 rows=478 width=36) (actual time=1.386..1.488 rows=478 loops=1)

  • Sort Key: cdp2_1.id, (ROW((max(cd_status_ddboost.num_files)), (max(cd_status_ddboost.remaining_bytes)))) DESC
  • Sort Method: quicksort Memory: 62kB
201. 0.241 1.213 ↑ 1.0 478 1

Merge Right Join (cost=74.10..90.85 rows=478 width=36) (actual time=0.908..1.213 rows=478 loops=1)

  • Merge Cond: ((cd_status_ddboost.path_id = cdp2_1.id) AND (cd_status_ddboost.system_id = cdp2_1.local_system_id))
202. 0.002 0.012 ↓ 0.0 0 1

GroupAggregate (cost=28.29..36.16 rows=350 width=24) (actual time=0.012..0.012 rows=0 loops=1)

  • Group Key: cd_status_ddboost.path_id, cd_status_ddboost.system_id
203. 0.007 0.010 ↓ 0.0 0 1

Sort (cost=28.29..29.16 rows=350 width=24) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: cd_status_ddboost.path_id, cd_status_ddboost.system_id
  • Sort Method: quicksort Memory: 25kB
204. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on cd_status_ddboost (cost=0.00..13.50 rows=350 width=24) (actual time=0.003..0.003 rows=0 loops=1)

205. 0.315 0.960 ↑ 1.0 478 1

Sort (cost=45.81..47.00 rows=478 width=12) (actual time=0.890..0.960 rows=478 loops=1)

  • Sort Key: cdp2_1.id, cdp2_1.local_system_id
  • Sort Method: quicksort Memory: 47kB
206. 0.074 0.645 ↑ 1.0 478 1

Subquery Scan on cdp2_1 (cost=14.98..24.54 rows=478 width=12) (actual time=0.437..0.645 rows=478 loops=1)

207. 0.508 0.571 ↑ 1.0 478 1

HashAggregate (cost=14.98..19.76 rows=478 width=16) (actual time=0.436..0.571 rows=478 loops=1)

  • Group Key: cfg_ddboost_path.id
208. 0.063 0.063 ↑ 1.0 478 1

Seq Scan on cfg_ddboost_path (cost=0.00..13.78 rows=478 width=16) (actual time=0.002..0.063 rows=478 loops=1)

209. 0.000 241.074 ↓ 0.0 0 1

Hash (cost=64,873.86..64,873.86 rows=1 width=80) (actual time=241.074..241.074 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
210. 0.000 241.074 ↓ 0.0 0 1

Subquery Scan on comp_table (cost=64,873.81..64,873.86 rows=1 width=80) (actual time=241.074..241.074 rows=0 loops=1)

211. 0.002 241.074 ↓ 0.0 0 1

GroupAggregate (cost=64,873.81..64,873.85 rows=1 width=88) (actual time=241.074..241.074 rows=0 loops=1)

  • Group Key: comp_table_innermost.id, comp_table_innermost.epoch, comp_table_innermost.local_system_id, comp_table_innermost.remote_is_registered, comp_table_innermost.status_last_hour (...)
212. 0.018 241.072 ↓ 0.0 0 1

Sort (cost=64,873.81..64,873.82 rows=1 width=117) (actual time=241.072..241.072 rows=0 loops=1)

  • Sort Key: comp_table_innermost.id, comp_table_innermost.epoch, comp_table_innermost.local_system_id, comp_table_innermost.remote_is_registered, comp_table_innermost.status_last (...)
  • Sort Method: quicksort Memory: 25kB
213. 0.002 241.054 ↓ 0.0 0 1

Subquery Scan on comp_table_innermost (cost=64,869.19..64,873.80 rows=1 width=117) (actual time=241.054..241.054 rows=0 loops=1)

  • Filter: (comp_table_innermost.epoch_rnk = 1)
214. 0.001 241.052 ↓ 0.0 0 1

WindowAgg (cost=64,869.19..64,872.03 rows=142 width=125) (actual time=241.052..241.052 rows=0 loops=1)

215. 0.008 241.051 ↓ 0.0 0 1

Sort (cost=64,869.19..64,869.54 rows=142 width=117) (actual time=241.051..241.051 rows=0 loops=1)

  • Sort Key: cfg_ddboost_path_1.id, hd_processed_ddboost_optdup.epoch DESC
  • Sort Method: quicksort Memory: 25kB
216. 0.013 241.043 ↓ 0.0 0 1

Hash Right Join (cost=64,843.10..64,864.11 rows=142 width=117) (actual time=241.043..241.043 rows=0 loops=1)

  • Hash Cond: ((cd_status_ddboost_1.path_id = cfg_ddboost_path_1.id) AND (cd_status_ddboost_1.system_id = cfg_ddboost_path_1.local_system_id))
217. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=17.00..20.50 rows=350 width=77) (never executed)

  • Group Key: cd_status_ddboost_1.path_id, cd_status_ddboost_1.system_id, cd_status_ddboost_1.status, cd_status_ddboost_1.status_msg
218. 0.000 0.000 ↓ 0.0 0

Seq Scan on cd_status_ddboost cd_status_ddboost_1 (cost=0.00..13.50 rows=350 width=77) (never executed)

219. 0.001 241.030 ↓ 0.0 0 1

Hash (cost=64,823.97..64,823.97 rows=142 width=52) (actual time=241.030..241.030 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
220. 0.081 241.029 ↓ 0.0 0 1

Hash Join (cost=64,387.57..64,823.97 rows=142 width=52) (actual time=241.029..241.029 rows=0 loops=1)

  • Hash Cond: ((cfg_ddboost_path_1.id = hd_processed_ddboost_optdup.path_id) AND (cfg_ddboost_path_1.local_system_id = hd_processed_ddboost_opt (...)
221. 0.349 0.416 ↑ 478.0 1 1

HashAggregate (cost=14.98..19.76 rows=478 width=36) (actual time=0.416..0.416 rows=1 loops=1)

  • Group Key: cfg_ddboost_path_1.id
222. 0.067 0.067 ↑ 1.0 478 1

Seq Scan on cfg_ddboost_path cfg_ddboost_path_1 (cost=0.00..13.78 rows=478 width=36) (actual time=0.006..0.067 rows=478 loops=1)

223. 0.001 240.532 ↓ 0.0 0 1

Hash (cost=64,194.95..64,194.95 rows=11,843 width=32) (actual time=240.532..240.532 rows=0 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 128kB
224. 240.531 240.531 ↓ 0.0 0 1

Seq Scan on hd_processed_ddboost_optdup (cost=0.00..64,194.95 rows=11,843 width=32) (actual time=240.531..240.531 rows=0 loops=1)

  • Filter: ((num_files_successful_last_hour + num_files_errored_last_hour) > '0'::double precision)
  • Rows Removed by Filter: 31,982
225.          

SubPlan (for Subquery Scan)

226. 0.033 15.424 ↑ 10.0 1 1

HashSetOp Intersect (cost=300.46..1,325.24 rows=10 width=12) (actual time=15.423..15.424 rows=1 loops=1)

227. 0.020 15.391 ↑ 6.5 201 1

Append (cost=300.46..1,321.99 rows=1,299 width=12) (actual time=0.946..15.391 rows=201 loops=1)

228. 0.003 0.947 ↑ 10.0 1 1

Subquery Scan on *SELECT* 1_2 (cost=300.46..300.61 rows=10 width=12) (actual time=0.945..0.947 rows=1 loops=1)

229. 0.001 0.944 ↑ 10.0 1 1

Unique (cost=300.46..300.51 rows=10 width=8) (actual time=0.943..0.944 rows=1 loops=1)

230. 0.017 0.943 ↑ 10.0 1 1

Sort (cost=300.46..300.49 rows=10 width=8) (actual time=0.942..0.943 rows=1 loops=1)

  • Sort Key: cfg_system_nodes_view_2.system_id
  • Sort Method: quicksort Memory: 25kB
231. 0.001 0.926 ↑ 10.0 1 1

Subquery Scan on cfg_system_nodes_view_2 (cost=0.57..300.30 rows=10 width=8) (actual time=0.787..0.926 rows=1 loops=1)

232. 0.185 0.925 ↑ 10.0 1 1

Nested Loop Left Join (cost=0.57..300.20 rows=10 width=8,468) (actual time=0.786..0.925 rows=1 loops=1)

233. 0.007 0.737 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.42..297.05 rows=1 width=16) (actual time=0.599..0.737 rows=1 loops=1)

234. 0.037 0.721 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.27..296.84 rows=1 width=16) (actual time=0.584..0.721 rows=1 loops=1)

  • Join Filter: (n_4.system_id = f_4.system_id)
  • Rows Removed by Join Filter: 200
235. 0.006 0.629 ↑ 1.0 1 1

Nested Loop (cost=0.27..283.32 rows=1 width=16) (actual time=0.570..0.629 rows=1 loops=1)

236. 0.607 0.607 ↑ 1.0 1 1

Seq Scan on cfg_systems s_4 (cost=0.00..275.01 rows=1 width=8) (actual time=0.551..0.607 rows=1 loops=1)

  • Filter: (lower((name)::text) = 'ddr-10.213.216.18-1'::text)
  • Rows Removed by Filter: 200
237. 0.016 0.016 ↑ 1.0 1 1

Index Scan using cfg_nodes_system_id_idx on cfg_nodes n_4 (cost=0.27..8.29 rows=1 width=20) (actual time=0.013..0.016 rows=1 loops=1)

  • Index Cond: (system_id = s_4.id)
238. 0.055 0.055 ↑ 1.0 201 1

Seq Scan on cd_cfg_systems_features_status f_4 (cost=0.00..11.01 rows=201 width=8) (actual time=0.006..0.055 rows=201 loops=1)

239. 0.009 0.009 ↑ 1.0 1 1

Index Only Scan using cd_cfg_collections_system_id_idx on cd_cfg_collections l_5 (cost=0.14..0.20 rows=1 width=8) (actual time=0.008..0.009 rows=1 loops=1)

  • Index Cond: (system_id = n_4.system_id)
  • Heap Fetches: 1
240. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using cd_cfg_ha_system_config_sys_status_idx on cd_cfg_ha_system_config sc_4 (cost=0.15..0.55 rows=10 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (system_id = n_4.system_id)
  • Heap Fetches: 0
241. 0.034 14.424 ↑ 6.4 200 1

Subquery Scan on *SELECT* 2_4 (cost=995.59..1,021.37 rows=1,289 width=12) (actual time=14.294..14.424 rows=200 loops=1)

242. 0.394 14.390 ↑ 6.4 200 1

HashAggregate (cost=995.59..1,008.48 rows=1,289 width=8) (actual time=14.293..14.390 rows=200 loops=1)

  • Group Key: n_5.system_id
243. 10.467 13.996 ↑ 6.4 200 1

Hash Right Join (cost=606.29..979.48 rows=1,289 width=8,468) (actual time=3.660..13.996 rows=200 loops=1)

  • Hash Cond: (sc_5.system_id = n_5.system_id)
244. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on cd_cfg_ha_system_config sc_5 (cost=0.00..30.40 rows=2,040 width=8) (actual time=0.003..0.003 rows=0 loops=1)

245. 0.081 3.526 ↓ 1.6 200 1

Hash (cost=604.70..604.70 rows=127 width=16) (actual time=3.526..3.526 rows=200 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 18kB
246. 0.137 3.445 ↓ 1.6 200 1

Hash Left Join (cost=92.97..604.70 rows=127 width=16) (actual time=0.540..3.445 rows=200 loops=1)

  • Hash Cond: (n_5.system_id = l_6.system_id)
247. 0.105 3.113 ↓ 1.6 200 1

Hash Left Join (cost=79.32..589.32 rows=127 width=16) (actual time=0.330..3.113 rows=200 loops=1)

  • Hash Cond: (n_5.system_id = f_5.system_id)
248. 0.120 2.893 ↓ 1.6 200 1

Hash Left Join (cost=65.80..574.05 rows=127 width=16) (actual time=0.205..2.893 rows=200 loops=1)

  • Hash Cond: (n_5.system_id = s_5.id)
249. 2.634 2.634 ↓ 1.6 200 1

Seq Scan on cfg_nodes n_5 (cost=0.00..506.51 rows=127 width=20) (actual time=0.059..2.634 rows=200 loops=1)

  • Filter: ((system_id = 17) OR (system_id = 18) OR (system_id = 19) OR (system_id = 20) OR (system_id = 21) OR (system_id = 22) OR (system_id = 23) OR (system (...)
  • Rows Removed by Filter: 1
250. 0.062 0.139 ↑ 1.0 201 1

Hash (cost=63.29..63.29 rows=201 width=8) (actual time=0.139..0.139 rows=201 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
251. 0.077 0.077 ↑ 1.0 201 1

Index Only Scan using cfg_systems_pkey on cfg_systems s_5 (cost=0.27..63.29 rows=201 width=8) (actual time=0.009..0.077 rows=201 loops=1)

  • Heap Fetches: 24
252. 0.053 0.115 ↑ 1.0 201 1

Hash (cost=11.01..11.01 rows=201 width=8) (actual time=0.115..0.115 rows=201 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
253. 0.062 0.062 ↑ 1.0 201 1

Seq Scan on cd_cfg_systems_features_status f_5 (cost=0.00..11.01 rows=201 width=8) (actual time=0.004..0.062 rows=201 loops=1)

254. 0.098 0.195 ↑ 1.0 200 1

Hash (cost=11.14..11.14 rows=200 width=8) (actual time=0.195..0.195 rows=200 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
255. 0.097 0.097 ↑ 1.0 200 1

Index Only Scan using cd_cfg_collections_system_id_idx on cd_cfg_collections l_6 (cost=0.14..11.14 rows=200 width=8) (actual time=0.011..0.097 rows=200 loops=1)

  • Heap Fetches: 94
256. 0.030 15.234 ↑ 10.0 1 1

HashSetOp Intersect (cost=300.46..1,325.24 rows=10 width=12) (actual time=15.234..15.234 rows=1 loops=1)

257. 0.023 15.204 ↑ 6.5 201 1

Append (cost=300.46..1,321.99 rows=1,299 width=12) (actual time=0.787..15.204 rows=201 loops=1)

258. 0.001 0.787 ↑ 10.0 1 1

Subquery Scan on *SELECT* 1_3 (cost=300.46..300.61 rows=10 width=12) (actual time=0.787..0.787 rows=1 loops=1)

259. 0.002 0.786 ↑ 10.0 1 1

Unique (cost=300.46..300.51 rows=10 width=8) (actual time=0.786..0.786 rows=1 loops=1)

260. 0.008 0.784 ↑ 10.0 1 1

Sort (cost=300.46..300.49 rows=10 width=8) (actual time=0.784..0.784 rows=1 loops=1)

  • Sort Key: cfg_system_nodes_view_3.system_id
  • Sort Method: quicksort Memory: 25kB
261. 0.000 0.776 ↑ 10.0 1 1

Subquery Scan on cfg_system_nodes_view_3 (cost=0.57..300.30 rows=10 width=8) (actual time=0.646..0.776 rows=1 loops=1)

262. 0.131 0.776 ↑ 10.0 1 1

Nested Loop Left Join (cost=0.57..300.20 rows=10 width=8,468) (actual time=0.646..0.776 rows=1 loops=1)

263. 0.006 0.643 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.42..297.05 rows=1 width=16) (actual time=0.514..0.643 rows=1 loops=1)

264. 0.035 0.630 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.27..296.84 rows=1 width=16) (actual time=0.502..0.630 rows=1 loops=1)

  • Join Filter: (n_6.system_id = f_6.system_id)
  • Rows Removed by Join Filter: 200
265. 0.004 0.548 ↑ 1.0 1 1

Nested Loop (cost=0.27..283.32 rows=1 width=16) (actual time=0.489..0.548 rows=1 loops=1)

266. 0.532 0.532 ↑ 1.0 1 1

Seq Scan on cfg_systems s_6 (cost=0.00..275.01 rows=1 width=8) (actual time=0.476..0.532 rows=1 loops=1)

  • Filter: (lower((name)::text) = 'ddr-10.213.216.18-1'::text)
  • Rows Removed by Filter: 200
267. 0.012 0.012 ↑ 1.0 1 1

Index Scan using cfg_nodes_system_id_idx on cfg_nodes n_6 (cost=0.27..8.29 rows=1 width=20) (actual time=0.009..0.012 rows=1 loops=1)

  • Index Cond: (system_id = s_6.id)
268. 0.047 0.047 ↑ 1.0 201 1

Seq Scan on cd_cfg_systems_features_status f_6 (cost=0.00..11.01 rows=201 width=8) (actual time=0.005..0.047 rows=201 loops=1)

269. 0.007 0.007 ↑ 1.0 1 1

Index Only Scan using cd_cfg_collections_system_id_idx on cd_cfg_collections l_7 (cost=0.14..0.20 rows=1 width=8) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (system_id = n_6.system_id)
  • Heap Fetches: 1
270. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using cd_cfg_ha_system_config_sys_status_idx on cd_cfg_ha_system_config sc_6 (cost=0.15..0.55 rows=10 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (system_id = n_6.system_id)
  • Heap Fetches: 0
271. 0.046 14.394 ↑ 6.4 200 1

Subquery Scan on *SELECT* 2_5 (cost=995.59..1,021.37 rows=1,289 width=12) (actual time=14.264..14.394 rows=200 loops=1)

272. 0.393 14.348 ↑ 6.4 200 1

HashAggregate (cost=995.59..1,008.48 rows=1,289 width=8) (actual time=14.263..14.348 rows=200 loops=1)

  • Group Key: n_7.system_id
273. 10.512 13.955 ↑ 6.4 200 1

Hash Right Join (cost=606.29..979.48 rows=1,289 width=8,468) (actual time=3.572..13.955 rows=200 loops=1)

  • Hash Cond: (sc_7.system_id = n_7.system_id)
274. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on cd_cfg_ha_system_config sc_7 (cost=0.00..30.40 rows=2,040 width=8) (actual time=0.002..0.002 rows=0 loops=1)

275. 0.089 3.441 ↓ 1.6 200 1

Hash (cost=604.70..604.70 rows=127 width=16) (actual time=3.441..3.441 rows=200 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 18kB
276. 0.137 3.352 ↓ 1.6 200 1

Hash Left Join (cost=92.97..604.70 rows=127 width=16) (actual time=0.515..3.352 rows=200 loops=1)

  • Hash Cond: (n_7.system_id = l_8.system_id)
277. 0.112 3.063 ↓ 1.6 200 1

Hash Left Join (cost=79.32..589.32 rows=127 width=16) (actual time=0.350..3.063 rows=200 loops=1)

  • Hash Cond: (n_7.system_id = f_7.system_id)
278. 0.122 2.836 ↓ 1.6 200 1

Hash Left Join (cost=65.80..574.05 rows=127 width=16) (actual time=0.220..2.836 rows=200 loops=1)

  • Hash Cond: (n_7.system_id = s_7.id)
279. 2.567 2.567 ↓ 1.6 200 1

Seq Scan on cfg_nodes n_7 (cost=0.00..506.51 rows=127 width=20) (actual time=0.065..2.567 rows=200 loops=1)

  • Filter: ((system_id = 17) OR (system_id = 18) OR (system_id = 19) OR (system_id = 20) OR (system_id = 21) OR (system_id = 22) OR (system_id = 23) OR (system (...)
  • Rows Removed by Filter: 1
280. 0.067 0.147 ↑ 1.0 201 1

Hash (cost=63.29..63.29 rows=201 width=8) (actual time=0.147..0.147 rows=201 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
281. 0.080 0.080 ↑ 1.0 201 1

Index Only Scan using cfg_systems_pkey on cfg_systems s_7 (cost=0.27..63.29 rows=201 width=8) (actual time=0.006..0.080 rows=201 loops=1)

  • Heap Fetches: 24
282. 0.059 0.115 ↑ 1.0 201 1

Hash (cost=11.01..11.01 rows=201 width=8) (actual time=0.115..0.115 rows=201 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
283. 0.056 0.056 ↑ 1.0 201 1

Seq Scan on cd_cfg_systems_features_status f_7 (cost=0.00..11.01 rows=201 width=8) (actual time=0.004..0.056 rows=201 loops=1)

284. 0.052 0.152 ↑ 1.0 200 1

Hash (cost=11.14..11.14 rows=200 width=8) (actual time=0.152..0.152 rows=200 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
285. 0.100 0.100 ↑ 1.0 200 1

Index Only Scan using cd_cfg_collections_system_id_idx on cd_cfg_collections l_8 (cost=0.14..11.14 rows=200 width=8) (actual time=0.013..0.100 rows=200 loops=1)

  • Heap Fetches: 94
286. 0.000 291.120 ↓ 0.0 0 1

GroupAggregate (cost=67,085.26..67,085.29 rows=1 width=86) (actual time=291.120..291.120 rows=0 loops=1)

  • Group Key: hd_2.system_id, cs_1.name, cs_1.type, hd_2.path_id
287. 0.016 291.120 ↓ 0.0 0 1

Sort (cost=67,085.26..67,085.26 rows=1 width=78) (actual time=291.120..291.120 rows=0 loops=1)

  • Sort Key: hd_2.system_id, cs_1.name, cs_1.type, hd_2.path_id
  • Sort Method: quicksort Memory: 25kB
288. 0.000 291.104 ↓ 0.0 0 1

Nested Loop (cost=67,077.18..67,085.25 rows=1 width=78) (actual time=291.104..291.104 rows=0 loops=1)

289. 0.002 291.104 ↓ 0.0 0 1

GroupAggregate (cost=67,076.91..67,076.94 rows=1 width=48) (actual time=291.104..291.104 rows=0 loops=1)

  • Group Key: hd_2.system_id, hd_2.path_id
290. 0.005 291.102 ↓ 0.0 0 1

Sort (cost=67,076.91..67,076.92 rows=1 width=48) (actual time=291.102..291.102 rows=0 loops=1)

  • Sort Key: hd_2.system_id, hd_2.path_id
  • Sort Method: quicksort Memory: 25kB
291. 0.010 291.097 ↓ 0.0 0 1

Hash Join (cost=66,051.98..67,076.90 rows=1 width=48) (actual time=291.097..291.097 rows=0 loops=1)

  • Hash Cond: ("ANY_subquery_1".system_id = hd_2.system_id)
292. 0.001 16.171 ↑ 10.0 1 1

Subquery Scan on ANY_subquery_1 (cost=300.46..1,325.34 rows=10 width=8) (actual time=16.171..16.171 rows=1 loops=1)

293. 0.048 16.170 ↑ 10.0 1 1

HashSetOp Intersect (cost=300.46..1,325.24 rows=10 width=12) (actual time=16.170..16.170 rows=1 loops=1)

294. 0.019 16.122 ↑ 6.5 201 1

Append (cost=300.46..1,321.99 rows=1,299 width=12) (actual time=0.772..16.122 rows=201 loops=1)

295. 0.001 0.773 ↑ 10.0 1 1

Subquery Scan on *SELECT* 1_1 (cost=300.46..300.61 rows=10 width=12) (actual time=0.772..0.773 rows=1 loops=1)

296. 0.002 0.772 ↑ 10.0 1 1

Unique (cost=300.46..300.51 rows=10 width=8) (actual time=0.771..0.772 rows=1 loops=1)

297. 0.010 0.770 ↑ 10.0 1 1

Sort (cost=300.46..300.49 rows=10 width=8) (actual time=0.769..0.770 rows=1 loops=1)

  • Sort Key: cfg_system_nodes_view_1.system_id
  • Sort Method: quicksort Memory: 25kB
298. 0.000 0.760 ↑ 10.0 1 1

Subquery Scan on cfg_system_nodes_view_1 (cost=0.57..300.30 rows=10 width=8) (actual time=0.618..0.760 rows=1 loops=1)

299. 0.105 0.760 ↑ 10.0 1 1

Nested Loop Left Join (cost=0.57..300.20 rows=10 width=8,468) (actual time=0.618..0.760 rows=1 loops=1)

  • -> Index Only Scan using cd_cfg_ha_system_config_sys_status_idx on cd_cfg_ha_system_config sc_2 (cost=0.15..0.55 rows=10 width=8) (actual (...)
300. 0.010 0.655 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.42..297.05 rows=1 width=16) (actual time=0.514..0.655 rows=1 loops=1)

  • -> Index Only Scan using cd_cfg_collections_system_id_idx on cd_cfg_collections l_3 (cost=0.14..0.20 rows=1 width=8) (actual time=0. (...)
  • Index Cond: (system_id = n_2.system_id)
  • Heap Fetches: 0
301. 0.092 0.645 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.27..296.84 rows=1 width=16) (actual time=0.505..0.645 rows=1 loops=1)

  • Join Filter: (n_2.system_id = f_2.system_id)
  • Rows Removed by Join Filter: 200
  • -> Seq Scan on cd_cfg_systems_features_status f_2 (cost=0.00..11.01 rows=201 width=8) (actual time=0.003..0.052 rows=201 loops (...)
  • Index Cond: (system_id = n_2.system_id)
  • Heap Fetches: 1
302. 0.012 0.553 ↑ 1.0 1 1

Nested Loop (cost=0.27..283.32 rows=1 width=16) (actual time=0.494..0.553 rows=1 loops=1)

  • -> Index Scan using cfg_nodes_system_id_idx on cfg_nodes n_2 (cost=0.27..8.29 rows=1 width=20) (actual time=0.006..0.008 (...)
303. 0.541 0.541 ↑ 1.0 1 1

Seq Scan on cfg_systems s_2 (cost=0.00..275.01 rows=1 width=8) (actual time=0.484..0.541 rows=1 loops=1)

  • Filter: (lower((name)::text) = 'ddr-10.213.216.18-1'::text)
  • Rows Removed by Filter: 200
  • Index Cond: (system_id = s_2.id)
304. 0.039 15.330 ↑ 6.4 200 1

Subquery Scan on *SELECT* 2_3 (cost=995.59..1,021.37 rows=1,289 width=12) (actual time=15.206..15.330 rows=200 loops=1)

305. 0.429 15.291 ↑ 6.4 200 1

HashAggregate (cost=995.59..1,008.48 rows=1,289 width=8) (actual time=15.205..15.291 rows=200 loops=1)

  • Group Key: n_3.system_id
306. 11.347 14.862 ↑ 6.4 200 1

Hash Right Join (cost=606.29..979.48 rows=1,289 width=8,468) (actual time=3.642..14.862 rows=200 loops=1)

  • Hash Cond: (sc_3.system_id = n_3.system_id)
307. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on cd_cfg_ha_system_config sc_3 (cost=0.00..30.40 rows=2,040 width=8) (actual time=0.003..0.003 rows=0 loops=1)

308. 0.095 3.512 ↓ 1.6 200 1

Hash (cost=604.70..604.70 rows=127 width=16) (actual time=3.511..3.512 rows=200 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 18kB
309. 0.129 3.417 ↓ 1.6 200 1

Hash Left Join (cost=92.97..604.70 rows=127 width=16) (actual time=0.511..3.417 rows=200 loops=1)

  • Hash Cond: (n_3.system_id = l_4.system_id)
310. 0.118 3.141 ↓ 1.6 200 1

Hash Left Join (cost=79.32..589.32 rows=127 width=16) (actual time=0.353..3.141 rows=200 loops=1)

  • Hash Cond: (n_3.system_id = f_3.system_id)
311. 0.128 2.903 ↓ 1.6 200 1

Hash Left Join (cost=65.80..574.05 rows=127 width=16) (actual time=0.221..2.903 rows=200 loops=1)

  • Hash Cond: (n_3.system_id = s_3.id)
312. 2.623 2.623 ↓ 1.6 200 1

Seq Scan on cfg_nodes n_3 (cost=0.00..506.51 rows=127 width=20) (actual time=0.060..2.623 rows=200 loops=1)

  • Filter: ((system_id = 17) OR (system_id = 18) OR (system_id = 19) OR (system_id = 20) OR (system_id = 21) OR (system_id = (...)
  • Rows Removed by Filter: 1
313. 0.152 0.152 ↑ 1.0 201 1

Hash (cost=63.29..63.29 rows=201 width=8) (actual time=0.152..0.152 rows=201 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
  • -> Index Only Scan using cfg_systems_pkey on cfg_systems s_3 (cost=0.27..63.29 rows=201 width=8) (actual time=0.005..0.0 (...)
  • Heap Fetches: 24
314. 0.120 0.120 ↑ 1.0 201 1

Hash (cost=11.01..11.01 rows=201 width=8) (actual time=0.120..0.120 rows=201 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
  • -> Seq Scan on cd_cfg_systems_features_status f_3 (cost=0.00..11.01 rows=201 width=8) (actual time=0.004..0.056 rows=201 loops (...)
315. 0.147 0.147 ↑ 1.0 200 1

Hash (cost=11.14..11.14 rows=200 width=8) (actual time=0.147..0.147 rows=200 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
  • -> Index Only Scan using cd_cfg_collections_system_id_idx on cd_cfg_collections l_4 (cost=0.14..11.14 rows=200 width=8) (actual time (...)
  • Heap Fetches: 94
316. 0.000 274.916 ↓ 0.0 0 1

Hash (cost=65,751.51..65,751.51 rows=1 width=48) (actual time=274.916..274.916 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
317. 0.003 274.916 ↓ 0.0 0 1

Merge Join (cost=65,743.72..65,751.51 rows=1 width=48) (actual time=274.916..274.916 rows=0 loops=1)

  • Merge Cond: (data_output_1.id = hd_2.path_id)
318. 0.003 274.884 ↑ 2.0 1 1

Subquery Scan on data_output_1 (cost=65,735.27..65,750.80 rows=2 width=4) (actual time=274.884..274.884 rows=1 loops=1)

  • Filter: (data_output_1.comp_table_id_rank = 1)
319. 0.017 274.881 ↑ 478.0 1 1

WindowAgg (cost=65,735.27..65,744.83 rows=478 width=4,176) (actual time=274.881..274.881 rows=1 loops=1)

320. 0.200 274.864 ↑ 478.0 1 1

Sort (cost=65,735.27..65,736.46 rows=478 width=8) (actual time=274.864..274.864 rows=1 loops=1)

  • Sort Key: cdp_1.id, cdp2_2.id DESC
  • Sort Method: quicksort Memory: 47kB
321. 0.192 274.664 ↑ 1.0 478 1

Hash Left Join (cost=65,643.14..65,713.99 rows=478 width=8) (actual time=273.099..274.664 rows=478 loops=1)

  • Hash Cond: (cdp_1.id = comp_table_1.id)
322. 0.273 13.609 ↑ 1.0 478 1

Hash Left Join (cost=769.28..838.33 rows=478 width=8) (actual time=12.216..13.609 rows=478 loops=1)

  • Hash Cond: (cdp_1.id = measure_table_1.id)
323. 0.279 10.900 ↑ 1.0 478 1

Hash Left Join (cost=641.60..708.83 rows=478 width=8) (actual time=9.755..10.900 rows=478 loops=1)

  • Hash Cond: ((cdp_1.local_system_id = cdp2_2.remote_system_id) AND (cdp_1.remote_system_id = cdp2_2.local_system_id) AND (cdp_1.local_mtree_i (...)
324. 0.364 10.200 ↑ 1.0 478 1

Hash Left Join (cost=619.45..666.96 rows=478 width=28) (actual time=9.314..10.200 rows=478 loops=1)

  • Hash Cond: ((cdp_1.remote_mtree_id = ccm2_1.mtree_id) AND (cdp_1.remote_system_id = ccm2_1.system_id))
325. 0.529 5.399 ↑ 1.0 478 1

Hash Left Join (cost=309.72..340.36 rows=478 width=36) (actual time=4.831..5.399 rows=478 loops=1)

  • Hash Cond: ((cdp_1.local_mtree_id = ccm_1.mtree_id) AND (cdp_1.local_system_id = ccm_1.system_id))
326. 0.099 0.099 ↑ 1.0 478 1

Seq Scan on cfg_ddboost_path cdp_1 (cost=0.00..13.78 rows=478 width=36) (actual time=0.010..0.099 rows=478 loops=1)

327. 1.945 4.771 ↑ 1.0 4,989 1

Hash (cost=234.89..234.89 rows=4,989 width=24) (actual time=4.771..4.771 rows=4,989 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 302kB
328. 2.826 2.826 ↑ 1.0 4,989 1

Seq Scan on cd_cfg_mtrees ccm_1 (cost=0.00..234.89 rows=4,989 width=24) (actual time=0.008..2.826 rows=4,989 loops=1)

329. 1.960 4.437 ↑ 1.0 4,989 1

Hash (cost=234.89..234.89 rows=4,989 width=24) (actual time=4.437..4.437 rows=4,989 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 302kB
330. 2.477 2.477 ↑ 1.0 4,989 1

Seq Scan on cd_cfg_mtrees ccm2_1 (cost=0.00..234.89 rows=4,989 width=24) (actual time=0.005..2.477 rows=4,989 loops=1)

331. 0.210 0.421 ↑ 1.0 478 1

Hash (cost=13.78..13.78 rows=478 width=28) (actual time=0.421..0.421 rows=478 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 38kB
332. 0.211 0.211 ↑ 1.0 478 1

Seq Scan on cfg_ddboost_path cdp2_2 (cost=0.00..13.78 rows=478 width=28) (actual time=0.006..0.211 rows=478 loops=1)

333. 0.142 2.436 ↓ 239.0 478 1

Hash (cost=127.66..127.66 rows=2 width=4) (actual time=2.436..2.436 rows=478 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
334. 0.131 2.294 ↓ 239.0 478 1

Subquery Scan on measure_table_1 (cost=112.12..127.66 rows=2 width=4) (actual time=1.441..2.294 rows=478 loops=1)

  • Filter: (measure_table_1.rnk_num_files_remaining_bytes = 1)
335. 0.664 2.163 ↑ 1.0 478 1

WindowAgg (cost=112.12..121.68 rows=478 width=56) (actual time=1.438..2.163 rows=478 loops=1)

336. 0.247 1.499 ↑ 1.0 478 1

Sort (cost=112.12..113.32 rows=478 width=36) (actual time=1.427..1.499 rows=478 loops=1)

  • Sort Key: cdp2_3.id, (ROW((max(cd_status_ddboost_2.num_files)), (max(cd_status_ddboost_2.remaining_bytes)))) DESC
  • Sort Method: quicksort Memory: 62kB
337. 0.277 1.252 ↑ 1.0 478 1

Merge Right Join (cost=74.10..90.85 rows=478 width=36) (actual time=0.905..1.252 rows=478 loops=1)

  • Merge Cond: ((cd_status_ddboost_2.path_id = cdp2_3.id) AND (cd_status_ddboost_2.system_id = cdp2_3.local_system_id))
338. 0.003 0.013 ↓ 0.0 0 1

GroupAggregate (cost=28.29..36.16 rows=350 width=24) (actual time=0.013..0.013 rows=0 loops=1)

  • Group Key: cd_status_ddboost_2.path_id, cd_status_ddboost_2.system_id
339. 0.010 0.010 ↓ 0.0 0 1

Sort (cost=28.29..29.16 rows=350 width=24) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: cd_status_ddboost_2.path_id, cd_status_ddboost_2.system_id
  • Sort Method: quicksort Memory: 25kB
  • -> Seq Scan on cd_status_ddboost cd_status_ddboost_2 (cost=0.00..13.50 rows=350 width=24) (actual time (...)
340. 0.320 0.962 ↑ 1.0 478 1

Sort (cost=45.81..47.00 rows=478 width=12) (actual time=0.886..0.962 rows=478 loops=1)

  • Sort Key: cdp2_3.id, cdp2_3.local_system_id
  • Sort Method: quicksort Memory: 47kB
341. 0.079 0.642 ↑ 1.0 478 1

Subquery Scan on cdp2_3 (cost=14.98..24.54 rows=478 width=12) (actual time=0.423..0.642 rows=478 loops=1)

342. 0.563 0.563 ↑ 1.0 478 1

HashAggregate (cost=14.98..19.76 rows=478 width=16) (actual time=0.421..0.563 rows=478 loops=1)

  • Group Key: cfg_ddboost_path_2.id
  • -> Seq Scan on cfg_ddboost_path cfg_ddboost_path_2 (cost=0.00..13.78 rows=478 width=16) (actual (...)
343. 0.000 260.863 ↓ 0.0 0 1

Hash (cost=64,873.85..64,873.85 rows=1 width=4) (actual time=260.863..260.863 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
344. 0.003 260.864 ↓ 0.0 0 1

Subquery Scan on comp_table_1 (cost=64,873.81..64,873.85 rows=1 width=4) (actual time=260.863..260.864 rows=0 loops=1)

345. 0.002 260.861 ↓ 0.0 0 1

GroupAggregate (cost=64,873.81..64,873.84 rows=1 width=88) (actual time=260.861..260.861 rows=0 loops=1)

  • Group Key: comp_table_innermost_1.id, comp_table_innermost_1.epoch, comp_table_innermost_1.local_system_id, comp_table_innermost_1.rem (...)
346. 0.019 260.859 ↓ 0.0 0 1

Sort (cost=64,873.81..64,873.82 rows=1 width=52) (actual time=260.859..260.859 rows=0 loops=1)

  • Sort Key: comp_table_innermost_1.id, comp_table_innermost_1.epoch, comp_table_innermost_1.local_system_id, comp_table_innermost_ (...)
  • Sort Method: quicksort Memory: 25kB
  • -> Subquery Scan on comp_table_innermost_1 (cost=64,869.19..64873.80 rows=1 width=52) (actual time=260.842..260.842 rows=0 loop (...)
  • Filter: (comp_table_innermost_1.epoch_rnk = 1)
347. 0.001 260.840 ↓ 0.0 0 1

WindowAgg (cost=64,869.19..64,872.03 rows=142 width=580) (actual time=260.840..260.840 rows=0 loops=1)

348. 0.012 260.839 ↓ 0.0 0 1

Sort (cost=64,869.19..64,869.54 rows=142 width=52) (actual time=260.839..260.839 rows=0 loops=1)

  • Sort Key: cfg_ddboost_path_3.id, hd_processed_ddboost_optdup_1.epoch DESC
  • Sort Method: quicksort Memory: 25kB
349. 0.014 260.827 ↓ 0.0 0 1

Hash Right Join (cost=64,843.10..64,864.11 rows=142 width=52) (actual time=260.827..260.827 rows=0 loops=1)

  • Hash Cond: ((cd_status_ddboost_3.path_id = cfg_ddboost_path_3.id) AND (cd_status_ddboost_3.system_id = c (...)
350. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=17.00..20.50 rows=350 width=77) (never executed)

  • Group Key: cd_status_ddboost_3.path_id, cd_status_ddboost_3.system_id, cd_status_ddboost_3.status, (...)
  • -> Seq Scan on cd_status_ddboost cd_status_ddboost_3 (cost=0.00..13.50 rows=350 width=77) (never (...)
351. 260.813 260.813 ↓ 0.0 0 1

Hash (cost=64,823.97..64,823.97 rows=142 width=52) (actual time=260.813..260.813 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
  • -> Hash Join (cost=64,387.57..64823.97 rows=142 width=52) (actual time=260.811..260.811 rows=0 lo (...)
  • Hash Cond: ((cfg_ddboost_path_3.id = hd_processed_ddboost_optdup_1.path_id) AND (cfg_ddboost (...)
  • -> HashAggregate (cost=14.98..19.76 rows=478 width=36) (actual time=0.408..0.408 rows=1 lo (...)
  • Group Key: cfg_ddboost_path_3.id
  • -> Seq Scan on cfg_ddboost_path cfg_ddboost_path_3 (cost=0.00..13.78 rows=478 width= (...)
  • -> Hash (cost=64,194.95..64194.95 rows=11,843 width=32) (actual time=260.329..260.329 rows=0 (...)
  • Buckets: 16,384 Batches: 1 Memory Usage: 128kB
  • -> Seq Scan on hd_processed_ddboost_optdup hd_processed_ddboost_optdup_1 (cost=0.00. (...)
  • Filter: ((num_files_successful_last_hour + num_files_errored_last_hour) > '0'::d (...)
  • Rows Removed by Filter: 31,982
352. 0.029 0.029 ↓ 0.0 0 1

Sort (cost=8.45..8.46 rows=1 width=48) (actual time=0.029..0.029 rows=0 loops=1)

  • Sort Key: hd_2.path_id
  • Sort Method: quicksort Memory: 25kB
  • -> Index Scan using hd_processed_ddboost_optdup_epoch_idx on hd_processed_ddboost_optdup hd_2 (cost=0.41..8.44 rows=1 width=48) (actual time=0.014..0.014 rows=0 loops=1 (...)
  • Index Cond: ((epoch >= 1,596,398,819) AND (epoch <= 1,596,485,219))
  • Filter: ((is_active = 1) AND ((interval_mask & 1) > 0))
353. 0.000 0.000 ↓ 0.0 0

Index Scan using cfg_systems_pkey on cfg_systems cs_1 (cost=0.27..8.29 rows=1 width=38) (never executed)

  • Index Cond: (id = hd_2.system_id)
Planning time : 78.383 ms
Execution time : 4,373.784 ms