{"begin":1676278685,"end":1676278746,"serverless_tenant_id":"7777","serverless_project_id":"8888","serverless_cluster_id":"9999","schema_name":"test","digest":"eaf1d3f8340faa334054cd1a3e1f747e708ad6a6bf912a62692fe9f06128c0b4","plan_digest":"7c654bab14898f8e192808feda72c6044866c2becf16e574e80134123cad4dec","stmt_type":"Select","normalized_sql":"select * from `t1` join `t2` join `t3` join `t7` join `t5` join `t6` join `t4` join `t8`","table_names":"test.t1,test.t2,test.t3,test.t7,test.t5,test.t6,test.t4,test.t8","is_internal":false,"sample_sql":"SELECT * FROM t1 JOIN t2 JOIN t3 JOIN t7 JOIN t5 JOIN t6 JOIN t4 JOIN t8","charset":"utf8mb4","collation":"utf8mb4_bin","prev_sql":"","sample_plan":"hR4sMAkxN18yNQkwCTEwOgEA8GU1MzY2MTYyMjA0MzkzNDcyCUNBUlRFU0lBTiBpbm5lciBqb2luCTAJdGltZToxLjE1bXMsIGxvb3BzOjEsIGJ1aWxkX2hhc2hfdGFibGU6e3RvdGFsOjg2MS4zwrVzLCBmZXRjaDoZEABiATIsOjBzfQkwIEJ5dGVzEQgECjEBpQw0MShCASIAKU6sAHKcABQ3NzYuNcIBc4KeABA1NTAuNAUrBGZlAZ4ZEGaeAAAyBZ4AOUqeAHKWABA0OTQuNwVrgpYACDIyMw0rCZYZEGaWABgzCTMxXzU0OpYAGAlkYXRhOlQhkShGdWxsU2Nhbl81MzHFBDY3PigBZGNvcF90YXNrOiB7bnVtOiAxLCBtYXg6IDgxKVFEcHJvY19rZXlzOiAwLCBycGNfEScBDAB0QRoUIDc1MS42BeloY29wcl9jYWNoZV9oaXRfcmF0aW86IDAuMDAsCcoFbAhfZHUFGhRuOiA4LjIpjnhtYXhfZGlzdHNxbF9jb25jdXJyZW5jeTogMX0JMjQ3TTAITi9BDfgYMihQcm9iZVUsAAlO+AAAMRH4CDEyMS1gNYti+QAENTdNIZL7AAQ4MQ0uwvsADDcuMTklNab7ACQ0CTQzXzUxCTFfbc4ECXQh6Yg6dDQsIGtlZXAgb3JkZXI6ZmFsc2UsIHN0YXRzOnBzZXVkbyUJBGt2JX8EOnsltwQwc3XNDH0sIHNBKSBkZXRhaWw6IHtlyi33ODEsIGdldF9zbmFwc2hvdC30CDIyLgm+NHJvY2tzZGI6IHtibG9jQUhZAChjb3VudDogMn19fSG7AQRtTQAzOr8BAQF2TQMEMzONVjXCAGKBLQBfRoEEEDE1Mi4yJVoAZmXjGRAFMlKBBGVNBDQ4ik0DBDQ3JUwYbWU6ODUuMQVnFZJiVAIEMTVteJZUAhFZAGP+TwOeTwMENDY6kAFOTwMENDUR+gQxM2nvgvkACDkxNm0fjvkAEDg2NS44JVLC+QAINy42CTq6TQMENDVGTQMANf5NA8ZNAxH4vk0D5TgEMjc6vQEuAQByVQMEODWiogYINTE5bfFpVRkQZlUD5TgEMzU6VQMBAXKWAAQ0NSnLVV4FYkrpAwQyMbF9CZQZEAUyaukDBDAoNmoITu8CBDM5Ve8ENTSe6gMEOTay8QIAOTH5yvECADXSOQcEMzg6LQJS+wCV5AgxMjBlkTWMAGNaMAgEOTgJj47oAwQ5MQlVyvUAADQWUQm65gMEMzdG5gMAM/7mA8LmAwAzSde+5ANlRgQyOTq3AQEBdkYDBDIxPrUCZRZOSAMENDHtXG1IFRAFMmZIAwAzjn4KADMmfgoANu2Ygk4CDDEuMDUObQyOTgIMMS4wMQEsyk4CADnJx6ZOAhInCAAzjnwKADMifAoAOUntjvQAADcByP70AHL0AAQxNy3qpvQAEnUKADNKdQoAMf5CA8JCAwQ1MhpHCb5EAw==","sample_binary_plan":"6ydICuYnCgtIYXNoSm9pbl8yNRKhEy4QAAw3EoMJLhAAYDkS9gMKDlRhYmxlUmVhZGVyXzMyEuwBChAFE1RGdWxsU2Nhbl8zMSEBAAAAOA0/QSkAAQHwVYjDQDgCQAJKDAoKCgR0ZXN0EgJ0MVIea2VlcCBvcmRlcjpmYWxzZSwgc3RhdHM6cHNldWRvan50aWt2X3Rhc2s6e3RpbWU6MHMsIGxvb3BzOjF9LCBzAWvwXmRldGFpbDoge3RvdGFsX2tleXM6IDEsIGdldF9zbmFwc2hvdF90aW1lOiA1Mi41wrVzLCByb2Nrc2RiOiB7YmxvY2s6IHtjYWNoZV9oaXRfY291bnQ6IDJ9fX1w////CQMEAXgJCDj///8BGgECIVVVVVWVtwUd3SQBQAFSFWRhdGE6PgoBBFoTBX4EOTAFewRsbwW+FGKhAWNvcAnbECB7bnVtBbRAbWF4OiAxLjA3bXMsIHByb2MNzxgwLCBycGNfEScBDAVUASwAMQEsFGNvcHJfYxXERHJhdGlvOiAwLjAwLCBidWlsZAVqCF9kdQUaGG46IDE3LjMFkHBtYXhfZGlzdHNxbF9jb25jdXJyZW5jeTogMX1w9y73AEb5AQg0EupG+QEAM4r5AQAygvkBAHz++QE2+QEEMzkF7ABy9vcBAAGu9wEIM1oVJaMMNjYuMgV9kvkBADUhzf75AXL5AQw3Ljk2BZCi+QFB8BiqqqqqnCcuSfAMhNeXQUXwWBRDQVJURVNJQU4gaW5uZXIgam9pbloWBfgQNDIxLjEFaRH5ADtJiRRoYXNoX3SBQQA6abMMOjI0MU2NEGZldGNoHRAFMhg6MHN9EocJnYYMMzUS9T6GBAA4To0CADeKjQIAM/6NAsKNAgA4JRcAcvaNArKEBAg3WhQllQQxMp6FBAg5ODQFpo6MAgQ5MQlWwoUEDDcuNDcFZqKMAgQS/Tr4AQQ0ME5+BgA5ivgBADeC+AEAfv6FBDaFBAgyMy7++gEl+rKHBAA5bY8IMTU0Oo8DAKVigQYMOTY2Lqb+AQg4OTUN2MoAAgA1CWiiAAIIGgEBsowESfcENDUpeYaKBAQxMQ36jYoVEJWKoQ5Aq6pa56mB90EpAIDgN3nDQUOCDgUMODU0LknrgoQADDUxOS7JrwmEGRAVhAQSsy6kCQw0MRKOLh4FDDQzEvs+JgMANkomAwQ0NYomAwA1/iYDwiYDUU7+IAWqIAUENDVNKQQxM+kcMaVqJAMAMbIkAwA2EdbKJAMANkm9oiQDBBL8Pv4BADhO/gGOHAcANv7+Ab7+AQA0/iQFyiQFBDQ3GqsJBDg1oiMFCDgxNRpLDI4hBwA3FVrC/wEIOC4ywiMFAAKyIwUarwkEMzMahAlR/GKvCQgxNTIa0wqJoRkQmaE2kQQAOUK3BwA1TjUOADWONQ4ANP6TAr6TAgQyMq2P/pEEqpEEBDUxLZcIMTIxOjgGZpMECDg1N829lpQC0evClAIINy4xyaGmkwQA+jqTBAQ1NEqTBAA1jjwOADj+AALCAAIANP4AAkkAAAGqPg4ENTONkwQ2N41ncZYAo2K2CQg4MTUSTAuS/QEINTEuyerC/QHOkQS2tAmNkQA5ojIJCDIyM20liZEZEJWRDjgKxrYJCDc3Njp/AWIVBQg1NTBtfQmEGRAVhEQhhqwaM3plokMpF24FtbW4k0ZqNwoWuQoIMS4xEhIQMf5ifwAEODY2Qw8ZEChidWlsZDowc30YAQ==","plan_hint":"hash_join(@`sel_1` `test`.`t1`), use_index(@`sel_1` `test`.`t1` ), use_index(@`sel_1` `test`.`t2` ), hash_join(@`sel_1` `test`.`t3`), use_index(@`sel_1` `test`.`t3` ), use_index(@`sel_1` `test`.`t7` ), hash_join(@`sel_1` `test`.`t5`), use_index(@`sel_1` `test`.`t5` ), use_index(@`sel_1` `test`.`t6` ), hash_join(@`sel_1` `test`.`t4`), use_index(@`sel_1` `test`.`t4` ), use_index(@`sel_1` `test`.`t8` )","index_names":null,"exec_count":1,"sum_errors":0,"sum_warnings":0,"sum_latency":3546774,"max_latency":3546774,"min_latency":3546774,"sum_parse_latency":76266,"max_parse_latency":76266,"sum_compile_latency":1159979,"max_compile_latency":1159979,"sum_num_cop_tasks":8,"max_cop_process_time":0,"max_cop_process_address":"","max_cop_wait_time":0,"max_cop_wait_address":"","sum_process_time":0,"max_process_time":0,"sum_wait_time":0,"max_wait_time":0,"sum_backoff_time":0,"max_backoff_time":0,"sum_total_keys":8,"max_total_keys":8,"sum_processed_keys":0,"max_processed_keys":0,"sum_rocksdb_delete_skipped_count":0,"max_rocksdb_delete_skipped_count":0,"sum_rocksdb_key_skipped_count":0,"max_rocksdb_key_skipped_count":0,"sum_rocksdb_block_cache_hit_count":16,"max_rocksdb_block_cache_hit_count":16,"sum_rocksdb_block_read_count":0,"max_rocksdb_block_read_count":0,"sum_rocksdb_block_read_byte":0,"max_rocksdb_block_read_byte":0,"commit_count":0,"sum_get_commit_ts_time":0,"max_get_commit_ts_time":0,"sum_prewrite_time":0,"max_prewrite_time":0,"sum_commit_time":0,"max_commit_time":0,"sum_local_latch_time":0,"max_local_latch_time":0,"sum_commit_backoff_time":0,"max_commit_backoff_time":0,"sum_resolve_lock_time":0,"max_resolve_lock_time":0,"sum_write_keys":0,"max_write_keys":0,"sum_write_size":0,"max_write_size":0,"sum_prewrite_region_num":0,"max_prewrite_region_num":0,"sum_txn_retry":0,"max_txn_retry":0,"sum_backoff_times":0,"backoff_types":{},"auth_users":{"root":{}},"sum_mem":1976,"max_mem":1976,"sum_disk":0,"max_disk":0,"sum_affected_rows":0,"sum_kv_total":6862239,"sum_pd_total":25212,"sum_backoff_total":0,"sum_write_sql_resp_total":72215,"sum_result_rows":0,"max_result_rows":0,"min_result_rows":0,"prepared":false,"first_seen":"2023-02-13T16:58:47.799686975+08:00","last_seen":"2023-02-13T16:58:47.799686975+08:00","plan_in_cache":false,"plan_cache_hits":0,"plan_in_binding":false,"exec_retry_count":0,"exec_retry_time":0}
{"begin":1676278685,"end":1676278746,"serverless_tenant_id":"7777","serverless_project_id":"8888","serverless_cluster_id":"9999","schema_name":"test","digest":"e1a1c2706cdcfed4ac6b921a11ffaba090ccf0b5dff1c82567624ea14d503941","plan_digest":"1ba03a40221af760f29fd70bd16da99144c1446b9bccb413b5c621c9508a76c1","stmt_type":"Select","normalized_sql":"select * from `t8` join `t6` join `t7` join `t2` join `t4` join `t5` join `t3` join `t1`","table_names":"test.t8,test.t6,test.t7,test.t2,test.t4,test.t5,test.t3,test.t1","is_internal":false,"sample_sql":"SELECT * FROM t8 JOIN t6 JOIN t7 JOIN t2 JOIN t4 JOIN t5 JOIN t3 JOIN t1","charset":"utf8mb4","collation":"utf8mb4_bin","prev_sql":"","sample_plan":"lx4sMAkxN18yNQkwCTEwOgEA8GU1MzY2MTYyMjA0MzkzNDcyCUNBUlRFU0lBTiBpbm5lciBqb2luCTAJdGltZToxLjAxbXMsIGxvb3BzOjEsIGJ1aWxkX2hhc2hfdGFibGU6e3RvdGFsOjY2OC41wrVzLCBmZXRjaDoZEABiATIsOjBzfQkwIEJ5dGVzEQgECjEBpQw0MShCASIAKU6sAHKcABQ1NzEuOMIBc4KeABAzNzMuNgUrBGZlAZ4ZEGaeAAAyBZ4AOUqeAHKWABAzMzIuMgVrgpYAEDE1OS40BSsJlhkQZpYAGDMJMzFfNTQ6lgAYCWRhdGE6VCGRKEZ1bGxTY2FuXzUzMcUENTENZxWSaGNvcF90YXNrOiB7bnVtOiAxLCBtYXg6IDYwOQ29RHByb2Nfa2V5czogMCwgcnBjXxEpAQwAdEEcFCA1OTAuOQXAaGNvcHJfY2FjaGVfaGl0X3JhdGlvOiAwLjAwLAnMBW4IX2R1BRoYbjogNy42MQU6eG1heF9kaXN0c3FsX2NvbmN1cnJlbmN5OiAxfQkyNDdNMghOL0EN+hgyKFByb2JlVS4ACU76AAAxEfoMOTkuNwVnhvoABDg1DcyO+gAQNjY3LjMFWcr6AAQwNQU6pvoAJDQJNDNfNTEJMV9tzwQJdCHqiDp0Mywga2VlcCBvcmRlcjpmYWxzZSwgc3RhdHM6cHNldWRvJQgEa3YlfgQ6eyW2CDBzLDEODH0sIHNBKiBkZXRhaWw6IHtlyy32ODEsIGdldF9zbmFwc2hvdC3zADER+DRyb2Nrc2RiOiB7YmxvY0FJOf8oY291bnQ6IDJ9fX0hugEEbU4AMzq+AQEBdk4DBDU2PsIBZRwAX0aCBAgxNTAy5AMZEAUyUoIEZU4ENDiKTgMENDclTBRtZToxMDgt/IJVAgg5MTENk45VAgg4ODBtfQBjvk8DCDYuNolJplUCCfsANjqRAU5PAwQ0NRn7ADaeSgQIOTM4Dc2O+wAMOTEwLokQwvsACDcuNGnjpvsAZVAENDVGUAMANP5QA8ZQA8nBvk4D5ToEMjc6vQEuAQByVgMINzAwPsgBZSRKVgMINDA2rRgQZmV0Y2gdEAUyUlYD5ToEMzU6VgMBAXKWAAQzNUKuBQVkSpYACDEzNU0wCZYZEAUyUpYASfEAMDqWAE7xAgQzOVHxRmIIXjoHCDcwNo0WjvACCDY1NRouCcLwAgg2LjG+QAYF+gQzODouAlL6AJXmADlCXAle+gAEODIexgiO+gAINzg1TXvK+gAAN2kuuuoDBDM3RuoDADf+6gPC6gMANB6FCb7sA2VOBDI5Or4BAQF2TgMEODFNY9WnZRxOTgMEOTJNvG1OFRAFMmZOAwAzjogKADMiiAoAN6njFZBeUgIIOTk4jXSOUgIEOTTqPAbWhgoAM46GCgAzIoYKBDcxLV+C+gAIODM1qjEICDc5N95MAwQxNho7Db5MA0qGCgA4/kwDwkwDBDI1LVG+TAM=","sample_binary_plan":"/ydICvonCgtIYXNoSm9pbl8yNRKzEy4QAAw3Eo0JLhAAYDkS/AMKDlRhYmxlUmVhZGVyXzMyEuwBChAFE1RGdWxsU2Nhbl8zMSEBAAAAOA0/QSkAAQHwVYjDQDgCQAJKDAoKCgR0ZXN0EgJ0OFIea2VlcCBvcmRlcjpmYWxzZSwgc3RhdHM6cHNldWRvan50aWt2X3Rhc2s6e3RpbWU6MHMsIGxvb3BzOjF9LCBzAWvwXmRldGFpbDoge3RvdGFsX2tleXM6IDEsIGdldF9zbmFwc2hvdF90aW1lOiAyNS4zwrVzLCByb2Nrc2RiOiB7YmxvY2s6IHtjYWNoZV9oaXRfY291bnQ6IDJ9fX1w////CQMEAXgJCDj///8BGgECIVVVVVWVtwUd3SQBQAFSFWRhdGE6PgoBBFoVBX4ENzENfQRsbwXAFGKlAWNvcAndECB7bnVtBbYkbWF4OiA4MzUuNgWpDHByb2MN0xgwLCBycGNfESkBDAVYFCA3OTcuNAUuFGNvcHJfYxXKRHJhdGlvOiAwLjAwLCBidWlsZAVuCF9kdQUaGG46IDE2LjgFOnBtYXhfZGlzdHNxbF9jb25jdXJyZW5jeTogMX1w9y79AAQS+j7/AQA0Tv8BADOK/wEANv7/AcL/AQgzLjUF7gBy9v8BAAGu/wEIM1oTJacENzEFe4b9ARA5OTguOQUsjv0BDDk0MC4JWsL9AQg3LjYJOqL9AUH6GKqqqqqcJy5J+gyE15dBRfpYFENBUlRFU0lBTiBpbm5lciBqb2luWhYF+ggzODEteBH9ADtJjRRoYXNoX3SBSwA6ab0MOjE5Mm0lEGZldGNoHRAFMhg6MHN9Eo8JnZAEMzVGkAQAOE6RAgA3ipECADf+kQK+kQIENDFtufqRArKQBAA3jZAEOTFt/DGWapAEBDI5DamOkwIINzg1DS7CkwIINi43vpAEPo8GBDQwTv8BADmK/wEAMv7/Ab7/AQQzMW3p+v8BspAEADkt/wA3pv8BCDcwNm2Wjv8BCDY1NW3vyv8BADGpoaqSBAABzpIEDDU5LjelY1H8ZpIEBDM1rWCNkhUQlZKhFkCrqlrnqYH3QSkAgOA3ecNBQ4IWBQg3MDBtJoKEAAg0MDZNKQmEGRAVhAQStS62CQQ0MTYmBQw0MxL7OrcHDDQ2EupCtgkENDWKJwMANIInAwB8/rYJNrYJADGJE/olA64kBQQ0Nc27CDEwNjqlAWYlBRA5MzguMkVVjiYDBDkx6rgHADRJvaImAwQS/T7+AU4kBwA0jiQHADWC/gEAfv7+ATb+AQQyMs2n+gACriUFBDQ3VQAAOI36caVqAAIEMTGqtQsIODgwTS7KJgUANhbvC6IAAoGiyrgJBDU2oiYFBDUwDfyJohkQmaIyuAkANEZIDgA1TkgOADWOSA4AM/6UAr6UAgQxN00W+pQCrpQEADUeSA4AOT68BmaTAgg2ODXNOY6TBAQ2NhHXwpMCCDcuMLq5B0K4CQA1TkgOADWOSA4AMf7/Ab7/AQQyNxoTCPr/Aa6TBAQ1Mxq4CQA1HjQMhpIECDYwOY1kjv8BCDU5ME0tyv8BxkoO0rgJBDMyDdER/Wa4CQA1HrMMkZIREJWSCBoBAcq4CQA1QjkLYoQACDM3MzIWBRkQFYREIYasGjN6ZaJDKRduBbW1uJNGajkKABQSTw8YMS4wMW1zLIYDAQg2NjgaiQspAxkQKGJ1aWxkOjBzfRgB","plan_hint":"hash_join(@`sel_1` `test`.`t8`), use_index(@`sel_1` `test`.`t8` ), use_index(@`sel_1` `test`.`t6` ), hash_join(@`sel_1` `test`.`t7`), use_index(@`sel_1` `test`.`t7` ), use_index(@`sel_1` `test`.`t2` ), hash_join(@`sel_1` `test`.`t4`), use_index(@`sel_1` `test`.`t4` ), use_index(@`sel_1` `test`.`t5` ), hash_join(@`sel_1` `test`.`t3`), use_index(@`sel_1` `test`.`t3` ), use_index(@`sel_1` `test`.`t1` )","index_names":null,"exec_count":1,"sum_errors":0,"sum_warnings":0,"sum_latency":2931201,"max_latency":2931201,"min_latency":2931201,"sum_parse_latency":78640,"max_parse_latency":78640,"sum_compile_latency":982585,"max_compile_latency":982585,"sum_num_cop_tasks":8,"max_cop_process_time":0,"max_cop_process_address":"","max_cop_wait_time":0,"max_cop_wait_address":"","sum_process_time":0,"max_process_time":0,"sum_wait_time":0,"max_wait_time":0,"sum_backoff_time":0,"max_backoff_time":0,"sum_total_keys":8,"max_total_keys":8,"sum_processed_keys":0,"max_processed_keys":0,"sum_rocksdb_delete_skipped_count":0,"max_rocksdb_delete_skipped_count":0,"sum_rocksdb_key_skipped_count":0,"max_rocksdb_key_skipped_count":0,"sum_rocksdb_block_cache_hit_count":16,"max_rocksdb_block_cache_hit_count":16,"sum_rocksdb_block_read_count":0,"max_rocksdb_block_read_count":0,"sum_rocksdb_block_read_byte":0,"max_rocksdb_block_read_byte":0,"commit_count":0,"sum_get_commit_ts_time":0,"max_get_commit_ts_time":0,"sum_prewrite_time":0,"max_prewrite_time":0,"sum_commit_time":0,"max_commit_time":0,"sum_local_latch_time":0,"max_local_latch_time":0,"sum_commit_backoff_time":0,"max_commit_backoff_time":0,"sum_resolve_lock_time":0,"max_resolve_lock_time":0,"sum_write_keys":0,"max_write_keys":0,"sum_write_size":0,"max_write_size":0,"sum_prewrite_region_num":0,"max_prewrite_region_num":0,"sum_txn_retry":0,"max_txn_retry":0,"sum_backoff_times":0,"backoff_types":{},"auth_users":{"root":{}},"sum_mem":1235,"max_mem":1235,"sum_disk":0,"max_disk":0,"sum_affected_rows":0,"sum_kv_total":6110824,"sum_pd_total":27029,"sum_backoff_total":0,"sum_write_sql_resp_total":39390,"sum_result_rows":0,"max_result_rows":0,"min_result_rows":0,"prepared":false,"first_seen":"2023-02-13T16:58:47.82009329+08:00","last_seen":"2023-02-13T16:58:47.82009329+08:00","plan_in_cache":false,"plan_cache_hits":0,"plan_in_binding":false,"exec_retry_count":0,"exec_retry_time":0}
{"begin":1676278685,"end":1676278746,"serverless_tenant_id":"7777","serverless_project_id":"8888","serverless_cluster_id":"9999","schema_name":"test","digest":"57eaa0dcb1a82fa310d42012262e4a69ebb75e47b4e3386bd0a8d7b402fe000a","plan_digest":"2bf8831e5b8b08754f857c59fa88fd054c3550fe70452a9b26a8da064d7e059d","stmt_type":"Select","normalized_sql":"select * from `t7` join `t5` join `t8` join `t1` join `t2` join `t6` join `t4` join `t3`","table_names":"test.t7,test.t5,test.t8,test.t1,test.t2,test.t6,test.t4,test.t3","is_internal":false,"sample_sql":"SELECT * FROM t7 JOIN t5 JOIN t8 JOIN t1 JOIN t2 JOIN t6 JOIN t4 JOIN t3","charset":"utf8mb4","collation":"utf8mb4_bin","prev_sql":"","sample_plan":"mB4sMAkxN18yNQkwCTEwOgEA8GU1MzY2MTYyMjA0MzkzNDcyCUNBUlRFU0lBTiBpbm5lciBqb2luCTAJdGltZToxLjE3bXMsIGxvb3BzOjEsIGJ1aWxkX2hhc2hfdGFibGU6e3RvdGFsOjkzMS41wrVzLCBmZXRjaDoZEABiATIsOjBzfQkwIEJ5dGVzEQgECjEBpQw0MShCASIAKU6sAHKcABQ4NTcuN8IBc4KeAAg1NzkNKwRmZQGeGRBmngAAMgWeADlKngBylgAINDU0DWuClgAQMjY0LjMFwQmWGRBmlgAYMwkzMV81NDqWABgJZGF0YTpUIZEoRnVsbFNjYW5fNTMxxQw3OC42BWcVknBjb3BfdGFzazoge251bTogMSwgbWF4OiA4MjUuNAUrRHByb2Nfa2V5czogMCwgcnBjXxEpAQwAdEEcDCA3NzINwGhjb3ByX2NhY2hlX2hpdF9yYXRpbzogMC4wMCwJzAVuCF9kdQUaEG46IDEwDWh4bWF4X2Rpc3RzcWxfY29uY3VycmVuY3k6IDF9CTI0N00yCE4vQQ36GDIoUHJvYmVVLgAJTvoAADER+ggxMDAFzob5AAQ5OA2RjvkAQXoANQVZwvkACDguNAk6pvkAJDQJNDNfNTEJMV9tzgQJdCHpiDp0NCwga2VlcCBvcmRlcjpmYWxzZSwgc3RhdHM6cHNldWRvJQcEa3YlfQQ6eyW1BDBzdc0MfSwgc0EpIGRldGFpbDoge2XKLfU4MSwgZ2V0X3NuYXBzaG90LfIEMjRNSjRyb2Nrc2RiOiB7YmxvY0FIOf4oY291bnQ6IDJ9fX0huQEEbU0AMzq9AQEBdk0DBDg1nk0DBDE2ESsAZmXjGRB6TQMENDiKTQMENDclTBhtZTo5OS45JfuCVAIIOTEyLS6WVAIANg0uAGO+TQMIOC4wiUemVAKFRwQ0NjqQAU5NAwQ0NRH6EDEzMS44lvsAgUhJ5477AAg3ODEtVML7AAg3LjcJaKb7AGVPBDQ1Rk8DADL+TwPGTwOxmb5PA+U6BDI3Or8BLgEAclcDBDc5pjoHBDEwLcppVxkQZlcD5ToEMzU6VwMBAXKWAAg0MDQNa3VbBWQAX0ZuCAgxOTNNiwmWGRAFMlJuCEnzADA6lgBO8wIEMzlR8wQ1Nj5/BF46BxA5MzUuMmUdjvICCDg3Ms1vyvICADLpzabyAgX6BDM4Oi4CUvoAmecAMqL6AAQ3NKr6AAQ5Mv7nBK7nBGXsBDM3RuwDADj+7APG7AMANy0mvuwDZU4EMjk6vgEBAXZOAwQ3Mp5OAwgyMTUayAlpThkQek4DADOOiAoAMyKICgQ5NU31deBmTgMesAuSTgMEODNNrcpOAwA1FvAKvk4DjogKADMqiAqiNggMMS4wMQ5yDY75AAg5NDlNVcL5AAAxUY+m+QBpTUqICgA3/k0Dwk0DBDM4GiwJvk0D","sample_binary_plan":"gChICvsnCgtIYXNoSm9pbl8yNRK0Ey4QAAw3Eo4JLhAAYDkS+wMKDlRhYmxlUmVhZGVyXzMyEuwBChAFE1RGdWxsU2Nhbl8zMSEBAAAAOA0/QSkAAQHwVYjDQDgCQAJKDAoKCgR0ZXN0EgJ0N1Iea2VlcCBvcmRlcjpmYWxzZSwgc3RhdHM6cHNldWRvan50aWt2X3Rhc2s6e3RpbWU6MHMsIGxvb3BzOjF9LCBzAWvwXmRldGFpbDoge3RvdGFsX2tleXM6IDEsIGdldF9zbmFwc2hvdF90aW1lOiAzOC42wrVzLCByb2Nrc2RiOiB7YmxvY2s6IHtjYWNoZV9oaXRfY291bnQ6IDJ9fX1w////CQMEAXgJCDj///8BGgECIVVVVVWVtwUd3SQBQAFSFWRhdGE6PgoBBFoWBX4QMTA5LjkFfgRsbwXBFGKjAWNvcAneECB7bnVtBbdAbWF4OiAxLjAxbXMsIHByb2MN0hgwLCBycGNfEScBDAVXFCA5NDkuMgVYFGNvcHJfYxXJRHJhdGlvOiAwLjAwLCBidWlsZAVsCF9kdQUaEG46IDE3DTpwbWF4X2Rpc3RzcWxfY29uY3VycmVuY3k6IDF9cPcu/AAEEvw+/gEANE7+AQAziv4BADX+/gG+/gEMMjguNyUoAHL2/gEAAa7+AQgzWhUlpww5NS40BX0x/QClYv0BCDkzOQ2pjv8BCDg4Mw0uwv8BCDcuNQmUov8BQfsYqqqqqpwnLkn7DITXl0FF+1AUQ0FSVEVTSUFOIGlubmVyIGpvaW5N+hA0NzIuNTL9AAA7SY8UaGFzaF90gUwAOmm+FDoyMTUuMwUrEGZldGNoHRAFMhg6MHN9Eo8JnZEEMzVGkwIAOE6TAgA3ipMCADj+kwLCkwJxgfqTArKRBAA3UZMAMk05ipMCBDc0jSqOkwIIOTI2rWjCkwIIOC4wKf+ikwJC/wEENDBO/wEAOYr/AQAx/v8Bwv8BADTNEvr/AbKSBAA5Lf8ENTam/wEEMzWq/wEIODcyjezC/wEMNy4yNmX+ov8BCBoBAc6SBAQwNJ6SBBAxOTMuOAWUiZIZEJWSoRZAq6pa56mB90EpAIDgN3nDQUOCFgUINzk3OoEBADsFUkoWBQg1MTANrwmEGRAFMqUWALUutwkQNDESkAm9Jgw0MxL9OrkHBDQ2SicDBDQ1iicDADL+JwPCJwMAOI1P+icDriYFBDQ1zb0IMTMxTQCGJwUIODI1LaiOJwUINzgxbf/KKAMAN+lRoigDRicFTiYHADSOJgcANv4AAr4AAgAzcYL6AAIAAaq5CQA09SY+tgtquQkEMTJNqY7/AQQ4Nf4mB6omB4GjyrkJBDg1nqMEBDE2ESuJoxkQmaMySg4ANEZKDgA1TkoOADWOSg4ANP6TAr6TAgQyNC3q+pMCrpMEDDUxWhQSTAwIMTAwxZGKkQQEOTjti5aSAgA3jb/CkQQIOC40/pEEADVOSg4ANY5KDgAz/v4Bwv4BCDkuMSWC+v4BrpEEADUeSg4AN/EOiv8BADIedg6O/wEINzcyGnwNwv8BBDEwTWeikAbauAkENTSekQQIMjY0Dc6JkRkQlZEBhMa4CQQ4Naa4CQA3HsoPCYQZEBWERCGGrBozemWiQykXbgW1tbiTRmo5Cm3/CC4xNw4dElEAYjcKCDkzMW3QCX8ZEChidWlsZDowc30YAQ==","plan_hint":"hash_join(@`sel_1` `test`.`t7`), use_index(@`sel_1` `test`.`t7` ), use_index(@`sel_1` `test`.`t5` ), hash_join(@`sel_1` `test`.`t8`), use_index(@`sel_1` `test`.`t8` ), use_index(@`sel_1` `test`.`t1` ), hash_join(@`sel_1` `test`.`t2`), use_index(@`sel_1` `test`.`t2` ), use_index(@`sel_1` `test`.`t6` ), hash_join(@`sel_1` `test`.`t4`), use_index(@`sel_1` `test`.`t4` ), use_index(@`sel_1` `test`.`t3` )","index_names":null,"exec_count":1,"sum_errors":0,"sum_warnings":0,"sum_latency":3244086,"max_latency":3244086,"min_latency":3244086,"sum_parse_latency":103364,"max_parse_latency":103364,"sum_compile_latency":1006400,"max_compile_latency":1006400,"sum_num_cop_tasks":8,"max_cop_process_time":0,"max_cop_process_address":"","max_cop_wait_time":0,"max_cop_wait_address":"","sum_process_time":0,"max_process_time":0,"sum_wait_time":0,"max_wait_time":0,"sum_backoff_time":0,"max_backoff_time":0,"sum_total_keys":8,"max_total_keys":8,"sum_processed_keys":0,"max_processed_keys":0,"sum_rocksdb_delete_skipped_count":0,"max_rocksdb_delete_skipped_count":0,"sum_rocksdb_key_skipped_count":0,"max_rocksdb_key_skipped_count":0,"sum_rocksdb_block_cache_hit_count":16,"max_rocksdb_block_cache_hit_count":16,"sum_rocksdb_block_read_count":0,"max_rocksdb_block_read_count":0,"sum_rocksdb_block_read_byte":0,"max_rocksdb_block_read_byte":0,"commit_count":0,"sum_get_commit_ts_time":0,"max_get_commit_ts_time":0,"sum_prewrite_time":0,"max_prewrite_time":0,"sum_commit_time":0,"max_commit_time":0,"sum_local_latch_time":0,"max_local_latch_time":0,"sum_commit_backoff_time":0,"max_commit_backoff_time":0,"sum_resolve_lock_time":0,"max_resolve_lock_time":0,"sum_write_keys":0,"max_write_keys":0,"sum_write_size":0,"max_write_size":0,"sum_prewrite_region_num":0,"max_prewrite_region_num":0,"sum_txn_retry":0,"max_txn_retry":0,"sum_backoff_times":0,"backoff_types":{},"auth_users":{"root":{}},"sum_mem":1729,"max_mem":1729,"sum_disk":0,"max_disk":0,"sum_affected_rows":0,"sum_kv_total":6739319,"sum_pd_total":24165,"sum_backoff_total":0,"sum_write_sql_resp_total":58038,"sum_result_rows":0,"max_result_rows":0,"min_result_rows":0,"prepared":false,"first_seen":"2023-02-13T16:58:47.836069768+08:00","last_seen":"2023-02-13T16:58:47.836069768+08:00","plan_in_cache":false,"plan_cache_hits":0,"plan_in_binding":false,"exec_retry_count":0,"exec_retry_time":0}
{"begin":1676278685,"end":1676278746,"serverless_tenant_id":"7777","serverless_project_id":"8888","serverless_cluster_id":"9999","schema_name":"test","digest":"ec20b8d42ab80c7a922cafe4a47d1d805828fe997d9dcf87b4f8612732a938d5","plan_digest":"97bde8c30a2e8f5c2b32a942be4d11785b9ab21a82466dc2aa70f04bc353fbed","stmt_type":"Select","normalized_sql":"select * from `t6` join `t1` join `t3` join `t4` join `t5` join `t8` join `t7` join `t2`","table_names":"test.t6,test.t1,test.t3,test.t4,test.t5,test.t8,test.t7,test.t2","is_internal":false,"sample_sql":"SELECT * FROM t6 JOIN t1 JOIN t3 JOIN t4 JOIN t5 JOIN t8 JOIN t7 JOIN t2","charset":"utf8mb4","collation":"utf8mb4_bin","prev_sql":"","sample_plan":"jx4sMAkxN18yNQkwCTEwOgEA8GU1MzY2MTYyMjA0MzkzNDcyCUNBUlRFU0lBTiBpbm5lciBqb2luCTAJdGltZToxLjA4bXMsIGxvb3BzOjEsIGJ1aWxkX2hhc2hfdGFibGU6e3RvdGFsOjgwOS45wrVzLCBmZXRjaDoZEABiATIsOjBzfQkwIEJ5dGVzEQgECjEBpQw0MShCASIAKU6sAHKcABQ3MzcuN8IBc4KeAAg1MjkyngAZEGaeAAAyBZ4AOUqeAHKWABA0NzQuNZaWAAgyMzQNwQRmZSE0GRBmlgAYMwkzMV81NDqWABgJZGF0YTpUIZEoRnVsbFNjYW5fNTM1xQA0EWg1KWhjb3BfdGFzazoge251bTogMSwgbWF4OiA4NDMNvkRwcm9jX2tleXM6IDAsIHJwY18RKQEMAHRBHQAgIeUAOAXsaGNvcHJfY2FjaGVfaGl0X3JhdGlvOiAwLjAwLAnNBW4IX2R1BRoYbjogOC4wMwU6eG1heF9kaXN0c3FsX2NvbmN1cnJlbmN5OiAxfQkyNDdNMwhOL0EN+xgyKFByb2JlVS8ACU77AAAxEfsQMjIxLjQFaIL7AAw5NjQuCZOO+wAIOTE5LSnC+wAINy40Sbem+wAkNAk0M181MQkxX23RBAl0IeyIOnQ3LCBrZWVwIG9yZGVyOmZhbHNlLCBzdGF0czpwc2V1ZG8lCQRrdiV/BDp7JbcEMHN10Ax9LCBzQSwgZGV0YWlsOiB7Zc0t9zgxLCBnZXRfc25hcHNob3Qt9AQ0Ny0mNHJvY2tzZGI6IHtibG9jQUpZAChjb3VudDogMn19fSG7AQRtUAAzOr8BAQFyUAMIMzg4bSU1wmUeAF9GhAQQMTU3LjYl7QBmZVAZEAUyUoQEZVAENDiKUAMENDclTBhtZTo5Ny4xBWcVkl5PAwg5NDgNK45UAgQ4OdpNAww3LjE5BZGmUgIJ+AA2Oo4BTk0DBDQ1EfgEODgtX4b4AAQ1NQ0rjvgAEDkwNC4yBcAAY75HBAg3Ljepbab6AGVMBDQ1RkwDADX+TAPGTAMxJr5MA+U6BDI3Or4BLgEAclQDADhNLzXIAGLhgkpSAwg2MDFt7mlSGRAFMlJSA+U4BDM1OlIDAQFylAAIMzU3zUyClgAEMTOp0wmUEQ5mkgBJ7AAwOpIATuwCDDM5CTAW+QgENzWiOAYEODgNuZLsAgQzMd44Bgg4LjG+OAYF+gQzODooAlL6AAA3EfoAOfEHNYhi3gQAN7L6AAQxOE1MyuYDADapcbrmAwQzN0bmAwAz/uYDxuYDADdNS77mA2VKBDI5Or4BAQFySgMINDc2rU81wmUcSuADBDI0NjIHGRAFMlLgA0lUjoIKADMiggoIMjAwGoALFZNeVQIMMS4wNQ5yDJJNAwA5kTTCUwIINi42iUWmUwIJ+Y6ACgAzJoAKRowBZvkABDEynvkAMSXC9wAEMTUtiKb3AOUwADNKfAoANv5KA8JKAwQzMq08vkoD","sample_binary_plan":"9ydICvInCgtIYXNoSm9pbl8yNRKrEy4QAAw3EosJLhAAYDkS+QMKDlRhYmxlUmVhZGVyXzMyEuwBChAFE1RGdWxsU2Nhbl8zMSEBAAAAOA0/QSkAAQHwVYjDQDgCQAJKDAoKCgR0ZXN0EgJ0NlIea2VlcCBvcmRlcjpmYWxzZSwgc3RhdHM6cHNldWRvan50aWt2X3Rhc2s6e3RpbWU6MHMsIGxvb3BzOjF9LCBzAWvwXmRldGFpbDoge3RvdGFsX2tleXM6IDEsIGdldF9zbmFwc2hvdF90aW1lOiAzMi41wrVzLCByb2Nrc2RiOiB7YmxvY2s6IHtjYWNoZV9oaXRfY291bnQ6IDJ9fX1w////CQMEAXgJCDj///8BGgECIVVVVVWVtwUd3SQBQAFSFWRhdGE6PgoBBFoWBX4QMjc2LjIFfgRsbwXBFGKhAWNvcAneECB7bnVtBbdAbWF4OiAxLjEybXMsIHByb2MN0hgwLCBycGNfEScBDAVXECAxLjA1ASwUY29wcl9jFcdEcmF0aW86IDAuMDAsIGJ1aWxkBWoIX2R1BRoYbjogMTUuOQWQcG1heF9kaXN0c3FsX2NvbmN1cnJlbmN5OiAxfXD3LvoABBL7PvwBADRO/AEAM4r8AQAx/vwBvvwBBDE4/vwBKfwAAa78AQAzMfwEMDAtbDH8AKNq/AEp0I78ARA5OTcuOCXEwv4BDDYuNjQFOqL+AUH4GKqqqqqcJy5J+AyE15dBRfhQFENBUlRFU0lBTiBpbm5lciBqb2luDfsANEL3AgA7SY4UaGFzaF90gUkAOmm7FDoyNDcuNgWUEGZldGNoHRAFMgw6MHN9No4EDDM1Evw+kgIAOE6SAgA3ipICADP+kgK+kgIINDcuKYIAcv6OBKqOBAg3WhWFNww5NC4zJWtRkQClYpECCDk3OE1lkpMCBDE4DVrCkwIMNy42MQWUopMCQv8BBDQwTv8BADmK/wEANP7/Ab7/AQQyOf6RBMqRBAA5Lf8ENzVNfIr/AQA4sv8BBDMxDdfC/wEMOC4xN7b/AQgaAQHKkgQEMzWxNRH9ADeFYEqSBAQxM2miiZARDgUugY6hEkCrqlrnqYH3QSkAgOA3ecNBQ2oSBQAUZXsEODHpdxF+YhAFCDYwMW1LCYAZEBWCBBK1Lq4JEDQxEo0JKq4JBDQzRiEDADZKIQMENDWKIQMANf4hA74hAwQ0Nc0O/iAFqiAFBDQ1bSEEODgNfTGmaiAFADURqZIgBQQwNBoHCsIhAww3Ljc1tiEDBBL6Oh8HADROHwcANI4fBwA4/v8Bvv8BBDUyLYL6/wEAAaqxCQA09R8ENy7JizH/ZrAJCDk0OA0sjv8BBDg52rAJBDcujTeiHQeBnsawCQwzODguqYcR+2KgBAQxNTawCRkQmaAEkQkukAQIORL9OpECADVOPg4ANY4+DgA3/pECvpECBDQ3rY76kQKuPg4ANSI+DgQyMaayBwA2Ht0JjpICBDkxHokIypEEADRJK6KUAkYAAk5CDgA1jkIOADL+AAK+AAIENTIaxA36AAKukQQANR5CDggxNDQ6lwNmkQYIODQzGoQJjgACCDgwORrfC8IAAgg4LjAWRQyiAALWsgkINDc0DdGClAQEMjMxKBY0CRkQlZQBhK62CRa/EQg3Mzc6gQFiGAUINTI5TSoJhBkQFYREIYasGjN6ZaJDKRduBbW1uJNGgjcKDDEuMDgO6BGCAwEh0RZiCgl/GRAoYnVpbGQ6MHN9GAE=","plan_hint":"hash_join(@`sel_1` `test`.`t6`), use_index(@`sel_1` `test`.`t6` ), use_index(@`sel_1` `test`.`t1` ), hash_join(@`sel_1` `test`.`t3`), use_index(@`sel_1` `test`.`t3` ), use_index(@`sel_1` `test`.`t4` ), hash_join(@`sel_1` `test`.`t5`), use_index(@`sel_1` `test`.`t5` ), use_index(@`sel_1` `test`.`t8` ), hash_join(@`sel_1` `test`.`t7`), use_index(@`sel_1` `test`.`t7` ), use_index(@`sel_1` `test`.`t2` )","index_names":null,"exec_count":1,"sum_errors":0,"sum_warnings":0,"sum_latency":3010330,"max_latency":3010330,"min_latency":3010330,"sum_parse_latency":70958,"max_parse_latency":70958,"sum_compile_latency":941239,"max_compile_latency":941239,"sum_num_cop_tasks":8,"max_cop_process_time":0,"max_cop_process_address":"","max_cop_wait_time":0,"max_cop_wait_address":"","sum_process_time":0,"max_process_time":0,"sum_wait_time":0,"max_wait_time":0,"sum_backoff_time":0,"max_backoff_time":0,"sum_total_keys":8,"max_total_keys":8,"sum_processed_keys":0,"max_processed_keys":0,"sum_rocksdb_delete_skipped_count":0,"max_rocksdb_delete_skipped_count":0,"sum_rocksdb_key_skipped_count":0,"max_rocksdb_key_skipped_count":0,"sum_rocksdb_block_cache_hit_count":16,"max_rocksdb_block_cache_hit_count":16,"sum_rocksdb_block_read_count":0,"max_rocksdb_block_read_count":0,"sum_rocksdb_block_read_byte":0,"max_rocksdb_block_read_byte":0,"commit_count":0,"sum_get_commit_ts_time":0,"max_get_commit_ts_time":0,"sum_prewrite_time":0,"max_prewrite_time":0,"sum_commit_time":0,"max_commit_time":0,"sum_local_latch_time":0,"max_local_latch_time":0,"sum_commit_backoff_time":0,"max_commit_backoff_time":0,"sum_resolve_lock_time":0,"max_resolve_lock_time":0,"sum_write_keys":0,"max_write_keys":0,"sum_write_size":0,"max_write_size":0,"sum_prewrite_region_num":0,"max_prewrite_region_num":0,"sum_txn_retry":0,"max_txn_retry":0,"sum_backoff_times":0,"backoff_types":{},"auth_users":{"root":{}},"sum_mem":1235,"max_mem":1235,"sum_disk":0,"max_disk":0,"sum_affected_rows":0,"sum_kv_total":7252784,"sum_pd_total":28076,"sum_backoff_total":0,"sum_write_sql_resp_total":59015,"sum_result_rows":0,"max_result_rows":0,"min_result_rows":0,"prepared":false,"first_seen":"2023-02-13T16:58:47.852724885+08:00","last_seen":"2023-02-13T16:58:47.852724885+08:00","plan_in_cache":false,"plan_cache_hits":0,"plan_in_binding":false,"exec_retry_count":0,"exec_retry_time":0}
{"begin":1676278685,"end":1676278746,"serverless_tenant_id":"7777","serverless_project_id":"8888","serverless_cluster_id":"9999","schema_name":"test","digest":"e78977e78c0f7baf76055a2684bbb8c62e227bc630f17257abac85bffdfb69f5","plan_digest":"5a9c10ea3ebfad5ad11d6c899a7c01cf6e048d171a8b9b38567eee48f989a95a","stmt_type":"Select","normalized_sql":"select * from `t6` join `t4` join `t1` join `t3` join `t7` join `t8` join `t5` join `t2`","table_names":"test.t6,test.t4,test.t1,test.t3,test.t7,test.t8,test.t5,test.t2","is_internal":false,"sample_sql":"SELECT * FROM t6 JOIN t4 JOIN t1 JOIN t3 JOIN t7 JOIN t8 JOIN t5 JOIN t2","charset":"utf8mb4","collation":"utf8mb4_bin","prev_sql":"","sample_plan":"gR4sMAkxN18yNQkwCTEwOgEA8GU1MzY2MTYyMjA0MzkzNDcyCUNBUlRFU0lBTiBpbm5lciBqb2luCTAJdGltZToxLjIxbXMsIGxvb3BzOjEsIGJ1aWxkX2hhc2hfdGFibGU6e3RvdGFsOjk2Mi41wrVzLCBmZXRjaDoZEABiATIsOjBzfQkwIEJ5dGVzEQgECjEBpQw0MShCASIAKU6sAHKcABQ4NzIuNMIBc4KeABA0NzAuOQUrBGZlAZ4ZEGaeAAAyBZ4AOUqeAHKWAAg0MTANa4KWAAQyMBErCZYZEGaWABgzCTMxXzU0OpYAGAlkYXRhOlQhkShGdWxsU2Nhbl81MzXFBDM4LZwVk2hjb3BfdGFzazoge251bTogMSwgbWF4OiA4NzMtVERwcm9jX2tleXM6IDAsIHJwY18RKQEMAHRBHRQgODMwLjMlV2hjb3ByX2NhY2hlX2hpdF9yYXRpbzogMC4wMCwJzQVuCF9kdQUaFG46IDcuNSm8eG1heF9kaXN0c3FsX2NvbmN1cnJlbmN5OiAxfQkyNDdNMwhOL0EN+xgyKFByb2JlVS8ACU77AAAxFfsMMTUuNwWigvsADDEuMDRB6475AAwxLjAxASzC9wAMOC42NgWPpvcAJDQJNDNfNTEJMV9tzQQJdCHoiDp0NSwga2VlcCBvcmRlcjpmYWxzZSwgc3RhdHM6cHNldWRvJQUEa3YlewQ6eyWzBDBzdcwMfSwgc0EoIGRldGFpbDoge2XJLfM4MSwgZ2V0X3NuYXBzaG90LfAEMjAFvDRyb2Nrc2RiOiB7YmxvY0FEOfooY291bnQ6IDJ9fX0htQEEbUoAMzq5AQEBckoDEDU5Ni44BXE1vGUYAF9GfgQIMzMxLecQZmV0Y2gdEAUyUn4EZUoENDiKSgMENDclShRtZToxNjI2kQBeSAMMMS4yOEEhlk0CBDIzASwAY8ZEAwA2KSCmTQIJ9QA2OosBTkQDBDQ1FfUEMTI+0gRm9wBpGI73ABA5NDcuMSVOwvkAADgNOab4AGVFBDQ1RkUDADf+RQPGRQMAM03WvkcD5S8EMjc6vAEuAQByTwMEODGx24JPAwg1NTct8mlPGRBmTwPlLwQzNTpPAwEBcpYADDQ4MS46VAMFZErlAwQxNRErCZYZEAUyauUDADA6lgBO8AIEMzlR8Ag5MS6ppDUoau8CojMGBDk40YrC7wIIOS45Fr0IpvACZegEMzg6LAJS+ACZ3QQ4Oe3OivkABDI5gbOO6AMIMS4yJSXK9wAAMIkgpvcAZecEMzdG5wMAMf7nA8bnAwAyGnQJvucDZUkEMjk6uwEBAXZJAwQ0Na0WNb5lF0pJAwQyMTYuBxkQBTJmSQMAM454CgAzJngKADSqSgMAM/5QAoJQAsY2BmlGjnIKADMqcgoAOBqLCDWIZj8EADGqRgMAMSUiwkYDBDE4TYi+RgMAMUZGAwA2/kYDxkYDADctTb5GAw==","sample_binary_plan":"6SdICuQnCgtIYXNoSm9pbl8yNRKoEy4QAAw3EocJLhAAYDkS+QMKDlRhYmxlUmVhZGVyXzMyEuwBChAFE1RGdWxsU2Nhbl8zMSEBAAAAOA0/QSkAAQHwVYjDQDgCQAJKDAoKCgR0ZXN0EgJ0NlIea2VlcCBvcmRlcjpmYWxzZSwgc3RhdHM6cHNldWRvan50aWt2X3Rhc2s6e3RpbWU6MHMsIGxvb3BzOjF9LCBzAWvwXmRldGFpbDoge3RvdGFsX2tleXM6IDEsIGdldF9zbmFwc2hvdF90aW1lOiAyNy43wrVzLCByb2Nrc2RiOiB7YmxvY2s6IHtjYWNoZV9oaXRfY291bnQ6IDJ9fX1w////CQMEAXgJCDj///8BGgECIVVVVVWVtwUd3SQBQAFSFWRhdGE6PgoBBFoWBX4IMTE4DX4EbG8FwRRioQFjb3AJ3hAge251bQW3QG1heDogMS4xOW1zLCBwcm9jDdIYMCwgcnBjXxEnAQwFVwEsADMBLBRjb3ByX2MVx0RyYXRpbzogMC4wMCwgYnVpbGQFaghfZHUFGhhuOiAxOC41JQ5wbWF4X2Rpc3RzcWxfY29uY3VycmVuY3k6IDF9cPcu+gAEEvc+/AEANE78AQAzivwBADT+/AG+/AEENDAN7gBy9vwBAAGu/AEAMzH8DDQxLjYlbDH8AJ9q/AElz5b7AQQyNNL7AQg4LjEFjqL6AUH0GKqqqqqcJy5J9AyE15dBRfRQFENBUlRFU0lBTiBpbm5lciBqb2luDfcINDQ1DWkR9wA7SYoUaGFzaF90gUUAOmm3DDoyMTFtHhBmZXRjaB0QBTIYOjBzfRKKCZ2KBDM1RooEADhOjgIAN4qOAgAx/o4Cvo4CBDIy/o4CSY6yigQANy2XEDE4OS4zRQAxl26KBAAyqooE2o8CCDkuMLqQAgQS+jqKBAQ0ME78AQA5ivwBADP+/AG+/AEENDUtfv6KBK6KBAg5WhXFLwA5PokEAKNqiQQAMIVejooECDk4NW2/wocGDDkuOTlFjaqNBAABzo0EDDgxLjIFaVH2Yo0EBDE1ESuJjRkQlY2hEUCrqlrnqYH3QSkAgOA3ecNBQ4IRBRA4MTMuNJaEAAw1NTcuKRgJhBkQFYQEEqouqwkQNDESiAm9IQQ0M0YlAwA2SiUDBDQ1iiUDADf+JQO+JQMMMjMuOCUp+iUDriEFBDQ1sSEEMTItfFErBKIBZqsJBDAx4YSSJgMENDftEMImA8KyB0KsCQA0Th4HADSOHgcAOP79AcL9ARHu+v0BAAGqrAkMNDdaFKUiBDE2NiYEchwHADie+wEIMS4yEtcJwvkBCDcuNmkJqh8FAALKHwUINTk2bXJR9GIfBQQzMzasCRkQmZsEiwkuiwQAOUKOAgw1MhLqQjYOADWONg4ANYKOAgB8/jYOOjYOADD+iQS+iQQANSY0DvFXMZVujgKmrwcAMY21wo4CCDguNhbIDKKOAgQS/TqqCQA1TjQOADWONA4AMoL6AQB+/voBOvoBADUatg3+iASqiAQANSI0DgAzHqAPMfwApWKFBgQ4Nx5YCI6HBgg4MzAaggrCAAIINy41FsAIogACABrWrQkEMTA6ggdijgQEMjARKxYpCRkQlY4BhMqtCQQ3Mp6tCQQ0NzaEABkQFYREIYasGjN6ZaJDKRduBbW1uJNGai4KzYoELjISWwhRAGIDAQQ5Nh5PDikDGRAoYnVpbGQ6MHN9GAE=","plan_hint":"hash_join(@`sel_1` `test`.`t6`), use_index(@`sel_1` `test`.`t6` ), use_index(@`sel_1` `test`.`t4` ), hash_join(@`sel_1` `test`.`t1`), use_index(@`sel_1` `test`.`t1` ), use_index(@`sel_1` `test`.`t3` ), hash_join(@`sel_1` `test`.`t7`), use_index(@`sel_1` `test`.`t7` ), use_index(@`sel_1` `test`.`t8` ), hash_join(@`sel_1` `test`.`t5`), use_index(@`sel_1` `test`.`t5` ), use_index(@`sel_1` `test`.`t2` )","index_names":null,"exec_count":1,"sum_errors":0,"sum_warnings":0,"sum_latency":3617033,"max_latency":3617033,"min_latency":3617033,"sum_parse_latency":59992,"max_parse_latency":59992,"sum_compile_latency":812942,"max_compile_latency":812942,"sum_num_cop_tasks":8,"max_cop_process_time":0,"max_cop_process_address":"","max_cop_wait_time":0,"max_cop_wait_address":"","sum_process_time":0,"max_process_time":0,"sum_wait_time":0,"max_wait_time":0,"sum_backoff_time":0,"max_backoff_time":0,"sum_total_keys":8,"max_total_keys":8,"sum_processed_keys":0,"max_processed_keys":0,"sum_rocksdb_delete_skipped_count":0,"max_rocksdb_delete_skipped_count":0,"sum_rocksdb_key_skipped_count":0,"max_rocksdb_key_skipped_count":0,"sum_rocksdb_block_cache_hit_count":16,"max_rocksdb_block_cache_hit_count":16,"sum_rocksdb_block_read_count":0,"max_rocksdb_block_read_count":0,"sum_rocksdb_block_read_byte":0,"max_rocksdb_block_read_byte":0,"commit_count":0,"sum_get_commit_ts_time":0,"max_get_commit_ts_time":0,"sum_prewrite_time":0,"max_prewrite_time":0,"sum_commit_time":0,"max_commit_time":0,"sum_local_latch_time":0,"max_local_latch_time":0,"sum_commit_backoff_time":0,"max_commit_backoff_time":0,"sum_resolve_lock_time":0,"max_resolve_lock_time":0,"sum_write_keys":0,"max_write_keys":0,"sum_write_size":0,"max_write_size":0,"sum_prewrite_region_num":0,"max_prewrite_region_num":0,"sum_txn_retry":0,"max_txn_retry":0,"sum_backoff_times":0,"backoff_types":{},"auth_users":{"root":{}},"sum_mem":1002,"max_mem":1002,"sum_disk":0,"max_disk":0,"sum_affected_rows":0,"sum_kv_total":8443563,"sum_pd_total":418694,"sum_backoff_total":0,"sum_write_sql_resp_total":57130,"sum_result_rows":0,"max_result_rows":0,"min_result_rows":0,"prepared":false,"first_seen":"2023-02-13T16:58:47.869721801+08:00","last_seen":"2023-02-13T16:58:47.869721801+08:00","plan_in_cache":false,"plan_cache_hits":0,"plan_in_binding":false,"exec_retry_count":0,"exec_retry_time":0}
{"begin":1676278685,"end":1676278746,"serverless_tenant_id":"7777","serverless_project_id":"8888","serverless_cluster_id":"9999","schema_name":"test","digest":"e5456f013c5a84db0d61973405e4120aab912215f23dbda1ee951e387a84e5e1","plan_digest":"c26e14afbc4b2d34c7427bd77d67bcca9f7f282bd1d261d49701d40c2763bc1f","stmt_type":"Select","normalized_sql":"select * from `t3` join `t1` join `t8` join `t6` join `t2` join `t5` join `t4` join `t7`","table_names":"test.t3,test.t1,test.t8,test.t6,test.t2,test.t5,test.t4,test.t7","is_internal":false,"sample_sql":"SELECT * FROM t3 JOIN t1 JOIN t8 JOIN t6 JOIN t2 JOIN t5 JOIN t4 JOIN t7","charset":"utf8mb4","collation":"utf8mb4_bin","prev_sql":"","sample_plan":"hx4sMAkxN18yNQkwCTEwOgEA8GU1MzY2MTYyMjA0MzkzNDcyCUNBUlRFU0lBTiBpbm5lciBqb2luCTAJdGltZToxLjA5bXMsIGxvb3BzOjEsIGJ1aWxkX2hhc2hfdGFibGU6e3RvdGFsOjgxMC42wrVzLCBmZXRjaDoZEABiATIsOjBzfQkwIEJ5dGVzEQgECjEBpQw0MShCASIAKU6sAHKcABQ3MTguNMIBc4KeABA0NjUuMwUrBGZlAZ4ZEGaeAAAyBZ4AOUqeAHKWABA0MTAuNwVrgpYACDE4OQ0rCZYZEGaWABgzCTMxXzU0OpYAGAlkYXRhOlQhkShGdWxsU2Nhbl81MzHFDDg1Ljg2kgBoY29wX3Rhc2s6IHtudW06IDEsIG1heDogNjk0LVNEcHJvY19rZXlzOiAwLCBycGNfESkBDAB0QRwMIDY0OQVXaGNvcHJfY2FjaGVfaGl0X3JhdGlvOiAwLjAwLAnKBWwIX2R1BRoYbjogOS43MQU6eG1heF9kaXN0c3FsX2NvbmN1cnJlbmN5OiAxfQkyNDdNMAhOL0EN+BgyKFByb2JlVSwACU74AAAxEfgMMTgzLgmiNYte+QAMMS4wN0HojvcADDEuMDMBLMr3AAQyMrr3ACQ0CTQzXzUxCTFfbcoECXQh5Yg6dDQsIGtlZXAgb3JkZXI6ZmFsc2UsIHN0YXRzOnBzZXVkbyUFBGt2JXsEOnslsQQwc3XJDH0sIHNBJSBkZXRhaWw6IHtlxi3xODEsIGdldF9zbmFwc2hvdC3uBDI1Bbw0cm9ja3NkYjoge2Jsb2NBQjn6KGNvdW50OiAyfX19IbUBBG1HADM6uQEBAXZHAwQ3MAVvNbplEwBfRnkEBDIwSdwQZmV0Y2gVDgUuUnUEZUEENDiKQQMENDclRBBtZTo3NJ5IAgg3ODBtbI5KAgw3MTQuKVYAY8ZDAw34ukMDBDQ2OooBTkMDBDQ1EfoEOTcNzzWIXkIDCDg1Oa1jjvoADDgyNS5pDML6AAQxMA1opvoAZUYENDVGRgMAMv5GA8ZGAwA57Se+SAPlLQQyNzq+AS4BAHJQAwg3NjYNeTXKZSRKUgMIMzkzDStpVBkQBTJSVgPlLQQzNTpWAwEBcpYACDMwOC3NgpYABDE0Oi0HFRBmlgBp7AAwOpYATvICBDM5VfIAM22TFZJi8gIINjUuyceS8gIEMDLe8gIIOS40Fr0IpvICBfoEMzg6LgJS+gCV5ggxMDWe+wAIOTc5qvsACDkxNRroCMLtAwg3LjHpwqb7AGXtBDM3Ru0DADj+7QPC7QMENTkt877tA2VPBDI5Or8BAQFyTwMINDUxPqkGAGIOXAtK5QMIMjc2LcJp5RkQBTJS5QNJVY58CgAzInwKCDE5Nw1oglADDDEuMzMOWAmOTgMMMS4yOAEswlECCDguMRaeC6ZRAgn3jnsKADMiewoEMjiu9wAANAHLmvcAEqcKwvcABDE3TYqm9wAMNAk0MwHSQnsKADP+SAPCSAMENDLNJr5IAw==","sample_binary_plan":"7ydICuonCgtIYXNoSm9pbl8yNRKwEy4QAAw3EokJLhAAYDkS+QMKDlRhYmxlUmVhZGVyXzMyEuwBChAFE1RGdWxsU2Nhbl8zMSEBAAAAOA0/QSkAAQHwVYjDQDgCQAJKDAoKCgR0ZXN0EgJ0M1Iea2VlcCBvcmRlcjpmYWxzZSwgc3RhdHM6cHNldWRvan50aWt2X3Rhc2s6e3RpbWU6MHMsIGxvb3BzOjF9LCBzAWvwXmRldGFpbDoge3RvdGFsX2tleXM6IDEsIGdldF9zbmFwc2hvdF90aW1lOiA0Mi4zwrVzLCByb2Nrc2RiOiB7YmxvY2s6IHtjYWNoZV9oaXRfY291bnQ6IDJ9fX1w////CQMEAXgJCDj///8BGgECIVVVVVWVtwUd3SQBQAFSFWRhdGE6PgoBBFoWBX4QMjg3LjEFfgRsbwXBFGKhAWNvcAneECB7bnVtBbdAbWF4OiAxLjM0bXMsIHByb2MN0hgwLCBycGNfEScBDAVXECAxLjI3ASwUY29wcl9jFcdEcmF0aW86IDAuMDAsIGJ1aWxkBWoIX2R1BRoYbjogMTcuMgWQcG1heF9kaXN0c3FsX2NvbmN1cnJlbmN5OiAxfXD3LvoARvwBADRO/AEAM4r8AQAx/vwBwvwBCDQuNQXuAHL2/AEAAa78AQAzLfwEMTmy/AEAMyHQmvwBADgBLML8AQw4LjE3JQ6i/AFB9hiqqqqqnCcuSfYMhNeXQUX2UBRDQVJURVNJQU4gaW5uZXIgam9pbg35EDQ1MS45BWlR9QA7SYwUaGFzaF90gUcAOmm5DDoyNzZtIBBmZXRjaB0QBTIYOjBzfRKQCZ2MDDM1Ev0+jAQAOE6QAgA3ipACADj+kAK+kAIENTltfvqQArKMBAA3LZcIMTA1bQ4xlwClYowECDk3OS2YjpICDDkxNS5JWsKUAgg3LjFJK6KUAgQS/DoAAgQ0ME4AAgA5igACADb+AAK+AAIEMjT+AAJJALKQBAg5WhXFNQQ5M6L/AQg4NjWq/wEIODAyDdfC/wEMOS40M4Uqov8BCBoBAcqTBAgzMDgaBghR/GKTBAgxNDlNzYmTGRCVk6EXQKuqWuepgfdBKQCA4Dd5w0FDghcFEDc2Ni42Be2ChAAIMzkzDSsJhBkQFYQEEqguswkENDE2swkENDNGJwMANkonAwQ0NYonAwAy/icDwicDADkN/v4nBaonBQQ0NXEnCDcuODKmAWYmBQg4NTlNVo4mBQg4MjXeJwMEMTANaKInA0b/AU4mBwA0jiYHADX+/wHC/wEAOP7/ASn/AAGqtgkENDct/wQ3NDq8CGb/AQg3ODBNK47/AQQ3MR6NCsomBQAwSZOi/wGBoq65CQAUxSIINDcwMvoCADeFbk63CQ2QiZ4RDgUuErMJBIgJKrMJDDQ5Evc6swcMNTIS6kI/DgA1jj8OADSCjQIAfP4/DjY/DgAy/kEMEkEMrrEJADUePQ4IMTgzOowCbj0OADASEQ6OigIIMS4wEm0MyogCADK+PQ4A+j76AU49DgA1jj0OADeC+gEAfv76ATr6AQgxLjRlD/qGBq6HBAQ1M42HBDg1jVseLAgAo2KsCwg2OTQNqY79AQQ2NBZwC8r9AQA3FsoQqoUEzqsJCDQxMBqACRH7ZqsJADg6qwkVEJWLDi8KyqsJBDE4LVOChAAINDY17ZypDRkQFYREIYasGjN6ZaJDKRduBbW1uJNGaiwKqYoMMS4wOQ7kD4J/AAg4MTDtLQl/GRAoYnVpbGQ6MHN9GAE=","plan_hint":"hash_join(@`sel_1` `test`.`t3`), use_index(@`sel_1` `test`.`t3` ), use_index(@`sel_1` `test`.`t1` ), hash_join(@`sel_1` `test`.`t8`), use_index(@`sel_1` `test`.`t8` ), use_index(@`sel_1` `test`.`t6` ), hash_join(@`sel_1` `test`.`t2`), use_index(@`sel_1` `test`.`t2` ), use_index(@`sel_1` `test`.`t5` ), hash_join(@`sel_1` `test`.`t4`), use_index(@`sel_1` `test`.`t4` ), use_index(@`sel_1` `test`.`t7` )","index_names":null,"exec_count":1,"sum_errors":0,"sum_warnings":0,"sum_latency":3246181,"max_latency":3246181,"min_latency":3246181,"sum_parse_latency":60971,"max_parse_latency":60971,"sum_compile_latency":1004025,"max_compile_latency":1004025,"sum_num_cop_tasks":8,"max_cop_process_time":0,"max_cop_process_address":"","max_cop_wait_time":0,"max_cop_wait_address":"","sum_process_time":0,"max_process_time":0,"sum_wait_time":0,"max_wait_time":0,"sum_backoff_time":0,"max_backoff_time":0,"sum_total_keys":8,"max_total_keys":8,"sum_processed_keys":0,"max_processed_keys":0,"sum_rocksdb_delete_skipped_count":0,"max_rocksdb_delete_skipped_count":0,"sum_rocksdb_key_skipped_count":0,"max_rocksdb_key_skipped_count":0,"sum_rocksdb_block_cache_hit_count":16,"max_rocksdb_block_cache_hit_count":16,"sum_rocksdb_block_read_count":0,"max_rocksdb_block_read_count":0,"sum_rocksdb_block_read_byte":0,"max_rocksdb_block_read_byte":0,"commit_count":0,"sum_get_commit_ts_time":0,"max_get_commit_ts_time":0,"sum_prewrite_time":0,"max_prewrite_time":0,"sum_commit_time":0,"max_commit_time":0,"sum_local_latch_time":0,"max_local_latch_time":0,"sum_commit_backoff_time":0,"max_commit_backoff_time":0,"sum_resolve_lock_time":0,"max_resolve_lock_time":0,"sum_write_keys":0,"max_write_keys":0,"sum_write_size":0,"max_write_size":0,"sum_prewrite_region_num":0,"max_prewrite_region_num":0,"sum_txn_retry":0,"max_txn_retry":0,"sum_backoff_times":0,"backoff_types":{},"auth_users":{"root":{}},"sum_mem":1235,"max_mem":1235,"sum_disk":0,"max_disk":0,"sum_affected_rows":0,"sum_kv_total":7326188,"sum_pd_total":28634,"sum_backoff_total":0,"sum_write_sql_resp_total":59992,"sum_result_rows":0,"max_result_rows":0,"min_result_rows":0,"prepared":false,"first_seen":"2023-02-13T16:58:47.886755733+08:00","last_seen":"2023-02-13T16:58:47.886755733+08:00","plan_in_cache":false,"plan_cache_hits":0,"plan_in_binding":false,"exec_retry_count":0,"exec_retry_time":0}