Started: 2026-11-22T06:05:33+03:00 Database driver: mysql Database version: 8.0.42-0ubuntu0.20.04.1 PHP CLI memory: 8192M === ESTIMATED TABLE SIZES (metadata only) === TABLE: actions | engine=InnoDB | estimated_rows=19964 | MB=1.5 TABLE: districts | engine=MyISAM | estimated_rows=146 | MB=0.0 TABLE: incident_data | engine=InnoDB | estimated_rows=107742 | MB=54.2 TABLE: parishes | engine=MyISAM | estimated_rows=9442 | MB=1.8 TABLE: perpetrators | engine=InnoDB | estimated_rows=9579475 | MB=6057.8 TABLE: services | engine=InnoDB | estimated_rows=12 | MB=0.0 TABLE: sub_counties | engine=MyISAM | estimated_rows=2193 | MB=0.4 TABLE: victim | engine=InnoDB | estimated_rows=84108 | MB=16.0 === INDEX COLUMNS (metadata only) === INDEX: actions.actions_uuid_unique[uuid] INDEX: actions.idx_actions_victim_id[victim_id] INDEX: actions.PRIMARY[id] INDEX: incident_data.idx_districtid[districtid] INDEX: incident_data.idx_parishid[parishid] INDEX: incident_data.idx_subcountyid[subcountyid] INDEX: incident_data.incident_data_uuid_unique[uuid] INDEX: incident_data.incident_date_id_idx[incident_date,id] INDEX: incident_data.incident_district_date_idx[districtid,incident_date] INDEX: incident_data.incident_dup_check_idx[victimid,incidentid,incident_date] INDEX: incident_data.incident_owner_date_idx[created_by,incident_date] INDEX: incident_data.incident_type_date_idx[incidentid,incident_date] INDEX: incident_data.PRIMARY[id] INDEX: perpetrators.idx_perpetrators_victimid_relation[victimid,relation] INDEX: perpetrators.perpetrators_uuid_unique[uuid] INDEX: perpetrators.PRIMARY[id] INDEX: victim.idx_districtid[districtid] INDEX: victim.idx_parishid[parishid] INDEX: victim.idx_subcountyid[subcountyid] INDEX: victim.idx_victim_created_by[created_by] INDEX: victim.PRIMARY[id] INDEX: victim.victim_crb_date_district_idx[crb_number,interview_date,districtid] INDEX: victim.victim_survivor_date_district_idx[survivor_code,interview_date,districtid] INDEX: victim.victim_uuid_unique[uuid] === MYSQL SERVER SETTINGS / STATUS === MYSQL: innodb_buffer_pool_size=2147483648 MYSQL: long_query_time=1.000000 MYSQL: max_allowed_packet=67108864 MYSQL: slow_query_log=ON MYSQL: tmp_table_size=67108864 MYSQL: Created_tmp_disk_tables=8 MYSQL: Slow_queries=152 MYSQL: Threads_running=3 === BOUNDED QUERY TESTS === EXPLAIN simple: table=i | type=range | key=PRIMARY | est_rows=53872 | extra=Using where EXPLAIN simple: table=v | type=eq_ref | key=PRIMARY | est_rows=1 | extra=Using where; Using index First 1000 incident/victim IDs 0.006 sec | rows=1000 Distinct victim IDs in sample: 498 Actions lookup (1000-row incident sample) 0.003 sec | rows=0 Perpetrators lookup (same sample) 2.478 sec | rows=504 Action+authority records (same sample) 0.019 sec | rows=0 Perpetrator group query (same sample) 3.442 sec | rows=490 REAL controller base join first 1000 rows 3.459 sec | rows=1000 === CURRENT DATABASE ACTIVITY (NO SQL OR USER DETAILS) === ACTIVE DB: seconds=0 | command=Execute | state=executing Peak CLI memory MB: 6 Finished: 2026-11-22T06:05:42+03:00