# Log filter for slow queries?

**URL:** <https://forum.inductiveautomation.com/t/log-filter-for-slow-queries/53537>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [November 29, 2021, 4:45pm UTC](https://forum.inductiveautomation.com/t/log-filter-for-slow-queries/53537 "2021-11-29T16:45:23Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [November 29, 2021, 6:49pm UTC](https://forum.inductiveautomation.com/t/log-filter-for-slow-queries/53537/8 "2021-11-29T18:49:27Z")

</div>

Ok great I have it working well enough now so that I can revisit the queries and see some specifics.

For anyone wondering how to do the same thing, this is a function I call from a gateway message handler:

```auto
"""
These scripts can ONLY be run on the gateway context.
"""
from com.inductiveautomation.ignition.gateway import IgnitionGateway
import system.util

logger = system.util.getLogger("gateway.query")
LIMIT = 100

def getLongQueries():
	"""
	Note: 
	query.duration is a long, measuring milliseconds
	query.startTime is the unix-time
	"""
	context = IgnitionGateway.get()
	logger.info("Got context")
	name = 'myDatasource'
	queries = context.getDatasourceManager().getDatasource(name).getMetrics().getExpensiveQueries()
	for query in queries:
		if query.duration > LIMIT:
			logger.info("Query: " + str(query.getQuery()))
			logger.info("Length of query: " + str(query.duration))
			logger.info("Start time: " + str(query.startTime))

```

---

_[View the full topic](https://forum.inductiveautomation.com/t/log-filter-for-slow-queries/53537)._