From: Andy Allan <git@gravitystorm.co.uk>
Date: Wed, 29 May 2019 10:02:50 +0000 (+0200)
Subject: Update annotations to show 'using' clause on indexes
X-Git-Tag: live~3110^2
X-Git-Url: https://git.openstreetmap.org./rails.git/commitdiff_plain/8ae8768cd352b2b85d61c4c04c0fc5caa82fcdbe

Update annotations to show 'using' clause on indexes
---

diff --git a/app/models/changeset.rb b/app/models/changeset.rb
index 2c4c6d85c..d57086a8e 100644
--- a/app/models/changeset.rb
+++ b/app/models/changeset.rb
@@ -14,7 +14,7 @@
 #
 # Indexes
 #
-#  changesets_bbox_idx                (min_lat,max_lat,min_lon,max_lon)
+#  changesets_bbox_idx                (min_lat,max_lat,min_lon,max_lon) USING gist
 #  changesets_closed_at_idx           (closed_at)
 #  changesets_created_at_idx          (created_at)
 #  changesets_user_id_created_at_idx  (user_id,created_at)
diff --git a/app/models/note_comment.rb b/app/models/note_comment.rb
index 065c37a5c..388f890a6 100644
--- a/app/models/note_comment.rb
+++ b/app/models/note_comment.rb
@@ -13,7 +13,7 @@
 #
 # Indexes
 #
-#  index_note_comments_on_body        (to_tsvector('english'::regconfig, body))
+#  index_note_comments_on_body        (to_tsvector('english'::regconfig, body)) USING gin
 #  index_note_comments_on_created_at  (created_at)
 #  note_comments_note_id_idx          (note_id)
 #