@Ignore("performance")
  @Test
  public void testDeletionWritePerformance() throws SQLException, IOException {
    int fileNumMax = 10000;
    int fileNumStep = 100;
    int deletionRepetitions = 10;
    List<Integer> fileNumsRecorded = new ArrayList<>();
    List<Long> timeConsumptionNsRecorded = new ArrayList<>();

    try (Connection connection = EnvFactory.getEnv().getConnection(BaseEnv.TABLE_SQL_DIALECT);
        Statement statement = connection.createStatement()) {
      statement.execute("SET CONFIGURATION enable_seq_space_compaction='false'");

      statement.execute("create database if not exists test");
      statement.execute("use test");

      statement.execute("create table table1(deviceId STRING TAG, s0 INT32 FIELD)");

      for (int i = 1; i <= fileNumMax; i++) {
        statement.execute(
            String.format("INSERT INTO test.table1(time, deviceId, s0) VALUES(%d,'d0',%d)", i, i));
        statement.execute("FLUSH");

        if (i % fileNumStep == 0) {
          long start = System.nanoTime();
          for (int j = 0; j < deletionRepetitions; j++) {
            statement.execute("DELETE FROM test.table1 WHERE deviceId = 'd0'");
          }
          long end = System.nanoTime();
          fileNumsRecorded.add(i);
          long timeConsumption = (end - start) / deletionRepetitions;
          timeConsumptionNsRecorded.add(timeConsumption);

          System.out.println(i + "," + timeConsumption);
        }
      }
    }

    try (BufferedWriter writer = new BufferedWriter(new FileWriter("test.txt"))) {
      writer.write(
          fileNumsRecorded.stream().map(i -> Integer.toString(i)).collect(Collectors.joining(",")));
      writer.write("\n");
      writer.write(
          timeConsumptionNsRecorded.stream()
              .map(i -> Long.toString(i))
              .collect(Collectors.joining(",")));
      writer.flush();
    }
  }
Should delete this case after the deletion value filter feature be implemented
integration-test/src/test/java/org/apache/iotdb/relational/it/db/it/IoTDBDeletionTableIT.java