Space
Database Size: 423 MB
27 unused indices. Remove them for faster writes.
rails generate migration remove_unused_indexes
And paste
remove_index :uk_postcodes, name: "idx_postcodes_plain" remove_index :execution_entity, name: "idx_execution_entity_stopped_at_status_deleted_at" remove_index :item_variants, name: "idx_item_variants_name" remove_index :execution_entity, name: "idx_execution_entity_workflow_id_started_at" remove_index :items, name: "idx_items_name" remove_index :project_relation, name: "IDX_5f0643f6717905a05164090dde" remove_index :project_relation, name: "IDX_61448d56d61802b5dfde5cdb00" remove_index :credentials_entity, name: "idx_07fde106c0b471d8cc80a64fc8" remove_index :categories, name: "idx_categories_name" remove_index :items, name: "idx_items_category_id" remove_index :project_relation, name: "project_relation_role_idx" remove_index :user, name: "user_role_idx" remove_index :test_case_execution, name: "IDX_8e4b4774db42f1e6dda3452b2a" remove_index :dynamic_credential_entry, name: "IDX_99b3e329d13b7bb2fa9b6a43f5" remove_index :dynamic_credential_resolver, name: "IDX_9c9ee9df586e60bb723234e499" remove_index :execution_annotation_tags, name: "IDX_a3697779b366e131b2bbdae297" remove_index :workflow_dependency, name: "IDX_a4ff2d9b9628ea988fa9e7d0bf" remove_index :chat_hub_messages, name: "IDX_chat_hub_messages_sessionId" remove_index :chat_hub_sessions, name: "IDX_chat_hub_sessions_owner_lastmsg_id" remove_index :dynamic_credential_entry, name: "IDX_d57808fe08b77464f6a88a2549" remove_index :test_run, name: "IDX_d6870d3b6e4c185d33926f423c" remove_index :workflow_dependency, name: "IDX_e48a201071ab85d9d09119d640" remove_index :workflow_dependency, name: "IDX_e7fe1cfda990c14a445937d0b9" remove_index :item_components, name: "idx_item_components_item_id" remove_index :item_options, name: "idx_item_options_item_id" remove_index :item_tags, name: "idx_item_tags_item_id" remove_index :item_tags, name: "idx_item_tags_name"
| Relation | Size |
|---|---|
| uk_postcodes | 149 MB |
| idx_postcodes_fast_lookup | 120 MB |
| uk_postcodes_pkey | 81.4 MB |
| idx_postcodes_plain UNUSED | 58.3 MB |
| orders kebab_king | 680 KB |
| execution_data | 608 KB |
| order_items kebab_king | 528 KB |
| PK_ec15125755151e3a7e00e00014f | 424 KB |
| workflow_history | 152 KB |
| idx_execution_entity_stopped_at_status_deleted_at UNUSED | 136 KB |
| idx_order_items_order_id kebab_king | 120 KB |
| order_items_pkey kebab_king | 120 KB |
| orders_pkey kebab_king | 120 KB |
| workflow_entity | 112 KB |
| binary_data | 104 KB |
| idx_item_variants_name kebab_king UNUSED | 96 KB |
| execution_data_pkey | 88 KB |
| idx_execution_entity_workflow_id_started_at UNUSED | 88 KB |
| idx_orders_customer_id kebab_king | 72 KB |
| items kebab_king | 56 KB |
| role_scope | 56 KB |
| execution_entity | 48 KB |
| migrations | 48 KB |
| scope | 48 KB |
| webhook_entity | 48 KB |
| PK_role_scope | 40 KB |
| idx_items_name kebab_king UNUSED | 40 KB |
| insights_by_period | 40 KB |
| item_variants kebab_king | 40 KB |
| items_name_category_id_key kebab_king | 40 KB |
| workflow_statistics | 40 KB |
| IDX_070b5de842ece9ccdda0d9738b | 16 KB |
| IDX_1d8ab99d5861c9388d2dc1cf73 | 16 KB |
| IDX_1e31657f5fe46816c34be7c1b4 | 16 KB |
| IDX_56900edc3cfd16612e2ef2c6a8 | 16 KB |
| IDX_5f0643f6717905a05164090dde UNUSED | 16 KB |
| IDX_60b6a84299eeb3f671dfec7693 | 16 KB |
| IDX_61448d56d61802b5dfde5cdb00 UNUSED | 16 KB |
| IDX_UniqueRoleDisplayName | 16 KB |
| IDX_execution_entity_deletedAt | 16 KB |
| IDX_role_scope_scopeSlug | 16 KB |
| IDX_workflow_entity_name | 16 KB |
| PK_1caaa312a5d7184a003be0f0cb6 | 16 KB |
| PK_35c9b140caaf6da09cfabb0d675 | 16 KB |
| PK_4d68b1358bb5b766d3e78f32f57 | 16 KB |
| PK_5ba87620386b847201c9531c58f | 16 KB |
| PK_8c82d7f526340ab734260ea46be | 16 KB |
| PK_8ef3a59796a228913f251779cff | 16 KB |
| PK_b21ace2e13596ccd87dc9bf4ea6 | 16 KB |
| PK_b606942249b90cc39b0265f0575 | 16 KB |
| PK_b6572dd6173e4cd06fe79937b58 | 16 KB |
| PK_bfc45df0481abd7f355d6187da1 | 16 KB |
| PK_c788f7caf88e91e365c97d6d04a | 16 KB |
| PK_dc0fe14e6d9943f268e7b119f69ab8bd | 16 KB |
| PK_ea8f538c94b6e352418254ed6474a81f | 16 KB |
| PK_f448a94c35218b6208ce20cf5a1 | 16 KB |
| PK_fc3691585b39408bb0551122af6 | 16 KB |
| UQ_e12875dfb3b1d92d7d7c5377e2 | 16 KB |
| business_hours_pkey kebab_king | 16 KB |
| categories_name_key kebab_king | 16 KB |
| categories_pkey kebab_king | 16 KB |
| client_registry | 16 KB |
| client_registry_client_slug_key | 16 KB |
| client_registry_db_schema_key | 16 KB |
| client_registry_pkey | 16 KB |
| credentials_entity | 16 KB |
| credentials_entity_pkey | 16 KB |
| customers kebab_king | 16 KB |
| customers_phone_key kebab_king | 16 KB |
| customers_pkey kebab_king | 16 KB |
| idx_07fde106c0b471d8cc80a64fc8 UNUSED | 16 KB |
| idx_16f4436789e804e3e1c9eeb240 | 16 KB |
| idx_categories_name kebab_king UNUSED | 16 KB |
| idx_customers_phone kebab_king | 16 KB |
| idx_item_variants_item_id kebab_king | 16 KB |
| idx_items_category_id kebab_king UNUSED | 16 KB |
| insights_raw | 16 KB |
| item_variants_pkey kebab_king | 16 KB |
| items_pkey kebab_king | 16 KB |
| pk_credentials_entity_id | 16 KB |
| pk_e3e63bbf986767844bbe1166d4e | 16 KB |
| pk_workflow_entity_id | 16 KB |
| pk_workflow_statistics | 16 KB |
| project | 16 KB |
| project_relation | 16 KB |
| project_relation_role_idx UNUSED | 16 KB |
| project_relation_role_project_idx | 16 KB |
| role | 16 KB |
| settings | 16 KB |
| shared_credentials | 16 KB |
| shared_workflow | 16 KB |
| user | 16 KB |
| user_role_idx UNUSED | 16 KB |
| workflow_entity_pkey | 16 KB |
| IDX_14f68deffaf858465715995508 | 8 KB |
| IDX_1ef35bac35d20bdae979d917a3 | 8 KB |
| IDX_63d7bbae72c767cf162d459fcc | 8 KB |
| IDX_8e4b4774db42f1e6dda3452b2a UNUSED | 8 KB |
| IDX_97f863fa83c4786f1956508496 | 8 KB |
| IDX_99b3e329d13b7bb2fa9b6a43f5 UNUSED | 8 KB |
| IDX_9c9ee9df586e60bb723234e499 UNUSED | 8 KB |
| IDX_a3697779b366e131b2bbdae297 UNUSED | 8 KB |
| IDX_a4ff2d9b9628ea988fa9e7d0bf UNUSED | 8 KB |
| IDX_ae51b54c4bb430cf92f48b623f | 8 KB |
| IDX_c1519757391996eb06064f0e7c | 8 KB |
| IDX_cec8eea3bf49551482ccb4933e | 8 KB |
| IDX_chat_hub_messages_sessionId UNUSED | 8 KB |
| IDX_chat_hub_sessions_owner_lastmsg_id UNUSED | 8 KB |
| IDX_d57808fe08b77464f6a88a2549 UNUSED | 8 KB |
| IDX_d6870d3b6e4c185d33926f423c UNUSED | 8 KB |
| IDX_e48a201071ab85d9d09119d640 UNUSED | 8 KB |
| IDX_e7fe1cfda990c14a445937d0b9 UNUSED | 8 KB |
| PK_011c050f566e9db509a0fadb9b9 | 8 KB |
| PK_08cc9197c39b028c1e9beca225940576fd1a5804 | 8 KB |
| PK_17a0b6284f8d626aae88e1c16e4 | 8 KB |
| PK_1eafef1273c70e4464fec703412 | 8 KB |
| PK_27e4e00852f6b06a925a4d83a3e | 8 KB |
| PK_52325e34cd7a2f0f67b0f3cad65 | 8 KB |
| PK_5779069b7235b256d91f7af1a15 | 8 KB |
| PK_6278a41a706740c94c02e288df8 | 8 KB |
| PK_673cb121ee4a8a5e27850c72c51 | 8 KB |
| PK_69dfa041592c30bbc0d4b84aa00 | 8 KB |
| PK_74abaed0b30711b6532598b0392 | 8 KB |
| PK_7704a5add6baed43eef835f0bfb | 8 KB |
| PK_7afcf93ffa20c4252869a7c6a23 | 8 KB |
| PK_7bc73da3b8be7591696e14809d5 | 8 KB |
| PK_85b9ada746802c8993103470f05 | 8 KB |
| PK_8ebd28194e4f792f96b5933423fc439df97d9689 | 8 KB |
| PK_90c121f77a78a6580e94b794bce | 8 KB |
| PK_978fa5caa3468f463dac9d92e69 | 8 KB |
| PK_979ec03d31294cca484be65d11f | 8 KB |
| PK_b76cfb088dcdaf5275e9980bb64 | 8 KB |
| PK_c4759172d3431bae6f04e678e0d | 8 KB |
| PK_ca04b9d8dc72de268fe07a65773 | 8 KB |
| PK_dcd71f96a5d5f4bf79e67d322bf | 8 KB |
| PK_e226d0001b9e6097cbfe70617cb | 8 KB |
| PK_f39a3b36bbdf0e2979ddb21cf78 | 8 KB |
| PK_fb91ab932cfbd694061501cc20f | 8 KB |
| UQ_083721d99ce8db4033e2958ebb4 | 8 KB |
| UQ_8082ec4890f892f0bc77473a123 | 8 KB |
| UQ_b23096ef747281ac944d28e8b0d | 8 KB |
| auth_identity_pkey | 8 KB |
| auth_provider_sync_history | 8 KB |
| auth_provider_sync_history_pkey | 8 KB |
| business_hours kebab_king | 8 KB |
| categories kebab_king | 8 KB |
| chat_hub_agents | 8 KB |
| chat_hub_messages | 8 KB |
| chat_hub_sessions | 8 KB |
| dynamic_credential_entry | 8 KB |
| dynamic_credential_resolver | 8 KB |
| event_destinations | 8 KB |
| event_destinations_pkey | 8 KB |
| execution_annotations | 8 KB |
| execution_metadata | 8 KB |
| idx_812eb05f7451ca757fb98444ce | 8 KB |
| idx_execution_entity_wait_till_status_deleted_at | 8 KB |
| idx_item_components_item_id kebab_king UNUSED | 8 KB |
| idx_item_options_item_id kebab_king UNUSED | 8 KB |
| idx_item_tags_item_id kebab_king UNUSED | 8 KB |
| idx_item_tags_name kebab_king UNUSED | 8 KB |
| idx_workflows_tags_workflow_id | 8 KB |
| insights_metadata | 8 KB |
| installed_nodes | 8 KB |
| invalid_auth_token | 8 KB |
| item_components_pkey kebab_king | 8 KB |
| item_options_pkey kebab_king | 8 KB |
| item_tags_pkey kebab_king | 8 KB |
| oauth_access_tokens | 8 KB |
| oauth_authorization_codes | 8 KB |
| oauth_clients | 8 KB |
| oauth_refresh_tokens | 8 KB |
| oauth_user_consents | 8 KB |
| pk_tag_entity_id | 8 KB |
| pk_workflows_tags | 8 KB |
| processed_data | 8 KB |
| tag_entity_pkey | 8 KB |
| test_case_execution | 8 KB |
| test_run | 8 KB |
| user_api_keys | 8 KB |
| variables_global_key_unique | 8 KB |
| variables_pkey | 8 KB |
| variables_project_key_unique | 8 KB |
| workflow_dependency | 8 KB |
| workflow_publish_history | 8 KB |
| annotation_tag_entity | 0 Bytes |
| auth_identity | 0 Bytes |
| data_table | 0 Bytes |
| data_table_column | 0 Bytes |
| execution_annotation_tags | 0 Bytes |
| folder | 0 Bytes |
| folder_tag | 0 Bytes |
| installed_packages | 0 Bytes |
| item_components kebab_king | 0 Bytes |
| item_options kebab_king | 0 Bytes |
| item_tags kebab_king | 0 Bytes |
| tag_entity | 0 Bytes |
| variables | 0 Bytes |
| workflows_tags | 0 Bytes |