Queries — Rails Pulse

Rails Pulse

P95 Query Time

34 ms

3.9%

Compared to previous 7 days

Execution Rate

37.04 / hour

3.8%

Compared to previous 7 days

Database Load

72.5%

3.2%

Compared to previous 7 days

Queries

Click marker to copy SHA

Query	P95	P99	Executions ▼	Tags
SELECT * FROM users WHERE id = ?	33 ms	34 ms	471	-
SELECT users.*, COUNT(DISTINCT posts.id) as post_count, COUNT(DISTINCT comments.id) as comment_co...	33 ms	34 ms	470	-
SELECT users., posts., comments.*, COUNT(DISTINCT posts.id) as post_count, COUNT(DISTINCT comme...	32 ms	34 ms	459	-
SELECT * FROM comments WHERE post_id = ? ORDER BY created_at DESC LIMIT ?	32 ms	34 ms	456	-
SELECT * FROM posts WHERE user_id = ? ORDER BY created_at DESC LIMIT ?	33 ms	34 ms	439	-
SELECT * FROM users LEFT JOIN posts ON users.id = posts.user_id LEFT JOIN comments ON posts.id = ...	32 ms	34 ms	438	-
SELECT DISTINCT users., posts., comments.* FROM users, posts, comments WHERE users.id = posts.u...	33 ms	34 ms	437	-
SELECT * FROM (SELECT users.id, users.name, users.email, COUNT(posts.id) as post_count FROM users...	33 ms	34 ms	422	-
SELECT users.* FROM users LEFT JOIN posts ON users.id = posts.user_id LEFT JOIN comments ON posts...	32 ms	34 ms	421	-
SELECT name FROM users	33 ms	34 ms	419	-

Total of 22 record(s).

Rows per page

Page 1 of 3