explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mtyH

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

Result (cost=0.00..2,379,748,826.94 rows=5,560,683,882 width=1,552) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Window (cost=0.00..1,551,251,414.08 rows=5,560,683,882 width=1,573) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Gather Motion 96:1 (slice39; segments: 96) (cost=0.00..1,551,251,414.08 rows=533,825,652,614 width=1,267) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..30,997,919.92 rows=5,560,683,882 width=1,267) (actual rows= loops=)

  • Hash Cond: tmp_product_dim.iss_ccy_cd::text = pg_temp_726308.t_fx_rt_ref.ccy_cd::text AND CASE WHEN o_calc.ets_regn_cd::text = 'tk'::text THEN 'm33'::text WHEN o_calc.ets_regn_cd::text = 'hk'::text THEN 'm37'::text WHEN o_calc.ets_regn_cd::text = 'ln'::text THEN 'm32'::text WHEN o_calc.ets_regn_cd::text = 'ny'::text THEN 'm31'::text ELSE 'm31'::text END = pg_temp_726308.t_fx_rt_ref.source::text
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..5,480,107.28 rows=770,863,871 width=1,258) (actual rows= loops=)

  • Hash Cond: o_calc.cmsn_ccy = pg_temp_726308.t_fx_rt_ref.ccy_cd AND CASE WHEN o_calc.ets_regn_cd::text = 'tk'::text THEN 'm33'::text WHEN o_calc.ets_regn_cd::text = 'hk'::text THEN 'm37'::text WHEN o_calc.ets_regn_cd::text = 'ln'::text THEN 'm32'::text WHEN o_calc.ets_regn_cd::text = 'ny'::text THEN 'm31'::text ELSE 'm31'::text END = pg_temp_726308.t_fx_rt_ref.source::text
6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,973,283.70 rows=101,535,129 width=1,245) (actual rows= loops=)

  • Hash Cond: o_stg_current.trade_ccy = pg_temp_726308.t_fx_rt_ref.ccy_cd AND CASE WHEN o_calc.ets_regn_cd::text = 'tk'::text THEN 'm33'::text WHEN o_calc.ets_regn_cd::text = 'hk'::text THEN 'm37'::text WHEN o_calc.ets_regn_cd::text = 'ln'::text THEN 'm32'::text WHEN o_calc.ets_regn_cd::text = 'ny'::text THEN 'm31'::text ELSE 'm31'::text END = pg_temp_726308.t_fx_rt_ref.source::text
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,514,924.78 rows=14,075,565 width=1,236) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_entitlement_ref.order_id
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,447,445.55 rows=6,663,148 width=1,232) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_multi_dim.order_id
9. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,415,360.94 rows=3,170,506 width=1,228) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_ueo_notional.order_id
10. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,399,178.49 rows=2,312,859 width=1,223) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_legacy_clnt_dim.order_id
11. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,387,305.62 rows=1,687,213 width=1,215) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_multi_dim_2.order_id
12. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,378,578.11 rows=1,230,809 width=1,211) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_eo_multi_dim_3.order_id
13. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,372,114.29 rows=897,866 width=1,207) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_trd_firm_acct_dim.order_id
14. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,367,296.55 rows=654,986 width=1,203) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_ms_dest_dim.order_id
15. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,363,675.79 rows=477,807 width=1,199) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_multi_dim_4.order_id
16. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,360,925.42 rows=348,557 width=1,195) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_order_type_dim.order_id
17. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,358,808.58 rows=254,270 width=1,187) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_eo_multi_dim2.order_id
18. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,357,155.34 rows=185,488 width=1,183) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_eo_multi_dim.order_id
19. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,355,835.65 rows=135,312 width=1,179) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_o_multi_dim_5.order_id AND tmp_ets_regn.order_id::text = tmp_o_multi_dim_5.order_id::text
20. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,354,748.52 rows=98,709 width=1,198) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_sls_mgmt_sys_dim.order_id AND tmp_ets_regn.order_id::text = tmp_sls_mgmt_sys_dim.order_id::text
21. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,353,832.50 rows=72,008 width=1,194) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_dest_dim.order_id AND tmp_ets_regn.order_id::text = tmp_dest_dim.order_id::text
22. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,353,048.81 rows=52,529 width=1,190) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_xctn_trdr_dim.order_id AND tmp_ets_regn.order_id::text = tmp_xctn_trdr_dim.order_id::text
23. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,352,361.35 rows=38,320 width=1,186) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_sls_trdr_dim.order_id AND tmp_ets_regn.order_id::text = tmp_sls_trdr_dim.order_id::text
24. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,351,743.87 rows=27,954 width=1,182) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_product_dim.order_id AND tmp_ets_regn.order_id::text = tmp_product_dim.order_id::text
25. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,351,177.37 rows=20,392 width=1,170) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_ets_regn.order_id::bpchar
26. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,350,649.95 rows=14,876 width=1,139) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_side_dim.order_id
27. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,350,150.25 rows=10,852 width=1,135) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_id = tmp_app_dim.order_id
28. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,349,669.31 rows=7,917 width=1,131) (actual rows= loops=)

  • Hash Cond: o_stg_current.directed_broker_client_tnl_id = idgdm.client_dim.trdg_nm_loc_id::bpchar
  • Join Filter: idgdm.client_dim.start_ts <= o_stg_current.create_ts AND idgdm.client_dim.end_ts >= o_stg_current.create_ts
29. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,345,423.82 rows=7,917 width=1,135) (actual rows= loops=)

  • Hash Cond: tmp_o_is_rpt.order_id = o_stg_current.order_id
30. 0.000 0.000 ↓ 0.0

Table Scan on tmp_o_is_rpt (cost=0.00..431.00 rows=8 width=25) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Hash (cost=1,344,756.98..1,344,756.98 rows=7,917 width=1,133) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice34; segments: 96) (cost=0.00..1,344,756.98 rows=7,917 width=1,133) (actual rows= loops=)

  • Hash Key: o_stg_current.order_id
33. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,344,348.57 rows=7,917 width=1,133) (actual rows= loops=)

  • Hash Cond: o_calc.expire_time_char = idgdm.time_dim.char_hh24miss
34. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,343,183.92 rows=7,917 width=1,129) (actual rows= loops=)

  • Hash Cond: o_calc.effective_time_char = idgdm.time_dim.char_hh24miss
35. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,342,021.77 rows=7,917 width=1,125) (actual rows= loops=)

  • Hash Cond: o_calc.cmsn_ccy = idgdm.currency_dim.ccy_cd::bpchar
  • Join Filter: idgdm.currency_dim.start_ts <= o_stg_current.create_ts AND idgdm.currency_dim.end_ts >= o_stg_current.create_ts
36. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,340,822.30 rows=7,917 width=1,123) (actual rows= loops=)

  • Hash Cond: o_stg_current.portfolio_name::text = portfolio_name_dim.pflo_nm::text
  • Join Filter: portfolio_name_dim.start_ts <= o_stg_current.create_ts AND portfolio_name_dim.end_ts >= o_stg_current.create_ts
37. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice29; segments: 96) (cost=0.00..1,339,649.71 rows=5,655 width=1,119) (actual rows= loops=)

  • Hash Key: o_stg_current.portfolio_name
38. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,339,537.78 rows=5,655 width=1,119) (actual rows= loops=)

  • Hash Cond: o_stg_current.time_in_force = time_in_force_dim.tm_in_force_cd::bpchar
  • Join Filter: time_in_force_dim.start_ts <= o_stg_current.create_ts AND time_in_force_dim.end_ts >= o_stg_current.create_ts
39. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,339,079.99 rows=4,147 width=1,117) (actual rows= loops=)

  • Hash Cond: o_calc.stgy_lkp_key::text = strategy_dim.etl_dim_lkp_key::text
  • Join Filter: strategy_dim.start_ts <= o_stg_current.create_ts AND strategy_dim.end_ts >= o_stg_current.create_ts
40. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,338,628.15 rows=4,147 width=1,113) (actual rows= loops=)

  • Hash Cond: o_stg_current.order_capacity_code = order_capacity_dim.ord_cap_cd::bpchar
  • Join Filter: order_capacity_dim.start_ts <= o_stg_current.create_ts AND order_capacity_dim.end_ts >= o_stg_current.create_ts
41. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,338,176.39 rows=4,147 width=1,111) (actual rows= loops=)

  • Hash Cond: CASE WHEN o_calc.sales_bus_line_id::text = ''::text THEN 'xxxxxxxx'::character varying ELSE o_calc.sales_bus_line_id END::text = sales_bus_line_dim.bsns_ln::text AND CASE WHEN o_calc.sales_bus_region::text = ''::text THEN 'xxxxxxxx'::character varying ELSE o_calc.sales_bus_region END::text = sales_bus_line_dim.bsns_regn::text AND CASE WHEN o_calc.sales_bus_division::text = ''::text THEN 'xxxxxxxx'::character varying ELSE o_calc.sales_bus_division END::text = sales_bus_line_dim.bsns_div::text AND CASE WHEN o_calc.sales_bus_office::text = ''::text THEN 'xxxxxxxx'::character varying ELSE o_calc.sales_bus_office END::text = sales_bus_line_dim.bsns_offc::text
  • Join Filter: sales_bus_line_dim.start_ts <= o_stg_current.create_ts AND sales_bus_line_dim.end_ts >= o_stg_current.create_ts
42. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,337,722.45 rows=4,147 width=1,127) (actual rows= loops=)

  • Hash Cond: o_calc.tnl_id = idgdm.client_dim.trdg_nm_loc_id::bpchar
  • Join Filter: idgdm.client_dim.start_ts <= o_stg_current.create_ts AND idgdm.client_dim.end_ts >= o_stg_current.create_ts
43. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice23; segments: 96) (cost=0.00..1,337,228.30 rows=251 width=1,123) (actual rows= loops=)

  • Hash Key: o_calc.tnl_id
44. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,337,227.41 rows=251 width=1,123) (actual rows= loops=)

  • Hash Cond: o_stg_current.market_id::text = product_market_dim.mkt_id::text
  • Join Filter: product_market_dim.start_ts <= o_stg_current.create_ts AND product_market_dim.end_ts >= o_stg_current.create_ts
45. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice21; segments: 96) (cost=0.00..1,329,257.83 rows=180 width=1,132) (actual rows= loops=)

  • Hash Key: o_stg_current.market_id
46. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,329,257.12 rows=180 width=1,132) (actual rows= loops=)

  • Hash Cond: o_calc.last_exec_ts_char = idgdm.time_dim.char_hh24miss
47. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,328,825.25 rows=180 width=1,128) (actual rows= loops=)

  • Hash Cond: o_calc.last_exec_dt = idgdm.date_dim.cndr_dt
48. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,328,388.02 rows=90 width=1,124) (actual rows= loops=)

  • Hash Cond: o_calc.first_exec_ts_char = idgdm.time_dim.char_hh24miss
49. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice17; segments: 96) (cost=0.00..1,327,956.59 rows=90 width=1,120) (actual rows= loops=)

  • Hash Key: o_calc.first_exec_ts_char
50. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,327,954.75 rows=90 width=1,120) (actual rows= loops=)

  • Hash Cond: o_calc.first_exec_dt = idgdm.date_dim.cndr_dt
51. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice15; segments: 96) (cost=0.00..1,327,520.60 rows=45 width=1,116) (actual rows= loops=)

  • Hash Key: o_calc.first_exec_dt
52. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,327,518.77 rows=45 width=1,116) (actual rows= loops=)

  • Hash Cond: o_calc.cndr_trd_dt = idgdm.date_dim.cndr_dt
53. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice13; segments: 96) (cost=0.00..1,327,085.32 rows=23 width=1,112) (actual rows= loops=)

  • Hash Key: o_calc.cndr_trd_dt
54. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,327,084.98 rows=23 width=1,112) (actual rows= loops=)

  • Hash Cond: o_calc.order_entry_time_char = idgdm.time_dim.char_hh24miss
55. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice11; segments: 96) (cost=0.00..1,326,653.88 rows=23 width=1,108) (actual rows= loops=)

  • Hash Key: o_calc.order_entry_time_char
56. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,326,652.46 rows=23 width=1,108) (actual rows= loops=)

  • Hash Cond: o_calc.order_entry_dt = idgdm.date_dim.cndr_dt
57. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice9; segments: 96) (cost=0.00..1,326,218.81 rows=23 width=1,104) (actual rows= loops=)

  • Hash Key: o_calc.order_entry_dt
58. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,326,218.28 rows=23 width=1,104) (actual rows= loops=)

  • Hash Cond: o_calc.init_entry_time_char = idgdm.time_dim.char_hh24miss
59. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice7; segments: 96) (cost=0.00..1,325,787.17 rows=23 width=1,100) (actual rows= loops=)

  • Hash Key: o_calc.init_entry_time_char
60. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,325,785.77 rows=23 width=1,100) (actual rows= loops=)

  • Hash Cond: o_calc.init_entry_dt = idgdm.date_dim.cndr_dt
61. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice5; segments: 96) (cost=0.00..1,325,352.16 rows=23 width=1,096) (actual rows= loops=)

  • Hash Key: o_calc.init_entry_dt
62. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,325,351.63 rows=23 width=1,096) (actual rows= loops=)

  • Hash Cond: o_calc.trade_ccy = idgdm.currency_dim.ccy_cd::bpchar
  • Join Filter: idgdm.currency_dim.start_ts <= o_stg_current.create_ts AND idgdm.currency_dim.end_ts >= o_stg_current.create_ts
63. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,324,920.51 rows=23 width=1,091) (actual rows= loops=)

  • Hash Cond: o_calc.order_id = o_stg_current.order_id AND o_calc.order_vid = o_stg_current.order_vid
64. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..1,324,058.13 rows=17 width=222) (actual rows= loops=)

  • Join Filter: true
65. 0.000 0.000 ↓ 0.0

Table Scan on o_calc (cost=0.00..431.00 rows=17 width=214) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:96 (slice2) (cost=0.00..431.00 rows=96 width=8) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Aggregate (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Gather Motion 96:1 (slice1; segments: 96) (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Aggregate (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Partition Selector for clnt_eo_fct (dynamic scan id: 1) (cost=10.00..100.00 rows=2 width=4) (actual rows= loops=)

  • Partitions selected: 0 (out of 153)
73. 0.000 0.000 ↓ 0.0

Dynamic Table Scan on clnt_eo_fct (dynamic scan id: 1) (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

  • Filter: cndr_trd_dt >= '2019-10-06 08:09:27.942173-04'::timestamp with time zone
74. 0.000 0.000 ↓ 0.0

Hash (cost=862.07..862.07 rows=11 width=897) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..862.07 rows=11 width=897) (actual rows= loops=)

  • Hash Cond: o_stg_current.side = side_dim.side_cd::bpchar
  • Join Filter: side_dim.start_ts <= o_stg_current.create_ts AND side_dim.end_ts >= o_stg_current.create_ts
76. 0.000 0.000 ↓ 0.0

Table Scan on o_stg_current (cost=0.00..431.01 rows=11 width=899) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=18) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Broadcast Motion 96:96 (slice3; segments: 96) (cost=0.00..431.00 rows=1 width=18) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Table Scan on side_dim (cost=0.00..431.00 rows=1 width=18) (actual rows= loops=)

  • Filter: side_key <> ALL ('{-1,-2}'::integer[])
80. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=21) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Broadcast Motion 96:96 (slice4; segments: 96) (cost=0.00..431.00 rows=1 width=21) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Table Scan on currency_dim (cost=0.00..431.00 rows=1 width=21) (actual rows= loops=)

  • Filter: ccy_key <> ALL ('{-1,-2}'::integer[])
83. 0.000 0.000 ↓ 0.0

Hash (cost=431.04..431.04 rows=191 width=8) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice6; segments: 96) (cost=0.00..431.04 rows=191 width=8) (actual rows= loops=)

  • Hash Key: idgdm.date_dim.cndr_dt
85. 0.000 0.000 ↓ 0.0

Table Scan on date_dim (cost=0.00..431.03 rows=191 width=8) (actual rows= loops=)

  • Filter: dt_key <> ALL ('{-1,-2}'::integer[])
86. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=12) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice8; segments: 96) (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

  • Hash Key: idgdm.time_dim.char_hh24miss
88. 0.000 0.000 ↓ 0.0

Table Scan on time_dim (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

  • Filter: tm_key <> ALL ('{-1,-2}'::integer[])
89. 0.000 0.000 ↓ 0.0

Hash (cost=431.04..431.04 rows=191 width=8) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice10; segments: 96) (cost=0.00..431.04 rows=191 width=8) (actual rows= loops=)

  • Hash Key: idgdm.date_dim.cndr_dt
91. 0.000 0.000 ↓ 0.0

Table Scan on date_dim (cost=0.00..431.03 rows=191 width=8) (actual rows= loops=)

  • Filter: dt_key <> ALL ('{-1,-2}'::integer[])
92. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=12) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice12; segments: 96) (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

  • Hash Key: idgdm.time_dim.char_hh24miss
94. 0.000 0.000 ↓ 0.0

Table Scan on time_dim (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

  • Filter: tm_key <> ALL ('{-1,-2}'::integer[])
95. 0.000 0.000 ↓ 0.0

Hash (cost=431.04..431.04 rows=191 width=8) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice14; segments: 96) (cost=0.00..431.04 rows=191 width=8) (actual rows= loops=)

  • Hash Key: idgdm.date_dim.cndr_dt
97. 0.000 0.000 ↓ 0.0

Table Scan on date_dim (cost=0.00..431.03 rows=191 width=8) (actual rows= loops=)

  • Filter: dt_key <> ALL ('{-1,-2}'::integer[])
98. 0.000 0.000 ↓ 0.0

Hash (cost=431.04..431.04 rows=191 width=8) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice16; segments: 96) (cost=0.00..431.04 rows=191 width=8) (actual rows= loops=)

  • Hash Key: idgdm.date_dim.cndr_dt
100. 0.000 0.000 ↓ 0.0

Table Scan on date_dim (cost=0.00..431.03 rows=191 width=8) (actual rows= loops=)

  • Filter: dt_key <> ALL ('{-1,-2}'::integer[])
101. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=12) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice18; segments: 96) (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

  • Hash Key: idgdm.time_dim.char_hh24miss
103. 0.000 0.000 ↓ 0.0

Table Scan on time_dim (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

  • Filter: tm_key <> ALL ('{-1,-2}'::integer[])
104. 0.000 0.000 ↓ 0.0

Hash (cost=431.31..431.31 rows=18,267 width=8) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Broadcast Motion 96:96 (slice19; segments: 96) (cost=0.00..431.31 rows=18,267 width=8) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

Table Scan on date_dim (cost=0.00..431.03 rows=191 width=8) (actual rows= loops=)

  • Filter: dt_key <> ALL ('{-1,-2}'::integer[])
107. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=12) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

Broadcast Motion 96:96 (slice20; segments: 96) (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Table Scan on time_dim (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

  • Filter: tm_key <> ALL ('{-1,-2}'::integer[])
110. 0.000 0.000 ↓ 0.0

Hash (cost=2,366.50..2,366.50 rows=4,603,735 width=33) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice22; segments: 96) (cost=0.00..2,366.50 rows=4,603,735 width=33) (actual rows= loops=)

  • Hash Key: product_market_dim.mkt_id
112. 0.000 0.000 ↓ 0.0

Table Scan on product_market_dim (cost=0.00..1,608.41 rows=4,603,735 width=33) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Hash (cost=448.68..448.68 rows=30,240 width=31) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice24; segments: 96) (cost=0.00..448.68 rows=30,240 width=31) (actual rows= loops=)

  • Hash Key: idgdm.client_dim.trdg_nm_loc_id
115. 0.000 0.000 ↓ 0.0

Table Scan on client_dim (cost=0.00..445.75 rows=30,240 width=31) (actual rows= loops=)

  • Filter: client_key <> ALL ('{-1,-2}'::integer[])
116. 0.000 0.000 ↓ 0.0

Hash (cost=431.01..431.01 rows=1 width=41) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Broadcast Motion 96:96 (slice25; segments: 96) (cost=0.00..431.01 rows=1 width=41) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Table Scan on sales_bus_line_dim (cost=0.00..431.00 rows=1 width=41) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=19) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

Broadcast Motion 96:96 (slice26; segments: 96) (cost=0.00..431.00 rows=1 width=19) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Table Scan on order_capacity_dim (cost=0.00..431.00 rows=1 width=19) (actual rows= loops=)

  • Filter: ord_cap_key <> ALL ('{-1,-2}'::integer[])
122. 0.000 0.000 ↓ 0.0

Hash (cost=431.01..431.01 rows=1 width=49) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Broadcast Motion 96:96 (slice27; segments: 96) (cost=0.00..431.01 rows=1 width=49) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

Table Scan on strategy_dim (cost=0.00..431.00 rows=1 width=49) (actual rows= loops=)

  • Filter: stgy_key <> ALL ('{-1,-2}'::integer[])
125. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=36 width=20) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Broadcast Motion 96:96 (slice28; segments: 96) (cost=0.00..431.00 rows=36 width=20) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

Table Scan on time_in_force_dim (cost=0.00..431.00 rows=1 width=20) (actual rows= loops=)

  • Filter: tm_in_force_key <> ALL ('{-1,-2}'::integer[])
128. 0.000 0.000 ↓ 0.0

Hash (cost=435.34..435.34 rows=18,288 width=34) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

Redistribute Motion 96:96 (slice30; segments: 96) (cost=0.00..435.34 rows=18,288 width=34) (actual rows= loops=)

  • Hash Key: portfolio_name_dim.pflo_nm
130. 0.000 0.000 ↓ 0.0

Table Scan on portfolio_name_dim (cost=0.00..433.39 rows=18,288 width=34) (actual rows= loops=)

  • Filter: pflo_nm_key <> ALL ('{-1,-2}'::integer[])
131. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=21) (actual rows= loops=)

132. 0.000 0.000 ↓ 0.0

Broadcast Motion 96:96 (slice31; segments: 96) (cost=0.00..431.00 rows=1 width=21) (actual rows= loops=)

133. 0.000 0.000 ↓ 0.0

Table Scan on currency_dim (cost=0.00..431.00 rows=1 width=21) (actual rows= loops=)

  • Filter: ccy_key <> ALL ('{-1,-2}'::integer[])
134. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=12) (actual rows= loops=)

135. 0.000 0.000 ↓ 0.0

Broadcast Motion 96:96 (slice32; segments: 96) (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

136. 0.000 0.000 ↓ 0.0

Table Scan on time_dim (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

  • Filter: tm_key <> ALL ('{-1,-2}'::integer[])
137. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=12) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Broadcast Motion 96:96 (slice33; segments: 96) (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

Table Scan on time_dim (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

  • Filter: tm_key <> ALL ('{-1,-2}'::integer[])
140. 0.000 0.000 ↓ 0.0

Hash (cost=613.78..613.78 rows=2,903,039 width=31) (actual rows= loops=)

141. 0.000 0.000 ↓ 0.0

Broadcast Motion 96:96 (slice35; segments: 96) (cost=0.00..613.78 rows=2,903,039 width=31) (actual rows= loops=)

142. 0.000 0.000 ↓ 0.0

Table Scan on client_dim (cost=0.00..445.75 rows=30,240 width=31) (actual rows= loops=)

  • Filter: client_key <> ALL ('{-1,-2}'::integer[])
143. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=27) (actual rows= loops=)

144. 0.000 0.000 ↓ 0.0

Table Scan on tmp_app_dim (cost=0.00..431.00 rows=11 width=27) (actual rows= loops=)

145. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=27) (actual rows= loops=)

146. 0.000 0.000 ↓ 0.0

Table Scan on tmp_side_dim (cost=0.00..431.00 rows=11 width=27) (actual rows= loops=)

147. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=31) (actual rows= loops=)

148. 0.000 0.000 ↓ 0.0

Table Scan on tmp_ets_regn (cost=0.00..431.00 rows=11 width=31) (actual rows= loops=)

149. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=35) (actual rows= loops=)

150. 0.000 0.000 ↓ 0.0

Table Scan on tmp_product_dim (cost=0.00..431.00 rows=11 width=35) (actual rows= loops=)

151. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=27) (actual rows= loops=)

152. 0.000 0.000 ↓ 0.0

Table Scan on tmp_sls_trdr_dim (cost=0.00..431.00 rows=11 width=27) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=27) (actual rows= loops=)

154. 0.000 0.000 ↓ 0.0

Table Scan on tmp_xctn_trdr_dim (cost=0.00..431.00 rows=11 width=27) (actual rows= loops=)

155. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=27) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Table Scan on tmp_dest_dim (cost=0.00..431.00 rows=11 width=27) (actual rows= loops=)

157. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=27) (actual rows= loops=)

158. 0.000 0.000 ↓ 0.0

Table Scan on tmp_sls_mgmt_sys_dim (cost=0.00..431.00 rows=11 width=27) (actual rows= loops=)

159. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=27) (actual rows= loops=)

160. 0.000 0.000 ↓ 0.0

Table Scan on tmp_o_multi_dim_5 (cost=0.00..431.00 rows=11 width=27) (actual rows= loops=)

161. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=27) (actual rows= loops=)

162. 0.000 0.000 ↓ 0.0

Table Scan on tmp_eo_multi_dim (cost=0.00..431.00 rows=11 width=27) (actual rows= loops=)

163. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=27) (actual rows= loops=)

164. 0.000 0.000 ↓ 0.0

Table Scan on tmp_eo_multi_dim2 (cost=0.00..431.00 rows=11 width=27) (actual rows= loops=)

165. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=31) (actual rows= loops=)

166. 0.000 0.000 ↓ 0.0

Table Scan on tmp_order_type_dim (cost=0.00..431.00 rows=11 width=31) (actual rows= loops=)

167. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=27) (actual rows= loops=)

168. 0.000 0.000 ↓ 0.0

Table Scan on tmp_multi_dim_4 (cost=0.00..431.00 rows=11 width=27) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=27) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

Table Scan on tmp_ms_dest_dim (cost=0.00..431.00 rows=11 width=27) (actual rows= loops=)

171. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=27) (actual rows= loops=)

172. 0.000 0.000 ↓ 0.0

Table Scan on tmp_trd_firm_acct_dim (cost=0.00..431.00 rows=11 width=27) (actual rows= loops=)

173. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=27) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

Table Scan on tmp_eo_multi_dim_3 (cost=0.00..431.00 rows=11 width=27) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=27) (actual rows= loops=)

176. 0.000 0.000 ↓ 0.0

Table Scan on tmp_multi_dim_2 (cost=0.00..431.00 rows=11 width=27) (actual rows= loops=)

177. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=31) (actual rows= loops=)

178. 0.000 0.000 ↓ 0.0

Table Scan on tmp_legacy_clnt_dim (cost=0.00..431.00 rows=11 width=31) (actual rows= loops=)

179. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=11 width=28) (actual rows= loops=)

180. 0.000 0.000 ↓ 0.0

Table Scan on tmp_ueo_notional (cost=0.00..431.00 rows=11 width=28) (actual rows= loops=)

181. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=17 width=27) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

Table Scan on tmp_multi_dim (cost=0.00..431.00 rows=17 width=27) (actual rows= loops=)

183. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=17 width=27) (actual rows= loops=)

184. 0.000 0.000 ↓ 0.0

Table Scan on tmp_entitlement_ref (cost=0.00..431.00 rows=17 width=27) (actual rows= loops=)

185. 0.000 0.000 ↓ 0.0

Hash (cost=431.05..431.05 rows=1,273 width=21) (actual rows= loops=)

186. 0.000 0.000 ↓ 0.0

Broadcast Motion 96:96 (slice36; segments: 96) (cost=0.00..431.05 rows=1,273 width=21) (actual rows= loops=)

187. 0.000 0.000 ↓ 0.0

Table Scan on t_fx_rt_ref (cost=0.00..431.00 rows=14 width=21) (actual rows= loops=)

188. 0.000 0.000 ↓ 0.0

Hash (cost=431.05..431.05 rows=1,273 width=21) (actual rows= loops=)

189. 0.000 0.000 ↓ 0.0

Broadcast Motion 96:96 (slice37; segments: 96) (cost=0.00..431.05 rows=1,273 width=21) (actual rows= loops=)

190. 0.000 0.000 ↓ 0.0

Table Scan on t_fx_rt_ref (cost=0.00..431.00 rows=14 width=21) (actual rows= loops=)

191. 0.000 0.000 ↓ 0.0

Hash (cost=431.05..431.05 rows=1,273 width=21) (actual rows= loops=)

192. 0.000 0.000 ↓ 0.0

Broadcast Motion 96:96 (slice38; segments: 96) (cost=0.00..431.05 rows=1,273 width=21) (actual rows= loops=)

193. 0.000 0.000 ↓ 0.0

Table Scan on t_fx_rt_ref (cost=0.00..431.00 rows=14 width=21) (actual rows= loops=)