[data] increase default interval for idle detection
diff --git a/python/ray/data/_internal/execution/resource_manager.py b/python/ray/data/_internal/execution/resource_manager.py
index a5dd60c18fafb..30e9791566580 100644
--- a/python/ray/data/_internal/execution/resource_manager.py
+++ b/python/ray/data/_internal/execution/resource_manager.py
@@ -283,7 +283,7 @@ class IdleDetector:
         # The interval to detect idle operators.
         # When downstream is idle, we'll allow reading at least one task output
         # per this interval,
-        DETECTION_INTERVAL_S = 1.0
+        DETECTION_INTERVAL_S = 10.0
         # Print a warning if an operator is idle for this time.
         WARN_ON_IDLE_TIME_S = 60.0
         # Whether a warning has been printed.
diff --git a/python/ray/data/tests/test_backpressure_e2e.py b/python/ray/data/tests/test_backpressure_e2e.py
index 049b57dcc10df..169bbb3d210b2 100644
--- a/python/ray/data/tests/test_backpressure_e2e.py
+++ b/python/ray/data/tests/test_backpressure_e2e.py
@@ -1,4 +1,5 @@
 import time
+from unittest.mock import patch
 
 import numpy as np
 import pandas as pd
@@ -183,7 +184,17 @@ def foo(self):
         block_size=block_size,
         insert_limit_op=insert_limit_op,
     )
-    assert len(ds.take_all()) == num_blocks
+
+    from ray.data._internal.execution.resource_manager import (
+        ReservationOpResourceAllocator,
+    )
+
+    with patch.object(
+        ReservationOpResourceAllocator.IdleDetector,
+        "DETECTION_INTERVAL_S",
+        0.1,
+    ):
+        assert len(ds.take_all()) == num_blocks
 
 
 def test_no_deadlock_with_preserve_order(

<!-- Thank you for your contribution! Please review https://github.com/ray-project/ray/blob/master/CONTRIBUTING.rst before opening a pull request. -->

<!-- Please add a reviewer to the assignee section when you create a PR. If you don't have the access to it, we will shortly find a reviewer and assign them to your PR. -->

## Why are these changes needed?

This idle detection is used to deal with the resource contention issue. Previously, we allow pulling one block per second. This is too aggressive and will cause exceeded memory usage. Change the default interval to 10 seconds. 

## Related issue number

<!-- For example: "Closes #1234" -->

## Checks

- [ ] I've signed off every commit(by using the -s flag, i.e., `git commit -s`) in this PR.
- [ ] I've run `scripts/format.sh` to lint the changes in this PR.
- [ ] I've included any doc changes needed for https://docs.ray.io/en/master/.
    - [ ] I've added any new APIs to the API Reference. For example, if I added a 
           method in Tune, I've added it in `doc/source/tune/api/` under the 
           corresponding `.rst` file.
- [ ] I've made sure the tests are passing. Note that there might be a few flaky tests, see the recent failures at https://flakey-tests.ray.io/
- Testing Strategy
   - [ ] Unit tests
   - [ ] Release tests
   - [ ] This PR is not tested :(
