2018/09/17 10:18:42.887 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS `DN_TYPE`,`A0`.`CREATE_TIME`,`A0`.`LAST_ACCESS_TIME`,`A0`.`OWNER`,`A0`.`RETENTION`,`A0`.`TBL_NAME`,`A0`.`TBL_TYPE`,`A0`.`TBL_ID` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` WHERE `A0`.`TBL_NAME` = 'table_tag_t100_p400_c100_1535622485748910166' AND `B0`.`NAME` = 'test_tidb_4'
2018/09/17 10:18:42.895 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`DESC`,`B0`.`DB_LOCATION_URI`,`B0`.`NAME`,`B0`.`OWNER_NAME`,`B0`.`OWNER_TYPE`,`B0`.`DB_ID`,`C0`.`INPUT_FORMAT`,`C0`.`IS_COMPRESSED`,`C0`.`IS_STOREDASSUBDIRECTORIES`,`C0`.`LOCATION`,`C0`.`NUM_BUCKETS`,`C0`.`OUTPUT_FORMAT`,`C0`.`SD_ID`,`A0`.`VIEW_EXPANDED_TEXT`,`A0`.`VIEW_ORIGINAL_TEXT` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` LEFT OUTER JOIN `SDS` `C0` ON `A0`.`SD_ID` = `C0`.`SD_ID` WHERE `A0`.`TBL_ID` = 44446
2018/09/17 10:18:42.919 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`CD_ID` FROM `SDS` `A0` LEFT OUTER JOIN `CDS` `B0` ON `A0`.`CD_ID` = `B0`.`CD_ID` WHERE `A0`.`SD_ID` = 34498396
2018/09/17 10:18:42.941 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`NAME`,`B0`.`SLIB`,`B0`.`SERDE_ID` FROM `SDS` `A0` LEFT OUTER JOIN `SERDES` `B0` ON `A0`.`SERDE_ID` = `B0`.`SERDE_ID` WHERE `A0`.`SD_ID` = 34498396
2018/09/17 10:18:42.949 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `A0`.`PARAM_KEY`,`A0`.`PARAM_VALUE` FROM `SERDE_PARAMS` `A0` WHERE `A0`.`SERDE_ID` = 34406506 AND `A0`.`PARAM_KEY` IS NOT NULL
2018/09/17 10:18:42.990 set.go:180: [info] con:3342031 autocommit=1
2018/09/17 10:18:42.990 set.go:180: [info] con:3342031 tx_read_only=0
2018/09/17 10:18:42.990 set.go:180: [info] con:3342031 transaction_read_only=0
2018/09/17 10:18:42.998 set.go:180: [info] con:3342030 autocommit=0
2018/09/17 10:18:43.000 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS `DN_TYPE`,`A0`.`CREATE_TIME`,`A0`.`LAST_ACCESS_TIME`,`A0`.`OWNER`,`A0`.`RETENTION`,`A0`.`TBL_NAME`,`A0`.`TBL_TYPE`,`A0`.`TBL_ID` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` WHERE `A0`.`TBL_NAME` = 'table_tag_t100_p400_c100_1535622485748910166' AND `B0`.`NAME` = 'test_tidb_4'
2018/09/17 10:18:43.006 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`DESC`,`B0`.`DB_LOCATION_URI`,`B0`.`NAME`,`B0`.`OWNER_NAME`,`B0`.`OWNER_TYPE`,`B0`.`DB_ID`,`C0`.`INPUT_FORMAT`,`C0`.`IS_COMPRESSED`,`C0`.`IS_STOREDASSUBDIRECTORIES`,`C0`.`LOCATION`,`C0`.`NUM_BUCKETS`,`C0`.`OUTPUT_FORMAT`,`C0`.`SD_ID`,`A0`.`VIEW_EXPANDED_TEXT`,`A0`.`VIEW_ORIGINAL_TEXT` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` LEFT OUTER JOIN `SDS` `C0` ON `A0`.`SD_ID` = `C0`.`SD_ID` WHERE `A0`.`TBL_ID` = 44446
2018/09/17 10:18:43.022 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`CD_ID` FROM `SDS` `A0` LEFT OUTER JOIN `CDS` `B0` ON `A0`.`CD_ID` = `B0`.`CD_ID` WHERE `A0`.`SD_ID` = 34498396
2018/09/17 10:18:43.039 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`NAME`,`B0`.`SLIB`,`B0`.`SERDE_ID` FROM `SDS` `A0` LEFT OUTER JOIN `SERDES` `B0` ON `A0`.`SERDE_ID` = `B0`.`SERDE_ID` WHERE `A0`.`SD_ID` = 34498396
2018/09/17 10:18:43.043 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `A0`.`PARAM_KEY`,`A0`.`PARAM_VALUE` FROM `SERDE_PARAMS` `A0` WHERE `A0`.`SERDE_ID` = 34406506 AND `A0`.`PARAM_KEY` IS NOT NULL
2018/09/17 10:18:43.074 set.go:180: [info] con:3342030 autocommit=1
2018/09/17 10:18:43.074 set.go:180: [info] con:3342030 tx_read_only=0
2018/09/17 10:18:43.074 set.go:180: [info] con:3342030 transaction_read_only=0
2018/09/17 10:18:43.091 set.go:180: [info] con:3342031 autocommit=0
2018/09/17 10:18:43.093 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS `DN_TYPE`,`A0`.`CREATE_TIME`,`A0`.`LAST_ACCESS_TIME`,`A0`.`OWNER`,`A0`.`RETENTION`,`A0`.`TBL_NAME`,`A0`.`TBL_TYPE`,`A0`.`TBL_ID` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` WHERE `A0`.`TBL_NAME` = 'table_tag_t100_p400_c100_1535622485748910166' AND `B0`.`NAME` = 'test_tidb_4'
2018/09/17 10:18:43.100 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`DESC`,`B0`.`DB_LOCATION_URI`,`B0`.`NAME`,`B0`.`OWNER_NAME`,`B0`.`OWNER_TYPE`,`B0`.`DB_ID`,`C0`.`INPUT_FORMAT`,`C0`.`IS_COMPRESSED`,`C0`.`IS_STOREDASSUBDIRECTORIES`,`C0`.`LOCATION`,`C0`.`NUM_BUCKETS`,`C0`.`OUTPUT_FORMAT`,`C0`.`SD_ID`,`A0`.`VIEW_EXPANDED_TEXT`,`A0`.`VIEW_ORIGINAL_TEXT` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` LEFT OUTER JOIN `SDS` `C0` ON `A0`.`SD_ID` = `C0`.`SD_ID` WHERE `A0`.`TBL_ID` = 44446
2018/09/17 10:18:43.114 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`CD_ID` FROM `SDS` `A0` LEFT OUTER JOIN `CDS` `B0` ON `A0`.`CD_ID` = `B0`.`CD_ID` WHERE `A0`.`SD_ID` = 34498396
2018/09/17 10:18:43.133 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`NAME`,`B0`.`SLIB`,`B0`.`SERDE_ID` FROM `SDS` `A0` LEFT OUTER JOIN `SERDES` `B0` ON `A0`.`SERDE_ID` = `B0`.`SERDE_ID` WHERE `A0`.`SD_ID` = 34498396
2018/09/17 10:18:43.137 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `A0`.`PARAM_KEY`,`A0`.`PARAM_VALUE` FROM `SERDE_PARAMS` `A0` WHERE `A0`.`SERDE_ID` = 34406506 AND `A0`.`PARAM_KEY` IS NOT NULL
2018/09/17 10:18:43.166 set.go:180: [info] con:3342031 autocommit=1
2018/09/17 10:18:43.167 set.go:180: [info] con:3342031 tx_read_only=0
2018/09/17 10:18:43.167 set.go:180: [info] con:3342031 transaction_read_only=0
2018/09/17 10:18:43.177 set.go:180: [info] con:3342030 autocommit=0
2018/09/17 10:18:43.179 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `A0`.`PART_NAME` AS `NUCORDER0` FROM `PARTITIONS` `A0` LEFT OUTER JOIN `TBLS` `B0` ON `A0`.`TBL_ID` = `B0`.`TBL_ID` LEFT OUTER JOIN `DBS` `C0` ON `B0`.`DB_ID` = `C0`.`DB_ID` WHERE `C0`.`NAME` = 'test_tidb_4' AND `B0`.`TBL_NAME` = 'table_tag_t100_p400_c100_1535622485748910166' ORDER BY `NUCORDER0`
2018/09/17 10:18:43.200 set.go:180: [info] con:3342030 autocommit=1
2018/09/17 10:18:43.200 set.go:180: [info] con:3342030 tx_read_only=0
2018/09/17 10:18:43.200 set.go:180: [info] con:3342030 transaction_read_only=0
2018/09/17 10:18:49.300 set.go:180: [info] con:3342031 autocommit=0
2018/09/17 10:18:49.302 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS `DN_TYPE`,`A0`.`CREATE_TIME`,`A0`.`LAST_ACCESS_TIME`,`A0`.`OWNER`,`A0`.`RETENTION`,`A0`.`TBL_NAME`,`A0`.`TBL_TYPE`,`A0`.`TBL_ID` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` WHERE `A0`.`TBL_NAME` = 'table_tag_t100_p400_c100_1535622485748910166' AND `B0`.`NAME` = 'test_tidb_4'
2018/09/17 10:18:49.309 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`DESC`,`B0`.`DB_LOCATION_URI`,`B0`.`NAME`,`B0`.`OWNER_NAME`,`B0`.`OWNER_TYPE`,`B0`.`DB_ID`,`C0`.`INPUT_FORMAT`,`C0`.`IS_COMPRESSED`,`C0`.`IS_STOREDASSUBDIRECTORIES`,`C0`.`LOCATION`,`C0`.`NUM_BUCKETS`,`C0`.`OUTPUT_FORMAT`,`C0`.`SD_ID`,`A0`.`VIEW_EXPANDED_TEXT`,`A0`.`VIEW_ORIGINAL_TEXT` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` LEFT OUTER JOIN `SDS` `C0` ON `A0`.`SD_ID` = `C0`.`SD_ID` WHERE `A0`.`TBL_ID` = 44446
2018/09/17 10:18:49.324 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`CD_ID` FROM `SDS` `A0` LEFT OUTER JOIN `CDS` `B0` ON `A0`.`CD_ID` = `B0`.`CD_ID` WHERE `A0`.`SD_ID` = 34498396
2018/09/17 10:18:49.343 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`NAME`,`B0`.`SLIB`,`B0`.`SERDE_ID` FROM `SDS` `A0` LEFT OUTER JOIN `SERDES` `B0` ON `A0`.`SERDE_ID` = `B0`.`SERDE_ID` WHERE `A0`.`SD_ID` = 34498396
2018/09/17 10:18:49.347 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `A0`.`PARAM_KEY`,`A0`.`PARAM_VALUE` FROM `SERDE_PARAMS` `A0` WHERE `A0`.`SERDE_ID` = 34406506 AND `A0`.`PARAM_KEY` IS NOT NULL
2018/09/17 10:18:49.381 set.go:180: [info] con:3342031 autocommit=1
2018/09/17 10:18:49.382 set.go:180: [info] con:3342031 tx_read_only=0
2018/09/17 10:18:49.382 set.go:180: [info] con:3342031 transaction_read_only=0
2018/09/17 10:18:49.398 set.go:180: [info] con:3342030 autocommit=0
2018/09/17 10:18:49.400 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS `DN_TYPE`,`A0`.`CREATE_TIME`,`A0`.`LAST_ACCESS_TIME`,`A0`.`OWNER`,`A0`.`RETENTION`,`A0`.`TBL_NAME`,`A0`.`TBL_TYPE`,`A0`.`TBL_ID` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` WHERE `A0`.`TBL_NAME` = 'table_tag_t100_p400_c100_1535622485748910166' AND `B0`.`NAME` = 'test_tidb_4'
2018/09/17 10:18:49.406 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`DESC`,`B0`.`DB_LOCATION_URI`,`B0`.`NAME`,`B0`.`OWNER_NAME`,`B0`.`OWNER_TYPE`,`B0`.`DB_ID`,`C0`.`INPUT_FORMAT`,`C0`.`IS_COMPRESSED`,`C0`.`IS_STOREDASSUBDIRECTORIES`,`C0`.`LOCATION`,`C0`.`NUM_BUCKETS`,`C0`.`OUTPUT_FORMAT`,`C0`.`SD_ID`,`A0`.`VIEW_EXPANDED_TEXT`,`A0`.`VIEW_ORIGINAL_TEXT` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` LEFT OUTER JOIN `SDS` `C0` ON `A0`.`SD_ID` = `C0`.`SD_ID` WHERE `A0`.`TBL_ID` = 44446
2018/09/17 10:18:49.422 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`CD_ID` FROM `SDS` `A0` LEFT OUTER JOIN `CDS` `B0` ON `A0`.`CD_ID` = `B0`.`CD_ID` WHERE `A0`.`SD_ID` = 34498396
2018/09/17 10:18:49.440 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`NAME`,`B0`.`SLIB`,`B0`.`SERDE_ID` FROM `SDS` `A0` LEFT OUTER JOIN `SERDES` `B0` ON `A0`.`SERDE_ID` = `B0`.`SERDE_ID` WHERE `A0`.`SD_ID` = 34498396
2018/09/17 10:18:49.444 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `A0`.`PARAM_KEY`,`A0`.`PARAM_VALUE` FROM `SERDE_PARAMS` `A0` WHERE `A0`.`SERDE_ID` = 34406506 AND `A0`.`PARAM_KEY` IS NOT NULL
2018/09/17 10:18:49.474 set.go:180: [info] con:3342030 autocommit=1
2018/09/17 10:18:49.475 set.go:180: [info] con:3342030 tx_read_only=0
2018/09/17 10:18:49.475 set.go:180: [info] con:3342030 transaction_read_only=0
2018/09/17 10:18:49.482 set.go:180: [info] con:3342031 autocommit=0
2018/09/17 10:18:49.485 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `A0`.`PART_NAME` AS `NUCORDER0` FROM `PARTITIONS` `A0` LEFT OUTER JOIN `TBLS` `B0` ON `A0`.`TBL_ID` = `B0`.`TBL_ID` LEFT OUTER JOIN `DBS` `C0` ON `B0`.`DB_ID` = `C0`.`DB_ID` WHERE `C0`.`NAME` = 'test_tidb_4' AND `B0`.`TBL_NAME` = 'table_tag_t100_p400_c100_1535622485748910166' ORDER BY `NUCORDER0`
2018/09/17 10:18:49.499 set.go:180: [info] con:3342031 autocommit=1
2018/09/17 10:18:49.500 set.go:180: [info] con:3342031 tx_read_only=0
2018/09/17 10:18:49.500 set.go:180: [info] con:3342031 transaction_read_only=0
2018/09/17 10:18:49.503 set.go:180: [info] con:3342030 autocommit=0
2018/09/17 10:18:49.505 compiler.go:78: [warning] [EXPENSIVE_QUERY] select TBL_ID from TBLS inner join DBS on TBLS.DB_ID = DBS.DB_ID where TBLS.TBL_NAME = 'table_tag_t100_p400_c100_1535622485748910166' and DBS.NAME = 'test_tidb_4'
2018/09/17 10:18:49.513 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PARTITIONS.PART_ID from PARTITIONS  where PARTITIONS.TBL_ID = 44446 and "PARTITIONS"."PART_NAME" in ('p1=0/p2=0','p1=1/p2=1','p1=10/p2=10','p1=100/p2=100','p1=101/p2=101','p1=102/p2=102','p1=103/p2=103','p1=104/p2=104','p1=105/p2=105','p1=106/p2=106','p1=107/p2=107','p1=108/p2=108','p1=109/p2=109','p1=11/p2=11','p1=110/p2=110','p1=111/p2=111','p1=112/p2=112','p1=113/p2=113','p1=114/p2=114','p1=115/p2=115','p1=116/p2=116','p1=117/p2=117','p1=118/p2=118','p1=119/p2=119','p1=12/p2=12','p1=120/p2=120','p1=121/p2=121','p1=122/p2=122','p1=123/p2=123','p1=124/p2=124','p1=125/p2=125','p1=126/p2=126','p1=127/p2=127','p1=128/p2=128','p1=129/p2=129','p1=13/p2=13','p1=130/p2=130','p1=131/p2=131','p1=132/p2=132','p1=133/p2=133','p1=134/p2=134','p1=135/p2=135','p1=136/p2=136','p1=137/p2=137','p1=138/p2=138','p1=139/p2=139','p1=14/p2=14','p1=140/p2=140','p1=141/p2=141','p1=142/p2=142','p1=143/p2=143','p1=144/p2=144','p1=145/p2=145','p1=146/p2=146','p1=147/p2=147','p1=148/p2=148','p1=149/p2=149','p1=15/p2=15','p1=150/ len(4838)
2018/09/17 10:18:49.525 compiler.go:78: [warning] [EXPENSIVE_QUERY] select /*+ TIDB_INLJ(PARTITIONS, SDS) */ "PARTITIONS"."PART_ID", "SDS"."SD_ID", "SDS"."CD_ID", "SDS"."SERDE_ID", "PARTITIONS"."CREATE_TIME", "PARTITIONS"."LAST_ACCESS_TIME", "SDS"."INPUT_FORMAT", "SDS"."IS_COMPRESSED", "SDS"."IS_STOREDASSUBDIRECTORIES", "SDS"."LOCATION", "SDS"."NUM_BUCKETS", "SDS"."OUTPUT_FORMAT" from "PARTITIONS"  left outer join "SDS" on "PARTITIONS"."SD_ID" = "SDS"."SD_ID" where "PART_ID" in (34561178,34561179,34560934,34560935,34560936,34560937,34560938,34560939,34560940,34560824,34560941,34560942,34560943,34560944,34560945,34560946,34561072,34561073,34561074,34561075,34561076,34561077,34561078,34561079,34561080,34560838,34561081,34561082,34561083,34561084,34561085,34561086,34561140,34560844,34561141,34561142,34561143,34561144,34561145,34561146,34561147,34561148,34561149,34561150,34560845,34561151,34561152,34561153,34561154,34561087,34561088,34561089,34561090,34560839,34561091,34561092,34561093,34561094,34561095,34561096,34561097,34561098,34561099,34561100,34560840,34561101,34561102,34561 len(3141)
2018/09/17 10:18:49.552 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "SERDES"."NAME", "SERDES"."SLIB" from "SERDES" where "SERDE_ID" in (34406507,34406508,34406517,34406607,34406608,34406609,34406610,34406611,34406612,34406613,34406614,34406615,34406616,34406518,34406617,34406618,34406619,34406620,34406621,34406622,34406623,34406624,34406625,34406626,34406519,34406627,34406628,34406629,34406630,34406631,34406632,34406633,34406634,34406635,34406636,34406520,34406637,34406638,34406639,34406640,34406641,34406642,34406643,34406644,34406645,34406646,34406521,34406647,34406648,34406649,34406650,34406651,34406652,34406653,34406654,34406655,34406656,34406522,34406657,34406658,34406659,34406660,34406661,34406662,34406663,34406664,34406665,34406666,34406523,34406667,34406668,34406669,34406670,34406671,34406672,34406673,34406674,34406675,34406676,34406524,34406677,34406678,34406679,34406680,34406681,34406682,34406683,34406684,34406685,34406686,34406525,34406687,34406688,34406689,34406690,34406691,34406692,34406693,34406694,34406695,34406696,34406526,34406697,34406698,34406699,3440 len(2775)
2018/09/17 10:18:49.574 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "PART_ID", "PARAM_KEY", "PARAM_VALUE" from "PARTITION_PARAMS" where "PART_ID" in (34561178,34561179,34560934,34560935,34560936,34560937,34560938,34560939,34560940,34560824,34560941,34560942,34560943,34560944,34560945,34560946,34561072,34561073,34561074,34561075,34561076,34561077,34561078,34561079,34561080,34560838,34561081,34561082,34561083,34561084,34561085,34561086,34561140,34560844,34561141,34561142,34561143,34561144,34561145,34561146,34561147,34561148,34561149,34561150,34560845,34561151,34561152,34561153,34561154,34561087,34561088,34561089,34561090,34560839,34561091,34561092,34561093,34561094,34561095,34561096,34561097,34561098,34561099,34561100,34560840,34561101,34561102,34561103,34561104,34561105,34561106,34561107,34561108,34561109,34561110,34560814,34561042,34561043,34561044,34561045,34561046,34561047,34561048,34561049,34561050,34560835,34561051,34561052,34561053,34561054,34561055,34561056,34561057,34561058,34561059,34561060,34560836,34561061,34561062,34561063,34561064,34561065,34561066,34561067 len(2840)
2018/09/17 10:18:49.611 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "PART_ID", "PART_KEY_VAL" from "PARTITION_KEY_VALS" where "PART_ID" in (34561178,34561179,34560934,34560935,34560936,34560937,34560938,34560939,34560940,34560824,34560941,34560942,34560943,34560944,34560945,34560946,34561072,34561073,34561074,34561075,34561076,34561077,34561078,34561079,34561080,34560838,34561081,34561082,34561083,34561084,34561085,34561086,34561140,34560844,34561141,34561142,34561143,34561144,34561145,34561146,34561147,34561148,34561149,34561150,34560845,34561151,34561152,34561153,34561154,34561087,34561088,34561089,34561090,34560839,34561091,34561092,34561093,34561094,34561095,34561096,34561097,34561098,34561099,34561100,34560840,34561101,34561102,34561103,34561104,34561105,34561106,34561107,34561108,34561109,34561110,34560814,34561042,34561043,34561044,34561045,34561046,34561047,34561048,34561049,34561050,34560835,34561051,34561052,34561053,34561054,34561055,34561056,34561057,34561058,34561059,34561060,34560836,34561061,34561062,34561063,34561064,34561065,34561066,34561067,34561068, len(2844)
2018/09/17 10:18:49.740 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "SERDE_ID", "PARAM_KEY", "PARAM_VALUE" from "SERDE_PARAMS" where "SERDE_ID" in (34406507,34406508,34406517,34406607,34406608,34406609,34406610,34406611,34406612,34406613,34406614,34406615,34406616,34406518,34406617,34406618,34406619,34406620,34406621,34406622,34406623,34406624,34406625,34406626,34406519,34406627,34406628,34406629,34406630,34406631,34406632,34406633,34406634,34406635,34406636,34406520,34406637,34406638,34406639,34406640,34406641,34406642,34406643,34406644,34406645,34406646,34406521,34406647,34406648,34406649,34406650,34406651,34406652,34406653,34406654,34406655,34406656,34406522,34406657,34406658,34406659,34406660,34406661,34406662,34406663,34406664,34406665,34406666,34406523,34406667,34406668,34406669,34406670,34406671,34406672,34406673,34406674,34406675,34406676,34406524,34406677,34406678,34406679,34406680,34406681,34406682,34406683,34406684,34406685,34406686,34406525,34406687,34406688,34406689,34406690,34406691,34406692,34406693,34406694,34406695,34406696,34406526,34406697,34406698,3 len(2839)
2018/09/17 10:18:49.773 set.go:180: [info] con:3342030 autocommit=1
2018/09/17 10:18:49.774 set.go:180: [info] con:3342030 tx_read_only=0
2018/09/17 10:18:49.774 set.go:180: [info] con:3342030 transaction_read_only=0
2018/09/17 10:18:49.812 set.go:180: [info] con:3342031 autocommit=0
2018/09/17 10:18:49.814 compiler.go:78: [warning] [EXPENSIVE_QUERY] select TBL_ID from TBLS inner join DBS on TBLS.DB_ID = DBS.DB_ID where TBLS.TBL_NAME = 'table_tag_t100_p400_c100_1535622485748910166' and DBS.NAME = 'test_tidb_4'
2018/09/17 10:18:49.820 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PARTITIONS.PART_ID from PARTITIONS  where PARTITIONS.TBL_ID = 44446 and "PARTITIONS"."PART_NAME" in ('p1=369/p2=369','p1=37/p2=37','p1=370/p2=370','p1=371/p2=371','p1=372/p2=372','p1=373/p2=373','p1=374/p2=374','p1=375/p2=375','p1=376/p2=376','p1=377/p2=377','p1=378/p2=378','p1=379/p2=379','p1=38/p2=38','p1=380/p2=380','p1=381/p2=381','p1=382/p2=382','p1=383/p2=383','p1=384/p2=384','p1=385/p2=385','p1=386/p2=386','p1=387/p2=387','p1=388/p2=388','p1=389/p2=389','p1=39/p2=39','p1=390/p2=390','p1=391/p2=391','p1=392/p2=392','p1=393/p2=393','p1=394/p2=394','p1=395/p2=395','p1=396/p2=396','p1=397/p2=397','p1=398/p2=398','p1=399/p2=399','p1=4/p2=4','p1=40/p2=40','p1=41/p2=41','p1=42/p2=42','p1=43/p2=43','p1=44/p2=44','p1=45/p2=45','p1=46/p2=46','p1=47/p2=47','p1=48/p2=48','p1=49/p2=49','p1=5/p2=5','p1=50/p2=50','p1=51/p2=51','p1=52/p2=52','p1=53/p2=53','p1=54/p2=54','p1=55/p2=55','p1=56/p2=56','p1=57/p2=57','p1=58/p2=58','p1=59/p2=59','p1=6/p2=6','p1=60/p2=60','p1=61/p2=61','p1=62/p2=62','p1=63/p2=63','p1=64 len(1558)
2018/09/17 10:18:49.836 compiler.go:78: [warning] [EXPENSIVE_QUERY] select /*+ TIDB_INLJ(PARTITIONS, SDS) */ "PARTITIONS"."PART_ID", "SDS"."SD_ID", "SDS"."CD_ID", "SDS"."SERDE_ID", "PARTITIONS"."CREATE_TIME", "PARTITIONS"."LAST_ACCESS_TIME", "SDS"."INPUT_FORMAT", "SDS"."IS_COMPRESSED", "SDS"."IS_STOREDASSUBDIRECTORIES", "SDS"."LOCATION", "SDS"."NUM_BUCKETS", "SDS"."OUTPUT_FORMAT" from "PARTITIONS"  left outer join "SDS" on "PARTITIONS"."SD_ID" = "SDS"."SD_ID" where "PART_ID" in (34560876,34560877,34560864,34560865,34560874,34560875,34560859,34560860,34561201,34561202,34561203,34561204,34561205,34561206,34561207,34561208,34561209,34561210,34560815,34560851,34560872,34560873,34560816,34560861,34560856,34560857,34560858,34561180,34560848,34561181,34561182,34561183,34561184,34561185,34561186,34561187,34561188,34561189,34561190,34560849,34561191,34561192,34561193,34561194,34561195,34561196,34561197,34561198,34561199,34561200,34560850,34560862,34560863,34560867,34560868,34560869,34560870,34560817,34560871,34560855,34560852,34560853,34560854,34560866,34560880,34560898,34560899,34560 len(1341)
2018/09/17 10:18:49.850 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "SERDES"."NAME", "SERDES"."SLIB" from "SERDES" where "SERDE_ID" in (34406876,34406544,34406877,34406878,34406879,34406880,34406881,34406882,34406883,34406884,34406885,34406886,34406545,34406887,34406888,34406889,34406890,34406891,34406892,34406893,34406894,34406895,34406896,34406546,34406897,34406898,34406899,34406900,34406901,34406902,34406903,34406904,34406905,34406906,34406511,34406547,34406548,34406549,34406550,34406551,34406552,34406553,34406554,34406555,34406556,34406512,34406557,34406558,34406559,34406560,34406561,34406562,34406563,34406564,34406565,34406566,34406513,34406567,34406568,34406569,34406570,34406571,34406572,34406573,34406574,34406575,34406576,34406514,34406577,34406578,34406579,34406580,34406581,34406582,34406583,34406584,34406585,34406586,34406515,34406587,34406588,34406589,34406590,34406591,34406592,34406593,34406594,34406595,34406596,34406516,34406597,34406598,34406599,34406600,34406601,34406602,34406603,34406604,34406605,34406606)
2018/09/17 10:18:49.860 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "PART_ID", "PARAM_KEY", "PARAM_VALUE" from "PARTITION_PARAMS" where "PART_ID" in (34560876,34560877,34560864,34560865,34560874,34560875,34560859,34560860,34561201,34561202,34561203,34561204,34561205,34561206,34561207,34561208,34561209,34561210,34560815,34560851,34560872,34560873,34560816,34560861,34560856,34560857,34560858,34561180,34560848,34561181,34561182,34561183,34561184,34561185,34561186,34561187,34561188,34561189,34561190,34560849,34561191,34561192,34561193,34561194,34561195,34561196,34561197,34561198,34561199,34561200,34560850,34560862,34560863,34560867,34560868,34560869,34560870,34560817,34560871,34560855,34560852,34560853,34560854,34560866,34560880,34560898,34560899,34560883,34560884,34560896,34560897,34560878,34560879,34560900,34560819,34560891,34560892,34560893,34560818,34560881,34560882,34560904,34560886,34560887,34560888,34560889,34560890,34560894,34560895,34560820,34560901,34560902,34560903,34560905,34560906,34560907,34560908,34560910,34560885,34560909) and "PARAM_KEY" is not null order  len(1040)
2018/09/17 10:18:49.878 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "PART_ID", "PART_KEY_VAL" from "PARTITION_KEY_VALS" where "PART_ID" in (34560876,34560877,34560864,34560865,34560874,34560875,34560859,34560860,34561201,34561202,34561203,34561204,34561205,34561206,34561207,34561208,34561209,34561210,34560815,34560851,34560872,34560873,34560816,34560861,34560856,34560857,34560858,34561180,34560848,34561181,34561182,34561183,34561184,34561185,34561186,34561187,34561188,34561189,34561190,34560849,34561191,34561192,34561193,34561194,34561195,34561196,34561197,34561198,34561199,34561200,34560850,34560862,34560863,34560867,34560868,34560869,34560870,34560817,34560871,34560855,34560852,34560853,34560854,34560866,34560880,34560898,34560899,34560883,34560884,34560896,34560897,34560878,34560879,34560900,34560819,34560891,34560892,34560893,34560818,34560881,34560882,34560904,34560886,34560887,34560888,34560889,34560890,34560894,34560895,34560820,34560901,34560902,34560903,34560905,34560906,34560907,34560908,34560910,34560885,34560909) and "INTEGER_IDX" >= 0 order by "PART_ID" as len(1044)
2018/09/17 10:18:49.942 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "SERDE_ID", "PARAM_KEY", "PARAM_VALUE" from "SERDE_PARAMS" where "SERDE_ID" in (34406876,34406544,34406877,34406878,34406879,34406880,34406881,34406882,34406883,34406884,34406885,34406886,34406545,34406887,34406888,34406889,34406890,34406891,34406892,34406893,34406894,34406895,34406896,34406546,34406897,34406898,34406899,34406900,34406901,34406902,34406903,34406904,34406905,34406906,34406511,34406547,34406548,34406549,34406550,34406551,34406552,34406553,34406554,34406555,34406556,34406512,34406557,34406558,34406559,34406560,34406561,34406562,34406563,34406564,34406565,34406566,34406513,34406567,34406568,34406569,34406570,34406571,34406572,34406573,34406574,34406575,34406576,34406514,34406577,34406578,34406579,34406580,34406581,34406582,34406583,34406584,34406585,34406586,34406515,34406587,34406588,34406589,34406590,34406591,34406592,34406593,34406594,34406595,34406596,34406516,34406597,34406598,34406599,34406600,34406601,34406602,34406603,34406604,34406605,34406606) and "PARAM_KEY" is not null order by len(1039)
2018/09/17 10:18:49.959 set.go:180: [info] con:3342031 autocommit=1
2018/09/17 10:18:49.959 set.go:180: [info] con:3342031 tx_read_only=0
2018/09/17 10:18:49.959 set.go:180: [info] con:3342031 transaction_read_only=0
2018/09/17 10:18:49.975 set.go:180: [info] con:3342030 autocommit=0
2018/09/17 10:18:49.977 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS `DN_TYPE`,`A0`.`CREATE_TIME`,`A0`.`LAST_ACCESS_TIME`,`A0`.`OWNER`,`A0`.`RETENTION`,`A0`.`TBL_NAME`,`A0`.`TBL_TYPE`,`A0`.`TBL_ID` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` WHERE `A0`.`TBL_NAME` = 'table_tag_t100_p400_c100_1535622485748910166' AND `B0`.`NAME` = 'test_tidb_4'
2018/09/17 10:18:49.983 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`DESC`,`B0`.`DB_LOCATION_URI`,`B0`.`NAME`,`B0`.`OWNER_NAME`,`B0`.`OWNER_TYPE`,`B0`.`DB_ID`,`C0`.`INPUT_FORMAT`,`C0`.`IS_COMPRESSED`,`C0`.`IS_STOREDASSUBDIRECTORIES`,`C0`.`LOCATION`,`C0`.`NUM_BUCKETS`,`C0`.`OUTPUT_FORMAT`,`C0`.`SD_ID`,`A0`.`VIEW_EXPANDED_TEXT`,`A0`.`VIEW_ORIGINAL_TEXT` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` LEFT OUTER JOIN `SDS` `C0` ON `A0`.`SD_ID` = `C0`.`SD_ID` WHERE `A0`.`TBL_ID` = 44446
2018/09/17 10:18:49.997 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`CD_ID` FROM `SDS` `A0` LEFT OUTER JOIN `CDS` `B0` ON `A0`.`CD_ID` = `B0`.`CD_ID` WHERE `A0`.`SD_ID` = 34498396
2018/09/17 10:18:50.016 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`NAME`,`B0`.`SLIB`,`B0`.`SERDE_ID` FROM `SDS` `A0` LEFT OUTER JOIN `SERDES` `B0` ON `A0`.`SERDE_ID` = `B0`.`SERDE_ID` WHERE `A0`.`SD_ID` = 34498396
2018/09/17 10:18:50.020 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `A0`.`PARAM_KEY`,`A0`.`PARAM_VALUE` FROM `SERDE_PARAMS` `A0` WHERE `A0`.`SERDE_ID` = 34406506 AND `A0`.`PARAM_KEY` IS NOT NULL
2018/09/17 10:18:50.049 set.go:180: [info] con:3342030 autocommit=1
2018/09/17 10:18:50.050 set.go:180: [info] con:3342030 tx_read_only=0
2018/09/17 10:18:50.050 set.go:180: [info] con:3342030 transaction_read_only=0
2018/09/17 10:18:50.120 set.go:180: [info] con:3342031 autocommit=0
2018/09/17 10:18:50.122 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS `DN_TYPE`,`A0`.`CREATE_TIME`,`A0`.`LAST_ACCESS_TIME`,`A0`.`OWNER`,`A0`.`RETENTION`,`A0`.`TBL_NAME`,`A0`.`TBL_TYPE`,`A0`.`TBL_ID` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` WHERE `A0`.`TBL_NAME` = 'table_tag_t100_p400_c100_1535622485748910166' AND `B0`.`NAME` = 'test_tidb_4'
2018/09/17 10:18:50.128 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`DESC`,`B0`.`DB_LOCATION_URI`,`B0`.`NAME`,`B0`.`OWNER_NAME`,`B0`.`OWNER_TYPE`,`B0`.`DB_ID`,`C0`.`INPUT_FORMAT`,`C0`.`IS_COMPRESSED`,`C0`.`IS_STOREDASSUBDIRECTORIES`,`C0`.`LOCATION`,`C0`.`NUM_BUCKETS`,`C0`.`OUTPUT_FORMAT`,`C0`.`SD_ID`,`A0`.`VIEW_EXPANDED_TEXT`,`A0`.`VIEW_ORIGINAL_TEXT` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` LEFT OUTER JOIN `SDS` `C0` ON `A0`.`SD_ID` = `C0`.`SD_ID` WHERE `A0`.`TBL_ID` = 44446
2018/09/17 10:18:50.142 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`CD_ID` FROM `SDS` `A0` LEFT OUTER JOIN `CDS` `B0` ON `A0`.`CD_ID` = `B0`.`CD_ID` WHERE `A0`.`SD_ID` = 34498396
2018/09/17 10:18:50.160 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `B0`.`NAME`,`B0`.`SLIB`,`B0`.`SERDE_ID` FROM `SDS` `A0` LEFT OUTER JOIN `SERDES` `B0` ON `A0`.`SERDE_ID` = `B0`.`SERDE_ID` WHERE `A0`.`SD_ID` = 34498396
2018/09/17 10:18:50.164 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT `A0`.`PARAM_KEY`,`A0`.`PARAM_VALUE` FROM `SERDE_PARAMS` `A0` WHERE `A0`.`SERDE_ID` = 34406506 AND `A0`.`PARAM_KEY` IS NOT NULL
2018/09/17 10:18:50.201 compiler.go:78: [warning] [EXPENSIVE_QUERY] SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS `DN_TYPE`,`A0`.`CREATE_TIME`,`A0`.`LAST_ACCESS_TIME`,`A0`.`OWNER`,`A0`.`RETENTION`,`A0`.`TBL_NAME`,`A0`.`TBL_TYPE`,`A0`.`TBL_ID` FROM `TBLS` `A0` LEFT OUTER JOIN `DBS` `B0` ON `A0`.`DB_ID` = `B0`.`DB_ID` WHERE `A0`.`TBL_NAME` = 'table_tag_t100_p400_c100_1535622485748910166' AND `B0`.`NAME` = 'test_tidb_4'
2018/09/17 10:18:50.207 compiler.go:78: [warning] [EXPENSIVE_QUERY] select TBL_ID from TBLS inner join DBS on TBLS.DB_ID = DBS.DB_ID where TBLS.TBL_NAME = 'table_tag_t100_p400_c100_1535622485748910166' and DBS.NAME = 'test_tidb_4'
2018/09/17 10:18:50.211 set.go:180: [info] con:3342031 sql_select_limit=300
2018/09/17 10:18:50.211 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PARTITIONS.PART_ID from PARTITIONS  where PARTITIONS.TBL_ID = 44446 order by PART_NAME asc
2018/09/17 10:18:50.224 set.go:180: [info] con:3342031 sql_select_limit=18446744073709551615
2018/09/17 10:18:50.229 compiler.go:78: [warning] [EXPENSIVE_QUERY] select /*+ TIDB_INLJ(PARTITIONS, SDS) */ "PARTITIONS"."PART_ID", "SDS"."SD_ID", "SDS"."CD_ID", "SDS"."SERDE_ID", "PARTITIONS"."CREATE_TIME", "PARTITIONS"."LAST_ACCESS_TIME", "SDS"."INPUT_FORMAT", "SDS"."IS_COMPRESSED", "SDS"."IS_STOREDASSUBDIRECTORIES", "SDS"."LOCATION", "SDS"."NUM_BUCKETS", "SDS"."OUTPUT_FORMAT" from "PARTITIONS"  left outer join "SDS" on "PARTITIONS"."SD_ID" = "SDS"."SD_ID" where "PART_ID" in (34560811,34560812,34560821,34560911,34560912,34560913,34560914,34560915,34560916,34560917,34560918,34560919,34560920,34560822,34560921,34560922,34560923,34560924,34560925,34560926,34560927,34560928,34560929,34560930,34560823,34560931,34560932,34560933,34560934,34560935,34560936,34560937,34560938,34560939,34560940,34560824,34560941,34560942,34560943,34560944,34560945,34560946,34560947,34560948,34560949,34560950,34560825,34560951,34560952,34560953,34560954,34560955,34560956,34560957,34560958,34560959,34560960,34560826,34560961,34560962,34560963,34560964,34560965,34560966,34560967,34560968,34560969,34560 len(3141)
2018/09/17 10:18:50.256 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "SERDES"."NAME", "SERDES"."SLIB" from "SERDES" where "SERDE_ID" in (34406507,34406508,34406517,34406607,34406608,34406609,34406610,34406611,34406612,34406613,34406614,34406615,34406616,34406518,34406617,34406618,34406619,34406620,34406621,34406622,34406623,34406624,34406625,34406626,34406519,34406627,34406628,34406629,34406630,34406631,34406632,34406633,34406634,34406635,34406636,34406520,34406637,34406638,34406639,34406640,34406641,34406642,34406643,34406644,34406645,34406646,34406521,34406647,34406648,34406649,34406650,34406651,34406652,34406653,34406654,34406655,34406656,34406522,34406657,34406658,34406659,34406660,34406661,34406662,34406663,34406664,34406665,34406666,34406523,34406667,34406668,34406669,34406670,34406671,34406672,34406673,34406674,34406675,34406676,34406524,34406677,34406678,34406679,34406680,34406681,34406682,34406683,34406684,34406685,34406686,34406525,34406687,34406688,34406689,34406690,34406691,34406692,34406693,34406694,34406695,34406696,34406526,34406697,34406698,34406699,3440 len(2775)
2018/09/17 10:18:50.277 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "PART_ID", "PARAM_KEY", "PARAM_VALUE" from "PARTITION_PARAMS" where "PART_ID" in (34560811,34560812,34560821,34560911,34560912,34560913,34560914,34560915,34560916,34560917,34560918,34560919,34560920,34560822,34560921,34560922,34560923,34560924,34560925,34560926,34560927,34560928,34560929,34560930,34560823,34560931,34560932,34560933,34560934,34560935,34560936,34560937,34560938,34560939,34560940,34560824,34560941,34560942,34560943,34560944,34560945,34560946,34560947,34560948,34560949,34560950,34560825,34560951,34560952,34560953,34560954,34560955,34560956,34560957,34560958,34560959,34560960,34560826,34560961,34560962,34560963,34560964,34560965,34560966,34560967,34560968,34560969,34560970,34560827,34560971,34560972,34560973,34560974,34560975,34560976,34560977,34560978,34560979,34560980,34560828,34560981,34560982,34560983,34560984,34560985,34560986,34560987,34560988,34560989,34560990,34560829,34560991,34560992,34560993,34560994,34560995,34560996,34560997,34560998,34560999,34561000,34560830,34561001,34561002 len(2840)
2018/09/17 10:18:50.309 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "PART_ID", "PART_KEY_VAL" from "PARTITION_KEY_VALS" where "PART_ID" in (34560811,34560812,34560821,34560911,34560912,34560913,34560914,34560915,34560916,34560917,34560918,34560919,34560920,34560822,34560921,34560922,34560923,34560924,34560925,34560926,34560927,34560928,34560929,34560930,34560823,34560931,34560932,34560933,34560934,34560935,34560936,34560937,34560938,34560939,34560940,34560824,34560941,34560942,34560943,34560944,34560945,34560946,34560947,34560948,34560949,34560950,34560825,34560951,34560952,34560953,34560954,34560955,34560956,34560957,34560958,34560959,34560960,34560826,34560961,34560962,34560963,34560964,34560965,34560966,34560967,34560968,34560969,34560970,34560827,34560971,34560972,34560973,34560974,34560975,34560976,34560977,34560978,34560979,34560980,34560828,34560981,34560982,34560983,34560984,34560985,34560986,34560987,34560988,34560989,34560990,34560829,34560991,34560992,34560993,34560994,34560995,34560996,34560997,34560998,34560999,34561000,34560830,34561001,34561002,34561003, len(2844)
2018/09/17 10:18:50.444 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "SERDE_ID", "PARAM_KEY", "PARAM_VALUE" from "SERDE_PARAMS" where "SERDE_ID" in (34406507,34406508,34406517,34406607,34406608,34406609,34406610,34406611,34406612,34406613,34406614,34406615,34406616,34406518,34406617,34406618,34406619,34406620,34406621,34406622,34406623,34406624,34406625,34406626,34406519,34406627,34406628,34406629,34406630,34406631,34406632,34406633,34406634,34406635,34406636,34406520,34406637,34406638,34406639,34406640,34406641,34406642,34406643,34406644,34406645,34406646,34406521,34406647,34406648,34406649,34406650,34406651,34406652,34406653,34406654,34406655,34406656,34406522,34406657,34406658,34406659,34406660,34406661,34406662,34406663,34406664,34406665,34406666,34406523,34406667,34406668,34406669,34406670,34406671,34406672,34406673,34406674,34406675,34406676,34406524,34406677,34406678,34406679,34406680,34406681,34406682,34406683,34406684,34406685,34406686,34406525,34406687,34406688,34406689,34406690,34406691,34406692,34406693,34406694,34406695,34406696,34406526,34406697,34406698,3 len(2839)
2018/09/17 10:18:50.476 compiler.go:78: [warning] [EXPENSIVE_QUERY] select TBL_ID from TBLS inner join DBS on TBLS.DB_ID = DBS.DB_ID where TBLS.TBL_NAME = 'table_tag_t100_p400_c100_1535622485748910166' and DBS.NAME = 'test_tidb_4'
2018/09/17 10:18:50.484 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PARTITIONS.PART_ID from PARTITIONS where PARTITIONS.TBL_ID = 44446 and PARTITIONS.PART_NAME in ('p1=0/p2=0','p1=1/p2=1','p1=10/p2=10','p1=100/p2=100','p1=101/p2=101','p1=102/p2=102','p1=103/p2=103','p1=104/p2=104','p1=105/p2=105','p1=106/p2=106','p1=107/p2=107','p1=108/p2=108','p1=109/p2=109','p1=11/p2=11','p1=110/p2=110','p1=111/p2=111','p1=112/p2=112','p1=113/p2=113','p1=114/p2=114','p1=115/p2=115','p1=116/p2=116','p1=117/p2=117','p1=118/p2=118','p1=119/p2=119','p1=12/p2=12','p1=120/p2=120','p1=121/p2=121','p1=122/p2=122','p1=123/p2=123','p1=124/p2=124','p1=125/p2=125','p1=126/p2=126','p1=127/p2=127','p1=128/p2=128','p1=129/p2=129','p1=13/p2=13','p1=130/p2=130','p1=131/p2=131','p1=132/p2=132','p1=133/p2=133','p1=134/p2=134','p1=135/p2=135','p1=136/p2=136','p1=137/p2=137','p1=138/p2=138','p1=139/p2=139','p1=14/p2=14','p1=140/p2=140','p1=141/p2=141','p1=142/p2=142','p1=143/p2=143','p1=144/p2=144','p1=145/p2=145','p1=146/p2=146','p1=147/p2=147','p1=148/p2=148','p1=149/p2=149','p1=15/p2=15','p1=150/p2=15 len(4833)
2018/09/17 10:18:50.535 compiler.go:78: [warning] [EXPENSIVE_QUERY] select TBL_ID from TBLS inner join DBS on TBLS.DB_ID = DBS.DB_ID where TBLS.TBL_NAME = 'table_tag_t100_p400_c100_1535622485748910166' and DBS.NAME = 'test_tidb_4'
2018/09/17 10:18:50.543 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PARTITIONS.PART_ID from PARTITIONS where PARTITIONS.TBL_ID = 44446 and PARTITIONS.PART_NAME in ('p1=0/p2=0','p1=1/p2=1','p1=10/p2=10','p1=100/p2=100','p1=101/p2=101','p1=102/p2=102','p1=103/p2=103','p1=104/p2=104','p1=105/p2=105','p1=106/p2=106','p1=107/p2=107','p1=108/p2=108','p1=109/p2=109','p1=11/p2=11','p1=110/p2=110','p1=111/p2=111','p1=112/p2=112','p1=113/p2=113','p1=114/p2=114','p1=115/p2=115','p1=116/p2=116','p1=117/p2=117','p1=118/p2=118','p1=119/p2=119','p1=12/p2=12','p1=120/p2=120','p1=121/p2=121','p1=122/p2=122','p1=123/p2=123','p1=124/p2=124','p1=125/p2=125','p1=126/p2=126','p1=127/p2=127','p1=128/p2=128','p1=129/p2=129','p1=13/p2=13','p1=130/p2=130','p1=131/p2=131','p1=132/p2=132','p1=133/p2=133','p1=134/p2=134','p1=135/p2=135','p1=136/p2=136','p1=137/p2=137','p1=138/p2=138','p1=139/p2=139','p1=14/p2=14','p1=140/p2=140','p1=141/p2=141','p1=142/p2=142','p1=143/p2=143','p1=144/p2=144','p1=145/p2=145','p1=146/p2=146','p1=147/p2=147','p1=148/p2=148','p1=149/p2=149','p1=15/p2=15','p1=150/p2=15 len(4833)
2018/09/17 10:18:50.573 compiler.go:78: [warning] [EXPENSIVE_QUERY] select TBL_ID from TBLS inner join DBS on TBLS.DB_ID = DBS.DB_ID where TBLS.TBL_NAME = 'table_tag_t100_p400_c100_1535622485748910166' and DBS.NAME = 'test_tidb_4'
2018/09/17 10:18:50.581 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PARTITIONS.SD_ID from PARTITIONS where PARTITIONS.TBL_ID = 44446 and PARTITIONS.PART_NAME in ('p1=0/p2=0','p1=1/p2=1','p1=10/p2=10','p1=100/p2=100','p1=101/p2=101','p1=102/p2=102','p1=103/p2=103','p1=104/p2=104','p1=105/p2=105','p1=106/p2=106','p1=107/p2=107','p1=108/p2=108','p1=109/p2=109','p1=11/p2=11','p1=110/p2=110','p1=111/p2=111','p1=112/p2=112','p1=113/p2=113','p1=114/p2=114','p1=115/p2=115','p1=116/p2=116','p1=117/p2=117','p1=118/p2=118','p1=119/p2=119','p1=12/p2=12','p1=120/p2=120','p1=121/p2=121','p1=122/p2=122','p1=123/p2=123','p1=124/p2=124','p1=125/p2=125','p1=126/p2=126','p1=127/p2=127','p1=128/p2=128','p1=129/p2=129','p1=13/p2=13','p1=130/p2=130','p1=131/p2=131','p1=132/p2=132','p1=133/p2=133','p1=134/p2=134','p1=135/p2=135','p1=136/p2=136','p1=137/p2=137','p1=138/p2=138','p1=139/p2=139','p1=14/p2=14','p1=140/p2=140','p1=141/p2=141','p1=142/p2=142','p1=143/p2=143','p1=144/p2=144','p1=145/p2=145','p1=146/p2=146','p1=147/p2=147','p1=148/p2=148','p1=149/p2=149','p1=15/p2=15','p1=150/p2=150' len(4831)
2018/09/17 10:18:50.593 compiler.go:78: [warning] [EXPENSIVE_QUERY] select CD_ID from SDS where SD_ID in (34498397,34498398,34498399,34498400,34498407,34498408,34498409,34498410,34498411,34498412,34498413,34498414,34498415,34498416,34498417,34498418,34498419,34498420,34498421,34498422,34498423,34498424,34498425,34498426,34498427,34498428,34498429,34498430,34498431,34498432,34498433,34498497,34498498,34498499,34498500,34498501,34498502,34498503,34498504,34498505,34498506,34498507,34498508,34498509,34498510,34498511,34498512,34498513,34498514,34498515,34498516,34498517,34498518,34498519,34498520,34498521,34498522,34498523,34498524,34498525,34498526,34498527,34498528,34498529,34498530,34498531,34498532,34498533,34498534,34498535,34498536,34498537,34498538,34498539,34498540,34498541,34498542,34498543,34498544,34498545,34498546,34498547,34498548,34498549,34498550,34498551,34498552,34498553,34498554,34498555,34498556,34498557,34498558,34498559,34498560,34498561,34498562,34498563,34498564,34498565,34498566,34498567,34498568,34498569,34498570,34498571,34498572,34498573,34498574,34498 len(2738)
2018/09/17 10:18:50.645 compiler.go:78: [warning] [EXPENSIVE_QUERY] select count(1) from SDS where CD_ID = 58102
2018/09/17 10:18:50.669 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PARTITIONS.PART_ID from PARTITIONS where PARTITIONS.TBL_ID = 44446 and PARTITIONS.PART_NAME in ('p1=0/p2=0','p1=1/p2=1','p1=10/p2=10','p1=100/p2=100','p1=101/p2=101','p1=102/p2=102','p1=103/p2=103','p1=104/p2=104','p1=105/p2=105','p1=106/p2=106','p1=107/p2=107','p1=108/p2=108','p1=109/p2=109','p1=11/p2=11','p1=110/p2=110','p1=111/p2=111','p1=112/p2=112','p1=113/p2=113','p1=114/p2=114','p1=115/p2=115','p1=116/p2=116','p1=117/p2=117','p1=118/p2=118','p1=119/p2=119','p1=12/p2=12','p1=120/p2=120','p1=121/p2=121','p1=122/p2=122','p1=123/p2=123','p1=124/p2=124','p1=125/p2=125','p1=126/p2=126','p1=127/p2=127','p1=128/p2=128','p1=129/p2=129','p1=13/p2=13','p1=130/p2=130','p1=131/p2=131','p1=132/p2=132','p1=133/p2=133','p1=134/p2=134','p1=135/p2=135','p1=136/p2=136','p1=137/p2=137','p1=138/p2=138','p1=139/p2=139','p1=14/p2=14','p1=140/p2=140','p1=141/p2=141','p1=142/p2=142','p1=143/p2=143','p1=144/p2=144','p1=145/p2=145','p1=146/p2=146','p1=147/p2=147','p1=148/p2=148','p1=149/p2=149','p1=15/p2=15','p1=150/p2=15 len(4833)
2018/09/17 10:18:50.679 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PARTITIONS.SD_ID from PARTITIONS where PARTITIONS.TBL_ID = 44446 and PARTITIONS.PART_NAME in ('p1=0/p2=0','p1=1/p2=1','p1=10/p2=10','p1=100/p2=100','p1=101/p2=101','p1=102/p2=102','p1=103/p2=103','p1=104/p2=104','p1=105/p2=105','p1=106/p2=106','p1=107/p2=107','p1=108/p2=108','p1=109/p2=109','p1=11/p2=11','p1=110/p2=110','p1=111/p2=111','p1=112/p2=112','p1=113/p2=113','p1=114/p2=114','p1=115/p2=115','p1=116/p2=116','p1=117/p2=117','p1=118/p2=118','p1=119/p2=119','p1=12/p2=12','p1=120/p2=120','p1=121/p2=121','p1=122/p2=122','p1=123/p2=123','p1=124/p2=124','p1=125/p2=125','p1=126/p2=126','p1=127/p2=127','p1=128/p2=128','p1=129/p2=129','p1=13/p2=13','p1=130/p2=130','p1=131/p2=131','p1=132/p2=132','p1=133/p2=133','p1=134/p2=134','p1=135/p2=135','p1=136/p2=136','p1=137/p2=137','p1=138/p2=138','p1=139/p2=139','p1=14/p2=14','p1=140/p2=140','p1=141/p2=141','p1=142/p2=142','p1=143/p2=143','p1=144/p2=144','p1=145/p2=145','p1=146/p2=146','p1=147/p2=147','p1=148/p2=148','p1=149/p2=149','p1=15/p2=15','p1=150/p2=150' len(4831)
2018/09/17 10:18:50.693 compiler.go:78: [warning] [EXPENSIVE_QUERY] select SERDE_ID from SDS where SD_ID in (34498397,34498398,34498399,34498400,34498407,34498408,34498409,34498410,34498411,34498412,34498413,34498414,34498415,34498416,34498417,34498418,34498419,34498420,34498421,34498422,34498423,34498424,34498425,34498426,34498427,34498428,34498429,34498430,34498431,34498432,34498433,34498497,34498498,34498499,34498500,34498501,34498502,34498503,34498504,34498505,34498506,34498507,34498508,34498509,34498510,34498511,34498512,34498513,34498514,34498515,34498516,34498517,34498518,34498519,34498520,34498521,34498522,34498523,34498524,34498525,34498526,34498527,34498528,34498529,34498530,34498531,34498532,34498533,34498534,34498535,34498536,34498537,34498538,34498539,34498540,34498541,34498542,34498543,34498544,34498545,34498546,34498547,34498548,34498549,34498550,34498551,34498552,34498553,34498554,34498555,34498556,34498557,34498558,34498559,34498560,34498561,34498562,34498563,34498564,34498565,34498566,34498567,34498568,34498569,34498570,34498571,34498572,34498573,34498574,34 len(2741)
2018/09/17 10:18:50.716 compiler.go:78: [warning] [EXPENSIVE_QUERY] delete from SERDE_PARAMS where SERDE_ID in (34406507,34406508,34406509,34406510,34406517,34406518,34406519,34406520,34406521,34406522,34406523,34406524,34406525,34406526,34406527,34406528,34406529,34406530,34406531,34406532,34406533,34406534,34406535,34406536,34406537,34406538,34406539,34406540,34406541,34406542,34406543,34406607,34406608,34406609,34406610,34406611,34406612,34406613,34406614,34406615,34406616,34406617,34406618,34406619,34406620,34406621,34406622,34406623,34406624,34406625,34406626,34406627,34406628,34406629,34406630,34406631,34406632,34406633,34406634,34406635,34406636,34406637,34406638,34406639,34406640,34406641,34406642,34406643,34406644,34406645,34406646,34406647,34406648,34406649,34406650,34406651,34406652,34406653,34406654,34406655,34406656,34406657,34406658,34406659,34406660,34406661,34406662,34406663,34406664,34406665,34406666,34406667,34406668,34406669,34406670,34406671,34406672,34406673,34406674,34406675,34406676,34406677,34406678,34406679,34406680,34406681,34406682,34406683,34406684 len(2744)
2018/09/17 10:18:50.761 compiler.go:78: [warning] [EXPENSIVE_QUERY] delete from SERDES where SERDE_ID in (34406507,34406508,34406509,34406510,34406517,34406518,34406519,34406520,34406521,34406522,34406523,34406524,34406525,34406526,34406527,34406528,34406529,34406530,34406531,34406532,34406533,34406534,34406535,34406536,34406537,34406538,34406539,34406540,34406541,34406542,34406543,34406607,34406608,34406609,34406610,34406611,34406612,34406613,34406614,34406615,34406616,34406617,34406618,34406619,34406620,34406621,34406622,34406623,34406624,34406625,34406626,34406627,34406628,34406629,34406630,34406631,34406632,34406633,34406634,34406635,34406636,34406637,34406638,34406639,34406640,34406641,34406642,34406643,34406644,34406645,34406646,34406647,34406648,34406649,34406650,34406651,34406652,34406653,34406654,34406655,34406656,34406657,34406658,34406659,34406660,34406661,34406662,34406663,34406664,34406665,34406666,34406667,34406668,34406669,34406670,34406671,34406672,34406673,34406674,34406675,34406676,34406677,34406678,34406679,34406680,34406681,34406682,34406683,34406684,34406 len(2738)
2018/09/17 10:18:50.947 compiler.go:78: [warning] [EXPENSIVE_QUERY] delete from SDS where SD_ID in (34498397,34498398,34498399,34498400,34498407,34498408,34498409,34498410,34498411,34498412,34498413,34498414,34498415,34498416,34498417,34498418,34498419,34498420,34498421,34498422,34498423,34498424,34498425,34498426,34498427,34498428,34498429,34498430,34498431,34498432,34498433,34498497,34498498,34498499,34498500,34498501,34498502,34498503,34498504,34498505,34498506,34498507,34498508,34498509,34498510,34498511,34498512,34498513,34498514,34498515,34498516,34498517,34498518,34498519,34498520,34498521,34498522,34498523,34498524,34498525,34498526,34498527,34498528,34498529,34498530,34498531,34498532,34498533,34498534,34498535,34498536,34498537,34498538,34498539,34498540,34498541,34498542,34498543,34498544,34498545,34498546,34498547,34498548,34498549,34498550,34498551,34498552,34498553,34498554,34498555,34498556,34498557,34498558,34498559,34498560,34498561,34498562,34498563,34498564,34498565,34498566,34498567,34498568,34498569,34498570,34498571,34498572,34498573,34498574,34498575,34 len(2732)
2018/09/17 10:18:50.980 compiler.go:78: [warning] [EXPENSIVE_QUERY] delete from PARTITION_KEY_VALS where PART_ID in (34561178,34561179,34561087,34561088,34561089,34561090,34560839,34561091,34561092,34561093,34561094,34561095,34561096,34561097,34561098,34561099,34561100,34560840,34561101,34561102,34561103,34561104,34561105,34561106,34561107,34561108,34561109,34561110,34560814,34560934,34560935,34560936,34560937,34560938,34560939,34560940,34560824,34560941,34560942,34560943,34560944,34560945,34560946,34561072,34561073,34561074,34561075,34561076,34561077,34561078,34561079,34561080,34560838,34561081,34561082,34561083,34561084,34561085,34561086,34561140,34560844,34561141,34561142,34561143,34561144,34561145,34561146,34561147,34561148,34561149,34561150,34560845,34561151,34561152,34561153,34561154,34561027,34561028,34561029,34561030,34560833,34561031,34561032,34561033,34561034,34561035,34561036,34561037,34561038,34561039,34561040,34560834,34561041,34560947,34560948,34560949,34560950,34560825,34560951,34560952,34560953,34560954,34560955,34560956,34560957,34560958,34560959,34560960,345 len(2749)
2018/09/17 10:18:51.032 compiler.go:78: [warning] [EXPENSIVE_QUERY] delete from PARTITION_PARAMS where PART_ID in (34561178,34561179,34561087,34561088,34561089,34561090,34560839,34561091,34561092,34561093,34561094,34561095,34561096,34561097,34561098,34561099,34561100,34560840,34561101,34561102,34561103,34561104,34561105,34561106,34561107,34561108,34561109,34561110,34560814,34560934,34560935,34560936,34560937,34560938,34560939,34560940,34560824,34560941,34560942,34560943,34560944,34560945,34560946,34561072,34561073,34561074,34561075,34561076,34561077,34561078,34561079,34561080,34560838,34561081,34561082,34561083,34561084,34561085,34561086,34561140,34560844,34561141,34561142,34561143,34561144,34561145,34561146,34561147,34561148,34561149,34561150,34560845,34561151,34561152,34561153,34561154,34561027,34561028,34561029,34561030,34560833,34561031,34561032,34561033,34561034,34561035,34561036,34561037,34561038,34561039,34561040,34560834,34561041,34560947,34560948,34560949,34560950,34560825,34560951,34560952,34560953,34560954,34560955,34560956,34560957,34560958,34560959,34560960,34560 len(2747)
2018/09/17 10:18:51.065 compiler.go:78: [warning] [EXPENSIVE_QUERY] delete from PARTITIONS where PART_ID in (34561178,34561179,34561087,34561088,34561089,34561090,34560839,34561091,34561092,34561093,34561094,34561095,34561096,34561097,34561098,34561099,34561100,34560840,34561101,34561102,34561103,34561104,34561105,34561106,34561107,34561108,34561109,34561110,34560814,34560934,34560935,34560936,34560937,34560938,34560939,34560940,34560824,34560941,34560942,34560943,34560944,34560945,34560946,34561072,34561073,34561074,34561075,34561076,34561077,34561078,34561079,34561080,34560838,34561081,34561082,34561083,34561084,34561085,34561086,34561140,34560844,34561141,34561142,34561143,34561144,34561145,34561146,34561147,34561148,34561149,34561150,34560845,34561151,34561152,34561153,34561154,34561027,34561028,34561029,34561030,34560833,34561031,34561032,34561033,34561034,34561035,34561036,34561037,34561038,34561039,34561040,34560834,34561041,34560947,34560948,34560949,34560950,34560825,34560951,34560952,34560953,34560954,34560955,34560956,34560957,34560958,34560959,34560960,34560826,34 len(2741)
2018/09/17 10:18:51.095 set.go:180: [info] con:3342031 sql_select_limit=300
2018/09/17 10:18:51.095 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PARTITIONS.PART_ID from PARTITIONS  where PARTITIONS.TBL_ID = 44446 order by PART_NAME asc
2018/09/17 10:18:51.108 set.go:180: [info] con:3342031 sql_select_limit=18446744073709551615
2018/09/17 10:18:51.110 compiler.go:78: [warning] [EXPENSIVE_QUERY] select /*+ TIDB_INLJ(PARTITIONS, SDS) */ "PARTITIONS"."PART_ID", "SDS"."SD_ID", "SDS"."CD_ID", "SDS"."SERDE_ID", "PARTITIONS"."CREATE_TIME", "PARTITIONS"."LAST_ACCESS_TIME", "SDS"."INPUT_FORMAT", "SDS"."IS_COMPRESSED", "SDS"."IS_STOREDASSUBDIRECTORIES", "SDS"."LOCATION", "SDS"."NUM_BUCKETS", "SDS"."OUTPUT_FORMAT" from "PARTITIONS"  left outer join "SDS" on "PARTITIONS"."SD_ID" = "SDS"."SD_ID" where "PART_ID" in (34561180,34560848,34561181,34561182,34561183,34561184,34561185,34561186,34561187,34561188,34561189,34561190,34560849,34561191,34561192,34561193,34561194,34561195,34561196,34561197,34561198,34561199,34561200,34560850,34561201,34561202,34561203,34561204,34561205,34561206,34561207,34561208,34561209,34561210,34560815,34560851,34560852,34560853,34560854,34560855,34560856,34560857,34560858,34560859,34560860,34560816,34560861,34560862,34560863,34560864,34560865,34560866,34560867,34560868,34560869,34560870,34560817,34560871,34560872,34560873,34560874,34560875,34560876,34560877,34560878,34560879,34560880,34560 len(1341)
2018/09/17 10:18:51.804 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:613.241226ms txn_start_ts:402954840985567235 region_id:492 store_addr:10.20.94.3:20160 kv_process_ms:430
2018/09/17 10:18:52.552 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.360906416s txn_start_ts:402954840985567235 region_id:540 store_addr:10.20.94.5:20160 kv_process_ms:788
2018/09/17 10:18:52.553 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.362185984s txn_start_ts:402954840985567235 region_id:512 store_addr:10.20.94.5:20160 kv_process_ms:819
2018/09/17 10:18:52.559 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.368031544s txn_start_ts:402954840985567235 region_id:532 store_addr:10.20.94.5:20160 kv_process_ms:817
2018/09/17 10:18:52.764 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.573329471s txn_start_ts:402954840985567235 region_id:516 store_addr:10.20.94.3:20160 kv_process_ms:743
2018/09/17 10:18:52.833 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.641962217s txn_start_ts:402954840985567235 region_id:568 store_addr:10.20.94.4:20160 kv_process_ms:769
2018/09/17 10:18:52.931 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.740102772s txn_start_ts:402954840985567235 region_id:548 store_addr:10.20.94.4:20160 kv_process_ms:750
2018/09/17 10:18:52.950 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.758708635s txn_start_ts:402954840985567235 region_id:556 store_addr:10.20.94.3:20160 kv_process_ms:782
2018/09/17 10:18:52.983 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.791604076s txn_start_ts:402954840985567235 region_id:560 store_addr:10.20.94.4:20160 kv_process_ms:810
2018/09/17 10:18:53.014 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.822970956s txn_start_ts:402954840985567235 region_id:576 store_addr:10.20.94.4:20160 kv_process_ms:834
2018/09/17 10:18:53.018 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.792103763s txn_start_ts:402954840985567235 region_id:520 store_addr:10.20.94.4:20160 kv_process_ms:742
2018/09/17 10:18:53.037 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.845703147s txn_start_ts:402954840985567235 region_id:496 store_addr:10.20.94.4:20160 kv_process_ms:789
2018/09/17 10:18:53.068 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.877345633s txn_start_ts:402954840985567235 region_id:504 store_addr:10.20.94.3:20160 kv_process_ms:743
2018/09/17 10:18:53.089 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.284689599s txn_start_ts:402954840985567235 region_id:584 store_addr:10.20.94.4:20160 kv_process_ms:905
2018/09/17 10:18:53.096 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.9047361s txn_start_ts:402954840985567235 region_id:588 store_addr:10.20.94.3:20160 kv_process_ms:765
2018/09/17 10:18:53.121 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.929992591s txn_start_ts:402954840985567235 region_id:544 store_addr:10.20.94.3:20160 kv_process_ms:781
2018/09/17 10:18:53.554 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:994.683729ms txn_start_ts:402954840985567235 region_id:528 store_addr:10.20.94.3:20160 kv_process_ms:726
2018/09/17 10:18:53.656 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.103213936s txn_start_ts:402954840985567235 region_id:592 store_addr:10.20.94.4:20160 kv_process_ms:821
2018/09/17 10:18:53.686 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.133581174s txn_start_ts:402954840985567235 region_id:580 store_addr:10.20.94.3:20160 kv_process_ms:847
2018/09/17 10:18:53.846 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.012421634s txn_start_ts:402954840985567235 region_id:788 store_addr:10.20.94.5:20160 kv_process_ms:754
2018/09/17 10:18:53.972 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.040425248s txn_start_ts:402954840985567235 region_id:816 store_addr:10.20.94.4:20160 kv_process_ms:752
2018/09/17 10:18:54.056 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.041806038s txn_start_ts:402954840985567235 region_id:900 store_addr:10.20.94.3:20160 kv_process_ms:741
2018/09/17 10:18:54.128 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.039021948s txn_start_ts:402954840985567235 region_id:1012 store_addr:10.20.94.3:20160 kv_process_ms:726
2018/09/17 10:18:54.167 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.070930352s txn_start_ts:402954840985567235 region_id:1032 store_addr:10.20.94.5:20160 kv_process_ms:824
2018/09/17 10:18:54.219 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.236815573s txn_start_ts:402954840985567235 region_id:872 store_addr:10.20.94.4:20160 kv_process_ms:873
2018/09/17 10:18:54.261 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.495999548s txn_start_ts:402954840985567235 region_id:600 store_addr:10.20.94.4:20160 kv_process_ms:932
2018/09/17 10:18:54.343 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.306498507s txn_start_ts:402954840985567235 region_id:960 store_addr:10.20.94.4:20160 kv_process_ms:952
2018/09/17 10:18:54.375 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.307181343s txn_start_ts:402954840985567235 region_id:992 store_addr:10.20.94.4:20160 kv_process_ms:952
2018/09/17 10:18:54.429 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.479620866s txn_start_ts:402954840985567235 region_id:836 store_addr:10.20.94.4:20160 kv_process_ms:873
2018/09/17 10:18:54.650 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.095648704s txn_start_ts:402954840985567235 region_id:1092 store_addr:10.20.94.5:20160 kv_process_ms:800
2018/09/17 10:18:54.702 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.684101234s txn_start_ts:402954840985567235 region_id:928 store_addr:10.20.94.4:20160 kv_process_ms:910
2018/09/17 10:18:54.725 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.068812541s txn_start_ts:402954840985567235 region_id:1124 store_addr:10.20.94.3:20160 kv_process_ms:788
2018/09/17 10:18:54.786 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.664738886s txn_start_ts:402954840985567235 region_id:1072 store_addr:10.20.94.4:20160 kv_process_ms:896
2018/09/17 10:18:54.951 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.104980886s txn_start_ts:402954840985567235 region_id:1180 store_addr:10.20.94.4:20160 kv_process_ms:848
2018/09/17 10:18:55.167 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.195468718s txn_start_ts:402954840985567235 region_id:1204 store_addr:10.20.94.4:20160 kv_process_ms:867
2018/09/17 10:18:55.197 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.069143961s txn_start_ts:402954840985567235 region_id:1272 store_addr:10.20.94.3:20160 kv_process_ms:755
2018/09/17 10:18:55.275 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.589627347s txn_start_ts:402954840985567235 region_id:1156 store_addr:10.20.94.4:20160 kv_process_ms:905 kv_wait_ms:257
2018/09/17 10:18:55.333 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.277108456s txn_start_ts:402954840985567235 region_id:1228 store_addr:10.20.94.4:20160 kv_process_ms:873
2018/09/17 10:18:55.372 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.152819286s txn_start_ts:402954840985567235 region_id:1316 store_addr:10.20.94.3:20160 kv_process_ms:806
2018/09/17 10:18:55.414 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.070584945s txn_start_ts:402954840985567235 region_id:1376 store_addr:10.20.94.3:20160 kv_process_ms:767
2018/09/17 10:18:55.639 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:989.155015ms txn_start_ts:402954840985567235 region_id:1468 store_addr:10.20.94.3:20160 kv_process_ms:748
2018/09/17 10:18:55.766 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.064019881s txn_start_ts:402954840985567235 region_id:1488 store_addr:10.20.94.5:20160 kv_process_ms:792
2018/09/17 10:18:55.843 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.056752396s txn_start_ts:402954840985567235 region_id:1544 store_addr:10.20.94.5:20160 kv_process_ms:779
2018/09/17 10:18:55.873 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.612644981s txn_start_ts:402954840985567235 region_id:1356 store_addr:10.20.94.4:20160 kv_process_ms:836 kv_wait_ms:478
2018/09/17 10:18:55.931 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.501458073s txn_start_ts:402954840985567235 region_id:1436 store_addr:10.20.94.4:20160 kv_process_ms:894
2018/09/17 10:18:56.134 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.758505414s txn_start_ts:402954840985567235 region_id:1396 store_addr:10.20.94.4:20160 kv_process_ms:840 kv_wait_ms:382
2018/09/17 10:18:56.157 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.431348633s txn_start_ts:402954840985567235 region_id:1516 store_addr:10.20.94.4:20160 kv_process_ms:893
2018/09/17 10:18:56.201 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:2.034333595s txn_start_ts:402954840985567235 region_id:1288 store_addr:10.20.94.4:20160 kv_process_ms:911
2018/09/17 10:18:56.327 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.159935173s txn_start_ts:402954840985567235 region_id:1596 store_addr:10.20.94.4:20160 kv_process_ms:786
2018/09/17 10:18:56.436 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.485147063s txn_start_ts:402954840985567235 region_id:1572 store_addr:10.20.94.4:20160 kv_process_ms:920
2018/09/17 10:18:56.491 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.096232409s txn_start_ts:402954840985567235 region_id:1656 store_addr:10.20.94.3:20160 kv_process_ms:759
2018/09/17 10:18:56.511 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.313154646s txn_start_ts:402954840985567235 region_id:1636 store_addr:10.20.94.4:20160 kv_process_ms:943
2018/09/17 10:18:57.289 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.232587397s txn_start_ts:402954840985567235 region_id:1680 store_addr:10.20.94.4:20160 kv_process_ms:794
2018/09/17 10:18:57.767 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:965.379291ms txn_start_ts:402954840985567235 region_id:1708 store_addr:10.20.94.4:20160 kv_process_ms:719
2018/09/17 10:18:58.407 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.030513677s txn_start_ts:402954840985567235 region_id:1732 store_addr:10.20.94.4:20160 kv_process_ms:764
2018/09/17 10:18:58.900 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:990.28304ms txn_start_ts:402954840985567235 region_id:1764 store_addr:10.20.94.3:20160 kv_process_ms:721
2018/09/17 10:18:59.497 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:996.378107ms txn_start_ts:402954840985567235 region_id:1804 store_addr:10.20.94.3:20160 kv_process_ms:742
2018/09/17 10:19:00.155 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:964.592693ms txn_start_ts:402954840985567235 region_id:1828 store_addr:10.20.94.3:20160 kv_process_ms:723
2018/09/17 10:19:00.863 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:958.483626ms txn_start_ts:402954840985567235 region_id:1856 store_addr:10.20.94.3:20160 kv_process_ms:730
2018/09/17 10:19:01.409 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.004020937s txn_start_ts:402954840985567235 region_id:1880 store_addr:10.20.94.4:20160 kv_process_ms:764
2018/09/17 10:19:01.889 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.004787065s txn_start_ts:402954840985567235 region_id:1908 store_addr:10.20.94.3:20160 kv_process_ms:751
2018/09/17 10:19:02.414 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.047052036s txn_start_ts:402954840985567235 region_id:1944 store_addr:10.20.94.4:20160 kv_process_ms:792
2018/09/17 10:19:02.969 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.077183295s txn_start_ts:402954840985567235 region_id:1968 store_addr:10.20.94.5:20160 kv_process_ms:776
2018/09/17 10:19:03.548 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:961.067428ms txn_start_ts:402954840985567235 region_id:1992 store_addr:10.20.94.3:20160 kv_process_ms:709
2018/09/17 10:19:04.289 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.016117292s txn_start_ts:402954840985567235 region_id:2020 store_addr:10.20.94.3:20160 kv_process_ms:767
2018/09/17 10:19:04.756 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:959.729479ms txn_start_ts:402954840985567235 region_id:2048 store_addr:10.20.94.3:20160 kv_process_ms:718
2018/09/17 10:19:05.340 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.057461892s txn_start_ts:402954840985567235 region_id:2080 store_addr:10.20.94.5:20160 kv_process_ms:806
2018/09/17 10:19:05.809 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.001275905s txn_start_ts:402954840985567235 region_id:2100 store_addr:10.20.94.3:20160 kv_process_ms:739
2018/09/17 10:19:06.330 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.0192732s txn_start_ts:402954840985567235 region_id:2124 store_addr:10.20.94.4:20160 kv_process_ms:752
2018/09/17 10:19:07.029 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:998.299933ms txn_start_ts:402954840985567235 region_id:2156 store_addr:10.20.94.4:20160 kv_process_ms:766
2018/09/17 10:19:07.731 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:998.596548ms txn_start_ts:402954840985567235 region_id:2184 store_addr:10.20.94.4:20160 kv_process_ms:760
2018/09/17 10:19:08.389 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.062715271s txn_start_ts:402954840985567235 region_id:2204 store_addr:10.20.94.4:20160 kv_process_ms:807
2018/09/17 10:19:08.875 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.023130329s txn_start_ts:402954840985567235 region_id:2236 store_addr:10.20.94.4:20160 kv_process_ms:778
2018/09/17 10:19:09.418 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.060601002s txn_start_ts:402954840985567235 region_id:2264 store_addr:10.20.94.5:20160 kv_process_ms:805
2018/09/17 10:19:09.914 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.029699367s txn_start_ts:402954840985567235 region_id:2304 store_addr:10.20.94.3:20160 kv_process_ms:771
2018/09/17 10:19:10.487 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.02671481s txn_start_ts:402954840985567235 region_id:2336 store_addr:10.20.94.4:20160 kv_process_ms:746
2018/09/17 10:19:11.362 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.117859527s txn_start_ts:402954840985567235 region_id:2364 store_addr:10.20.94.4:20160 kv_process_ms:758
2018/09/17 10:19:12.057 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.077771125s txn_start_ts:402954840985567235 region_id:2392 store_addr:10.20.94.5:20160 kv_process_ms:838
2018/09/17 10:19:12.589 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.002674514s txn_start_ts:402954840985567235 region_id:2416 store_addr:10.20.94.4:20160 kv_process_ms:772
2018/09/17 10:19:13.237 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.049760263s txn_start_ts:402954840985567235 region_id:2444 store_addr:10.20.94.4:20160 kv_process_ms:807
2018/09/17 10:19:13.679 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:985.838213ms txn_start_ts:402954840985567235 region_id:2484 store_addr:10.20.94.4:20160 kv_process_ms:766
2018/09/17 10:19:14.238 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.038769298s txn_start_ts:402954840985567235 region_id:2504 store_addr:10.20.94.3:20160 kv_process_ms:778
2018/09/17 10:19:14.766 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.027061787s txn_start_ts:402954840985567235 region_id:2524 store_addr:10.20.94.3:20160 kv_process_ms:770
2018/09/17 10:19:15.502 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:965.940208ms txn_start_ts:402954840985567235 region_id:2568 store_addr:10.20.94.4:20160 kv_process_ms:731
2018/09/17 10:19:16.318 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:993.894843ms txn_start_ts:402954840985567235 region_id:2588 store_addr:10.20.94.3:20160 kv_process_ms:757
2018/09/17 10:19:16.973 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.028615731s txn_start_ts:402954840985567235 region_id:2628 store_addr:10.20.94.3:20160 kv_process_ms:795
2018/09/17 10:19:17.566 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.016536928s txn_start_ts:402954840985567235 region_id:2648 store_addr:10.20.94.3:20160 kv_process_ms:778
2018/09/17 10:19:18.114 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.034148364s txn_start_ts:402954840985567235 region_id:2672 store_addr:10.20.94.3:20160 kv_process_ms:806
2018/09/17 10:19:18.722 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.113797495s txn_start_ts:402954840985567235 region_id:2700 store_addr:10.20.94.5:20160 kv_process_ms:875
2018/09/17 10:19:19.173 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.013843093s txn_start_ts:402954840985567235 region_id:2724 store_addr:10.20.94.3:20160 kv_process_ms:753
2018/09/17 10:19:19.737 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.010144208s txn_start_ts:402954840985567235 region_id:2768 store_addr:10.20.94.4:20160 kv_process_ms:762
2018/09/17 10:19:20.412 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.019157166s txn_start_ts:402954840985567235 region_id:2792 store_addr:10.20.94.4:20160 kv_process_ms:741
2018/09/17 10:19:21.145 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:992.009778ms txn_start_ts:402954840985567235 region_id:2808 store_addr:10.20.94.3:20160 kv_process_ms:759
2018/09/17 10:19:21.881 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:998.095491ms txn_start_ts:402954840985567235 region_id:2840 store_addr:10.20.94.3:20160 kv_process_ms:761
2018/09/17 10:19:22.432 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:995.383207ms txn_start_ts:402954840985567235 region_id:2880 store_addr:10.20.94.4:20160 kv_process_ms:759
2018/09/17 10:19:23.088 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.099662142s txn_start_ts:402954840985567235 region_id:2908 store_addr:10.20.94.5:20160 kv_process_ms:844
2018/09/17 10:19:23.653 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.119365601s txn_start_ts:402954840985567235 region_id:2932 store_addr:10.20.94.5:20160 kv_process_ms:877
2018/09/17 10:19:24.121 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.045646187s txn_start_ts:402954840985567235 region_id:2956 store_addr:10.20.94.3:20160 kv_process_ms:808
2018/09/17 10:19:24.661 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.034216689s txn_start_ts:402954840985567235 region_id:2984 store_addr:10.20.94.3:20160 kv_process_ms:800
2018/09/17 10:19:25.201 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.016522859s txn_start_ts:402954840985567235 region_id:3016 store_addr:10.20.94.4:20160 kv_process_ms:747
2018/09/17 10:19:25.892 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.003278524s txn_start_ts:402954840985567235 region_id:3052 store_addr:10.20.94.4:20160 kv_process_ms:753
2018/09/17 10:19:26.653 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.022780719s txn_start_ts:402954840985567235 region_id:3092 store_addr:10.20.94.3:20160 kv_process_ms:788
2018/09/17 10:19:27.482 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.049060062s txn_start_ts:402954840985567235 region_id:3112 store_addr:10.20.94.3:20160 kv_process_ms:811
2018/09/17 10:19:28.209 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.085841801s txn_start_ts:402954840985567235 region_id:3144 store_addr:10.20.94.5:20160 kv_process_ms:837
2018/09/17 10:19:28.782 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.100891702s txn_start_ts:402954840985567235 region_id:3168 store_addr:10.20.94.5:20160 kv_process_ms:856
2018/09/17 10:19:29.394 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.127492603s txn_start_ts:402954840985567235 region_id:3200 store_addr:10.20.94.5:20160 kv_process_ms:876
2018/09/17 10:19:29.955 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.005526025s txn_start_ts:402954840985567235 region_id:3232 store_addr:10.20.94.4:20160 kv_process_ms:774
2018/09/17 10:19:30.610 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.036432852s txn_start_ts:402954840985567235 region_id:3248 store_addr:10.20.94.5:20160 kv_process_ms:785
2018/09/17 10:19:31.136 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.018569497s txn_start_ts:402954840985567235 region_id:3280 store_addr:10.20.94.3:20160 kv_process_ms:761
2018/09/17 10:19:31.644 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.005941766s txn_start_ts:402954840985567235 region_id:3312 store_addr:10.20.94.4:20160 kv_process_ms:747
2018/09/17 10:19:32.202 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.048026847s txn_start_ts:402954840985567235 region_id:3340 store_addr:10.20.94.3:20160 kv_process_ms:778
2018/09/17 10:19:32.963 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.118884369s txn_start_ts:402954840985567235 region_id:3364 store_addr:10.20.94.3:20160 kv_process_ms:850
2018/09/17 10:19:33.633 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.049643729s txn_start_ts:402954840985567235 region_id:3396 store_addr:10.20.94.3:20160 kv_process_ms:817
2018/09/17 10:19:34.375 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:977.239428ms txn_start_ts:402954840985567235 region_id:3424 store_addr:10.20.94.4:20160 kv_process_ms:745
2018/09/17 10:19:34.959 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:976.898661ms txn_start_ts:402954840985567235 region_id:3464 store_addr:10.20.94.3:20160 kv_process_ms:743
2018/09/17 10:19:35.511 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:994.034413ms txn_start_ts:402954840985567235 region_id:3484 store_addr:10.20.94.4:20160 kv_process_ms:755
2018/09/17 10:19:36.116 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.048634711s txn_start_ts:402954840985567235 region_id:3512 store_addr:10.20.94.5:20160 kv_process_ms:801
2018/09/17 10:19:36.601 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:996.840706ms txn_start_ts:402954840985567235 region_id:3544 store_addr:10.20.94.3:20160 kv_process_ms:753
2018/09/17 10:19:37.168 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.029850455s txn_start_ts:402954840985567235 region_id:3568 store_addr:10.20.94.4:20160 kv_process_ms:783
2018/09/17 10:19:37.666 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.001308612s txn_start_ts:402954840985567235 region_id:3604 store_addr:10.20.94.4:20160 kv_process_ms:763
2018/09/17 10:19:38.211 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.028707753s txn_start_ts:402954840985567235 region_id:3640 store_addr:10.20.94.3:20160 kv_process_ms:777
2018/09/17 10:19:38.769 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.058886744s txn_start_ts:402954840985567235 region_id:3656 store_addr:10.20.94.3:20160 kv_process_ms:789
2018/09/17 10:19:39.390 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.016931143s txn_start_ts:402954840985567235 region_id:3688 store_addr:10.20.94.3:20160 kv_process_ms:759
2018/09/17 10:19:40.225 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.089227372s txn_start_ts:402954840985567235 region_id:3720 store_addr:10.20.94.4:20160 kv_process_ms:783
2018/09/17 10:19:40.937 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.04310395s txn_start_ts:402954840985567235 region_id:3752 store_addr:10.20.94.4:20160 kv_process_ms:801
2018/09/17 10:19:41.827 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.036597925s txn_start_ts:402954840985567235 region_id:3784 store_addr:10.20.94.4:20160 kv_process_ms:789
2018/09/17 10:19:42.528 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.109965754s txn_start_ts:402954840985567235 region_id:3800 store_addr:10.20.94.5:20160 kv_process_ms:870
2018/09/17 10:19:43.090 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.004898181s txn_start_ts:402954840985567235 region_id:3836 store_addr:10.20.94.3:20160 kv_process_ms:770
2018/09/17 10:19:43.818 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.117548796s txn_start_ts:402954840985567235 region_id:3864 store_addr:10.20.94.5:20160 kv_process_ms:865
2018/09/17 10:19:44.503 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.151048304s txn_start_ts:402954840985567235 region_id:3888 store_addr:10.20.94.5:20160 kv_process_ms:911
2018/09/17 10:19:44.959 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:997.759458ms txn_start_ts:402954840985567235 region_id:3924 store_addr:10.20.94.4:20160 kv_process_ms:768
2018/09/17 10:19:45.559 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.029554101s txn_start_ts:402954840985567235 region_id:3944 store_addr:10.20.94.3:20160 kv_process_ms:801
2018/09/17 10:19:46.209 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.103064617s txn_start_ts:402954840985567235 region_id:3972 store_addr:10.20.94.5:20160 kv_process_ms:866
2018/09/17 10:19:46.829 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.147679641s txn_start_ts:402954840985567235 region_id:4004 store_addr:10.20.94.5:20160 kv_process_ms:887
2018/09/17 10:19:47.424 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.174508946s txn_start_ts:402954840985567235 region_id:4036 store_addr:10.20.94.5:20160 kv_process_ms:902
2018/09/17 10:19:47.959 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.032846384s txn_start_ts:402954840985567235 region_id:4064 store_addr:10.20.94.4:20160 kv_process_ms:782
2018/09/17 10:19:48.833 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.152981256s txn_start_ts:402954840985567235 region_id:4088 store_addr:10.20.94.5:20160 kv_process_ms:892
2018/09/17 10:19:49.388 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:985.541579ms txn_start_ts:402954840985567235 region_id:4108 store_addr:10.20.94.4:20160 kv_process_ms:754
2018/09/17 10:19:50.386 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.159589474s txn_start_ts:402954840985567235 region_id:4152 store_addr:10.20.94.5:20160 kv_process_ms:913
2018/09/17 10:19:50.926 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.067403369s txn_start_ts:402954840985567235 region_id:4172 store_addr:10.20.94.5:20160 kv_process_ms:819
2018/09/17 10:19:51.732 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.152931709s txn_start_ts:402954840985567235 region_id:4204 store_addr:10.20.94.5:20160 kv_process_ms:911
2018/09/17 10:19:52.328 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:992.167465ms txn_start_ts:402954840985567235 region_id:4248 store_addr:10.20.94.3:20160 kv_process_ms:760
2018/09/17 10:19:53.005 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.032022648s txn_start_ts:402954840985567235 region_id:4276 store_addr:10.20.94.3:20160 kv_process_ms:796
2018/09/17 10:19:53.617 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.030785692s txn_start_ts:402954840985567235 region_id:4312 store_addr:10.20.94.4:20160 kv_process_ms:792
2018/09/17 10:19:54.317 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.148787318s txn_start_ts:402954840985567235 region_id:4328 store_addr:10.20.94.5:20160 kv_process_ms:897
2018/09/17 10:19:54.958 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.164109601s txn_start_ts:402954840985567235 region_id:4368 store_addr:10.20.94.5:20160 kv_process_ms:921
2018/09/17 10:19:55.508 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.011857483s txn_start_ts:402954840985567235 region_id:4388 store_addr:10.20.94.4:20160 kv_process_ms:777
2018/09/17 10:19:56.170 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.021931352s txn_start_ts:402954840985567235 region_id:4412 store_addr:10.20.94.3:20160 kv_process_ms:756
2018/09/17 10:19:56.777 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.076743563s txn_start_ts:402954840985567235 region_id:4452 store_addr:10.20.94.5:20160 kv_process_ms:805
2018/09/17 10:19:56.869 gc_worker.go:724: [info] [gc worker] 5962603b1980006 gc in process, safePoint: 402954516569260032, successful regions: 238, failed regions: 0, total cost time: 10m0.105436132s
2018/09/17 10:19:57.484 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.155928769s txn_start_ts:402954840985567235 region_id:4472 store_addr:10.20.94.5:20160 kv_process_ms:879
2018/09/17 10:19:58.142 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.027554325s txn_start_ts:402954840985567235 region_id:4496 store_addr:10.20.94.3:20160 kv_process_ms:753
2018/09/17 10:19:58.992 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.108099677s txn_start_ts:402954840985567235 region_id:4520 store_addr:10.20.94.3:20160 kv_process_ms:799
2018/09/17 10:19:59.817 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.138493615s txn_start_ts:402954840985567235 region_id:4560 store_addr:10.20.94.5:20160 kv_process_ms:895
2018/09/17 10:20:00.338 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.002477556s txn_start_ts:402954840985567235 region_id:4584 store_addr:10.20.94.3:20160 kv_process_ms:771
2018/09/17 10:20:00.887 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:992.258573ms txn_start_ts:402954840985567235 region_id:4604 store_addr:10.20.94.4:20160 kv_process_ms:759
2018/09/17 10:20:01.530 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.077611652s txn_start_ts:402954840985567235 region_id:4632 store_addr:10.20.94.4:20160 kv_process_ms:841
2018/09/17 10:20:02.135 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.106850287s txn_start_ts:402954840985567235 region_id:4668 store_addr:10.20.94.4:20160 kv_process_ms:865
2018/09/17 10:20:02.608 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.020269064s txn_start_ts:402954840985567235 region_id:4692 store_addr:10.20.94.4:20160 kv_process_ms:797
2018/09/17 10:20:03.271 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.121325896s txn_start_ts:402954840985567235 region_id:4720 store_addr:10.20.94.5:20160 kv_process_ms:880
2018/09/17 10:20:03.941 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.209998814s txn_start_ts:402954840985567235 region_id:4760 store_addr:10.20.94.5:20160 kv_process_ms:938
2018/09/17 10:20:04.433 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.138984729s txn_start_ts:402954840985567235 region_id:4776 store_addr:10.20.94.5:20160 kv_process_ms:878
2018/09/17 10:20:04.991 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.117881485s txn_start_ts:402954840985567235 region_id:4800 store_addr:10.20.94.5:20160 kv_process_ms:861
2018/09/17 10:20:05.618 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.149853948s txn_start_ts:402954840985567235 region_id:4840 store_addr:10.20.94.5:20160 kv_process_ms:897
2018/09/17 10:20:06.169 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.136286274s txn_start_ts:402954840985567235 region_id:4868 store_addr:10.20.94.5:20160 kv_process_ms:864
2018/09/17 10:20:06.685 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.09786305s txn_start_ts:402954840985567235 region_id:4900 store_addr:10.20.94.5:20160 kv_process_ms:827
2018/09/17 10:20:07.394 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.048559611s txn_start_ts:402954840985567235 region_id:4920 store_addr:10.20.94.3:20160 kv_process_ms:782
2018/09/17 10:20:08.215 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.104771708s txn_start_ts:402954840985567235 region_id:4944 store_addr:10.20.94.5:20160 kv_process_ms:830
2018/09/17 10:20:09.068 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.198206487s txn_start_ts:402954840985567235 region_id:4984 store_addr:10.20.94.5:20160 kv_process_ms:850
2018/09/17 10:20:09.724 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:991.552102ms txn_start_ts:402954840985567235 region_id:5012 store_addr:10.20.94.4:20160 kv_process_ms:756
2018/09/17 10:20:10.492 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.011704228s txn_start_ts:402954840985567235 region_id:5044 store_addr:10.20.94.3:20160 kv_process_ms:775
2018/09/17 10:20:11.113 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:978.463527ms txn_start_ts:402954840985567235 region_id:5072 store_addr:10.20.94.3:20160 kv_process_ms:744
2018/09/17 10:20:11.881 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.127289278s txn_start_ts:402954840985567235 region_id:5096 store_addr:10.20.94.5:20160 kv_process_ms:882
2018/09/17 10:20:12.334 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:984.03839ms txn_start_ts:402954840985567235 region_id:5136 store_addr:10.20.94.4:20160 kv_process_ms:745
2018/09/17 10:20:13.076 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.123857677s txn_start_ts:402954840985567235 region_id:5160 store_addr:10.20.94.5:20160 kv_process_ms:880
2018/09/17 10:20:13.579 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.017437418s txn_start_ts:402954840985567235 region_id:5192 store_addr:10.20.94.4:20160 kv_process_ms:790
2018/09/17 10:20:14.263 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.102265598s txn_start_ts:402954840985567235 region_id:5212 store_addr:10.20.94.5:20160 kv_process_ms:863
2018/09/17 10:20:14.755 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.003412999s txn_start_ts:402954840985567235 region_id:5240 store_addr:10.20.94.3:20160 kv_process_ms:766
2018/09/17 10:20:15.392 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.068027056s txn_start_ts:402954840985567235 region_id:5284 store_addr:10.20.94.3:20160 kv_process_ms:835
2018/09/17 10:20:16.041 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.11429647s txn_start_ts:402954840985567235 region_id:5320 store_addr:10.20.94.5:20160 kv_process_ms:869
2018/09/17 10:20:16.533 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.027835661s txn_start_ts:402954840985567235 region_id:5340 store_addr:10.20.94.3:20160 kv_process_ms:784
2018/09/17 10:20:17.118 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.062049315s txn_start_ts:402954840985567235 region_id:5372 store_addr:10.20.94.3:20160 kv_process_ms:804
2018/09/17 10:20:17.605 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:987.236708ms txn_start_ts:402954840985567235 region_id:5400 store_addr:10.20.94.4:20160 kv_process_ms:739
2018/09/17 10:20:18.280 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.018068663s txn_start_ts:402954840985567235 region_id:5432 store_addr:10.20.94.3:20160 kv_process_ms:764
2018/09/17 10:20:19.049 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.02989201s txn_start_ts:402954840985567235 region_id:5452 store_addr:10.20.94.3:20160 kv_process_ms:781
2018/09/17 10:20:19.875 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.148699514s txn_start_ts:402954840985567235 region_id:5488 store_addr:10.20.94.5:20160 kv_process_ms:845
2018/09/17 10:20:20.688 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.219358245s txn_start_ts:402954840985567235 region_id:5512 store_addr:10.20.94.5:20160 kv_process_ms:851
2018/09/17 10:20:21.304 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:1.017606082s txn_start_ts:402954840985567235 region_id:5536 store_addr:10.20.94.3:20160 kv_process_ms:774
2018/09/17 10:20:21.696 coprocessor.go:689: [info] [TIME_COP_PROCESS] resp_time:678.773134ms txn_start_ts:402954840985567235 region_id:604 store_addr:10.20.94.3:20160 kv_process_ms:524
2018/09/17 10:21:20.826 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "SERDES"."NAME", "SERDES"."SLIB" from "SERDES" where "SERDE_ID" in (34406876,34406544,34406877,34406878,34406879,34406880,34406881,34406882,34406883,34406884,34406885,34406886,34406545,34406887,34406888,34406889,34406890,34406891,34406892,34406893,34406894,34406895,34406896,34406546,34406897,34406898,34406899,34406900,34406901,34406902,34406903,34406904,34406905,34406906,34406511,34406547,34406548,34406549,34406550,34406551,34406552,34406553,34406554,34406555,34406556,34406512,34406557,34406558,34406559,34406560,34406561,34406562,34406563,34406564,34406565,34406566,34406513,34406567,34406568,34406569,34406570,34406571,34406572,34406573,34406574,34406575,34406576,34406514,34406577,34406578,34406579,34406580,34406581,34406582,34406583,34406584,34406585,34406586,34406515,34406587,34406588,34406589,34406590,34406591,34406592,34406593,34406594,34406595,34406596,34406516,34406597,34406598,34406599,34406600,34406601,34406602,34406603,34406604,34406605,34406606)
2018/09/17 10:21:20.841 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "PART_ID", "PARAM_KEY", "PARAM_VALUE" from "PARTITION_PARAMS" where "PART_ID" in (34561180,34560848,34561181,34561182,34561183,34561184,34561185,34561186,34561187,34561188,34561189,34561190,34560849,34561191,34561192,34561193,34561194,34561195,34561196,34561197,34561198,34561199,34561200,34560850,34561201,34561202,34561203,34561204,34561205,34561206,34561207,34561208,34561209,34561210,34560815,34560851,34560852,34560853,34560854,34560855,34560856,34560857,34560858,34560859,34560860,34560816,34560861,34560862,34560863,34560864,34560865,34560866,34560867,34560868,34560869,34560870,34560817,34560871,34560872,34560873,34560874,34560875,34560876,34560877,34560878,34560879,34560880,34560818,34560881,34560882,34560883,34560884,34560885,34560886,34560887,34560888,34560889,34560890,34560819,34560891,34560892,34560893,34560894,34560895,34560896,34560897,34560898,34560899,34560900,34560820,34560901,34560902,34560903,34560904,34560905,34560906,34560907,34560908,34560909,34560910) and "PARAM_KEY" is not null order  len(1040)
2018/09/17 10:21:20.858 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "PART_ID", "PART_KEY_VAL" from "PARTITION_KEY_VALS" where "PART_ID" in (34561180,34560848,34561181,34561182,34561183,34561184,34561185,34561186,34561187,34561188,34561189,34561190,34560849,34561191,34561192,34561193,34561194,34561195,34561196,34561197,34561198,34561199,34561200,34560850,34561201,34561202,34561203,34561204,34561205,34561206,34561207,34561208,34561209,34561210,34560815,34560851,34560852,34560853,34560854,34560855,34560856,34560857,34560858,34560859,34560860,34560816,34560861,34560862,34560863,34560864,34560865,34560866,34560867,34560868,34560869,34560870,34560817,34560871,34560872,34560873,34560874,34560875,34560876,34560877,34560878,34560879,34560880,34560818,34560881,34560882,34560883,34560884,34560885,34560886,34560887,34560888,34560889,34560890,34560819,34560891,34560892,34560893,34560894,34560895,34560896,34560897,34560898,34560899,34560900,34560820,34560901,34560902,34560903,34560904,34560905,34560906,34560907,34560908,34560909,34560910) and "INTEGER_IDX" >= 0 order by "PART_ID" as len(1044)
2018/09/17 10:21:20.939 compiler.go:78: [warning] [EXPENSIVE_QUERY] select "SERDE_ID", "PARAM_KEY", "PARAM_VALUE" from "SERDE_PARAMS" where "SERDE_ID" in (34406876,34406544,34406877,34406878,34406879,34406880,34406881,34406882,34406883,34406884,34406885,34406886,34406545,34406887,34406888,34406889,34406890,34406891,34406892,34406893,34406894,34406895,34406896,34406546,34406897,34406898,34406899,34406900,34406901,34406902,34406903,34406904,34406905,34406906,34406511,34406547,34406548,34406549,34406550,34406551,34406552,34406553,34406554,34406555,34406556,34406512,34406557,34406558,34406559,34406560,34406561,34406562,34406563,34406564,34406565,34406566,34406513,34406567,34406568,34406569,34406570,34406571,34406572,34406573,34406574,34406575,34406576,34406514,34406577,34406578,34406579,34406580,34406581,34406582,34406583,34406584,34406585,34406586,34406515,34406587,34406588,34406589,34406590,34406591,34406592,34406593,34406594,34406595,34406596,34406516,34406597,34406598,34406599,34406600,34406601,34406602,34406603,34406604,34406605,34406606) and "PARAM_KEY" is not null order by len(1039)
2018/09/17 10:21:20.971 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PARTITIONS.PART_ID from PARTITIONS where PARTITIONS.TBL_ID = 44446 and PARTITIONS.PART_NAME in ('p1=369/p2=369','p1=37/p2=37','p1=370/p2=370','p1=371/p2=371','p1=372/p2=372','p1=373/p2=373','p1=374/p2=374','p1=375/p2=375','p1=376/p2=376','p1=377/p2=377','p1=378/p2=378','p1=379/p2=379','p1=38/p2=38','p1=380/p2=380','p1=381/p2=381','p1=382/p2=382','p1=383/p2=383','p1=384/p2=384','p1=385/p2=385','p1=386/p2=386','p1=387/p2=387','p1=388/p2=388','p1=389/p2=389','p1=39/p2=39','p1=390/p2=390','p1=391/p2=391','p1=392/p2=392','p1=393/p2=393','p1=394/p2=394','p1=395/p2=395','p1=396/p2=396','p1=397/p2=397','p1=398/p2=398','p1=399/p2=399','p1=4/p2=4','p1=40/p2=40','p1=41/p2=41','p1=42/p2=42','p1=43/p2=43','p1=44/p2=44','p1=45/p2=45','p1=46/p2=46','p1=47/p2=47','p1=48/p2=48','p1=49/p2=49','p1=5/p2=5','p1=50/p2=50','p1=51/p2=51','p1=52/p2=52','p1=53/p2=53','p1=54/p2=54','p1=55/p2=55','p1=56/p2=56','p1=57/p2=57','p1=58/p2=58','p1=59/p2=59','p1=6/p2=6','p1=60/p2=60','p1=61/p2=61','p1=62/p2=62','p1=63/p2=63','p1=64/p2=6 len(1553)
2018/09/17 10:21:21.009 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PARTITIONS.PART_ID from PARTITIONS where PARTITIONS.TBL_ID = 44446 and PARTITIONS.PART_NAME in ('p1=369/p2=369','p1=37/p2=37','p1=370/p2=370','p1=371/p2=371','p1=372/p2=372','p1=373/p2=373','p1=374/p2=374','p1=375/p2=375','p1=376/p2=376','p1=377/p2=377','p1=378/p2=378','p1=379/p2=379','p1=38/p2=38','p1=380/p2=380','p1=381/p2=381','p1=382/p2=382','p1=383/p2=383','p1=384/p2=384','p1=385/p2=385','p1=386/p2=386','p1=387/p2=387','p1=388/p2=388','p1=389/p2=389','p1=39/p2=39','p1=390/p2=390','p1=391/p2=391','p1=392/p2=392','p1=393/p2=393','p1=394/p2=394','p1=395/p2=395','p1=396/p2=396','p1=397/p2=397','p1=398/p2=398','p1=399/p2=399','p1=4/p2=4','p1=40/p2=40','p1=41/p2=41','p1=42/p2=42','p1=43/p2=43','p1=44/p2=44','p1=45/p2=45','p1=46/p2=46','p1=47/p2=47','p1=48/p2=48','p1=49/p2=49','p1=5/p2=5','p1=50/p2=50','p1=51/p2=51','p1=52/p2=52','p1=53/p2=53','p1=54/p2=54','p1=55/p2=55','p1=56/p2=56','p1=57/p2=57','p1=58/p2=58','p1=59/p2=59','p1=6/p2=6','p1=60/p2=60','p1=61/p2=61','p1=62/p2=62','p1=63/p2=63','p1=64/p2=6 len(1553)
2018/09/17 10:21:21.032 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PARTITIONS.SD_ID from PARTITIONS where PARTITIONS.TBL_ID = 44446 and PARTITIONS.PART_NAME in ('p1=369/p2=369','p1=37/p2=37','p1=370/p2=370','p1=371/p2=371','p1=372/p2=372','p1=373/p2=373','p1=374/p2=374','p1=375/p2=375','p1=376/p2=376','p1=377/p2=377','p1=378/p2=378','p1=379/p2=379','p1=38/p2=38','p1=380/p2=380','p1=381/p2=381','p1=382/p2=382','p1=383/p2=383','p1=384/p2=384','p1=385/p2=385','p1=386/p2=386','p1=387/p2=387','p1=388/p2=388','p1=389/p2=389','p1=39/p2=39','p1=390/p2=390','p1=391/p2=391','p1=392/p2=392','p1=393/p2=393','p1=394/p2=394','p1=395/p2=395','p1=396/p2=396','p1=397/p2=397','p1=398/p2=398','p1=399/p2=399','p1=4/p2=4','p1=40/p2=40','p1=41/p2=41','p1=42/p2=42','p1=43/p2=43','p1=44/p2=44','p1=45/p2=45','p1=46/p2=46','p1=47/p2=47','p1=48/p2=48','p1=49/p2=49','p1=5/p2=5','p1=50/p2=50','p1=51/p2=51','p1=52/p2=52','p1=53/p2=53','p1=54/p2=54','p1=55/p2=55','p1=56/p2=56','p1=57/p2=57','p1=58/p2=58','p1=59/p2=59','p1=6/p2=6','p1=60/p2=60','p1=61/p2=61','p1=62/p2=62','p1=63/p2=63','p1=64/p2=64' len(1551)
2018/09/17 10:21:21.043 compiler.go:78: [warning] [EXPENSIVE_QUERY] select CD_ID from SDS where SD_ID in (34498401,34498402,34498403,34498404,34498405,34498406,34498434,34498435,34498436,34498437,34498438,34498439,34498440,34498441,34498442,34498443,34498444,34498445,34498446,34498447,34498448,34498449,34498450,34498451,34498452,34498453,34498454,34498455,34498456,34498457,34498458,34498459,34498460,34498461,34498462,34498463,34498464,34498465,34498466,34498467,34498468,34498469,34498470,34498471,34498472,34498473,34498474,34498475,34498476,34498477,34498478,34498479,34498480,34498481,34498482,34498483,34498484,34498485,34498486,34498487,34498488,34498489,34498490,34498491,34498492,34498493,34498494,34498495,34498496,34498766,34498767,34498768,34498769,34498770,34498771,34498772,34498773,34498774,34498775,34498776,34498777,34498778,34498779,34498780,34498781,34498782,34498783,34498784,34498785,34498786,34498787,34498788,34498789,34498790,34498791,34498792,34498793,34498794,34498795,34498796)
2018/09/17 10:21:21.054 compiler.go:78: [warning] [EXPENSIVE_QUERY] update SDS set CD_ID = null where SD_ID in (34498401,34498402,34498403,34498404,34498405,34498406,34498434,34498435,34498436,34498437,34498438,34498439,34498440,34498441,34498442,34498443,34498444,34498445,34498446,34498447,34498448,34498449,34498450,34498451,34498452,34498453,34498454,34498455,34498456,34498457,34498458,34498459,34498460,34498461,34498462,34498463,34498464,34498465,34498466,34498467,34498468,34498469,34498470,34498471,34498472,34498473,34498474,34498475,34498476,34498477,34498478,34498479,34498480,34498481,34498482,34498483,34498484,34498485,34498486,34498487,34498488,34498489,34498490,34498491,34498492,34498493,34498494,34498495,34498496,34498766,34498767,34498768,34498769,34498770,34498771,34498772,34498773,34498774,34498775,34498776,34498777,34498778,34498779,34498780,34498781,34498782,34498783,34498784,34498785,34498786,34498787,34498788,34498789,34498790,34498791,34498792,34498793,34498794,34498795,34498796)
2018/09/17 10:21:21.070 compiler.go:78: [warning] [EXPENSIVE_QUERY] select count(1) from SDS where CD_ID = 58102
2018/09/17 10:21:21.090 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PARTITIONS.PART_ID from PARTITIONS where PARTITIONS.TBL_ID = 44446 and PARTITIONS.PART_NAME in ('p1=369/p2=369','p1=37/p2=37','p1=370/p2=370','p1=371/p2=371','p1=372/p2=372','p1=373/p2=373','p1=374/p2=374','p1=375/p2=375','p1=376/p2=376','p1=377/p2=377','p1=378/p2=378','p1=379/p2=379','p1=38/p2=38','p1=380/p2=380','p1=381/p2=381','p1=382/p2=382','p1=383/p2=383','p1=384/p2=384','p1=385/p2=385','p1=386/p2=386','p1=387/p2=387','p1=388/p2=388','p1=389/p2=389','p1=39/p2=39','p1=390/p2=390','p1=391/p2=391','p1=392/p2=392','p1=393/p2=393','p1=394/p2=394','p1=395/p2=395','p1=396/p2=396','p1=397/p2=397','p1=398/p2=398','p1=399/p2=399','p1=4/p2=4','p1=40/p2=40','p1=41/p2=41','p1=42/p2=42','p1=43/p2=43','p1=44/p2=44','p1=45/p2=45','p1=46/p2=46','p1=47/p2=47','p1=48/p2=48','p1=49/p2=49','p1=5/p2=5','p1=50/p2=50','p1=51/p2=51','p1=52/p2=52','p1=53/p2=53','p1=54/p2=54','p1=55/p2=55','p1=56/p2=56','p1=57/p2=57','p1=58/p2=58','p1=59/p2=59','p1=6/p2=6','p1=60/p2=60','p1=61/p2=61','p1=62/p2=62','p1=63/p2=63','p1=64/p2=6 len(1553)
2018/09/17 10:21:21.098 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PARTITIONS.SD_ID from PARTITIONS where PARTITIONS.TBL_ID = 44446 and PARTITIONS.PART_NAME in ('p1=369/p2=369','p1=37/p2=37','p1=370/p2=370','p1=371/p2=371','p1=372/p2=372','p1=373/p2=373','p1=374/p2=374','p1=375/p2=375','p1=376/p2=376','p1=377/p2=377','p1=378/p2=378','p1=379/p2=379','p1=38/p2=38','p1=380/p2=380','p1=381/p2=381','p1=382/p2=382','p1=383/p2=383','p1=384/p2=384','p1=385/p2=385','p1=386/p2=386','p1=387/p2=387','p1=388/p2=388','p1=389/p2=389','p1=39/p2=39','p1=390/p2=390','p1=391/p2=391','p1=392/p2=392','p1=393/p2=393','p1=394/p2=394','p1=395/p2=395','p1=396/p2=396','p1=397/p2=397','p1=398/p2=398','p1=399/p2=399','p1=4/p2=4','p1=40/p2=40','p1=41/p2=41','p1=42/p2=42','p1=43/p2=43','p1=44/p2=44','p1=45/p2=45','p1=46/p2=46','p1=47/p2=47','p1=48/p2=48','p1=49/p2=49','p1=5/p2=5','p1=50/p2=50','p1=51/p2=51','p1=52/p2=52','p1=53/p2=53','p1=54/p2=54','p1=55/p2=55','p1=56/p2=56','p1=57/p2=57','p1=58/p2=58','p1=59/p2=59','p1=6/p2=6','p1=60/p2=60','p1=61/p2=61','p1=62/p2=62','p1=63/p2=63','p1=64/p2=64' len(1551)
2018/09/17 10:21:21.107 compiler.go:78: [warning] [EXPENSIVE_QUERY] select SERDE_ID from SDS where SD_ID in (34498401,34498402,34498403,34498404,34498405,34498406,34498434,34498435,34498436,34498437,34498438,34498439,34498440,34498441,34498442,34498443,34498444,34498445,34498446,34498447,34498448,34498449,34498450,34498451,34498452,34498453,34498454,34498455,34498456,34498457,34498458,34498459,34498460,34498461,34498462,34498463,34498464,34498465,34498466,34498467,34498468,34498469,34498470,34498471,34498472,34498473,34498474,34498475,34498476,34498477,34498478,34498479,34498480,34498481,34498482,34498483,34498484,34498485,34498486,34498487,34498488,34498489,34498490,34498491,34498492,34498493,34498494,34498495,34498496,34498766,34498767,34498768,34498769,34498770,34498771,34498772,34498773,34498774,34498775,34498776,34498777,34498778,34498779,34498780,34498781,34498782,34498783,34498784,34498785,34498786,34498787,34498788,34498789,34498790,34498791,34498792,34498793,34498794,34498795,34498796)
2018/09/17 10:21:21.117 compiler.go:78: [warning] [EXPENSIVE_QUERY] delete from SERDE_PARAMS where SERDE_ID in (34406511,34406512,34406513,34406514,34406515,34406516,34406544,34406545,34406546,34406547,34406548,34406549,34406550,34406551,34406552,34406553,34406554,34406555,34406556,34406557,34406558,34406559,34406560,34406561,34406562,34406563,34406564,34406565,34406566,34406567,34406568,34406569,34406570,34406571,34406572,34406573,34406574,34406575,34406576,34406577,34406578,34406579,34406580,34406581,34406582,34406583,34406584,34406585,34406586,34406587,34406588,34406589,34406590,34406591,34406592,34406593,34406594,34406595,34406596,34406597,34406598,34406599,34406600,34406601,34406602,34406603,34406604,34406605,34406606,34406876,34406877,34406878,34406879,34406880,34406881,34406882,34406883,34406884,34406885,34406886,34406887,34406888,34406889,34406890,34406891,34406892,34406893,34406894,34406895,34406896,34406897,34406898,34406899,34406900,34406901,34406902,34406903,34406904,34406905,34406906)
2018/09/17 10:21:21.140 compiler.go:78: [warning] [EXPENSIVE_QUERY] delete from SERDES where SERDE_ID in (34406511,34406512,34406513,34406514,34406515,34406516,34406544,34406545,34406546,34406547,34406548,34406549,34406550,34406551,34406552,34406553,34406554,34406555,34406556,34406557,34406558,34406559,34406560,34406561,34406562,34406563,34406564,34406565,34406566,34406567,34406568,34406569,34406570,34406571,34406572,34406573,34406574,34406575,34406576,34406577,34406578,34406579,34406580,34406581,34406582,34406583,34406584,34406585,34406586,34406587,34406588,34406589,34406590,34406591,34406592,34406593,34406594,34406595,34406596,34406597,34406598,34406599,34406600,34406601,34406602,34406603,34406604,34406605,34406606,34406876,34406877,34406878,34406879,34406880,34406881,34406882,34406883,34406884,34406885,34406886,34406887,34406888,34406889,34406890,34406891,34406892,34406893,34406894,34406895,34406896,34406897,34406898,34406899,34406900,34406901,34406902,34406903,34406904,34406905,34406906)
2018/09/17 10:21:21.231 compiler.go:78: [warning] [EXPENSIVE_QUERY] delete from SDS where SD_ID in (34498401,34498402,34498403,34498404,34498405,34498406,34498434,34498435,34498436,34498437,34498438,34498439,34498440,34498441,34498442,34498443,34498444,34498445,34498446,34498447,34498448,34498449,34498450,34498451,34498452,34498453,34498454,34498455,34498456,34498457,34498458,34498459,34498460,34498461,34498462,34498463,34498464,34498465,34498466,34498467,34498468,34498469,34498470,34498471,34498472,34498473,34498474,34498475,34498476,34498477,34498478,34498479,34498480,34498481,34498482,34498483,34498484,34498485,34498486,34498487,34498488,34498489,34498490,34498491,34498492,34498493,34498494,34498495,34498496,34498766,34498767,34498768,34498769,34498770,34498771,34498772,34498773,34498774,34498775,34498776,34498777,34498778,34498779,34498780,34498781,34498782,34498783,34498784,34498785,34498786,34498787,34498788,34498789,34498790,34498791,34498792,34498793,34498794,34498795,34498796)
2018/09/17 10:21:21.245 compiler.go:78: [warning] [EXPENSIVE_QUERY] delete from PARTITION_KEY_VALS where PART_ID in (34560864,34560865,34560867,34560868,34560869,34560874,34560875,34560870,34560817,34560871,34560859,34560860,34560866,34560855,34560862,34560863,34560876,34560877,34560872,34560873,34560856,34560857,34560858,34560852,34560853,34560854,34560878,34560879,34560816,34560861,34560880,34560883,34560884,34560818,34560881,34560882,34561201,34561202,34561203,34561204,34561205,34561206,34561207,34561208,34561209,34561210,34560815,34560851,34560896,34560897,34560885,34560894,34560895,34560900,34560888,34560889,34560890,34560886,34560887,34560905,34560906,34560904,34560898,34560899,34560820,34560901,34560902,34560903,34560907,34560908,34560909,34560910,34560819,34560891,34560892,34560893,34561180,34560848,34561181,34561182,34561183,34561184,34561185,34561186,34561187,34561188,34561189,34561190,34560849,34561191,34561192,34561193,34561194,34561195,34561196,34561197,34561198,34561199,34561200,34560850)
2018/09/17 10:21:21.266 compiler.go:78: [warning] [EXPENSIVE_QUERY] delete from PARTITION_PARAMS where PART_ID in (34560864,34560865,34560867,34560868,34560869,34560874,34560875,34560870,34560817,34560871,34560859,34560860,34560866,34560855,34560862,34560863,34560876,34560877,34560872,34560873,34560856,34560857,34560858,34560852,34560853,34560854,34560878,34560879,34560816,34560861,34560880,34560883,34560884,34560818,34560881,34560882,34561201,34561202,34561203,34561204,34561205,34561206,34561207,34561208,34561209,34561210,34560815,34560851,34560896,34560897,34560885,34560894,34560895,34560900,34560888,34560889,34560890,34560886,34560887,34560905,34560906,34560904,34560898,34560899,34560820,34560901,34560902,34560903,34560907,34560908,34560909,34560910,34560819,34560891,34560892,34560893,34561180,34560848,34561181,34561182,34561183,34561184,34561185,34561186,34561187,34561188,34561189,34561190,34560849,34561191,34561192,34561193,34561194,34561195,34561196,34561197,34561198,34561199,34561200,34560850)
2018/09/17 10:21:21.286 compiler.go:78: [warning] [EXPENSIVE_QUERY] delete from PARTITIONS where PART_ID in (34560864,34560865,34560867,34560868,34560869,34560874,34560875,34560870,34560817,34560871,34560859,34560860,34560866,34560855,34560862,34560863,34560876,34560877,34560872,34560873,34560856,34560857,34560858,34560852,34560853,34560854,34560878,34560879,34560816,34560861,34560880,34560883,34560884,34560818,34560881,34560882,34561201,34561202,34561203,34561204,34561205,34561206,34561207,34561208,34561209,34561210,34560815,34560851,34560896,34560897,34560885,34560894,34560895,34560900,34560888,34560889,34560890,34560886,34560887,34560905,34560906,34560904,34560898,34560899,34560820,34560901,34560902,34560903,34560907,34560908,34560909,34560910,34560819,34560891,34560892,34560893,34561180,34560848,34561181,34561182,34561183,34561184,34561185,34561186,34561187,34561188,34561189,34561190,34560849,34561191,34561192,34561193,34561194,34561195,34561196,34561197,34561198,34561199,34561200,34560850)
2018/09/17 10:21:21.302 set.go:180: [info] con:3342031 sql_select_limit=300
2018/09/17 10:21:21.302 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PARTITIONS.PART_ID from PARTITIONS  where PARTITIONS.TBL_ID = 44446 order by PART_NAME asc
2018/09/17 10:21:21.317 set.go:180: [info] con:3342031 sql_select_limit=18446744073709551615
2018/09/17 10:21:21.333 compiler.go:78: [warning] [EXPENSIVE_QUERY] select PART_ID from PARTITIONS where TBL_ID = 44446
2018/09/17 10:21:21.359 compiler.go:78: [warning] [EXPENSIVE_QUERY] select count(1) from SDS where CD_ID = 58102
2018/09/17 10:21:21.379 compiler.go:78: [warning] [EXPENSIVE_QUERY] delete from SERDE_PARAMS where SERDE_ID in (34406506)
2018/09/17 10:21:21.438 2pc.go:143: [info] [BIG_TXN] con:3342031 table id:65 size:382574, keys:11556, puts:0, dels:11556, locks:0, startTS:402954840985567235
2018/09/17 10:21:21.526 set.go:180: [info] con:3342031 autocommit=1
2018/09/17 10:21:21.526 set.go:180: [info] con:3342031 tx_read_only=0
2018/09/17 10:21:21.527 set.go:180: [info] con:3342031 transaction_read_only=0
2018/09/17 10:24:59.777 domain.go:567: [info] [domain] reload privilege success.
2018/09/17 10:29:57.071 gc_worker.go:724: [info] [gc worker] 5962603b1980006 gc in process, safePoint: 402954516569260032, successful regions: 520, failed regions: 0, total cost time: 20m0.307461863s