safe-global / safe-transaction-service / 20232480077

91%

master: 100%

push

github

Clean db indexes

- Swap wrong index names `history_decoded_not_proc_idx` and `history_decoded_processed_idx`
- Remove not used indexes

The following indexes have been identified as unused (0 scans) and are being removed to reduce database size:

| Index Name | Mainnet DB Size | Polygon DB Size | Usage Status | Justification |
|------------|----------------|-----------------|--------------|---------------|
| `history_ethereumtx_to_9fb37c13` | 1588 MB | 9893 MB | 0 scans | Unused - no queries filter by `to` field |
| `history_ethereumtx__from_e36d4662` | 1758 MB | 8707 MB | 0 scans | Unused - no queries filter by `_from` field |
| `history_ethereumtx_status_d1d0de2c` | 1074 MB | 6645 MB | 0 scans | Unused - no queries filter by `status` field |
| `history_internaltxdecoded_function_name_333ae03e` | 519 MB | 3204 MB | 0 scans (DB1) / 69K scans (DB2) | Replaced by dedicated `history_decoded_setup_idx` for `function_name="setup"` queries |
| `history_internaltxdecoded_function_name_333ae03e_like` | 519 MB | 3205 MB | 0 scans | Unused - no LIKE queries on `function_name` |
| `history_multisigtransaction_failed_4842ad6b` | 43 MB | N/A | 0 scans | Unused - field is used but index is not needed |
| `history_decoded_setup_idx` | 13 MB | 194 MB | 0 scans (DB1) / 62K scans (DB2) | **KEEPING** - Used in DB2, will monitor DB1 |
| `history_safe_banned_idx` | 8 KB | N/A | 0 scans | Unused - no queries filter by `banned=True` |

**Total Potential Savings:**
- Database 1: ~5.5 GB
- Database 2: ~28.5 GB

**Note:** The `function_name` indexes are being removed because:
- The dedicated `history_decoded_setup_idx` (partial index on `safe_address` WHERE `function_name="setup"`) covers the only production query that filters by `function_name`
- Admin interface filtering does not require these indexes for performance
- All other `function_name` queries are in tests or already-executed migrations

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

8551 of 9426 relevant lines covered (90.72%)

0.91 hits per line