MariaDB [tpch]> source Q4-json.sql; +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ANALYZE | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | { "query_optimization": { "r_total_time_ms": 0.348478973 }, "query_block": { "select_id": 1, "cost": 1269.692708, "r_loops": 1, "r_total_time_ms": 492.5004725, "filesort": { "sort_key": "ORDERS.O_ORDERPRIORITY", "r_loops": 1, "r_total_time_ms": 0.021515674, "r_used_priority_queue": false, "r_output_rows": 5, "r_buffer_size": "480", "r_sort_mode": "sort_key,rowid", "temporary_table": { "nested_loop": [ { "table": { "table_name": "ORDERS", "access_type": "ALL", "loops": 1, "r_loops": 1, "rows": 1488318, "r_rows": 1500000, "cost": 253.2600612, "r_table_time_ms": 204.0182149, "r_other_time_ms": 106.1968295, "r_engine_stats": { "pages_accessed": 12415 }, "filtered": 100, "r_total_filtered": 3.4572, "attached_condition": "ORDERS.O_ORDERDATE >= DATE'1995-01-01' and ORDERS.O_ORDERDATE < '1995-04-01' and (1,exists(subquery#2))", "r_filtered": 3.4572 } } ], "subqueries": [ { "subquery_cache": { "state": "disabled", "r_loops": 200, "r_hit_ratio": 0, "query_block": { "select_id": 2, "cost": 0.00210977, "r_loops": 56579, "r_total_time_ms": 169.7092088, "nested_loop": [ { "table": { "table_name": "LINEITEM", "access_type": "ref", "possible_keys": ["PRIMARY", "IDX_LINEITEM_ORDERKEY_FKIDX"], "key": "PRIMARY", "key_length": "8", "used_key_parts": ["L_ORDERKEY"], "ref": ["tpch.ORDERS.O_ORDERKEY"], "loops": 1, "r_loops": 56579, "rows": 3, "r_rows": 1.461832129, "cost": 0.00210977, "r_table_time_ms": 139.0593987, "r_other_time_ms": 9.138463196, "r_engine_stats": { "pages_accessed": 172197 }, "filtered": 100, "r_total_filtered": 62.69934348, "attached_condition": "LINEITEM.L_COMMITDATE < LINEITEM.L_RECEIPTDATE", "r_filtered": 62.69934348 } } ] } } } ] } } } } | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.492 sec) MariaDB [tpch]> notee