Delete data

This page documents an earlier version of InfluxDB. InfluxDB v2.7 is the latest stable version. View this page in the v2.7 documentation.

Use the influx CLI or the InfluxDB API /api/v2/delete endpoint to delete data from an InfluxDB bucket.

InfluxDB 2.3 supports deleting data by the following:

  • time range
  • measurement (_measurement)
  • tag

InfluxDB 2.3 does not support deleting data by field.

Once a delete request completes successfully, the deleted data is no longer queryable, but will remain on disk until the compaction service runs.

Delete data using the influx CLI

Use InfluxDB CLI connection configurations to provide your InfluxDB host, organization, and API token.

  1. Use the influx delete command to delete points from InfluxDB.

  2. Use the --bucket flag to specify which bucket to delete data from.

  3. Use the --start and --stop flags to define the time range to delete data from. Use RFC3339 timestamps.

  4. (Optional) Use the -p, --predicate flag to include a delete predicate that identifies which points to delete.

    Deleting data without a delete predicate deletes all data in the specified bucket with timestamps between the specified start and stop times.

Examples

Delete points in a specific measurement with a specific tag value
  1. influx delete --bucket example-bucket \
  2. --start '1970-01-01T00:00:00Z' \
  3. --stop $(date +"%Y-%m-%dT%H:%M:%SZ") \
  4. --predicate '_measurement="example-measurement" AND exampleTag="exampleTagValue"'
Delete all points in a specified time range
  1. influx delete --bucket example-bucket \
  2. --start 2020-03-01T00:00:00Z \
  3. --stop 2020-11-14T00:00:00Z

Delete data using the API

Use the InfluxDB API /api/v2/delete endpoint to delete points from InfluxDB.

  1. POST http://localhost:8086/api/v2/delete

Include the following:

  • Request method: POST
  • Headers:
    • Authorization: Token schema with your InfluxDB API token
    • Content-type: application/json
  • Query parameters:
  • Request body: JSON object with the following fields:
    * Required

    • * start: earliest time to delete data from (RFC3339)

    • * stop: latest time to delete data from (RFC3339)

    • predicate: delete predicate statement

      Deleting data without a delete predicate deletes all data in the specified bucket with timestamps between the specified start and stop times.

Examples

Delete points in a specific measurement with a specific tag value
  1. curl --request POST http://localhost:8086/api/v2/delete?org=example-org&bucket=example-bucket \
  2. --header 'Authorization: Token YOUR_API_TOKEN' \
  3. --header 'Content-Type: application/json' \
  4. --data '{
  5. "start": "2020-03-01T00:00:00Z",
  6. "stop": "2020-11-14T00:00:00Z",
  7. "predicate": "_measurement=\"example-measurement\" AND exampleTag=\"exampleTagValue\""
  8. }'
Delete all points in a specified time range
  1. curl --request POST http://localhost:8086/api/v2/delete?org=example-org&bucket=example-bucket \
  2. --header 'Authorization: Token YOUR_API_TOKEN' \
  3. --header 'Content-Type: application/json' \
  4. --data '{
  5. "start": "2020-03-01T00:00:00Z",
  6. "stop": "2020-11-14T00:00:00Z"
  7. }'

For more information, see the /api/v2/delete endpoint documentation.

delete