Строки получены программой при выполнении запросов. Созданные ею учебные таблицы удалены при завершении; этот отчёт сохраняет результат.
Фактические измерения и план EXPLAIN этого запуска
{
"fixture_rows": 100000,
"php_memory_limit": "512M",
"index_columns": [
"category_id",
"active",
"price_cents",
"id",
"name"
],
"plan_before": [
{
"id": "1",
"select_type": "SIMPLE",
"table": "mysql106_sql_screen_products",
"partitions": null,
"type": "ALL",
"possible_keys": null,
"key": null,
"key_len": null,
"ref": null,
"rows": "100000",
"filtered": "1.00",
"Extra": "Using where; Using filesort"
}
],
"plan_after": [
{
"id": "1",
"select_type": "SIMPLE",
"table": "mysql106_sql_screen_products",
"partitions": null,
"type": "ref",
"possible_keys": "mysql106_sql_screen_catalog",
"key": "mysql106_sql_screen_catalog",
"key_len": "5",
"ref": "const,const",
"rows": "3333",
"filtered": "100.00",
"Extra": "Using index"
}
],
"plan_select_star_same_filter": [
{
"id": "1",
"select_type": "SIMPLE",
"table": "mysql106_sql_screen_products",
"partitions": null,
"type": "ref",
"possible_keys": "mysql106_sql_screen_catalog",
"key": "mysql106_sql_screen_catalog",
"key_len": "5",
"ref": "const,const",
"rows": "3333",
"filtered": "100.00",
"Extra": null
}
],
"memory_observations": {
"metric": "memory_get_usage(false) delta in this one process; allocator/cache/runtime affect results",
"naive_fetch_all_bytes": 65154136,
"server_page_bytes": 7096
},
"elapsed_observations_ms": {
"naive_fetch_filter_sort": 73.1414,
"server_query_fetch": 0.411
},
"timing_caveat": "Index creation and data generation excluded; different cache state; not a benchmark or guaranteed speedup"
}