Explain

<%= form_tag explain_path do %>

<%= text_area_tag :query, @query, placeholder: "Enter a SQL query" %>

<%= submit_tag "Explain", class: "btn btn-info", style: "margin-right: 10px;" %> <% if @explain_analyze_enabled %> <%= submit_tag "Analyze", class: "btn btn-danger", style: "margin-right: 10px;" %> <% end %> <%= submit_tag "Visualize", class: "btn btn-danger" %>

<% end %> <% if @explanation %> <% if @visualize %>

Paste the output below into the <%= link_to "explain visualizer", PgHero.visualize_url, target: "_blank" %>

<% end %>

<%= @explanation %>

<% unless @visualize %>

<%= link_to "See how to interpret this", "https://www.postgresql.org/docs/current/static/using-explain.html", target: "_blank" %>

<% end %> <% if (index = @suggested_index) %> <%= render partial: "suggested_index", locals: {index: index, details: index[:details]} %> <% end %> <% elsif @error %>

<%= @error %>

<% end %>