explain.depesz.com

PostgreSQL's explain analyze made readable

Result: txVN

Settings
# exclusive inclusive rows x rows loops node
1. 8,140.832 129,570.124 ↑ 2.4 8,874 1

Unique (cost=110,589.73..113,067.46 rows=21,087 width=752) (actual time=116,188.307..129,570.124 rows=8,874 loops=1)

  • Output: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, r.system_id, r.ctx_id, r.epoch, l_1.dest_host, l_1.dest_path, r.processed_status, r.processed_status_msg, l_1.pai (...)
2. 114,474.129 121,429.292 ↓ 99.2 2,092,446 1

Sort (cost=110,589.73..110,642.45 rows=21,087 width=752) (actual time=116,188.305..121,429.292 rows=2,092,446 loops=1)

  • Output: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, r.system_id, r.ctx_id, r.epoch, l_1.dest_host, l_1.dest_path, r.processed_status, r.processed_status_msg, l (...)
  • Sort Key: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, r.system_id, r.ctx_id, r.epoch, l_1.dest_host, l_1.dest_path, r.processed_status, r.processed_status_msg, (...)
  • Sort Method: external merge Disk: 1058560kB
3. 3,584.878 6,955.163 ↓ 99.2 2,092,446 1

Hash Left Join (cost=84,155.84..102,082.26 rows=21,087 width=752) (actual time=3,163.368..6,955.163 rows=2,092,446 loops=1)

  • Output: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, r.system_id, r.ctx_id, r.epoch, l_1.dest_host, l_1.dest_path, r.processed_status, r.processed_status_ (...)
  • Hash Cond: (l_1.pair_id = ctx_1.pair_id)
4. 148.094 3,369.788 ↓ 16.8 139,572 1

Hash Left Join (cost=83,473.49..100,836.20 rows=8,302 width=752) (actual time=3,162.852..3,369.788 rows=139,572 loops=1)

  • Output: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, r.system_id, r.ctx_id, r.epoch, l_1.dest_host, l_1.dest_path, r.processed_status, r.processed_s (...)
  • Hash Cond: (l_1.pair_id = ctx.pair_id)
5. 11.203 3,220.977 ↓ 2.0 8,874 1

Hash Left Join (cost=82,794.06..99,887.11 rows=4,392 width=716) (actual time=3,162.119..3,220.977 rows=8,874 loops=1)

  • Output: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, r.system_id, r.ctx_id, r.epoch, l_1.dest_host, l_1.dest_path, r.processed_status, r.proce (...)
  • Hash Cond: (l_1.pair_id = cascades.pair_id)
6. 29.953 3,209.179 ↓ 2.0 8,874 1

Hash Right Join (cost=82,319.94..99,387.74 rows=4,392 width=712) (actual time=3,161.505..3,209.179 rows=8,874 loops=1)

  • Output: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, r.system_id, r.ctx_id, r.epoch, l_1.dest_host, l_1.dest_path, r.processed_status, r (...)
  • Hash Cond: ((hd_processed_space_repl_ctxs.system_id = l_1.system_id) AND (hd_processed_space_repl_ctxs.ctx_id = l_1.ctx_id))
7. 1.928 2,730.211 ↓ 20.5 923 1

Nested Loop (cost=66,778.60..83,796.74 rows=45 width=32) (actual time=2,712.224..2,730.211 rows=923 loops=1)

  • Output: hist.pre_comp_repl_speed, hist.post_comp_repl_speed, hd_processed_space_repl_ctxs.system_id, hd_processed_space_repl_ctxs.ctx_id
8. 1,032.411 2,713.515 ↑ 2.4 923 1

HashAggregate (cost=66,778.18..66,800.65 rows=2,247 width=24) (actual time=2,712.192..2,713.515 rows=923 loops=1)

  • Output: max(hd_processed_space_repl_ctxs.epoch), hd_processed_space_repl_ctxs.system_id, hd_processed_space_repl_ctxs.ctx_id
  • Group Key: hd_processed_space_repl_ctxs.system_id, hd_processed_space_repl_ctxs.ctx_id
9. 1,088.270 1,681.104 ↑ 1.0 741,579 1

Hash Semi Join (cost=696.02..61,171.26 rows=747,589 width=24) (actual time=37.526..1,681.104 rows=741,579 loops=1)

  • Output: hd_processed_space_repl_ctxs.system_id, hd_processed_space_repl_ctxs.ctx_id, hd_processed_space_repl_ctxs.epoch
  • Hash Cond: (hd_processed_space_repl_ctxs.system_id = n.system_id)
10. 555.342 555.342 ↑ 1.0 741,579 1

Seq Scan on processed.hd_processed_space_repl_ctxs (cost=0.00..50,195.89 rows=747,589 width=24) (actual time=0.015..555.342 rows=741,579 loops=1)

  • Output: hd_processed_space_repl_ctxs.system_id, hd_processed_space_repl_ctxs.interval_mask, hd_processed_space_repl_ctxs.count, hd_processed_space_repl_ctxs.is_missing, hd_processed_space_repl_ctxs.ep (...)
11. 0.090 37.492 ↑ 6.5 150 1

Hash (cost=683.91..683.91 rows=969 width=8) (actual time=37.492..37.492 rows=150 loops=1)

  • Output: n.system_id
  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
12. 0.455 37.402 ↑ 6.5 150 1

HashAggregate (cost=664.53..674.22 rows=969 width=8) (actual time=37.334..37.402 rows=150 loops=1)

  • Output: n.system_id
  • Group Key: n.system_id
13. 34.027 36.947 ↑ 6.5 150 1

Hash Right Join (cost=362.43..652.42 rows=969 width=7,958) (actual time=3.108..36.947 rows=150 loops=1)

  • Output: NULL::bigint, NULL::character varying(256), NULL::character varying(256), NULL::character varying(256), NULL::character varying(256), NULL::integer, NULL::character varying(256), N (...)
  • Hash Cond: (sc.system_id = n.system_id)
14. 0.011 0.011 ↓ 0.0 0 1

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

  • Output: sc.system_id, sc.status
15. 0.082 2.909 ↓ 1.6 150 1

Hash (cost=361.24..361.24 rows=95 width=16) (actual time=2.909..2.909 rows=150 loops=1)

  • Output: n.system_id, s.id
  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
16. 0.130 2.827 ↓ 1.6 150 1

Hash Left Join (cost=122.20..361.24 rows=95 width=16) (actual time=0.643..2.827 rows=150 loops=1)

  • Output: n.system_id, s.id
  • Hash Cond: (n.system_id = l.system_id)
17. 0.105 2.590 ↓ 1.6 150 1

Hash Left Join (cost=109.93..347.67 rows=95 width=16) (actual time=0.525..2.590 rows=150 loops=1)

  • Output: n.system_id, s.id
  • Hash Cond: (n.system_id = f.system_id)
18. 0.122 2.330 ↓ 1.6 150 1

Hash Left Join (cost=92.42..328.86 rows=95 width=16) (actual time=0.360..2.330 rows=150 loops=1)

  • Output: n.system_id, s.id
  • Hash Cond: (n.system_id = s.id)
19. 1.996 1.996 ↓ 1.6 150 1

Seq Scan on config.cfg_nodes n (cost=0.00..235.14 rows=95 width=20) (actual time=0.136..1.996 rows=150 loops=1)

  • Output: n.system_id, n.tz_id, n.id
  • Filter: ((n.system_id = 5) OR (n.system_id = 7) OR (n.system_id = 8) OR (n.system_id = 9) OR (n.system_id = 10) OR (n.system_id = 11) OR (n.system_id = 13) OR (...)
  • Rows Removed by Filter: 1
20. 0.086 0.212 ↑ 1.0 151 1

Hash (cost=90.53..90.53 rows=151 width=8) (actual time=0.212..0.212 rows=151 loops=1)

  • Output: s.id
  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
21. 0.126 0.126 ↑ 1.0 151 1

Index Only Scan using cfg_systems_pkey on config.cfg_systems s (cost=0.27..90.53 rows=151 width=8) (actual time=0.013..0.126 rows=151 loops=1)

  • Output: s.id
  • Heap Fetches: 35
22. 0.053 0.155 ↑ 1.0 150 1

Hash (cost=15.56..15.56 rows=156 width=8) (actual time=0.155..0.155 rows=150 loops=1)

  • Output: f.system_id
  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
23. 0.102 0.102 ↑ 1.0 150 1

Seq Scan on config.cd_cfg_systems_features_status f (cost=0.00..15.56 rows=156 width=8) (actual time=0.010..0.102 rows=150 loops=1)

  • Output: f.system_id
24. 0.052 0.107 ↑ 1.0 150 1

Hash (cost=10.39..10.39 rows=150 width=8) (actual time=0.107..0.107 rows=150 loops=1)

  • Output: l.system_id
  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
25. 0.055 0.055 ↑ 1.0 150 1

Index Only Scan using cd_cfg_collections_system_id_idx on config.cd_cfg_collections l (cost=0.14..10.39 rows=150 width=8) (actual time=0.020..0.055 rows=150 loops=1)

  • Output: l.system_id
  • Heap Fetches: 0
26. 14.768 14.768 ↑ 1.0 1 923

Index Scan using hd_processed_space_repl_ctxs_system_id_ctx_id_epoch_idx on processed.hd_processed_space_repl_ctxs hist (cost=0.42..7.54 rows=1 width=40) (actual time=0.015..0.016 rows=1 loops=923)

  • Output: hist.system_id, hist.interval_mask, hist.count, hist.is_missing, hist.epoch, hist.node_id, hist.ctx_id, hist.pre_comp_remaining, hist.pre_comp_replicated_cumu, hist.post_comp_remaining, hist.post_comp_rep (...)
  • Index Cond: ((hist.system_id = hd_processed_space_repl_ctxs.system_id) AND (hist.ctx_id = hd_processed_space_repl_ctxs.ctx_id) AND (hist.epoch = (max(hd_processed_space_repl_ctxs.epoch))))
  • Filter: (hist.is_active = 1)
27. 82.728 449.015 ↓ 2.0 8,874 1

Hash (cost=15,475.46..15,475.46 rows=4,392 width=696) (actual time=449.015..449.015 rows=8,874 loops=1)

  • Output: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, r.system_id, r.ctx_id, r.epoch, l_1.dest_host, l_1.dest_path, r.processed_sta (...)
  • Buckets: 8192 (originally 8192) Batches: 2 (originally 1) Memory Usage: 4033kB
28. 15.710 366.287 ↓ 2.0 8,874 1

Hash Semi Join (cost=14,371.30..15,475.46 rows=4,392 width=696) (actual time=322.364..366.287 rows=8,874 loops=1)

  • Output: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, r.system_id, r.ctx_id, r.epoch, l_1.dest_host, l_1.dest_path, r.process (...)
  • Hash Cond: (l_1.system_id = n_1.system_id)
29. 18.176 332.766 ↓ 1.0 8,922 1

Unique (cost=13,675.28..14,619.66 rows=8,785 width=696) (actual time=304.532..332.766 rows=8,922 loops=1)

  • Output: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, r.system_id, r.ctx_id, r.epoch, l_1.dest_host, l_1.dest_path, r.p (...)
30. 236.662 314.590 ↓ 1.0 8,922 1

Sort (cost=13,675.28..13,697.24 rows=8,785 width=696) (actual time=304.530..314.590 rows=8,922 loops=1)

  • Output: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, r.system_id, r.ctx_id, r.epoch, l_1.dest_host, l_1.dest_pat (...)
  • Sort Key: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, r.system_id, r.ctx_id, r.epoch, l_1.dest_host, l_1.dest_p (...)
  • Sort Method: external merge Disk: 4296kB
31. 1.300 77.928 ↓ 1.0 8,922 1

Append (cost=1,483.66..10,394.32 rows=8,785 width=696) (actual time=4.748..77.928 rows=8,922 loops=1)

32. 14.230 26.634 ↓ 1.0 8,848 1

Hash Join (cost=1,483.66..4,450.07 rows=8,473 width=3,808) (actual time=4.747..26.634 rows=8,848 loops=1)

  • Output: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, r.system_id, r.ctx_id, r.epoch, l_1.dest_host, (...)
  • Hash Cond: (r.pair_id = l_1.pair_id)
  • Join Filter: (l_1.id <> r.id)
  • Rows Removed by Join Filter: 378
33. 0.652 8.586 ↑ 1.0 886 1

Hash Left Join (cost=35.25..2,857.98 rows=886 width=1,787) (actual time=0.893..8.586 rows=886 loops=1)

  • Output: r.system_id, r.ctx_id, r.epoch, r.processed_status, r.processed_status_msg, r.pair_id, r.id, cctu2.id, cctu2.uuid, cctu2.name, cctu2.state, cct2.uuid, cct2.name, cct2.state, (...)
  • Hash Cond: (cctu2.tenant_id = cct2.id)
34. 1.961 7.905 ↑ 1.0 886 1

Hash Left Join (cost=33.86..2,845.07 rows=886 width=1,125) (actual time=0.849..7.905 rows=886 loops=1)

  • Output: r.system_id, r.ctx_id, r.epoch, r.processed_status, r.processed_status_msg, r.pair_id, r.id, cctu2.id, cctu2.uuid, cctu2.name, cctu2.state, cctu2.tenant_id
  • Hash Cond: (r.tenant_unit_id = cctu2.id)
35. 5.118 5.118 ↑ 1.0 886 1

Seq Scan on config.cd_cfg_repl_ctxs r (cost=0.00..2,803.86 rows=886 width=1,080) (actual time=0.006..5.118 rows=886 loops=1)

  • Output: r.id, r.epoch, r.system_id, r.ctx_id, r.source_host, r.source_path, r.dest_host, r.dest_path, r.is_src, r.repl_scheme, r.propagate_retention_lock, r.delta_enabled (...)
36. 0.303 0.826 ↑ 1.0 554 1

Hash (cost=26.94..26.94 rows=554 width=53) (actual time=0.826..0.826 rows=554 loops=1)

  • Output: cctu2.id, cctu2.uuid, cctu2.name, cctu2.state, cctu2.tenant_id
  • Buckets: 1024 Batches: 1 Memory Usage: 56kB
37. 0.523 0.523 ↑ 1.0 554 1

Seq Scan on config.cd_cfg_tenant_units cctu2 (cost=0.00..26.94 rows=554 width=53) (actual time=0.009..0.523 rows=554 loops=1)

  • Output: cctu2.id, cctu2.uuid, cctu2.name, cctu2.state, cctu2.tenant_id
  • Filter: (cctu2.id <> 0)
  • Rows Removed by Filter: 1
38. 0.011 0.029 ↑ 1.0 15 1

Hash (cost=1.20..1.20 rows=15 width=670) (actual time=0.029..0.029 rows=15 loops=1)

  • Output: cct2.uuid, cct2.name, cct2.state, cct2.id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
39. 0.018 0.018 ↑ 1.0 15 1

Seq Scan on config.cd_cfg_tenants cct2 (cost=0.00..1.20 rows=15 width=670) (actual time=0.009..0.018 rows=15 loops=1)

  • Output: cct2.uuid, cct2.name, cct2.state, cct2.id
  • Filter: (cct2.id <> 0)
  • Rows Removed by Filter: 1
40. 0.701 3.818 ↑ 1.0 378 1

Hash (cost=1,443.68..1,443.68 rows=378 width=2,045) (actual time=3.818..3.818 rows=378 loops=1)

  • Output: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, l_1.dest_host, l_1.dest_path, l_1.pair_st (...)
  • Buckets: 1024 Batches: 1 Memory Usage: 176kB
41. 0.400 3.117 ↑ 1.0 378 1

Hash Left Join (cost=390.45..1,443.68 rows=378 width=2,045) (actual time=1.062..3.117 rows=378 loops=1)

  • Output: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, l_1.dest_host, l_1.dest_path, l_1.p (...)
  • Hash Cond: (cctu1.tenant_id = cct1.id)
42. 0.878 2.691 ↑ 1.0 378 1

Hash Left Join (cost=389.07..1,437.38 rows=378 width=1,383) (actual time=1.020..2.691 rows=378 loops=1)

  • Output: l_1.pair_id, l_1.system_id, l_1.ctx_id, l_1.epoch, l_1.source_host, l_1.source_path, l_1.processed_status, l_1.processed_status_msg, l_1.dest_host, l_1.dest_path, (...)
  • Hash Cond: (l_1.tenant_unit_id = cctu1.id)
43. 0.874 1.089 ↑ 1.0 378 1

Bitmap Heap Scan on config.cd_cfg_repl_ctxs l_1 (cost=355.20..1,400.38 rows=378 width=1,338) (actual time=0.279..1.089 rows=378 loops=1)

  • Output: l_1.id, l_1.epoch, l_1.system_id, l_1.ctx_id, l_1.source_host, l_1.source_path, l_1.dest_host, l_1.dest_path, l_1.is_src, l_1.repl_scheme, l_1.propagate_ret (...)
  • Recheck Cond: (l_1.is_src = 1)
  • Heap Blocks: exact=224
44. 0.215 0.215 ↑ 1.0 378 1

Bitmap Index Scan on cd_cfg_repl_ctxs_is_src_idx (cost=0.00..355.11 rows=378 width=0) (actual time=0.215..0.215 rows=378 loops=1)

  • Index Cond: (l_1.is_src = 1)
45. 0.345 0.724 ↑ 1.0 554 1

Hash (cost=26.94..26.94 rows=554 width=53) (actual time=0.724..0.724 rows=554 loops=1)

  • Output: cctu1.id, cctu1.uuid, cctu1.name, cctu1.state, cctu1.tenant_id
  • Buckets: 1024 Batches: 1 Memory Usage: 56kB
46. 0.379 0.379 ↑ 1.0 554 1

Seq Scan on config.cd_cfg_tenant_units cctu1 (cost=0.00..26.94 rows=554 width=53) (actual time=0.020..0.379 rows=554 loops=1)

  • Output: cctu1.id, cctu1.uuid, cctu1.name, cctu1.state, cctu1.tenant_id
  • Filter: (cctu1.id <> 0)
  • Rows Removed by Filter: 1
47. 0.014 0.026 ↑ 1.0 15 1

Hash (cost=1.20..1.20 rows=15 width=670) (actual time=0.026..0.026 rows=15 loops=1)

  • Output: cct1.uuid, cct1.name, cct1.state, cct1.id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
48. 0.012 0.012 ↑ 1.0 15 1

Seq Scan on config.cd_cfg_tenants cct1 (cost=0.00..1.20 rows=15 width=670) (actual time=0.007..0.012 rows=15 loops=1)

  • Output: cct1.uuid, cct1.name, cct1.state, cct1.id
  • Filter: (cct1.id <> 0)
  • Rows Removed by Filter: 1
49. 0.054 35.319 ↑ 6.0 26 1

Subquery Scan on *SELECT* 2 (cost=2,926.64..2,929.76 rows=156 width=696) (actual time=34.877..35.319 rows=26 loops=1)

  • Output: "*SELECT* 2".pair_id, "*SELECT* 2".src_system_id, "*SELECT* 2".src_ctx_id, "*SELECT* 2".src_epoch, "*SELECT* 2".src_host, "*SELECT* 2".src_path, "*SELECT* 2".src_processed_status, (...)
50. 7.979 35.265 ↑ 6.0 26 1

HashAggregate (cost=2,926.64..2,928.20 rows=156 width=696) (actual time=34.871..35.265 rows=26 loops=1)

  • Output: ccrc.pair_id, min(ccrc.system_id), min(ccrc.ctx_id), min(ccrc.epoch), min((ccrc.source_host)::text), min((ccrc.source_path)::text), min((ccrc.processed_status)::text), min((c (...)
  • Group Key: ccrc.pair_id
  • Filter: ((count(*) = 1) AND (sum(ccrc.is_src) = 1))
  • Rows Removed by Filter: 130
51. 0.783 27.286 ↑ 1.0 886 1

Hash Left Join (cost=35.25..2,857.98 rows=886 width=2,041) (actual time=0.828..27.286 rows=886 loops=1)

  • Output: ccrc.pair_id, ccrc.system_id, ccrc.ctx_id, ccrc.epoch, ccrc.source_host, ccrc.source_path, ccrc.processed_status, ccrc.processed_status_msg, ccrc.dest_host, ccrc.dest_p (...)
  • Hash Cond: (cctu1_1.tenant_id = cct1_1.id)
52. 21.576 26.472 ↑ 1.0 886 1

Hash Left Join (cost=33.86..2,845.07 rows=886 width=1,379) (actual time=0.780..26.472 rows=886 loops=1)

  • Output: ccrc.pair_id, ccrc.system_id, ccrc.ctx_id, ccrc.epoch, ccrc.source_host, ccrc.source_path, ccrc.processed_status, ccrc.processed_status_msg, ccrc.dest_host, ccrc. (...)
  • Hash Cond: (ccrc.tenant_unit_id = cctu1_1.id)
53. 4.155 4.155 ↑ 1.0 886 1

Seq Scan on config.cd_cfg_repl_ctxs ccrc (cost=0.00..2,803.86 rows=886 width=1,334) (actual time=0.007..4.155 rows=886 loops=1)

  • Output: ccrc.id, ccrc.epoch, ccrc.system_id, ccrc.ctx_id, ccrc.source_host, ccrc.source_path, ccrc.dest_host, ccrc.dest_path, ccrc.is_src, ccrc.repl_scheme, ccrc.pr (...)
54. 0.278 0.741 ↑ 1.0 554 1

Hash (cost=26.94..26.94 rows=554 width=53) (actual time=0.741..0.741 rows=554 loops=1)

  • Output: cctu1_1.id, cctu1_1.uuid, cctu1_1.name, cctu1_1.state, cctu1_1.tenant_id
  • Buckets: 1024 Batches: 1 Memory Usage: 56kB
55. 0.463 0.463 ↑ 1.0 554 1

Seq Scan on config.cd_cfg_tenant_units cctu1_1 (cost=0.00..26.94 rows=554 width=53) (actual time=0.012..0.463 rows=554 loops=1)

  • Output: cctu1_1.id, cctu1_1.uuid, cctu1_1.name, cctu1_1.state, cctu1_1.tenant_id
  • Filter: (cctu1_1.id <> 0)
  • Rows Removed by Filter: 1
56. 0.011 0.031 ↑ 1.0 15 1

Hash (cost=1.20..1.20 rows=15 width=670) (actual time=0.031..0.031 rows=15 loops=1)

  • Output: cct1_1.uuid, cct1_1.name, cct1_1.state, cct1_1.id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
57. 0.020 0.020 ↑ 1.0 15 1

Seq Scan on config.cd_cfg_tenants cct1_1 (cost=0.00..1.20 rows=15 width=670) (actual time=0.009..0.020 rows=15 loops=1)

  • Output: cct1_1.uuid, cct1_1.name, cct1_1.state, cct1_1.id
  • Filter: (cct1_1.id <> 0)
  • Rows Removed by Filter: 1
58. 0.099 14.675 ↑ 3.2 48 1

Subquery Scan on *SELECT* 3 (cost=2,926.64..2,929.76 rows=156 width=696) (actual time=14.173..14.675 rows=48 loops=1)

  • Output: "*SELECT* 3".pair_id, NULL::bigint, NULL::bigint, NULL::bigint, "*SELECT* 3".src_host, "*SELECT* 3".src_path, NULL::character varying, NULL::character varying, "*SELECT* 3".dst_sys (...)
59. 7.780 14.576 ↑ 3.2 48 1

HashAggregate (cost=2,926.64..2,928.20 rows=156 width=696) (actual time=14.166..14.576 rows=48 loops=1)

  • Output: ccrc_1.pair_id, NULL::bigint, NULL::bigint, NULL::bigint, min((ccrc_1.source_host)::text), min((ccrc_1.source_path)::text), NULL::character varying, NULL::character varying, (...)
  • Group Key: ccrc_1.pair_id
  • Filter: ((count(*) = 1) AND (sum(ccrc_1.is_src) = 0))
  • Rows Removed by Filter: 108
60. 0.810 6.796 ↑ 1.0 886 1

Hash Left Join (cost=35.25..2,857.98 rows=886 width=2,041) (actual time=0.847..6.796 rows=886 loops=1)

  • Output: ccrc_1.pair_id, ccrc_1.source_host, ccrc_1.source_path, ccrc_1.system_id, ccrc_1.ctx_id, ccrc_1.epoch, ccrc_1.dest_host, ccrc_1.dest_path, ccrc_1.processed_status, ccrc (...)
  • Hash Cond: (cctu2_1.tenant_id = cct2_1.id)
61. 1.830 5.952 ↑ 1.0 886 1

Hash Left Join (cost=33.86..2,845.07 rows=886 width=1,379) (actual time=0.797..5.952 rows=886 loops=1)

  • Output: ccrc_1.pair_id, ccrc_1.source_host, ccrc_1.source_path, ccrc_1.system_id, ccrc_1.ctx_id, ccrc_1.epoch, ccrc_1.dest_host, ccrc_1.dest_path, ccrc_1.processed_status (...)
  • Hash Cond: (ccrc_1.tenant_unit_id = cctu2_1.id)
62. 3.360 3.360 ↑ 1.0 886 1

Seq Scan on config.cd_cfg_repl_ctxs ccrc_1 (cost=0.00..2,803.86 rows=886 width=1,334) (actual time=0.010..3.360 rows=886 loops=1)

  • Output: ccrc_1.id, ccrc_1.epoch, ccrc_1.system_id, ccrc_1.ctx_id, ccrc_1.source_host, ccrc_1.source_path, ccrc_1.dest_host, ccrc_1.dest_path, ccrc_1.is_src, ccrc_1. (...)
63. 0.319 0.762 ↑ 1.0 554 1

Hash (cost=26.94..26.94 rows=554 width=53) (actual time=0.762..0.762 rows=554 loops=1)

  • Output: cctu2_1.id, cctu2_1.uuid, cctu2_1.name, cctu2_1.state, cctu2_1.tenant_id
  • Buckets: 1024 Batches: 1 Memory Usage: 56kB
64. 0.443 0.443 ↑ 1.0 554 1

Seq Scan on config.cd_cfg_tenant_units cctu2_1 (cost=0.00..26.94 rows=554 width=53) (actual time=0.010..0.443 rows=554 loops=1)

  • Output: cctu2_1.id, cctu2_1.uuid, cctu2_1.name, cctu2_1.state, cctu2_1.tenant_id
  • Filter: (cctu2_1.id <> 0)
  • Rows Removed by Filter: 1
65. 0.016 0.034 ↑ 1.0 15 1

Hash (cost=1.20..1.20 rows=15 width=670) (actual time=0.034..0.034 rows=15 loops=1)

  • Output: cct2_1.uuid, cct2_1.name, cct2_1.state, cct2_1.id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
66. 0.018 0.018 ↑ 1.0 15 1

Seq Scan on config.cd_cfg_tenants cct2_1 (cost=0.00..1.20 rows=15 width=670) (actual time=0.009..0.018 rows=15 loops=1)

  • Output: cct2_1.uuid, cct2_1.name, cct2_1.state, cct2_1.id
  • Filter: (cct2_1.id <> 0)
  • Rows Removed by Filter: 1
67. 0.086 17.811 ↑ 6.5 150 1

Hash (cost=683.91..683.91 rows=969 width=8) (actual time=17.811..17.811 rows=150 loops=1)

  • Output: n_1.system_id
  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
68. 0.413 17.725 ↑ 6.5 150 1

HashAggregate (cost=664.53..674.22 rows=969 width=8) (actual time=17.662..17.725 rows=150 loops=1)

  • Output: n_1.system_id
  • Group Key: n_1.system_id
69. 14.445 17.312 ↑ 6.5 150 1

Hash Right Join (cost=362.43..652.42 rows=969 width=7,958) (actual time=3.313..17.312 rows=150 loops=1)

  • Output: NULL::bigint, NULL::character varying(256), NULL::character varying(256), NULL::character varying(256), NULL::character varying(256), NULL::integer, NULL::character varying(256), NULL::c (...)
  • Hash Cond: (sc_1.system_id = n_1.system_id)
70. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on config.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)

  • Output: sc_1.system_id, sc_1.status
71. 0.081 2.865 ↓ 1.6 150 1

Hash (cost=361.24..361.24 rows=95 width=16) (actual time=2.865..2.865 rows=150 loops=1)

  • Output: n_1.system_id, s_1.id
  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
72. 0.121 2.784 ↓ 1.6 150 1

Hash Left Join (cost=122.20..361.24 rows=95 width=16) (actual time=0.633..2.784 rows=150 loops=1)

  • Output: n_1.system_id, s_1.id
  • Hash Cond: (n_1.system_id = l_2.system_id)
73. 0.131 2.545 ↓ 1.6 150 1

Hash Left Join (cost=109.93..347.67 rows=95 width=16) (actual time=0.499..2.545 rows=150 loops=1)

  • Output: n_1.system_id, s_1.id
  • Hash Cond: (n_1.system_id = f_1.system_id)
74. 0.136 2.253 ↓ 1.6 150 1

Hash Left Join (cost=92.42..328.86 rows=95 width=16) (actual time=0.325..2.253 rows=150 loops=1)

  • Output: n_1.system_id, s_1.id
  • Hash Cond: (n_1.system_id = s_1.id)
75. 1.912 1.912 ↓ 1.6 150 1

Seq Scan on config.cfg_nodes n_1 (cost=0.00..235.14 rows=95 width=20) (actual time=0.101..1.912 rows=150 loops=1)

  • Output: n_1.system_id, n_1.tz_id, n_1.id
  • Filter: ((n_1.system_id = 5) OR (n_1.system_id = 7) OR (n_1.system_id = 8) OR (n_1.system_id = 9) OR (n_1.system_id = 10) OR (n_1.system_id = 11) OR (n_1.system_id (...)
  • Rows Removed by Filter: 1
76. 0.071 0.205 ↑ 1.0 151 1

Hash (cost=90.53..90.53 rows=151 width=8) (actual time=0.205..0.205 rows=151 loops=1)

  • Output: s_1.id
  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
77. 0.134 0.134 ↑ 1.0 151 1

Index Only Scan using cfg_systems_pkey on config.cfg_systems s_1 (cost=0.27..90.53 rows=151 width=8) (actual time=0.023..0.134 rows=151 loops=1)

  • Output: s_1.id
  • Heap Fetches: 35
78. 0.060 0.161 ↑ 1.0 150 1

Hash (cost=15.56..15.56 rows=156 width=8) (actual time=0.161..0.161 rows=150 loops=1)

  • Output: f_1.system_id
  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
79. 0.101 0.101 ↑ 1.0 150 1

Seq Scan on config.cd_cfg_systems_features_status f_1 (cost=0.00..15.56 rows=156 width=8) (actual time=0.008..0.101 rows=150 loops=1)

  • Output: f_1.system_id
80. 0.065 0.118 ↑ 1.0 150 1

Hash (cost=10.39..10.39 rows=150 width=8) (actual time=0.118..0.118 rows=150 loops=1)

  • Output: l_2.system_id
  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
81. 0.053 0.053 ↑ 1.0 150 1

Index Only Scan using cd_cfg_collections_system_id_idx on config.cd_cfg_collections l_2 (cost=0.14..10.39 rows=150 width=8) (actual time=0.024..0.053 rows=150 loops=1)

  • Output: l_2.system_id
  • Heap Fetches: 0
82. 0.027 0.595 ↑ 1.0 40 1

Hash (cost=473.62..473.62 rows=40 width=12) (actual time=0.595..0.595 rows=40 loops=1)

  • Output: cascades.cascade_status, cascades.pair_id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
83. 0.009 0.568 ↑ 1.0 40 1

Subquery Scan on cascades (cost=472.82..473.62 rows=40 width=12) (actual time=0.549..0.568 rows=40 loops=1)

  • Output: cascades.cascade_status, cascades.pair_id
84. 0.144 0.559 ↑ 1.0 40 1

HashAggregate (cost=472.82..473.22 rows=40 width=12) (actual time=0.548..0.559 rows=40 loops=1)

  • Output: icas.pair_id, max(CASE WHEN (icas.cascade_status = 1) THEN 2 ELSE CASE WHEN (icas.cascade_status = 2) THEN 3 ELSE CASE WHEN (icas.cascade_status = 3) THEN 1 ELSE CASE WHEN (icas.cascade_status = 4) THEN 1 (...)
  • Group Key: icas.pair_id
85. 0.058 0.415 ↑ 2.0 81 1

Nested Loop (cost=0.28..470.00 rows=161 width=12) (actual time=0.039..0.415 rows=81 loops=1)

  • Output: icas.pair_id, icas.cascade_status
86. 0.037 0.037 ↑ 1.0 80 1

Seq Scan on config.cd_cfg_repl_cascade icas (cost=0.00..2.80 rows=80 width=12) (actual time=0.012..0.037 rows=80 loops=1)

  • Output: icas.cascade_id, icas.pair_id, icas.cascade_sequence, icas.cascade_status, icas.cascade_status_msg
87. 0.320 0.320 ↑ 6.0 1 80

Index Only Scan using cd_cfg_repl_ctxs_state_pair_id_is_src_idx on config.cd_cfg_repl_ctxs ictx (cost=0.28..5.78 rows=6 width=8) (actual time=0.003..0.004 rows=1 loops=80)

  • Output: ictx.pair_id, ictx.state, ictx.is_src
  • Index Cond: (ictx.pair_id = icas.pair_id)
  • Heap Fetches: 0
88. 0.174 0.717 ↑ 1.0 378 1

Hash (cost=674.70..674.70 rows=378 width=44) (actual time=0.717..0.717 rows=378 loops=1)

  • Output: ctx.state, ctx.pair_id, (ROW(ctx.state, ctx.pair_id))
  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
89. 0.543 0.543 ↑ 1.0 378 1

Index Only Scan using cd_cfg_repl_ctxs_state_pair_id_is_src_idx on config.cd_cfg_repl_ctxs ctx (cost=0.28..674.70 rows=378 width=44) (actual time=0.012..0.543 rows=378 loops=1)

  • Output: ctx.state, ctx.pair_id, ROW(ctx.state, ctx.pair_id)
  • Index Cond: (ctx.is_src = 1)
  • Heap Fetches: 0
90. 0.195 0.497 ↑ 1.0 508 1

Hash (cost=676.00..676.00 rows=508 width=12) (actual time=0.497..0.497 rows=508 loops=1)

  • Output: ctx_1.state, ctx_1.pair_id
  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
91. 0.302 0.302 ↑ 1.0 508 1

Index Only Scan using cd_cfg_repl_ctxs_state_pair_id_is_src_idx on config.cd_cfg_repl_ctxs ctx_1 (cost=0.28..676.00 rows=508 width=12) (actual time=0.012..0.302 rows=508 loops=1)

  • Output: ctx_1.state, ctx_1.pair_id
  • Index Cond: (ctx_1.is_src = 0)
  • Heap Fetches: 0