search

box / Anemometer

Box SQL Slow Query Monitor
Apache License 2.0
1.39k stars 316 forks source link

Why ts_cnt shown in chart does not match to lower pane #51

Closed ghost closed 10 years ago

ghost commented 12 years ago

I have zoomed to peak area in chart based on ts_cnt column. Now value shown on chart is 6 whereas on lower pane there is only one query which shows ts_cnt as 2.

Similarly there is a confusion for other column like query_time_avg.

can you please let me know how chart is being populated and how it is related to lower tab where queries details are shown, is there any relationship between chart pane and lower query pane ?

gtowey commented 12 years ago

@Maheshpatilblr

I just tried to reproduce the issue you described and didn't see a problem between the ts_cnt from the graph and the values of the queries below it. Could you perhaps capture a screenshot that shows the issue you're having?

This might be a time zone related issue, but I'm not sure right now.

ghost commented 12 years ago

Gavin,

Unfortunately github does not have functionality to attach files and post it for an issue. Can you give me a alternate email-id where I can send you the screenshot?

On Wed, Oct 3, 2012 at 10:18 PM, Gavin Towey notifications@github.comwrote:

@Maheshpatilblr https://github.com/Maheshpatilblr

I just tried to reproduce the issue you described and didn't see a problem between the ts_cnt from the graph and the values of the queries below it. Could you perhaps capture a screenshot that shows the issue you're having?

This might be a time zone related issue, but I'm not sure right now.

— Reply to this email directly or view it on GitHubhttps://github.com/box/Anemometer/issues/51#issuecomment-9113259.

Regards, Mahesh

geoffreyanderson commented 12 years ago

@Maheshpatilblr Could you perhaps upload the screenshot somewhere and paste a link to it's more visible for other people to see? I'm curious to know what behavior you're seeing as well.

ghost commented 12 years ago

here is a link to screenshot describing a problem

https://www.dropbox.com/s/bcnpbxtebnocgi8/anemometer.PNG

On Thu, Oct 4, 2012 at 10:32 AM, Geoffrey Anderson <notifications@github.com

wrote:

@Maheshpatilblr https://github.com/Maheshpatilblr Could you perhaps upload the screenshot somewhere and paste a link to it's more visible for other people to see? I'm curious to know what behavior you're seeing as well.

— Reply to this email directly or view it on GitHubhttps://github.com/box/Anemometer/issues/51#issuecomment-9130693.

Regards, Mahesh

ghost commented 12 years ago

@geoffreyanderson I have given you a link that describes a problem but I have few other questions as well

Can you please explain me how chart is populated ? Is upper-pane (Visualization of chart plotted) and lower pane are inter-related?

ghost commented 12 years ago

@geoffreyanderson and @gtowey Any updates ?

gtowey commented 12 years ago

Sorry, I'm traveling on vacation right now. I'll be back next week and I can look more in to it then.

On Tue, Oct 9, 2012 at 12:43 AM, Maheshpatilblr notifications@github.comwrote:

@geoffreyanderson https://github.com/geoffreyanderson and @gtoweyhttps://github.com/gtoweyAny updates ?

— Reply to this email directly or view it on GitHubhttps://github.com/box/Anemometer/issues/51#issuecomment-9251604.

gtowey commented 12 years ago

@Maheshpatilblr

Hi, sorry for taking so long to get back to you -- in that screenshot, could you also open the "show raw SQL" button so I can see the actual query being executing to populate the table below the graph. That way I can compare that query to the values you have set the in graph search.

I have a feeling that this might be a time zone offset issue, but I can't be sure yet.

gtowey commented 10 years ago

I think this may also be related to issue #105