# Poor Performance: Snapshot creation takes over an hour for a 5-row table

**URL:** https://community.cratedb.com/t/poor-performance-snapshot-creation-takes-over-an-hour-for-a-5-row-table/2017
**Category:** CrateDB
**Tags:** sql
**Created:** [March 27, 2025, 8:17am UTC](https://community.cratedb.com/t/poor-performance-snapshot-creation-takes-over-an-hour-for-a-5-row-table/2017 "2025-03-27T08:17:04Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Jun\_Zhou](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/jun_zhou/32/1079_2.png) [@Jun\_Zhou](https://community.cratedb.com/u/Jun_Zhou)
#### Post date: [March 27, 2025, 8:17am UTC](https://community.cratedb.com/t/poor-performance-snapshot-creation-takes-over-an-hour-for-a-5-row-table/2017/1 "2025-03-27T08:17:04Z")

</div>

In CrateDB 5.5.2, snapshot creation for a 5-row table takes over an hour. What might cause this?

```auto
cr> select count(*) from xxaps.cs_test;
+----------+
| count(*) |
+----------+
| 5 |
+----------+
SELECT 1 row in set (0.003 sec)

cr> CREATE SNAPSHOT repo_cratedb001.snapshot_20250327_cs_test TABLE xxaps.cs_test WITH (wait_for_completion=true);

CREATE OK, 1 row affected (4041.797 sec)

cr> select * from sys.snapshots;
+-------------------+----------+---------------+---------------------------+-----------------+---------------+---------+------------------+-------------------+---------+
| concrete_indices | failures | finished | name | repository | started | state | table_partitions | tables | version |
+-------------------+----------+---------------+---------------------------+-----------------+---------------+---------+------------------+-------------------+---------+
| ["xxaps.cs_test"] | [] | 1743058299042 | snapshot_20250327_cs_test | repo_cratedb001 | 1743056839779 | SUCCESS | [] | ["xxaps.cs_test"] | 5.5.2 |
+-------------------+----------+---------------+---------------------------+-----------------+---------------+---------+------------------+-------------------+---------+
SELECT 1 row in set (0.092 sec)

```