{# This template is used to display detailed view data, when the QueryProfilerType is QUERY_SIGNATURE #} {% load number_formatter %} Query Profiled Data

Summary of the api

Queries Database time spent Database rows fetched Potential N+1 count Exact query duplicates
Total {{ summary.total_query_count|commafy }} {{ summary.total_query_execution_time_in_micros|commafy }} ms {{ summary.total_db_row_count|commafy }} {{ summary.potential_n_plus1_query_count|commafy }} {{ summary.exact_query_duplicates|commafy }}

Api Details by query signature

Query origin
Number of queries
Query time
Database rows
is N+1?

{% for query_signature, query_signature_statistics in query_signature_to_statistics.items %}

{{ query_signature_statistics.frequency|commafy }}
{{ query_signature_statistics.query_execution_time_in_micros|commafy }} ms
{{ query_signature_statistics.db_row_count|commafy }}
{% if query_signature_statistics.frequency > 1 %} N+1 {% else %} {% endif %}

{{ query_signature.query_without_params }}
Stack Trace
    {% for stack_trace in query_signature.app_stack_trace %}
  • {{ stack_trace }}
  • {% endfor %}
TL;DR  {{ query_signature.analysis.name }}
{% endfor %}