# SLOW Queries, how do i find them?

**URL:** <https://forum.inductiveautomation.com/t/slow-queries-how-do-i-find-them/8742>\
**Category:** Ignition\
**Created:** [July 17, 2014, 12:23pm UTC](https://forum.inductiveautomation.com/t/slow-queries-how-do-i-find-them/8742 "2014-07-17T12:23:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [July 17, 2014, 12:23pm UTC](https://forum.inductiveautomation.com/t/slow-queries-how-do-i-find-them/8742/1 "2014-07-17T12:23:45Z")

</div>

I was looking through the console and I found some slow queries. I want to try to make them faster but I don’t know where the queries are being called from?

Is there any way to track down where the queries are coming from? The application is pretty large

Thanks

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [July 17, 2014, 1:22pm UTC](https://forum.inductiveautomation.com/t/slow-queries-how-do-i-find-them/8742/2 "2014-07-17T13:22:58Z")

</div>

Yes, in the Designer top menu Edit -\> Find/Replace. Search your project for some of the text that is unique to a slow query. Search All Windows, Scripting and SQL Bridge All Groups. If you don’t find the slow query then search the next project on the Gateway.

---

<div class="post-metadata">

**Author:** ![SeanT](https://avatars.discourse-cdn.com/v4/letter/s/df788c/32.png) [@SeanT](https://forum.inductiveautomation.com/u/SeanT)\
**Post date:** [July 30, 2014, 4:05pm UTC](https://forum.inductiveautomation.com/t/slow-queries-how-do-i-find-them/8742/3 "2014-07-30T16:05:07Z")

</div>

If you’re using an external database, it can be helpful to set up slow query logging there. Search online for slow query logging, it’s usually just a setting like “log\_min\_duration\_statement” in PostgreSQL or “long\_query\_time” in MySQL. You can then find out if your database is doing something unexpected when it calculates its execution plan.