MariaDB [marvin_production]> select * from information_schema.optimizer_trace\G
*************************** 1. row ***************************
                            QUERY: select count(*) from ecommerce_support_events
                            TRACE: {
  "steps": [
    {
      "join_preparation": {
        "select_id": 1,
        "steps": [
          {
            "expanded_query": "select count(0) AS `count(*)` from ecommerce_support_events"
          }
        ]
      }
    },
    {
      "join_optimization": {
        "select_id": 1,
        "steps": [
          {
            "table_dependencies": [
              {
                "table": "ecommerce_support_events",
                "row_may_be_null": false,
                "map_bit": 0,
                "depends_on_map_bits": []
              }
            ]
          },
          {
            "rows_estimation": [
              {
                "table": "ecommerce_support_events",
                "table_scan": {
                  "rows": 19096665,
                  "cost": 184127
                }
              }
            ]
          },
          {
            "considered_execution_plans": [
              {
                "plan_prefix": [],
                "table": "ecommerce_support_events",
                "best_access_path": {
                  "considered_access_paths": [
                    {
                      "access_type": "scan",
                      "resulting_rows": 19096665,
                      "cost": 184127,
                      "chosen": true
                    }
                  ],
                  "chosen_access_method": {
                    "type": "scan",
                    "records": 19096665,
                    "cost": 184127,
                    "uses_join_buffering": false
                  }
                },
                "rows_for_plan": 19096665,
                "cost_for_plan": 4003460
              }
            ]
          },
          {
            "best_join_order": ["ecommerce_support_events"]
          },
          {
            "attaching_conditions_to_tables": {
              "attached_conditions_computation": [],
              "attached_conditions_summary": [
                {
                  "table": "ecommerce_support_events",
                  "attached": null
                }
              ]
            }
          }
        ]
      }
    },
    {
      "join_execution": {
        "select_id": 1,
        "steps": []
      }
    }
  ]
}
MISSING_BYTES_BEYOND_MAX_MEM_SIZE: 0
          INSUFFICIENT_PRIVILEGES: 0
1 row in set (0.000 sec)