# How to check database's queries?

**URL:** <https://www.ruby-forum.com/t/how-to-check-databases-queries/82786>\
**Category:** Rails\
**Created:** [January 21, 2007, 12:34am UTC](https://www.ruby-forum.com/t/how-to-check-databases-queries/82786 "2007-01-21T00:34:31Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![usser](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/8797f3/32.png) [@usser](https://www.ruby-forum.com/u/usser)\
**Post date:** [January 21, 2007, 12:34am UTC](https://www.ruby-forum.com/t/how-to-check-databases-queries/82786/1 "2007-01-21T00:34:31Z")

</div>

hi, i’m using postgres, is possible to retrieve the database’s queries  
for each page without install any plugin ? (and if is not possible,  
which plugin do you recommend ?)

---

<div class="post-metadata">

**Author:** ![usser](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/8797f3/32.png) [@usser](https://www.ruby-forum.com/u/usser)\
**Post date:** [January 21, 2007, 12:50am UTC](https://www.ruby-forum.com/t/how-to-check-databases-queries/82786/2 "2007-01-21T00:50:48Z")

</div>

On Sun, 2007-01-21 at 00:34 +0100, usser wrote:

> hi, i’m using postgres, is possible to retrieve the database’s queries  
> for each page without install any plugin ? (and if is not possible,  
> which plugin do you recommend ?)

try log/development.log

---

<div class="post-metadata">

**Author:** ![usser](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/8797f3/32.png) [@usser](https://www.ruby-forum.com/u/usser)\
**Post date:** [January 21, 2007, 12:53am UTC](https://www.ruby-forum.com/t/how-to-check-databases-queries/82786/3 "2007-01-21T00:53:38Z")

</div>

matt wrote:

> On Sun, 2007-01-21 at 00:34 +0100, usser wrote:
> 
> > hi, i’m using postgres, is possible to retrieve the database’s queries  
> > for each page without install any plugin ? (and if is not possible,  
> > which plugin do you recommend ?)
> 
> try log/development.log

yes, but is not possible to show the queries directly in the view? ☹  
i think that for this i need a plugin, right?

[another question that isn’t related about this, does exist any method  
which tell me how many days, hours, minutes, seconds remain between now  
and an input datetime ? i tried with since, but it doesn’t work (stack  
level too deep)]

---

<div class="post-metadata">

**Author:** ![usser](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/8797f3/32.png) [@usser](https://www.ruby-forum.com/u/usser)\
**Post date:** [January 21, 2007, 5:01am UTC](https://www.ruby-forum.com/t/how-to-check-databases-queries/82786/4 "2007-01-21T05:01:08Z")

</div>

distance\_of\_time\_in\_words(@object.created\_at, Time.now), for instance.

Take a look at the method source to see how they do it.

> **[ActionView::Helpers::DateHelper](https://api.rubyonrails.org/classes/ActionView/Helpers/DateHelper.html#M000571)**
>
> Action View Date Helpers The Date Helper primarily creates select/option tags for different kinds of dates and times or date and time elements.

---

<div class="post-metadata">

**Author:** ![usser](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/8797f3/32.png) [@usser](https://www.ruby-forum.com/u/usser)\
**Post date:** [January 22, 2007, 9:44pm UTC](https://www.ruby-forum.com/t/how-to-check-databases-queries/82786/5 "2007-01-22T21:44:58Z")

</div>

about the queries directly in the view, is possible ? i’ve installed  
query stats but it doesn’t work ☹

---

<div class="post-metadata">

**Author:** ![usser](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/8797f3/32.png) [@usser](https://www.ruby-forum.com/u/usser)\
**Post date:** [January 26, 2007, 5:27pm UTC](https://www.ruby-forum.com/t/how-to-check-databases-queries/82786/6 "2007-01-26T17:27:22Z")

</div>

usser wrote:

> about the queries directly in the view, is possible ? i’ve installed  
> query stats but it doesn’t work ☹

anyone? ☹

---

<div class="post-metadata">

**Author:** ![usser](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/8797f3/32.png) [@usser](https://www.ruby-forum.com/u/usser)\
**Post date:** [January 21, 2007, 12:00pm UTC](https://www.ruby-forum.com/t/how-to-check-databases-queries/82786/7 "2007-01-21T12:00:57Z")

</div>

removed\_email\_address@domain.invalid wrote:

> distance\_of\_time\_in\_words(@object.created\_at, Time.now), for instance.
> 
> Take a look at the method source to see how they do it.
> 
> [ActionView::Helpers::DateHelper](http://api.rubyonrails.org/classes/ActionView/Helpers/DateHelper.html#M000571)

thanks 🙂