Skip to content

Instantly share code, notes, and snippets.

@vdubyna

vdubyna/requests-per-hour.sql

Created November 13, 2014 13:30
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save vdubyna/d345c756ac75b2b7dd51 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save vdubyna/d345c756ac75b2b7dd51 to your computer and use it in GitHub Desktop.
Download ZIP
Requests per hour without static content
Raw
requests-per-hour.sql
select count(*), HOUR(lu.visit_time) from log_url_info as ui JOIN log_url as lu on lu.url_id=ui.url_id JOIN log_visitor_info as vi on lu.visitor_id=vi.visitor_id where date(lu.visit_time) = '2014-11-12' and !(url like '%.jpg%' or url like '%.png%' or url like '%.js%' or url like '%.css%' or url like '%.gif%' or url like '%.ico%' or url like '%.txt%') GROUP BY HOUR(lu.visit_time);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment