{% extends parent %}
{% block title %}Stats - Introspect{% endblock %}
{% block content %}
<h1>Stats &amp; Insights</h1>

{% if earliest_session %}
<p style="color: var(--text-muted, #888); margin-bottom: 1rem;">Data since {{ (earliest_session|string)[:10] }}</p>
{% endif %}

<div class="stat-grid">
    <div class="stat-card">
        <div class="value">{{ total_sessions }}</div>
        <div class="label">Total Sessions</div>
    </div>
    <div class="stat-card">
        <div class="value">{{ total_turns }}</div>
        <div class="label">Total Turns</div>
    </div>
    <div class="stat-card">
        <div class="value">{{ total_user_messages }}</div>
        <div class="label">User Messages</div>
    </div>
    <div class="stat-card">
        <div class="value">{{ total_tool_calls }}</div>
        <div class="label">Total Tool Calls</div>
    </div>
    <div class="stat-card">
        <div class="value">{{ total_failed }}</div>
        <div class="label">Failed Tool Calls</div>
    </div>
    <div class="stat-card">
        <div class="value">{{ avg_duration }}</div>
        <div class="label">Avg Duration</div>
    </div>
    <div class="stat-card">
        <div class="value">{{ avg_tool_calls }}</div>
        <div class="label">Avg Tools/Session</div>
    </div>
    {% if token_usage %}
    <div class="stat-card">
        <div class="value">{{ "{:,}".format(token_usage.input or 0) }}</div>
        <div class="label">Total Input Tokens</div>
    </div>
    <div class="stat-card">
        <div class="value">{{ "{:,}".format(token_usage.output or 0) }}</div>
        <div class="label">Total Output Tokens</div>
    </div>
    <div class="stat-card">
        <div class="value">{{ token_usage.cost or '—' }}</div>
        <div class="label">Estimated Cost (all-time)</div>
    </div>
    {% if avg_cost %}
    <div class="stat-card">
        <div class="value">{{ avg_cost }}</div>
        <div class="label">Avg Cost / Session</div>
    </div>
    {% endif %}
    {% endif %}
    {% if cache_tokens and (cache_tokens[0] or cache_tokens[1]) %}
    <div class="stat-card">
        <div class="value">{{ "{:,}".format(cache_tokens[0] or 0) }}</div>
        <div class="label">Cache Write Tokens</div>
    </div>
    <div class="stat-card">
        <div class="value">{{ "{:,}".format(cache_tokens[1] or 0) }}</div>
        <div class="label">Cache Read Tokens</div>
    </div>
    {% endif %}
</div>

{% if model_breakdown %}
<h2>Per-Model Breakdown</h2>
<div class="card">
    <table>
        <thead>
            <tr>
                <th>Model</th>
                <th>Sessions</th>
                <th>Avg Duration</th>
                <th>Avg Tool Calls</th>
            </tr>
        </thead>
        <tbody>
            {% for m in model_breakdown %}
            <tr>
                <td>{{ m[0] }}</td>
                <td>{{ m[1] }}</td>
                <td>{{ '%d:%02d'|format((m[2] or 0) // 60, (m[2] or 0) % 60) }}</td>
                <td>{{ '%.1f'|format(m[3] or 0) }}</td>
            </tr>
            {% endfor %}
        </tbody>
    </table>
</div>
{% endif %}

<h2>Session Duration Distribution</h2>
<div class="card">
    <table>
        <thead>
            <tr>
                <th style="width:120px;">Duration Bucket</th>
                <th style="width:60px;">Count</th>
                <th></th>
            </tr>
        </thead>
        <tbody>
            {% for bucket in duration_buckets %}
            <tr>
                <td>{{ bucket[0] }}</td>
                <td>{{ bucket[1] }}</td>
                <td><div style="background:#3b5bdb;height:1.2rem;border-radius:3px;width:{{ (bucket[1] / max_duration_count * 100)|round }}%;min-width:2px;"></div></td>
            </tr>
            {% endfor %}
        </tbody>
    </table>
</div>

<h2>Turns Per Session Distribution</h2>
<div class="card">
    <table>
        <thead>
            <tr>
                <th style="width:120px;">Turns Bucket</th>
                <th style="width:60px;">Count</th>
                <th></th>
            </tr>
        </thead>
        <tbody>
            {% for bucket in turns_buckets %}
            <tr>
                <td>{{ bucket[0] }}</td>
                <td>{{ bucket[1] }}</td>
                <td><div style="background:#3b5bdb;height:1.2rem;border-radius:3px;width:{{ (bucket[1] / max_turns_count * 100)|round }}%;min-width:2px;"></div></td>
            </tr>
            {% endfor %}
        </tbody>
    </table>
</div>

<h2>Tool Usage Breakdown</h2>
<div class="card">
    <table>
        <thead>
            <tr>
                <th>Tool Name</th>
                <th>Count</th>
                <th>% of Total</th>
                <th>Success Rate</th>
            </tr>
        </thead>
        <tbody>
            {% for tool in tool_breakdown %}
            <tr>
                <td>{{ tool[0] }}</td>
                <td>{{ tool[1] }}</td>
                <td>{{ "%.1f"|format(tool[3]) }}%</td>
                <td>{{ "%.1f"|format(tool[2]) }}%</td>
            </tr>
            {% endfor %}
        </tbody>
    </table>
</div>

{% if mcp_servers %}
<h2>MCP Servers</h2>
<div class="card">
    <table>
        <thead>
            <tr>
                <th>Server</th>
                <th>Total Calls</th>
                <th>Commands Used</th>
            </tr>
        </thead>
        <tbody>
            {% for s in mcp_servers %}
            <tr>
                <td>{{ s[0] }}</td>
                <td>{{ s[1] }}</td>
                <td>{{ s[2] }}</td>
            </tr>
            {% endfor %}
        </tbody>
    </table>
</div>

<h2>MCP Command Breakdown</h2>
<div class="card">
    <table>
        <thead>
            <tr>
                <th>Command</th>
                <th>Count</th>
                <th>% of Total</th>
                <th>Success Rate</th>
            </tr>
        </thead>
        <tbody>
            {% for tool in mcp_breakdown %}
            <tr>
                <td>{{ tool[0] }}</td>
                <td>{{ tool[1] }}</td>
                <td>{{ "%.1f"|format(tool[3]) }}%</td>
                <td>{{ "%.1f"|format(tool[2]) }}%</td>
            </tr>
            {% endfor %}
        </tbody>
    </table>
</div>
{% endif %}

{% if bash_breakdown %}
<h2>Bash Commands — By First Word</h2>
<div class="card">
    {% if bash_chained %}
    <p style="margin: 0.5rem 1rem; color: var(--text-muted, #888);">
        {{ bash_chained[0] }} of {{ bash_chained[1] }} bash calls ({{ "%.1f"|format(100.0 * bash_chained[0] / bash_chained[1]) if bash_chained[1] else 0 }}%) contain <code>&amp;&amp;</code> chaining
    </p>
    {% endif %}
    <table>
        <thead>
            <tr>
                <th>Command</th>
                <th>Count</th>
            </tr>
        </thead>
        <tbody>
            {% for cmd in bash_breakdown %}
            <tr>
                <td><code>{{ cmd[0] }}</code></td>
                <td>{{ cmd[1] }}</td>
            </tr>
            {% endfor %}
        </tbody>
    </table>
</div>
{% endif %}

{% if bash_two_words %}
<h2>Bash Commands — By First Two Words</h2>
<div class="card">
    <table>
        <thead>
            <tr>
                <th>Command</th>
                <th>Count</th>
            </tr>
        </thead>
        <tbody>
            {% for cmd in bash_two_words %}
            <tr>
                <td><code>{{ cmd[0] }}</code></td>
                <td>{{ cmd[1] }}</td>
            </tr>
            {% endfor %}
        </tbody>
    </table>
</div>
{% endif %}

<h2>Longest Sessions (Top 15)</h2>
<div class="card">
    <table>
        <thead>
            <tr>
                <th>Session ID</th>
                <th>Started At</th>
                <th>Duration</th>
                <th>Turns</th>
                <th>User Msgs</th>
                <th>Tool Calls</th>
                <th>Failed</th>
                <th>Model</th>
            </tr>
        </thead>
        <tbody>
            {% for s in longest_sessions %}
            <tr>
                <td><a href="/sessions/{{ s[0] }}" hx-get="/sessions/{{ s[0] }}" hx-target="#content" hx-push-url="true"><span class="truncate">{{ (s[0]|string)[:12] }}...</span></a></td>
                <td>{{ (s[1]|string)[:19] }}</td>
                <td>{{ s[2] }}</td>
                <td>{{ s[6] }}</td>
                <td>{{ s[4] }}</td>
                <td>{{ s[7] }}</td>
                <td>{{ s[8] }}</td>
                <td>{{ s[3] or '' }}</td>
            </tr>
            {% endfor %}
        </tbody>
    </table>
</div>

<h2>Most Tool Calls (Top 15 Sessions)</h2>
<div class="card">
    <table>
        <thead>
            <tr>
                <th>Session ID</th>
                <th>Tool Calls</th>
                <th>Failed</th>
                <th>Started At</th>
                <th>Duration</th>
                <th>Turns</th>
                <th>User Msgs</th>
                <th>Model</th>
            </tr>
        </thead>
        <tbody>
            {% for s in most_tools_sessions %}
            <tr>
                <td><a href="/sessions/{{ s[0] }}" hx-get="/sessions/{{ s[0] }}" hx-target="#content" hx-push-url="true"><span class="truncate">{{ (s[0]|string)[:12] }}...</span></a></td>
                <td>{{ s[1] }}</td>
                <td>{{ s[2] }}</td>
                <td>{{ (s[3]|string)[:19] }}</td>
                <td>{{ s[4] }}</td>
                <td>{{ s[8] }}</td>
                <td>{{ s[6] }}</td>
                <td>{{ s[5] or '' }}</td>
            </tr>
            {% endfor %}
        </tbody>
    </table>
</div>

<h2>Sessions Per Day</h2>
<div class="card">
    <table>
        <thead>
            <tr>
                <th>Date</th>
                <th>Sessions</th>
            </tr>
        </thead>
        <tbody>
            {% for day in sessions_per_day %}
            <tr>
                <td>{{ day[0] }}</td>
                <td>{{ day[1] }}</td>
            </tr>
            {% endfor %}
        </tbody>
    </table>
</div>
{% endblock %}