# How can I tell which transaction each SQL call is in?

**URL:** <https://www.ruby-forum.com/t/how-can-i-tell-which-transaction-each-sql-call-is-in/157324>\
**Category:** Rails\
**Created:** [January 9, 2009, 12:21pm UTC](https://www.ruby-forum.com/t/how-can-i-tell-which-transaction-each-sql-call-is-in/157324 "2009-01-09T12:21:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![greg](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/71c47a/32.png) [@greg](https://www.ruby-forum.com/u/greg)\
**Post date:** [January 9, 2009, 12:21pm UTC](https://www.ruby-forum.com/t/how-can-i-tell-which-transaction-each-sql-call-is-in/157324/1 "2009-01-09T12:21:27Z")

</div>

hi,

I’m trying to debug some transaction related issues in my code:

How could I tell which Sql statement (from logs) which transaction (if  
any) they are in?

Grg

---

<div class="post-metadata">

**Author:** ![greg](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/71c47a/32.png) [@greg](https://www.ruby-forum.com/u/greg)\
**Post date:** [January 9, 2009, 6:26pm UTC](https://www.ruby-forum.com/t/how-can-i-tell-which-transaction-each-sql-call-is-in/157324/2 "2009-01-09T18:26:33Z")

</div>

you should use query\_trace plugin.

Adam

On Fri, Jan 9, 2009 at 6:20 AM, Greg H. \<