Queries — Rails Pulse

Rails Pulse

P95 Query Time

34 ms

4.7%

Compared to previous 7 days

Execution Rate

37.27 / hour

5.1%

Compared to previous 7 days

Database Load

74.4%

3.6%

Compared to previous 7 days

Queries

Click marker to copy SHA

Query	P95	P99	Executions	Tags
SELECT users.* FROM users LEFT JOIN posts ON users.id = posts.user_id LEFT JOIN comments ON posts...	33 ms	34 ms	468	-
SELECT * FROM posts WHERE user_id = ? ORDER BY created_at DESC LIMIT ?	33 ms	34 ms	451	-
SELECT * FROM comments WHERE post_id = ? ORDER BY created_at DESC LIMIT ?	33 ms	34 ms	486	-
SELECT DISTINCT users., posts., comments.* FROM users, posts, comments WHERE users.id = posts.u...	32 ms	34 ms	421	-
SELECT * FROM users LEFT JOIN posts ON users.id = posts.user_id LEFT JOIN comments ON posts.id = ...	33 ms	34 ms	491	-
SELECT * FROM (SELECT users.id, users.name, users.email, COUNT(posts.id) as post_count FROM users...	33 ms	34 ms	449	-
SELECT * FROM posts WHERE title LIKE ? AND content LIKE ? AND LOWER(title) LIKE ? AND UPPER(conte...	32 ms	34 ms	436	-
SELECT users.*, COUNT(DISTINCT posts.id) as post_count, COUNT(DISTINCT comments.id) as comment_co...	32 ms	34 ms	451	-
DELETE FROM comments WHERE created_at < ?	32 ms	33 ms	93	-
SELECT * FROM users WHERE id = ?	32 ms	33 ms	462	-

Total of 22 record(s).

Rows per page

Page 1 of 3