{% with messages = get_flashed_messages(with_categories=true) %} {% if messages %} {% for category, message in messages %}
{{ message }}
{% endfor %} {% endif %} {% endwith %}

Most Expensive Queries

Download CSV

Query Performance Analysis

{{ queries|length }} queries analyzed

These are the most expensive queries based on total execution time. Click on "View Details" to see the full query text and performance metrics.

{% for query in queries %} {% endfor %}
# Calls Total Time (ms) Mean Time (ms) Rows Time per Row Query Preview Actions
{{ loop.index }} {{ query.calls }} {{ "%.2f"|format(query.total_time) }} {{ "%.2f"|format(query.mean_time) }} {{ query.rows }} {{ "%.4f"|format(query.time_per_row) }}
{{ query.query[:50] }}{% if query.query|length > 50 %}...{% endif %}
View Details

Performance Insights

Query Optimization Tips
  • Queries with high time-per-row values may benefit from index optimization
  • Frequently called queries with moderate performance issues can have a large cumulative impact
  • Check if queries returning many rows can be optimized with LIMIT or pagination
Next Steps
  • Review the full query text for complex queries
  • Check the execution plan with EXPLAIN ANALYZE
  • View the data lineage graph to understand table relationships
  • Consider adding indexes for frequently queried columns