lib/pghero/methods/suggested_indexes.rb in pghero-3.2.0 vs lib/pghero/methods/suggested_indexes.rb in pghero-3.3.0
- old
+ new
@@ -77,11 +77,11 @@
def autoindex(create: false)
suggested_indexes.each do |index|
p index
if create
- connection.execute("CREATE INDEX CONCURRENTLY ON #{quote_table_name(index[:table])} (#{index[:columns].map { |c| quote_table_name(c) }.join(",")})")
+ connection.execute("CREATE INDEX CONCURRENTLY ON #{quote_table_name(index[:table])} (#{index[:columns].map { |c| quote_column_name(c) }.join(",")})")
end
end
end
def best_index(statement)
@@ -308,10 +308,10 @@
}
end
end
def column_stats(schema: nil, table: nil)
- select_all <<-SQL
+ select_all <<~SQL
SELECT
schemaname AS schema,
tablename AS table,
attname AS column,
null_frac,