Selecto.Performance.QueryAnalyzer
(Selecto v0.4.5)
Copy Markdown
Query analysis and optimization using adapter-backed EXPLAIN support.
Provides deep insights into query performance by:
- Running EXPLAIN ANALYZE on queries
- Parsing execution plans
- Identifying performance bottlenecks
- Suggesting optimizations
- Tracking index usage
Summary
Functions
Analyze index usage for a query.
Analyze a query using EXPLAIN ANALYZE and return detailed performance information.
Compare performance of two queries.
Get query plan without executing (EXPLAIN only, no ANALYZE).
Get statistics for tables used in a query.
Functions
Analyze index usage for a query.
Analyze a query using EXPLAIN ANALYZE and return detailed performance information.
Options
:format- Output format (:text, :json, :xml, :yaml). Default: :json:analyze- Actually run the query (default: true):buffers- Include buffer usage (default: true):verbose- Include verbose output (default: false):timing- Include timing information (default: true):summary- Include summary (default: true):settings- Include settings (default: false)
Examples
iex> QueryAnalyzer.analyze_query(selecto)
{:ok, %{
execution_time: 45.2,
planning_time: 0.8,
plan: %{...},
suggestions: [...]
}}Compare performance of two queries.
Get query plan without executing (EXPLAIN only, no ANALYZE).
Get statistics for tables used in a query.