============================================================ 姝ラ 1: 鍒涘缓鐗╁寲瑙嗗浘 ============================================================ mv_dws_assistant_daily_detail_l1: 宸插瓨鍦紝璺宠繃 mv_dws_assistant_daily_detail_l2: 宸插瓨鍦紝璺宠繃 mv_dws_assistant_daily_detail_l3: 宸插瓨鍦紝璺宠繃 mv_dws_assistant_daily_detail_l4: 宸插瓨鍦紝璺宠繃 mv_dws_finance_daily_summary_l1: 宸插瓨鍦紝璺宠繃 mv_dws_finance_daily_summary_l2: 宸插瓨鍦紝璺宠繃 mv_dws_finance_daily_summary_l3: 宸插瓨鍦紝璺宠繃 mv_dws_finance_daily_summary_l4: 宸插瓨鍦紝璺宠繃 鐗╁寲瑙嗗浘: 8/8 鎴愬姛 ============================================================ 姝ラ 2: 鍒涘缓鐗╁寲瑙嗗浘绱㈠紩 ============================================================ idx_mv_assistant_daily_l1: OK idx_mv_assistant_daily_l2: OK idx_mv_assistant_daily_l3: OK idx_mv_assistant_daily_l4: OK idx_mv_finance_daily_l1: OK idx_mv_finance_daily_l2: OK idx_mv_finance_daily_l3: OK idx_mv_finance_daily_l4: OK 绱㈠紩: 8/8 鎴愬姛 ============================================================ 姝ラ 3: ANALYZE ============================================================ ods: 23 涓璞″凡 ANALYZE dwd: 40 涓璞″凡 ANALYZE dws: 37 涓璞″凡 ANALYZE meta: 3 涓璞″凡 ANALYZE core: 7 涓璞″凡 ANALYZE app: 0 涓璞″凡 ANALYZE ANALYZE 瀹屾垚 ============================================================ 姝ラ 4: 鏈€缁堥獙璇? ============================================================ OK ods.assistant_accounts_master: 223 琛? OK ods.assistant_cancellation_records: 100 琛? OK ods.assistant_service_records: 10203 琛? OK ods.goods_stock_movements: 35005 琛? OK ods.goods_stock_summary: 867 琛? OK ods.group_buy_packages: 52 琛? OK ods.group_buy_redemption_records: 19532 琛? OK ods.member_balance_changes: 7366 琛? OK ods.member_profiles: 1202 琛? OK ods.member_stored_value_cards: 2008 琛? OK ods.payment_transactions: 24674 琛? OK ods.platform_coupon_redemption_records: 18125 琛? OK ods.recharge_settlements: 3333 琛? OK ods.refund_transactions: 50 琛? OK ods.settlement_records: 55137 琛? OK ods.settlement_ticket_details: 193 琛? OK ods.site_tables_master: 949 琛? OK ods.stock_goods_category_tree: 9 琛? OK ods.store_goods_master: 1398 琛? OK ods.store_goods_sales_records: 17563 琛? OK ods.table_fee_discount_records: 3100 琛? OK ods.table_fee_transactions: 28881 琛? OK ods.tenant_goods_master: 176 琛? OK dwd.dim_assistant: 1208 琛? OK dwd.dim_assistant_ex: 1251 琛? OK dwd.dim_goods_category: 125 琛? OK dwd.dim_groupbuy_package: 373 琛? OK dwd.dim_groupbuy_package_ex: 373 琛? OK dwd.dim_member: 10801 琛? OK dwd.dim_member_card_account: 18370 琛? OK dwd.dim_member_card_account_ex: 18172 琛? OK dwd.dim_member_ex: 10770 琛? OK dwd.dim_site: 52 琛? OK dwd.dim_site_ex: 52 琛? OK dwd.dim_store_goods: 5444 琛? OK dwd.dim_store_goods_ex: 5402 琛? OK dwd.dim_table: 2749 琛? OK dwd.dim_table_ex: 2903 琛? OK dwd.dim_tenant_goods: 2018 琛? OK dwd.dim_tenant_goods_ex: 2016 琛? OK dwd.dwd_assistant_service_log: 5281 琛? OK dwd.dwd_assistant_service_log_ex: 5281 琛? OK dwd.dwd_assistant_trash_event: 100 琛? OK dwd.dwd_assistant_trash_event_ex: 100 琛? OK dwd.dwd_groupbuy_redemption: 12526 琛? OK dwd.dwd_groupbuy_redemption_ex: 12526 琛? OK dwd.dwd_member_balance_change: 5042 琛? OK dwd.dwd_member_balance_change_ex: 5042 琛? OK dwd.dwd_payment: 24597 琛? OK dwd.dwd_platform_coupon_redemption: 18069 琛? OK dwd.dwd_platform_coupon_redemption_ex: 18069 琛? OK dwd.dwd_recharge_order: 485 琛? OK dwd.dwd_recharge_order_ex: 485 琛? OK dwd.dwd_refund: 50 琛? OK dwd.dwd_refund_ex: 50 琛? OK dwd.dwd_settlement_head: 26115 琛? OK dwd.dwd_settlement_head_ex: 26115 琛? OK dwd.dwd_store_goods_sale: 17563 琛? OK dwd.dwd_store_goods_sale_ex: 17563 琛? OK dwd.dwd_table_fee_adjust: 3085 琛? OK dwd.dwd_table_fee_adjust_ex: 3085 琛? OK dwd.dwd_table_fee_log: 19847 琛? OK dwd.dwd_table_fee_log_ex: 19847 琛? OK dws.cfg_index_parameters: 127 琛? OK dws.dws_assistant_daily_detail: 5276 琛? OK dws.dws_finance_daily_summary: 210 琛? OK dws.dws_index_percentile_history: 80 琛? OK dws.dws_member_assistant_intimacy: 219 琛? OK dws.dws_member_newconv_index: 49 琛? OK dws.dws_member_visit_detail: 4398 琛? OK dws.dws_member_winback_index: 122 琛? OK meta.etl_cursor: 44 琛? OK meta.etl_run: 8726 琛? OK meta.etl_task: 49 琛? 鐗╁寲瑙嗗浘妫€鏌? OK dws.mv_dws_assistant_daily_detail_l1: 0 琛? OK dws.mv_dws_assistant_daily_detail_l2: 584 琛? OK dws.mv_dws_assistant_daily_detail_l3: 2400 琛? OK dws.mv_dws_assistant_daily_detail_l4: 4794 琛? OK dws.mv_dws_finance_daily_summary_l1: 0 琛? OK dws.mv_dws_finance_daily_summary_l2: 26 琛? OK dws.mv_dws_finance_daily_summary_l3: 86 琛? OK dws.mv_dws_finance_daily_summary_l4: 184 琛? 绱㈠紩缁熻: ods: 69 涓储寮? dwd: 135 涓储寮? dws: 123 涓储寮? meta: 5 涓储寮? ============================================================ 楠岃瘉閫氳繃: 74 琛? 572448 琛屽叏閮ㄤ竴鑷? ============================================================