Commit 3c5ad95
| Repository | bojemoi |
| Branch | main |
| Auteur | Betty |
| Hash | 3c5ad95aae949058e25c9b7ee4bb20ccf2620995 |
| Date | 2026-02-07 |
Description
ORDER BY RANDOM() on hosts table (6.15M rows) caused full sequential scans taking ~7.5s each, driving PostgreSQL to 459% CPU. TABLESAMPLE SYSTEM() samples random blocks at I/O level, reducing query time to milliseconds. Also fixes SQL injection in thearm_uzi via parameterized query.
Co-Authored-By: Claude Opus 4.6 noreply@anthropic.com