summaryrefslogtreecommitdiff
path: root/doc/development/adding_database_indexes.md
diff options
context:
space:
mode:
authorGitLab Bot <gitlab-bot@gitlab.com>2022-08-02 21:09:18 +0000
committerGitLab Bot <gitlab-bot@gitlab.com>2022-08-02 21:09:18 +0000
commit68da8a6cb432996324a4c2fe4dca70ae260ce73f (patch)
treefbaa3dbc4d8caccdcfac29afff238dee0d8084e5 /doc/development/adding_database_indexes.md
parente28bb9d18133611eef2a1357c57dc57ca97cfd5a (diff)
downloadgitlab-ce-68da8a6cb432996324a4c2fe4dca70ae260ce73f.tar.gz
Add latest changes from gitlab-org/gitlab@master
Diffstat (limited to 'doc/development/adding_database_indexes.md')
-rw-r--r--doc/development/adding_database_indexes.md9
1 files changed, 5 insertions, 4 deletions
diff --git a/doc/development/adding_database_indexes.md b/doc/development/adding_database_indexes.md
index 0211d2c822c..e18f1205718 100644
--- a/doc/development/adding_database_indexes.md
+++ b/doc/development/adding_database_indexes.md
@@ -259,15 +259,16 @@ end
### Verify the MR was deployed and the index exists in production
-You can verify if the MR was deployed to GitLab.com by executing
-`/chatops run auto_deploy status <merge_sha>`. To verify existence of
-the index, you can:
+You can verify if the post-deploy migration was executed on GitLab.com by:
+- Executing `/chatops run auto_deploy status <merge_sha>`. If the output returns `db/gprd`,
+ the post-deploy migration has been executed in the production database. More details in this
+ [guide](https://gitlab.com/gitlab-org/release/docs/-/blob/master/general/post_deploy_migration/readme.md#how-to-determine-if-a-post-deploy-migration-has-been-executed-on-gitlabcom).
- Use a meta-command in #database-lab, such as: `\d <index_name>`.
- Ensure that the index is not [`invalid`](https://www.postgresql.org/docs/12/sql-createindex.html#:~:text=The%20psql%20%5Cd%20command%20will%20report%20such%20an%20index%20as%20INVALID).
- Ask someone in #database to check if the index exists.
- With proper access, you can also verify directly on production or in a
-production clone.
+ production clone.
### Add a migration to create the index synchronously