safe-global / safe-transaction-service / 17467561510

91%

master: 100%

push

github

Remove some not used indexes for InternalTx

After analyzing usage of indexes in production:

- `call_type`, `tx_type` and `refund_address` indexes are never used.
- `value`, `to`, `timestamp` and `block_number` are close to no usage.
- `_from` index is covered in `("_from", "timestamp", "id")` index

Raw data about index usage in Mainnet and Worldchain production
databases:

```
mainnet => select schemaname || '.' || indexrelname as index, idx_scan, last_idx_scan from pg_stat_user_indexes;
                                 index                                  |  idx_scan  |         last_idx_scan
------------------------------------------------------------------------+------------+-------------------------------
 public.account_abstraction_safeoperation_pkey                          |       3305 | 2025-09-03 11:32:24.308323+00
 public.account_abstraction_safeoperation_user_operation_id_key         |     194047 | 2025-09-03 12:16:44.046243+00
 public.account_abstraction_safeoperationconfirmation_pkey              |          0 |
 public.account_abstraction_useroperation_pkey                          |     393064 | 2025-09-03 12:16:44.046243+00
 public.account_abstraction_useroperationreceipt_pkey                   |          0 |
 public.account_abstraction_useroperationreceipt_user_operation_id_key  |     196116 | 2025-09-03 12:16:44.046243+00
 public.auth_group_name_key                                             |          0 |
 public.auth_group_permissions_group_id_permission_id_0cd325b0_uniq     |          0 |
 public.auth_group_permissions_pkey                                     |          0 |
 public.auth_group_pkey                                                 |          0 |
 public.auth_permission_content_type_id_codename_01ab375a_uniq          |        824 | 2025-09-03 06:07:39.418652+00
 public.auth_permission_pkey                                            |          0 |
 public.auth_user_groups_pkey                                       ... (continued)

4 of 4 new or added lines in 1 file covered. (100.0%)

16209 of 17159 relevant lines covered (94.46%)

0.94 hits per line