Summary
Add a query execution statistics dashboard that tracks and displays performance metrics across query history, helping users identify slow queries and optimize their workflow.
Motivation
Understanding query performance patterns is crucial for database optimization. While pgrsql tracks execution time per query in history, there's no aggregated view or analysis. A statistics dashboard would help users identify performance bottlenecks and track improvements over time.
Proposed Behavior
- Stats panel: Accessible via a keyboard shortcut (e.g.,
Ctrl+Shift+S) or sidebar tab
- Metrics displayed:
- Total queries executed (session and all-time)
- Average/median/p95 execution time
- Slowest queries list
- Most frequently run queries
- Success/failure rate
- Queries per database breakdown
- Session metrics: Current session stats in header bar (queries run, avg time)
Acceptance Criteria
Summary
Add a query execution statistics dashboard that tracks and displays performance metrics across query history, helping users identify slow queries and optimize their workflow.
Motivation
Understanding query performance patterns is crucial for database optimization. While pgrsql tracks execution time per query in history, there's no aggregated view or analysis. A statistics dashboard would help users identify performance bottlenecks and track improvements over time.
Proposed Behavior
Ctrl+Shift+S) or sidebar tabAcceptance Criteria