泰山保险
  1. 泰山保险
  2. TAISHAN-887

【系统优化-版本待定】生产环境慢SQL统计,并标注SQL对应的功能,将统计信息整理贴到jira上

    问题详情

    • 项目环境:
      SIT

      描述

      slow sql 7873 millis. DELETE FROM dd_scheduling WHERE (upload_dept_code = ? AND batch_no = ?)["12","56"]

      slow sql 3883 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2024-01-09 03%"]

      slow sql 2005 millis. SELECT COUNT(1) FROM dd_case_info c
      LEFT JOIN dd_case_task t ON c.regist_no=t.regist_no
      WHERE 1=1
      AND t.loss_type='0101'
      AND c.forecast_case_no in
      (
      ?
      ,
      ?
      ,
      ?
      ,
      ?
      ,
      ?
      ,
      ?
      ,
      ?
      ,
      ?
      ,
      ?
      ,
      ?
      )

      AND c.video_user IS NOT NULL["VIDEO20240105102300陕A7N05J","VIDEO20240104163800蒙FAN412","VIDEO20240104105900蒙E106G8","VIDEO20240103101600LC0C74C45P1388982","VIDEO20240101161600鲁B6DJ02","VIDEO20231231104900蒙A082UQ","VIDEO20231231093300鲁V532SR","VIDEO20231229161600蒙DAN180","VIDEO20231228091100鲁GS779E","VIDEO20231225150000陕UCT270"]

      slow sql 2841 millis. SELECT COUNT(1)
      FROM
      dd_case_info c
      WHERE 1=1
      AND c.org_code LIKE '03%'
      and c.deal_type = ?
      AND c.has_commit_video='0'
      AND c.video_user IS NULL["1"]

      slow sql 3224 millis. SELECT
      c.regist_no,
      c.license_no,
      c.insured_name,
      c.linker_name,
      c.linker_phone,
      c.damage_time,
      c.report_time,
      c.damage_place,
      c.damage_remark,
      c.case_status,
      c.subrogation,
      c.vip_level,
      c.insurance_type,
      c.org_code,
      c.org_name,
      c.video_user,
      c.video_user_name,
      c.is_new_policy_flag,
      c.is_black_list,
      c.black_list_type,
      c.black_list_type_desc,
      c.deal_type,
      c.has_commit_video

      FROM
      dd_case_info c

      WHERE 1=1
      AND c.org_code LIKE '03%'
      and c.deal_type = ?
      AND c.has_commit_video='0'
      AND c.video_user IS NULL
      limit ? , ?["1",0,100]

      slow sql 4427 millis. SELECT COUNT( * ) FROM dd_case_info
      WHERE (org_code = ? AND create_time LIKE ?)["01","2024-01-09 17%"]

        活动

        刘宁 创建问题 -
        匿名 进行了改变 -
        字段 原值 新值
        描述 slow sql 7873 millis. DELETE FROM dd_scheduling WHERE (upload_dept_code = ? AND batch_no = ?)["12","56"]

        slow sql 3883 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2024-01-09 03%"]

        slow sql 2005 millis. SELECT COUNT(1) FROM dd_case_info c
                LEFT JOIN dd_case_task t ON c.regist_no=t.regist_no
                WHERE 1=1
                AND t.loss_type='0101'
                    AND c.forecast_case_no in
                     (
                        ?
                     ,
                        ?
                     ,
                        ?
                     ,
                        ?
                     ,
                        ?
                     ,
                        ?
                     ,
                        ?
                     ,
                        ?
                     ,
                        ?
                     ,
                        ?
                     )

                AND c.video_user IS NOT NULL["VIDEO20240105102300陕A7N05J","VIDEO20240104163800蒙FAN412","VIDEO20240104105900蒙E106G8","VIDEO20240103101600LC0C74C45P1388982","VIDEO20240101161600鲁B6DJ02","VIDEO20231231104900蒙A082UQ","VIDEO20231231093300鲁V532SR","VIDEO20231229161600蒙DAN180","VIDEO20231228091100鲁GS779E","VIDEO20231225150000陕UCT270"]


        slow sql 2841 millis. SELECT COUNT(1)
                FROM
                dd_case_info c
                WHERE 1=1
                    AND c.org_code LIKE '03%'
                    and c.deal_type = ?
                AND c.has_commit_video='0'
                AND c.video_user IS NULL["1"]

        slow sql 3224 millis. SELECT
                c.regist_no,
                c.license_no,
                c.insured_name,
                c.linker_name,
                c.linker_phone,
                c.damage_time,
                c.report_time,
                c.damage_place,
                c.damage_remark,
                c.case_status,
                c.subrogation,
                c.vip_level,
                c.insurance_type,
                c.org_code,
                c.org_name,
                c.video_user,
                c.video_user_name,
                c.is_new_policy_flag,
                c.is_black_list,
                c.black_list_type,
                c.black_list_type_desc,
                c.deal_type,
                c.has_commit_video

                FROM
                dd_case_info c

                WHERE 1=1
                    AND c.org_code LIKE '03%'
                    and c.deal_type = ?
                AND c.has_commit_video='0'
                AND c.video_user IS NULL
                limit ? , ?["1",0,100]


        slow sql 4427 millis. SELECT COUNT( * ) FROM dd_case_info
         WHERE (org_code = ? AND create_time LIKE ?)["01","2024-01-09 17%"]

          用户

          • 经办人:
            李小龙
            报告人:
            刘宁
          • 投票:
            0 为这个问题投票
            关注人:
            1 关注这个问题

            日期

            • 创建:
              更新:
              解决: