# Query time

**URL:** <https://www.ruby-forum.com/t/query-time/205084>\
**Category:** NGINX\
**Created:** [March 29, 2011, 7:00am UTC](https://www.ruby-forum.com/t/query-time/205084 "2011-03-29T07:00:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![luislavena](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/0ea827/32.png) [@luislavena](https://www.ruby-forum.com/u/luislavena)\
**Post date:** [March 29, 2011, 7:00am UTC](https://www.ruby-forum.com/t/query-time/205084/1 "2011-03-29T07:00:38Z")

</div>

Greetings,

I am not really sure if this is the right place to ask something like  
that but seeing all those available mods doing almost everything, here  
it goes.

Is there any way (php-cgi mod?) that i can use to measure the time it  
takes for a (sql) query to complete?

My setup uses nginx servers on a mysql cluster.

Thank you in advance and i am sorry also in advance if the subject is  
irrelevant.

## –

Alex

---

<div class="post-metadata">

**Author:** ![Alexander\_Economou](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f1d935/32.png) [@Alexander\_Economou](https://www.ruby-forum.com/u/Alexander_Economou)\
**Post date:** [March 29, 2011, 7:28pm UTC](https://www.ruby-forum.com/t/query-time/205084/2 "2011-03-29T19:28:14Z")

</div>

Look into the slow query log of mysql.

---

<div class="post-metadata">

**Author:** ![Alexander\_Economou](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f1d935/32.png) [@Alexander\_Economou](https://www.ruby-forum.com/u/Alexander_Economou)\
**Post date:** [March 29, 2011, 7:06pm UTC](https://www.ruby-forum.com/t/query-time/205084/3 "2011-03-29T19:06:00Z")

</div>

On Mar 29, Alexander Economou wrote:

> I am not really sure if this is the right place to ask something like  
> that but seeing all those available mods doing almost everything, here  
> it goes.
> 
> Is there any way (php-cgi mod?) that i can use to measure the time it  
> takes for a (sql) query to complete?

nginx does not execute php scripts. Infact, it has no idea that the  
proxy/fastcgi backend is even using php. So, the right place to look for  
would be on a php forum.

---

<div class="post-metadata">

**Author:** ![Alexander\_Economou](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f1d935/32.png) [@Alexander\_Economou](https://www.ruby-forum.com/u/Alexander_Economou)\
**Post date:** [March 30, 2011, 6:02pm UTC](https://www.ruby-forum.com/t/query-time/205084/4 "2011-03-30T18:02:26Z")

</div>

Thanks both of you 🙂

On 03/29/2011 08:27 PM, Ilan B. wrote:

> ```
> >Is there any way (php-cgi mod?) that i can use to measure the time it
> 
> ```
> 
> * * *
> 
> nginx mailing list  
> [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> [mailman.nginx.org archive](http://nginx.org/mailman/listinfo/nginx)

## –

Alexander Loukas Economou  
Systems & Network  
Administrator  
gsm : 6986 298 859  
email : [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)