# Quick growth of piece\_expiration.db

**URL:** <https://forum.storj.io/t/quick-growth-of-piece-expiration-db/24965>\
**Category:** troubleshooting\
**Tags:** database\
**Created:** [January 15, 2024, 5:58pm UTC](https://forum.storj.io/t/quick-growth-of-piece-expiration-db/24965 "2024-01-15T17:58:17Z")\
**Posts on this page:** 1\
**Showing post:** 34

<div class="post-metadata">

**Author:** ![nerdatwork](https://storj.bcdn.literatehosting.com/user_avatar/forum.storj.io/nerdatwork/32/1135_2.png) [@nerdatwork](https://forum.storj.io/u/nerdatwork)\
**Post date:** [January 22, 2024, 7:13am UTC](https://forum.storj.io/t/quick-growth-of-piece-expiration-db/24965/34 "2024-01-22T07:13:31Z")

</div>

First SQL query 👇

```auto
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 👇

```auto
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](https://sqlitebrowser.org/dl/)

---

_[View the full topic](https://forum.storj.io/t/quick-growth-of-piece-expiration-db/24965)._
