gistfile1.txt

% grep query log | lltsv -k sum,count,mean,query -K 
0.228929	232	0.000987	SELECT id, content, is_private, created_at, updated_at FROM memos WHERE user=? AND is_private=0 ORDER BY created_at
1.051638	550	0.001912	SELECT * FROM memos WHERE is_private=0 ORDER BY created_at DESC, id DESC LIMIT ?
0.112710	217	0.000519	SELECT id, username, password, salt FROM users WHERE username=?
0.521563	1713	0.000507	SELECT * FROM users WHERE id=?
0.244834	217	0.001128	SELECT id, content, is_private, created_at, updated_at FROM memos WHERE user=? ORDER BY created_at DESC
0.174648	217	0.000805	INSERT INTO memos (user, content, is_private, created_at) VALUES (?, ?, ?, now())
8.346507	1163	0.008119	SELECT count(*) AS c FROM memos WHERE is_private=0
0.268414	117621	0.000261	SELECT username FROM users WHERE id=?
42.714127	613	0.069680	SELECT * FROM memos WHERE is_private=0 ORDER BY created_at DESC, id DESC LIMIT ? OFFSET ?
0.134315	217	0.000619	UPDATE users SET last_access=now() WHERE id=?
0.596276	1422	0.000580	SELECT id, user, content, is_private, created_at, updated_at FROM memos WHERE id=?


$ grep handler log | lltsv -k sum,count,mean,handler -K
0.641095	217	0.002954	memoPostHandler
4.194775	217	0.019331	mypageHandler
64.651639	1422	0.062891	memoHandler
72.146588	613	0.117694	recentHandler
0.273067	5828	0.000266	public
25.840896	550	0.046983	topHandler
0.086980	217	0.000401	signinHandler
0.286411	217	0.001320	signoutHandler


$  grep template log | lltsv -k sum,count,mean,base -K 
2.597722	217	0.011971	mypage
61.467620	1321	0.059793	memo
9.246792	1163	0.008995	index
0.047431	217	0.000219	signin