asigatchov/slow_ip.sql

Created November 4, 2016 20:24

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/asigatchov/12a48a10a9e28c5296d9df71ec695cec.js"></script>
Save asigatchov/12a48a10a9e28c5296d9df71ec695cec to your computer and use it in GitHub Desktop.

Download ZIP

Поиск медленных ip клиетнов

Raw

slow_ip.sql

	SELECT
	floor(avg(resp_time), 2) AS avg_time,
	ip
	FROM access_log
	WHERE event_date = '2016-11-01'
	GROUP BY ip
	ORDER BY avg_time DESC
	LIMIT 10

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment