Auto-Delete Spans After 24 Hours: Is It Possible?

Phoenix does not currently support automatic deletion of spans after a certain time interval like 24 hours. However, you can manually connect to the database and issue queries to delete spans older than a certain date. For SQLite, there is no authentication required, and for PostgreSQL, you can log in as the root user to perform deletions (source).

Would you like more details on how to manually delete spans from the database?

Sources: - Slack conversation on TTL and manual deletion

Yes, Phoenix provides a function to delete specific traces by their IDs using the delete_traces function. Here is an example:

```

from phoenix.server.types import DbSessionFactory

async def delete_traces(db: DbSessionFactory, *trace_ids: str) -> List[int]: if not trace_ids: return [] stmt = ( delete(models.Trace) .where(models.Trace.trace_id.in_(set(trace_ids))) .returning(models.Trace.id) ) async with db() as session: return list(await session.scalars(stmt))