# Query running status

**URL:** <https://community.cratedb.com/t/query-running-status/684>\
**Category:** CrateDB\
**Created:** [May 20, 2021, 8:02am UTC](https://community.cratedb.com/t/query-running-status/684 "2021-05-20T08:02:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![kkhatri](https://avatars.discourse-cdn.com/v4/letter/k/977dab/32.png) [@kkhatri](https://community.cratedb.com/u/kkhatri)\
**Post date:** [May 20, 2021, 8:02am UTC](https://community.cratedb.com/t/query-running-status/684/1 "2021-05-20T08:02:53Z")

</div>

Hi,  
How can I get what is the status of running query?  
I can have a list of queries by “sys.jobs” but I want to know why any query is running long ? for what resource/reason it is running?

Thanks

---

<div class="post-metadata">

**Author:** ![proddata](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/proddata/32/1379_2.png) [@proddata](https://community.cratedb.com/u/proddata)\
**Post date:** [May 20, 2021, 8:10am UTC](https://community.cratedb.com/t/query-running-status/684/2 "2021-05-20T08:10:50Z")

</div>

Is there a specific query you have troubles with?

with

```sql
SELECT * FROM sys.jobs j
JOIN sys.operations o ON j.id = o.job_id
WHERE j.started < now();

```

you get a more complete pictures what operations related to the jobs are currently running.

---

<div class="post-metadata">

**Author:** ![kkhatri](https://avatars.discourse-cdn.com/v4/letter/k/977dab/32.png) [@kkhatri](https://community.cratedb.com/u/kkhatri)\
**Post date:** [May 20, 2021, 8:18am UTC](https://community.cratedb.com/t/query-running-status/684/3 "2021-05-20T08:18:04Z")

</div>

Thanks for your response.

---

<div class="post-metadata">

**Author:** ![kkhatri](https://avatars.discourse-cdn.com/v4/letter/k/977dab/32.png) [@kkhatri](https://community.cratedb.com/u/kkhatri)\
**Post date:** [May 20, 2021, 8:56am UTC](https://community.cratedb.com/t/query-running-status/684/4 "2021-05-20T08:56:13Z")

</div>

Do we have any queries which can we use to monitor cratedb running query status? Do we have running,blocking,waiting,locking,sleeping sessions related query?  
Thanks in advance it is helpful to us.

---

<div class="post-metadata">

**Author:** ![proddata](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/proddata/32/1379_2.png) [@proddata](https://community.cratedb.com/u/proddata)\
**Post date:** [May 20, 2021, 9:13am UTC](https://community.cratedb.com/t/query-running-status/684/5 "2021-05-20T09:13:01Z")

</div>

> [@kkhatri](#):
>
> blocking

No, not that I am aware of. If a query is in `sys.jobs` then it is considered `running`.  
If you think more information would be useful, I would kindly ask you to raise a feature request in the crate-repo and describe the use-case 🙂

> **[Issues · crate/crate](https://github.com/crate/crate/issues)**
>
> CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene. ...