Vacuuming did not run on personal_access_tokens table
This might be a minor issue, so feel free to close it out if there's no action necessary. According to Grafana, personal_access_tokens had about 20% dead tuples:
SELECT relname AS TableName, n_live_tup AS LiveTuples, n_dead_tup AS DeadTuples FROM pg_stat_user_tables ORDER by tablename;
Came back with:
<snip>
personal_access_tokens | 2688 | 660
After running VACUUM personal_access_token, the output was:
<snip>
personal_access_tokens | 1801910 | 0
autovacuum_enabled seems to be on.
gitlabhq_production=# \d+ personal_access_tokens;
Table "public.personal_access_tokens"
Column | Type | Modifiers | Storage | Stats target | Description
---------------+-----------------------------+---------------------------------------------------------------------+----------+--------------+-------------
id | integer | not null default nextval('personal_access_tokens_id_seq'::regclass) | plain | |
user_id | integer | not null | plain | |
token | character varying | not null | extended | |
name | character varying | not null | extended | |
revoked | boolean | default false | plain | |
expires_at | date | | plain | |
created_at | timestamp without time zone | not null | plain | |
updated_at | timestamp without time zone | not null | plain | |
scopes | character varying | not null default '--- [] +| extended | |
| | '::character varying | | |
impersonation | boolean | not null default false | plain | |
Indexes:
"personal_access_tokens_pkey" PRIMARY KEY, btree (id)
"index_personal_access_tokens_on_token" UNIQUE, btree (token)
"index_personal_access_tokens_on_user_id" btree (user_id)
Foreign-key constraints:
"fk_rails_08903b8f38" FOREIGN KEY (user_id) REFERENCES users(id)
Options: autovacuum_enabled=true, toast.autovacuum_enabled=true
