Space
Database Size: 171 MB
7 unused indices. Remove them for faster writes.
rails generate migration remove_unused_indexes
And paste
remove_index :execution_entity, name: "idx_execution_entity_workflow_id_started_at" remove_index :credentials_entity, name: "idx_07fde106c0b471d8cc80a64fc8" remove_index :webhook_entity, name: "idx_16f4436789e804e3e1c9eeb240" remove_index :test_metric, name: "IDX_3a4e9cf37111ac3270e2469b47" remove_index :test_run, name: "IDX_3a81713a76f2295b12b46cdfca" remove_index :test_case_execution, name: "IDX_8e4b4774db42f1e6dda3452b2a" remove_index :execution_annotation_tags, name: "IDX_a3697779b366e131b2bbdae297"
| Relation | Size |
|---|---|
| execution_data | 151 MB |
| workflow_entity | 5.48 MB |
| idx_execution_entity_workflow_id_started_at UNUSED | 1.39 MB |
| execution_entity | 1.31 MB |
| pk_e3e63bbf986767844bbe1166d4e | 568 KB |
| idx_execution_entity_stopped_at_status_deleted_at | 520 KB |
| execution_data_pkey | 464 KB |
| IDX_execution_entity_deletedAt | 280 KB |
| workflow_history | 248 KB |
| settings | 192 KB |
| webhook_entity | 48 KB |
| workflow_statistics | 48 KB |
| workflows_tags | 40 KB |
| PK_b6572dd6173e4cd06fe79937b58 | 32 KB |
| IDX_1e31657f5fe46816c34be7c1b4 | 16 KB |
| IDX_5f0643f6717905a05164090dde | 16 KB |
| IDX_61448d56d61802b5dfde5cdb00 | 16 KB |
| IDX_97f863fa83c4786f1956508496 | 16 KB |
| IDX_workflow_entity_name | 16 KB |
| PK_1caaa312a5d7184a003be0f0cb6 | 16 KB |
| PK_4d68b1358bb5b766d3e78f32f57 | 16 KB |
| PK_5779069b7235b256d91f7af1a15 | 16 KB |
| PK_5ba87620386b847201c9531c58f | 16 KB |
| PK_7afcf93ffa20c4252869a7c6a23 | 16 KB |
| PK_8c82d7f526340ab734260ea46be | 16 KB |
| PK_8ef3a59796a228913f251779cff | 16 KB |
| PK_b21ace2e13596ccd87dc9bf4ea6 | 16 KB |
| PK_dc0fe14e6d9943f268e7b119f69ab8bd | 16 KB |
| PK_e853ce24e8200abe5721d2c6ac552b73 | 16 KB |
| PK_ea8f538c94b6e352418254ed6474a81f | 16 KB |
| UQ_5b49d0f504f7ef31045a1fb2eb8 | 16 KB |
| UQ_e12875dfb3b1d92d7d7c5377e2 | 16 KB |
| credentials_entity | 16 KB |
| credentials_entity_pkey | 16 KB |
| execution_annotations | 16 KB |
| idx_07fde106c0b471d8cc80a64fc8 UNUSED | 16 KB |
| idx_16f4436789e804e3e1c9eeb240 UNUSED | 16 KB |
| idx_812eb05f7451ca757fb98444ce | 16 KB |
| idx_execution_entity_wait_till_status_deleted_at | 16 KB |
| idx_workflows_tags_workflow_id | 16 KB |
| invalid_auth_token | 16 KB |
| migrations | 16 KB |
| pk_credentials_entity_id | 16 KB |
| pk_tag_entity_id | 16 KB |
| pk_workflow_entity_id | 16 KB |
| pk_workflow_statistics | 16 KB |
| pk_workflows_tags | 16 KB |
| project | 16 KB |
| project_relation | 16 KB |
| shared_credentials | 16 KB |
| shared_workflow | 16 KB |
| tag_entity_pkey | 16 KB |
| user | 16 KB |
| workflow_entity_pkey | 16 KB |
| IDX_14f68deffaf858465715995508 | 8 KB |
| IDX_1d8ab99d5861c9388d2dc1cf73 | 8 KB |
| IDX_1ef35bac35d20bdae979d917a3 | 8 KB |
| IDX_3a4e9cf37111ac3270e2469b47 UNUSED | 8 KB |
| IDX_3a81713a76f2295b12b46cdfca UNUSED | 8 KB |
| IDX_60b6a84299eeb3f671dfec7693 | 8 KB |
| IDX_63d7bbae72c767cf162d459fcc | 8 KB |
| IDX_8e4b4774db42f1e6dda3452b2a UNUSED | 8 KB |
| IDX_9ec1ce6fbf82305f489adb971d | 8 KB |
| IDX_a3697779b366e131b2bbdae297 UNUSED | 8 KB |
| IDX_ae51b54c4bb430cf92f48b623f | 8 KB |
| IDX_b0dd0087fe3da02b0ffa4b9c5b | 8 KB |
| IDX_c1519757391996eb06064f0e7c | 8 KB |
| IDX_cec8eea3bf49551482ccb4933e | 8 KB |
| PK_011c050f566e9db509a0fadb9b9 | 8 KB |
| PK_08cc9197c39b028c1e9beca225940576fd1a5804 | 8 KB |
| PK_17a0b6284f8d626aae88e1c16e4 | 8 KB |
| PK_27e4e00852f6b06a925a4d83a3e | 8 KB |
| PK_3e98b8e20acc19c5030a8644142 | 8 KB |
| PK_6278a41a706740c94c02e288df8 | 8 KB |
| PK_69dfa041592c30bbc0d4b84aa00 | 8 KB |
| PK_8ebd28194e4f792f96b5933423fc439df97d9689 | 8 KB |
| PK_90c121f77a78a6580e94b794bce | 8 KB |
| PK_978fa5caa3468f463dac9d92e69 | 8 KB |
| PK_979ec03d31294cca484be65d11f | 8 KB |
| PK_b606942249b90cc39b0265f0575 | 8 KB |
| PK_ca04b9d8dc72de268fe07a65773 | 8 KB |
| PK_ec15125755151e3a7e00e00014f | 8 KB |
| PK_f448a94c35218b6208ce20cf5a1 | 8 KB |
| auth_identity_pkey | 8 KB |
| auth_provider_sync_history | 8 KB |
| auth_provider_sync_history_pkey | 8 KB |
| event_destinations | 8 KB |
| event_destinations_pkey | 8 KB |
| execution_metadata | 8 KB |
| installed_nodes | 8 KB |
| pk_test_definition_id | 8 KB |
| pk_variables_id | 8 KB |
| processed_data | 8 KB |
| role | 8 KB |
| tag_entity | 8 KB |
| test_case_execution | 8 KB |
| test_definition | 8 KB |
| test_definition_pkey | 8 KB |
| test_run | 8 KB |
| user_api_keys | 8 KB |
| variables_key_key | 8 KB |
| variables_pkey | 8 KB |
| annotation_tag_entity | 0 Bytes |
| auth_identity | 0 Bytes |
| execution_annotation_tags | 0 Bytes |
| folder | 0 Bytes |
| folder_tag | 0 Bytes |
| insights_by_period | 0 Bytes |
| insights_metadata | 0 Bytes |
| insights_raw | 0 Bytes |
| installed_packages | 0 Bytes |
| test_metric | 0 Bytes |
| variables | 0 Bytes |