A Statistics page compares the same time window across weeks as one bar per period, administrators can configure the SID and STAR names of each airport so arrivals and departures are charted by direction of traffic, and airborne-flight counts read a fifteen-minute rollup instead of scanning every position sample. v0.3.15 shipped the rollup without a version bump; its changes are listed here.
Added- Statistics accepts airports, a start and end time in the selected timezone, a weekday or every day, and a lookback in weeks, then charts detected departures and arrivals per period with totals, a period ledger, and a by-airport split when several airports are compared.
- Per-airport SID and STAR names live in a new airport_procedures table; a filed route is matched against the base identifier with or without its designator and runway suffix, and procedures sharing a group label are counted as one direction.
- Administrators listed in ADMIN_CIDS manage procedure names at /admin/airports after signing in with VATSIM.
- Statistics is reachable from the navigation rail.
Changed- Every airborne-flight figure on the overview, flight totals, rankings and the fourteen-day trend reads a new airborne_session_buckets rollup, one row per session and fifteen-minute bucket, written by the live ingest and the statsim backfill and pruned with everything else.
- Migration numbering: the airborne rollup is 006 and airport procedures are 007, applied in that order.
Fixed- The fourteen-day flight trend scanned about two million position samples per day on every request, never finished inside the statement ceiling, and once that ceiling was raised the abandoned scans held every pooled connection so past-day airport and country rankings failed on the connect timeout.
- Database failures the pool can name, such as a statement timeout, an exhausted pool, an unreachable server, rejected credentials or a missing schema, now reach the error boundary as a stable digest with a readable explanation.