Space

Database Size: 25.9 MB

11 unused indices. Remove them for faster writes.

rails generate migration remove_unused_indexes

And paste

remove_index :job, name: "idx_job_jobDefinitionVersionId"
remove_index :cloud_auth, name: "idx_cloudAuth_cloudProviderId"
remove_index :compute_env, name: "idx_computeEnv_cloudAuthId"
remove_index :compute_env, name: "idx_computeEnv_instanceTypeId"
remove_index :compute_env, name: "idx_computeEnv_instanceTypeLocationId"
remove_index :compute_spawn, name: "idx_computeSpawn_computeType"
remove_index :user, name: "idx_user_dateJoined"
remove_index :aws_vpc_subnet, name: "idx_awsVpcSubnet_awsVpcId"
remove_index :aws_vpc, name: "idx_awsVpc_cloudAuthIdRegionName"
remove_index :cron_job, name: "idx_cronJob_nextTriggerAtIsActive"
remove_index :job_run, name: "idx_jobRun_timeTakenCalc"

Relation	Size
compute_spawn	5.43 MB
job	3.68 MB
idx_job_projectIdSubmittedAtState	1.53 MB
job_run	1.3 MB
staging_logs	1.04 MB
unique_job_name	728 KB
idx_job_countStat	600 KB
idx_stagingLogs_objectIdPurpose	440 KB
job_pkey	344 KB
idx_jobRun_jobId	216 KB
job_run_pkey	168 KB
staging_logs_pkey	168 KB
idx_job_jobQueueId	128 KB
idx_job_jobDefinitionVersionId UNUSED	120 KB
idx_job_queueStatePriorityCreatedAt	112 KB
idx_jobRun_projectId	88 KB
idx_jobRun_state	88 KB
idx_jobRun_computeSpawnId	72 KB
country	64 KB
project	48 KB
_sqlx_migrations	16 KB
_sqlx_migrations_pkey	16 KB
cloud_auth	16 KB
cloud_auth_pkey	16 KB
cloud_provider	16 KB
cloud_provider_location_pkey	16 KB
cloud_provider_pkey	16 KB
compute_env	16 KB
compute_env_pkey	16 KB
compute_spawn_pkey	16 KB
container_registry_auth	16 KB
container_registry_auth_pkey	16 KB
continent_pkey	16 KB
country_pkey	16 KB
idx_cloudAuth_cloudProviderId UNUSED	16 KB
idx_cloudAuth_projectId	16 KB
idx_computeEnv_cloudAuthId UNUSED	16 KB
idx_computeEnv_computeType	16 KB
idx_computeEnv_instanceTypeId UNUSED	16 KB
idx_computeEnv_instanceTypeLocationId UNUSED	16 KB
idx_computeEnv_projectId	16 KB
idx_computeSpawn_computeEnvId	16 KB
idx_computeSpawn_computeType UNUSED	16 KB
idx_computeSpawn_jobQueueId	16 KB
idx_computeSpawn_projectId	16 KB
idx_computeSpawn_projectStateCreatedAt	16 KB
idx_computeSpawn_state	16 KB
idx_computeSpawn_stateTypeStateUpdated	16 KB
idx_project_isActiveLastSchedulerAccess	16 KB
idx_user_dateJoined UNUSED	16 KB
instance_family	16 KB
instance_family_pkey	16 KB
instance_type	16 KB
instance_type_location	16 KB
instance_type_location_pkey	16 KB
instance_type_pkey	16 KB
job_definition	16 KB
job_definition_pkey	16 KB
job_definition_version	16 KB
job_definition_version_pkey	16 KB
job_queue	16 KB
job_queue_compute_env_pkey	16 KB
job_queue_pkey	16 KB
location	16 KB
location_pkey	16 KB
project_api_key	16 KB
project_api_key_pkey	16 KB
project_pkey	16 KB
unique_cloudProviderLocation_code	16 KB
unique_cloudProvider_code	16 KB
unique_cloudProvider_name	16 KB
unique_continent_name	16 KB
unique_country_code	16 KB
unique_country_iso3	16 KB
unique_country_isoNumeric	16 KB
unique_country_name	16 KB
unique_instanceTypeLocation_cloudProviderLocation	16 KB
unique_instanceType_code	16 KB
unique_jobDefinitionVersion_version	16 KB
unique_jobDefinition_name	16 KB
unique_jobQueueComputeEnv_computeEnvId	16 KB
unique_jobQueue_name	16 KB
unique_location_slug	16 KB
unique_project_code	16 KB
unique_user_email	16 KB
unique_user_githubUserId	16 KB
unique_user_googleUserId	16 KB
user	16 KB
user_pkey	16 KB
action_log	8 KB
action_log_pkey	8 KB
aws_vpc	8 KB
aws_vpc_pkey	8 KB
aws_vpc_subnet	8 KB
aws_vpc_subnet_pkey	8 KB
cloud_provider_location	8 KB
continent	8 KB
cron_job	8 KB
cron_job_pkey	8 KB
idx_awsVpcSubnet_awsVpcId UNUSED	8 KB
idx_awsVpc_cloudAuthIdRegionName UNUSED	8 KB
idx_computeSpawn_stateTerminationQueued	8 KB
idx_cronJob_nextTriggerAtIsActive UNUSED	8 KB
idx_cronJob_projectId	8 KB
idx_jobRun_timeTakenCalc UNUSED	8 KB
idx_job_pendingExpiresAt	8 KB
idx_job_stateCreatedAt	8 KB
job_queue_compute_env	8 KB
project_user	8 KB
project_user_pkey	8 KB
unique_projectUser_userId	8 KB