Space
Database Size: 8.21 MB
11 unused indices. Remove them for faster writes.
rails generate migration remove_unused_indexes
And paste
remove_index :audit_log, name: "ix_audit_action" remove_index :audit_log, name: "ix_audit_actor" remove_index :invitations, name: "ix_invitations_email" remove_index :invitations, name: "ix_invitations_status" remove_index :permissions, name: "ix_permissions_tool" remove_index :sessions, name: "ix_sessions_expires" remove_index :users, name: "ix_users_status" remove_index :scheduled_job_runs, name: "ix_jobruns_name" remove_index :team_memberships, name: "ix_membership_team" remove_index :otp_codes, name: "ix_otp_email" remove_index :password_resets, name: "ix_resets_user"
| Relation | Size |
|---|---|
| alembic_version_pkc | 16 KB |
| audit_log | 16 KB |
| audit_log_pkey | 16 KB |
| invitation_teams_pkey | 16 KB |
| invitations_pkey | 16 KB |
| invitations_token_hash_key | 16 KB |
| ix_audit_action UNUSED | 16 KB |
| ix_audit_actor UNUSED | 16 KB |
| ix_invitations_email UNUSED | 16 KB |
| ix_invitations_status UNUSED | 16 KB |
| ix_invteams_invitation | 16 KB |
| ix_permissions_tool UNUSED | 16 KB |
| ix_sessions_expires UNUSED | 16 KB |
| ix_sessions_token | 16 KB |
| ix_sessions_user | 16 KB |
| ix_users_email | 16 KB |
| ix_users_status UNUSED | 16 KB |
| permissions_code_key | 16 KB |
| permissions_pkey | 16 KB |
| sessions_pkey | 16 KB |
| sessions_token_hash_key | 16 KB |
| teams_pkey | 16 KB |
| uq_pending_invite_per_email | 16 KB |
| uq_team_name_active | 16 KB |
| users | 16 KB |
| users_email_key | 16 KB |
| users_pkey | 16 KB |
| alembic_version | 8 KB |
| invitation_permissions_pkey | 8 KB |
| invitation_teams | 8 KB |
| invitations | 8 KB |
| ix_invperms_invitation | 8 KB |
| ix_jobruns_name UNUSED | 8 KB |
| ix_membership_team UNUSED | 8 KB |
| ix_membership_user | 8 KB |
| ix_otp_email UNUSED | 8 KB |
| ix_resets_user UNUSED | 8 KB |
| membership_permissions_pkey | 8 KB |
| otp_codes_pkey | 8 KB |
| password_resets_pkey | 8 KB |
| password_resets_token_hash_key | 8 KB |
| permissions | 8 KB |
| scheduled_job_runs_pkey | 8 KB |
| sessions | 8 KB |
| team_memberships_pkey | 8 KB |
| team_permissions_pkey | 8 KB |
| teams | 8 KB |
| uq_job_slot | 8 KB |
| uq_membership | 8 KB |
| uq_membership_permission | 8 KB |
| uq_team_permission | 8 KB |
| invitation_permissions | 0 Bytes |
| membership_permissions | 0 Bytes |
| otp_codes | 0 Bytes |
| password_resets | 0 Bytes |
| scheduled_job_runs | 0 Bytes |
| team_memberships | 0 Bytes |
| team_permissions | 0 Bytes |