# Get transactions that have been in the ethereum mempool for over X number of seconds

**URL:** https://community.bitquery.io/t/get-transactions-that-have-been-in-the-ethereum-mempool-for-over-x-number-of-seconds/2129
**Category:** GraphQL API
**Created:** [October 25, 2024, 3:59pm UTC](https://community.bitquery.io/t/get-transactions-that-have-been-in-the-ethereum-mempool-for-over-x-number-of-seconds/2129 "2024-10-25T15:59:32Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![testing](https://avatars.discourse-cdn.com/v4/letter/t/ecb155/32.png) [@testing](https://community.bitquery.io/u/testing)
#### Post date: [October 25, 2024, 3:59pm UTC](https://community.bitquery.io/t/get-transactions-that-have-been-in-the-ethereum-mempool-for-over-x-number-of-seconds/2129/1 "2024-10-25T15:59:32Z")

</div>

I am trying to create a query that will be able to isolate transactions that have been in the mempool for an abnormal amount of time. How can I go about doing that?

---

<div class="post-metadata">

### Author: ![Divya](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@Divya](https://community.bitquery.io/u/Divya)
#### Post date: [October 28, 2024, 7:39am UTC](https://community.bitquery.io/t/get-transactions-that-have-been-in-the-ethereum-mempool-for-over-x-number-of-seconds/2129/2 "2024-10-28T07:39:15Z")

</div>

There’s no query to calc duration present in mempool, you can get mempool tx data and try to check if confirmed after a set duration ( just my 2 cents).

Some sample queries

> **[Mempool API | Blockchain Data API (V2)](https://docs.bitquery.io/docs/examples/mempool/mempool-api/)**
>
> In this section we will look at some examples of how to write mempool queries to extract the necessary data from broadcasted transactions. To read more about how we offer mempool data, read the introduction here