# finding the line of code corresponding to an SQL statement

**URL:** <https://discuss.rubyonrails.org/t/finding-the-line-of-code-corresponding-to-an-sql-statement/25824>\
**Category:** rubyonrails-talk\
**Created:** [March 4, 2008, 10:03pm UTC](https://discuss.rubyonrails.org/t/finding-the-line-of-code-corresponding-to-an-sql-statement/25824 "2008-03-04T22:03:19Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jamie1](https://avatars.discourse-cdn.com/v4/letter/j/9e8a1a/32.png) [@jamie1](https://discuss.rubyonrails.org/u/jamie1)\
**Post date:** [March 4, 2008, 10:03pm UTC](https://discuss.rubyonrails.org/t/finding-the-line-of-code-corresponding-to-an-sql-statement/25824/1 "2008-03-04T22:03:19Z")

</div>

Wondering if any one has suggestions for changing the log output such that the line of code (and associated file) that resulted in a query is output to the log file when running in the development env.

for example:

ActionTracker Load (0.016000)e[0m e[0;1mSELECT \* FROM action\_trackers WHERE (name='topicviews' and entity\_id=93 and user\_id=88) LIMIT 1e[0m \<- action\_tracker.rb - line #45

---

<div class="post-metadata">

**Author:** ![Philip\_Hallstrom](https://avatars.discourse-cdn.com/v4/letter/p/bbe5ce/32.png) [@Philip\_Hallstrom](https://discuss.rubyonrails.org/u/Philip_Hallstrom)\
**Post date:** [March 4, 2008, 10:18pm UTC](https://discuss.rubyonrails.org/t/finding-the-line-of-code-corresponding-to-an-sql-statement/25824/2 "2008-03-04T22:18:39Z")

</div>

> Wondering if any one has suggestions for changing the log output such that the line of code (and associated file) that resulted in a query is output to the log file when running in the development env.

[http://agilewebdevelopment.com/plugins/sql\_logging](http://agilewebdevelopment.com/plugins/sql_logging)

---

<div class="post-metadata">

**Author:** ![Yong\_Bakos](https://avatars.discourse-cdn.com/v4/letter/y/6bbea6/32.png) [@Yong\_Bakos](https://discuss.rubyonrails.org/u/Yong_Bakos)\
**Post date:** [March 4, 2008, 11:36pm UTC](https://discuss.rubyonrails.org/t/finding-the-line-of-code-corresponding-to-an-sql-statement/25824/3 "2008-03-04T23:36:19Z")

</div>

You could try using a custom logger like log4r, or attempt to customize AR itself.

---

<div class="post-metadata">

**Author:** ![Steve\_Ross](https://avatars.discourse-cdn.com/v4/letter/s/3d9bf3/32.png) [@Steve\_Ross](https://discuss.rubyonrails.org/u/Steve_Ross)\
**Post date:** [March 4, 2008, 11:59pm UTC](https://discuss.rubyonrails.org/t/finding-the-line-of-code-corresponding-to-an-sql-statement/25824/4 "2008-03-04T23:59:16Z")

</div>

Check out:

[http://terralien.com/projects/querytrace/](http://terralien.com/projects/querytrace/)

---

<div class="post-metadata">

**Author:** ![jamie1](https://avatars.discourse-cdn.com/v4/letter/j/9e8a1a/32.png) [@jamie1](https://discuss.rubyonrails.org/u/jamie1)\
**Post date:** [March 5, 2008, 3:47am UTC](https://discuss.rubyonrails.org/t/finding-the-line-of-code-corresponding-to-an-sql-statement/25824/5 "2008-03-05T03:47:10Z")

</div>

fantastic! exactly what I was looking for!