命令窗口进入Dify部署目录中，执行命令
# 使用会话ID删除单条记录
docker-compose exec db psql -U postgres -d dify -c "
DELETE FROM messages WHERE conversation_id = '会话ID';
DELETE FROM conversations WHERE id = '会话ID';
"
# 删除30天前的日志
docker-compose exec db psql -U postgres -d dify -c "
DELETE FROM messages WHERE created_at < NOW() - INTERVAL '30 days';
DELETE FROM conversations WHERE created_at < NOW() - INTERVAL '30 days';
"
# 删除指定日期前的日志
docker-compose exec db psql -U postgres -d dify -c "
DELETE FROM messages WHERE created_at < '2025-01-01';
DELETE FROM conversations WHERE created_at < '2025-01-01';
"
# 清空全部日志
docker-compose exec db psql -U postgres -d dify -c "
DELETE FROM messages;
DELETE FROM conversations;
"