Quick growth of piece_expiration.db

Node Operators troubleshooting
34

First SQL query :point_down:

SELECT
 strftime('%Y', piece_expiration) AS year,
 COUNT (piece_id) AS num_piece_ids
FROM
   piece_expirations
GROUP BY
  year
ORDER BY
   year;

Second SQL query :point_down:

SELECT
    satellite_id, piece_id, piece_expiration, deletion_failed_at
FROM
    piece_expirations
WHERE
    piece_expiration < '2023-01-01 00:00:00'
ORDER BY
    piece_expiration;

You can get the binaries from Downloads - DB Browser for SQLite

2 Likes