Queries — Rails Pulse

Rails Pulse

P95 Query Time

34 ms

3.8%

Compared to previous 7 days

Execution Rate

37.53 / hour

2.1%

Compared to previous 7 days

Database Load

72.2%

3.2%

Compared to previous 7 days

Queries

Click marker to copy SHA

Query	P95	P99	Executions	Tags
SELECT * FROM posts WHERE title LIKE ? AND content LIKE ? AND LOWER(title) LIKE ? AND UPPER(conte...	33 ms	34 ms	449	-
SELECT * FROM users LEFT JOIN posts ON users.id = posts.user_id LEFT JOIN comments ON posts.id = ...	33 ms	34 ms	460	-
SELECT * FROM posts WHERE user_id = ? ORDER BY created_at DESC LIMIT ?	33 ms	34 ms	448	-
SELECT users., posts., comments.*, COUNT(DISTINCT posts.id) as post_count, COUNT(DISTINCT comme...	33 ms	34 ms	437	-
SELECT users.* FROM users LEFT JOIN posts ON users.id = posts.user_id LEFT JOIN comments ON posts...	33 ms	34 ms	464	-
SELECT users.*, COUNT(DISTINCT posts.id) as post_count, COUNT(DISTINCT comments.id) as comment_co...	33 ms	34 ms	476	-
SELECT name FROM users	33 ms	34 ms	458	-
SELECT * FROM users WHERE id = ?	32 ms	34 ms	427	-
SELECT * FROM comments WHERE post_id = ? ORDER BY created_at DESC LIMIT ?	32 ms	34 ms	460	-
SELECT * FROM posts WHERE created_at > ?	32 ms	34 ms	464	-

Total of 22 record(s).

Rows per page

Page 1 of 3