> For the complete documentation index, see [llms.txt](https://docs.snowkill.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.snowkill.net/condition/built-in-conditions/blocked-duration.md).

# Blocked Duration

### Condition

Query is stuck in `BLOCKED` status. It is usually caused by other transactions holding locks on specific objects.

### How to fix

* Consider re-writing ETL jobs to avoid locks
* Consider adding concurrency limit to run only one job instance in parallel.

### Example

```
    BlockedDurationCondition(
        notice_duration=60 * 5,  # query was locked by another transaction for 5 minutes
    ),
```

### Specific arguments

None. Only [standard duration arguments](/condition/built-in-conditions.md) are applied for this checker.