{% extends "base.html" %} {# CUI // SP-CTI — Cache Savings Dashboard (D-CACHE-VIS-1) #} {# NIST 800-53: SC-28 (Protection at Rest), AU-12 (Audit Record Generation), SA-11 (Developer Testing) #} {% block title %}Cache Savings — ICDEV™{% endblock %} {% set iqe_canvas = "cache_savings" %} {% set iqe_api_route = "/api/core/iqe-query" %} {% set iqe_title = "Query Cache Stats" %} {% set iqe_examples = [ {"label": "Hit rate by function", "query": "SELECT function, hit_rate_pct FROM cache.stats ORDER BY hit_rate_pct DESC"}, {"label": "Top functions by hits", "query": "SELECT function, total_hits, avoided_calls FROM cache.stats ORDER BY total_hits DESC LIMIT 10"}, {"label": "Cost savings breakdown", "query": "SELECT function, cost_usd_saved FROM cache.stats ORDER BY cost_usd_saved DESC"}, ] %} {% block content %}
| Function | Entries | Hit Rate | Avoided Calls | Read Tokens | Cost Saved |
|---|---|---|---|---|---|
| {{ fn.function }} | {{ "{:,}".format(fn.total_entries) }} | {{ fn.hit_rate_pct }}% | {{ "{:,}".format(fn.avoided_calls) }} | {{ "{:,}".format(fn.cache_read_tokens) }} | ${{ "%.4f"|format(fn.cost_usd_saved) }} |