postgresql语句解析

Question

pg数据库的慢语句收集，结果出现了一条这种慢语句，完全看不懂呀，有大腿知道这语句是在干什么吗

/* udaldump sql from 133.64.173.22-sxxa-4-1-c15-sev-nf8480m-04u30 */ COPY ""ratedb"".""call_lte_914_202212_28""(""ticket_id"", ""ticket_seq"", ""source_id"", ""oper_list_id"", ""event_type_id"", ""latn_id"", ""partner_id"", ""home_area_code"", ""log_user_name"", ""mdn_nbr"", ""collect_id"", ""switch_id"", ""ori_domain"", ""start_time"", ""end_time"", ""duration"", ""input_octets"", ""output_octets"", ""lant_pro_id"", ""service_option"", ""billing_object"", ""counts"", ""ori_charge"", ""disct_charge"", ""roam_flag"", ""tai_mcc"", ""tai_mnc"", ""tai_id"", ""ecgi_mcc"", ""ecgi_mnc"", ""ecgi_cell_id"", ""ecgi_lac_id"", ""billing_area_code"", ""billing_nbr"", ""acct_item_type_id"", ""disct_item_type_id"", ""billing_duration"", ""disct_rule_id"", ""event_pricing_strategy_id"", ""prd_ofr_id"", ""prd_inst_id"", ""ratable_value"", ""disct_out_ratable"", ""group_id"", ""upcalling_area_code"", ""pgw_address_used"", ""charging_id"", ""pdn_connection_charging_id"", ""serving_node_address"", ""serving_node_address_ipv6"", ""serving_node_type"", ""pgw_plmn_identifier"", ""pdp_type"", ""served_pdp_address"", ""served_meid"", ""user_location_information"", ""serving_node_plmn_identifier"", ""begin_time"", ""stop_time"", ""local_seq_num"", ""local_rec_seq_num"", ""qos_information"", ""rating_group"", ""report_time"", ""service_condition_change"", ""service_identifier"", ""time_of_first_usage"", ""time_of_last_usage"", ""time_usage"", ""record_type"", ""cause_for_record_closing"", ""node_id"", ""apn_selection_mode"", ""segment_id"", ""reserver1"", ""reserver2"", ""start_year"", ""start_month"", ""start_day"", ""start_hour"", ""start_mmss"", ""cust_type"", ""payment_type"", ""bsid"", ""acct_id"", ""cause"", ""balanceinfo"", ""discount_fee"", ""accumlatorinfo"", ""prod_offer_inst_id"", ""platform"", ""fee_type"", ""cdr_flag"", ""card_total_volume"", ""reserver3"", ""reserver4"", ""reserver5"", ""measure_domain"", ""ratableinfo"", ""uuid"", ""accuinfo"", ""cust_id"", ""batchno"", ""charge"", ""visit_area_code"", ""jt_uuid"", ""pay_mode"", ""offer_code"", ""rate_trace"", ""visitctry"", ""jt_old_uuid"", ""rfi"", ""rst"", ""ret"", ""rdv"", ""ruv"", ""b42"", ""b43"", ""rpt"", ""chd"", ""source_inst_id"", ""oper_type"", ""ept_type"", ""pub_int_seq"", ""str_pricing_plan_id"", ""pub_int_flag"", ""sm_int_result_code"", ""sm_int_offline_flag"", ""sm_int_req_type"", ""ambrdl"", ""ambrul"", ""inv_seq"", ""session_id"", ""served_pdp_address_ipv6"", ""pdu_session_id"", ""pdu_type"", ""rat_type"", ""cdr_str_nr_cellid"", ""cdr_online_mod5g"", ""cdr_quota_manage_indicator"", ""day"", ""callback_source_id"", ""ldr_id"", ""cdr_pub_str_hostid"", ""servicescenarious"", ""ocp_str_session_id"", ""sourcefile"", ""pay_mod"", ""calling_area_code"", ""re_trail"", ""cnplmn"") FROM STDIN csv DELIMITER AS '^E' QUOTE AS '^C'

Answer 1

应该是从STDIN(控制台标准输入）中导入csv格式数据到数据库ratedb中的call_lte_914_202212_28表中

COPY table_name [ ( column_name [, ...] ) ]
    FROM { 'filename' | STDIN }
    [ [ WITH ]
          [ BINARY ]
          [ DELIMITER [ AS ] 'delimiter_character' ]
          [ NULL [ AS ] 'null_string' ]
          [ CSV [ HEADER ]
                [ QUOTE [ AS ] 'quote_character' ]
                [ ESCAPE [ AS ] 'escape_character' ]
                [ FORCE NOT NULL column_name [, ...] ] ] ]

COPY { table_name [ ( column_name [, ...] ) ] | ( query ) }
    TO { 'filename' | STDOUT }
    [ [ WITH ]
          [ BINARY ]
          [ DELIMITER [ AS ] 'delimiter_character' ]
          [ NULL [ AS ] 'null_string' ]
          [ CSV [ HEADER ]
                [ QUOTE [ AS ] 'quote_character' ]
                [ ESCAPE [ AS ] 'escape_character' ]
                [ FORCE QUOTE { column_name [, ...] | * } ] ] ]

https://www.postgresql.org/docs/current/sql-copy.html