<% queries.reverse.each do |query| %> <% end %>
Pid Duration State
<%= query[:pid] %> <% if query[:duration_ms] %> <% sec = query[:duration_ms] / 1000.0 %> <% if sec < 1.minute %> <%= sec.round(1) %> s <% elsif sec < 1.day %> <%= Time.at(sec).utc.strftime("%H:%M:%S") %> <% else %> <% days = (sec / 1.day).floor %> <%= days %>d <%= Time.at(sec - days.days).utc.strftime("%H:%M:%S") %> <% end %> <% end %> <%= query[:state] %> <% if vacuum_progress[query[:pid]] %>
<%= vacuum_progress[query[:pid]][:phase] %> <% end %>
<% unless @database.filter_data %> <%= button_to "Explain", explain_path, params: {query: query[:query]}, form: {target: "_blank"}, class: "btn btn-info" %> <% end %> <%= button_to "Kill", kill_path(pid: query[:pid]), class: "btn btn-danger" %>
<%= query[:source] %> <%= query[:user] %>
<%= query[:query] %>