# Finding the line of code corresponding to an SQL statement

**URL:** <https://www.ruby-forum.com/t/finding-the-line-of-code-corresponding-to-an-sql-statement/130979>\
**Category:** Rails\
**Created:** [March 4, 2008, 11:03pm UTC](https://www.ruby-forum.com/t/finding-the-line-of-code-corresponding-to-an-sql-statement/130979 "2008-03-04T23:03:38Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jamie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/aca169/32.png) [@jamie](https://www.ruby-forum.com/u/jamie)\
**Post date:** [March 4, 2008, 11:03pm UTC](https://www.ruby-forum.com/t/finding-the-line-of-code-corresponding-to-an-sql-statement/130979/1 "2008-03-04T23:03:38Z")

</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) [0m [0;1mSELECT \* FROM  
action\_trackers WHERE (name=‘topicviews’ and entity\_id=93 and  
user\_id=88) LIMIT 1 [0m  
\<- action\_tracker.rb - line #45

---

<div class="post-metadata">

**Author:** ![jamie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/aca169/32.png) [@jamie](https://www.ruby-forum.com/u/jamie)\
**Post date:** [March 5, 2008, 12:36am UTC](https://www.ruby-forum.com/t/finding-the-line-of-code-corresponding-to-an-sql-statement/130979/2 "2008-03-05T00:36:27Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![jamie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/aca169/32.png) [@jamie](https://www.ruby-forum.com/u/jamie)\
**Post date:** [March 5, 2008, 2:48am UTC](https://www.ruby-forum.com/t/finding-the-line-of-code-corresponding-to-an-sql-statement/130979/3 "2008-03-05T02:48:26Z")

</div>

On Mar 4, 2008, at 3:36 PM, tshim wrote:

> > for example:
> > 
> > ActionTracker Load (0.016000) [0m [0;1mSELECT \* FROM  
> > action\_trackers WHERE (name=‘topicviews’ and entity\_id=93 and  
> > user\_id=88) LIMIT 1 [0m  
> > ← action\_tracker.rb - line #45

Check out:

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

---

<div class="post-metadata">

**Author:** ![jamie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/aca169/32.png) [@jamie](https://www.ruby-forum.com/u/jamie)\
**Post date:** [March 5, 2008, 4:47am UTC](https://www.ruby-forum.com/t/finding-the-line-of-code-corresponding-to-an-sql-statement/130979/4 "2008-03-05T04:47:39Z")

</div>

fantastic! exactly what I was looking for!

---

<div class="post-metadata">

**Author:** ![jamie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/aca169/32.png) [@jamie](https://www.ruby-forum.com/u/jamie)\
**Post date:** [March 5, 2008, 7:15am UTC](https://www.ruby-forum.com/t/finding-the-line-of-code-corresponding-to-an-sql-statement/130979/5 "2008-03-05T07:15:16Z")

</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)