<%= @query %>

<% if @explainable_query %>

<%= button_to "Explain", explain_path, params: {query: @explainable_query}, form: {target: "_blank"}, class: "btn btn-info" %>

<% end %> <% if @origins && @origins.keys.select { |k| k.length > 0 }.any? %> <% @origins.sort_by { |o, c| [-c, o.to_s] }.each do |origin, count| %> <% end %>

Approx. Time Origin
<% if origin.length > 0 %> <%= origin %> <% else %> Unknown <% end %>	<% pct = (100.0 * count / @total_count).round %> <% if pct == 0 %> < 1% <% else %> <%= pct %>% <% end %>

<% end %> <% if @chart_data %>

Total Time ms

Average Time ms

Calls

<% else %>

Enable <%= link_to "historical query stats", "https://github.com/ankane/pghero", target: "_blank" %> to see more details

<% end %> <% if @tables.any? %>

Tables

<% @tables.each do |table| %> <% end %>

Name	Rows	Indexes
<%= table %>	<%= @row_counts[table] %>	<% @indexes_by_table[table].to_a.sort_by { |i| [i[:primary] ? 0 : 1, i[:columns]] }.each do |i3| %> <%= i3[:columns].join(", ") %><% if i3[:using] != "btree" %> <%= i3[:using].to_s.upcase %><% end %> <% if i3[:primary] %> PRIMARY<% elsif i3[:unique] %> UNIQUE<% end %> <% end %>

<% end %>