cookbooks/db/files/default/monthly-reindex.sql

   1 REINDEX (VERBOSE) TABLE CONCURRENTLY acls;
   2 REINDEX (VERBOSE) TABLE CONCURRENTLY active_storage_attachments;
   3 REINDEX (VERBOSE) TABLE CONCURRENTLY active_storage_blobs;
   4 REINDEX (VERBOSE) TABLE CONCURRENTLY active_storage_variant_records;
   5 REINDEX (VERBOSE) TABLE CONCURRENTLY ar_internal_metadata;
   6 REINDEX (VERBOSE) TABLE CONCURRENTLY changeset_comments;
   7 REINDEX (VERBOSE) TABLE CONCURRENTLY changeset_tags;
   8 REINDEX (VERBOSE) TABLE CONCURRENTLY changesets;
   9 REINDEX (VERBOSE) TABLE CONCURRENTLY changesets_subscribers;
  10 REINDEX (VERBOSE) TABLE CONCURRENTLY client_applications;
  11 REINDEX (VERBOSE) TABLE CONCURRENTLY current_relation_members;
  12 REINDEX (VERBOSE) TABLE CONCURRENTLY delayed_jobs;
  13 REINDEX (VERBOSE) TABLE CONCURRENTLY diary_comments;
  14 REINDEX (VERBOSE) TABLE CONCURRENTLY diary_entries;
  15 REINDEX (VERBOSE) TABLE CONCURRENTLY diary_entry_subscriptions;
  16 REINDEX (VERBOSE) TABLE CONCURRENTLY friends;
  17 REINDEX (VERBOSE) TABLE CONCURRENTLY gpx_files;
  18 REINDEX (VERBOSE) TABLE CONCURRENTLY gpx_file_tags;
  19 REINDEX (VERBOSE) TABLE CONCURRENTLY issue_comments;
  20 REINDEX (VERBOSE) TABLE CONCURRENTLY issues;
  21 REINDEX (VERBOSE) TABLE CONCURRENTLY languages;
  22 REINDEX (VERBOSE) TABLE CONCURRENTLY messages;
  23 REINDEX (VERBOSE) TABLE CONCURRENTLY note_comments;
  24 REINDEX (VERBOSE) TABLE CONCURRENTLY notes;
  25 REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_access_grants;
  26 REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_access_tokens;
  27 REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_applications;
  28 REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_nonces;
  29 REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_tokens;
  30 REINDEX (VERBOSE) TABLE CONCURRENTLY redactions;
  31 REINDEX (VERBOSE) TABLE CONCURRENTLY reports;
  32 REINDEX (VERBOSE) TABLE CONCURRENTLY schema_migrations;
  33 REINDEX (VERBOSE) TABLE CONCURRENTLY user_blocks;
  34 REINDEX (VERBOSE) TABLE CONCURRENTLY user_mutes;
  35 REINDEX (VERBOSE) TABLE CONCURRENTLY user_preferences;
  36 REINDEX (VERBOSE) TABLE CONCURRENTLY user_roles;
  37 REINDEX (VERBOSE) TABLE CONCURRENTLY users;