Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT displayname, capture_time,
- satisfied_load_time AS load_time,
- satisfied_response_time AS apdex_response_time
- FROM session_page_summary, page, apdex_value
- WHERE displayname LIKE 'xyz%'
- AND capture_time >= '2012-11-01 00:00:00'
- AND capture_time <= '2012-11-07 00:00:00'
- AND page.page_id = session_page_summary.page_id
- AND page.page_id = apdex_value.page_id
- GROUP BY displayname
- ORDER BY displayname
- displayname capture_time loadtime responsetime
- >xyz-a 11/7/2012 0.12 1.34
- >xyz-b 11/7/2012 0.83 2.92
- >xyz-c 11/7/2012 0.56 1.02
- displayname capture_time loadtime responsetime
- >xyz-a 11/7/2012 0.72 1.82
- >xyz-b 11/15/2012 1.23 1.01
- >xyz-c 11/22/2012 2.83 0.78
- SELECT displayname, capture_time,
- satisfied_load_time AS load_time,
- satisfied_response_time AS apdex_response_time
- FROM session_page_summary sps, page p, apdex_value av
- WHERE displayname LIKE 'xyz%'
- AND page.page_id = session_page_summary.page_id
- AND page.page_id = apdex_value.page_id
- AND capture_time between '2012-11-01 00:00:00'AND '2012-11-07 00:00:00'
- GROUP BY displayname
- ORDER BY displayname
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement