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 DISTINCT users., posts., comments.* FROM users, posts, comments WHERE users.id = posts.u...	32 ms	34 ms	427	-
SELECT * FROM (SELECT users.id, users.name, users.email, COUNT(posts.id) as post_count FROM users...	32 ms	34 ms	426	-
SELECT id, name, email FROM users WHERE id = ?	31 ms	32 ms	81	-
DELETE FROM posts WHERE id = ?	32 ms	32 ms	89	-
UPDATE posts SET title = ?, content = ?, updated_at = ? WHERE id = ?	31 ms	32 ms	93	-
UPDATE posts SET view_count = view_count + ? WHERE published = ?	31 ms	33 ms	76	-
SELECT id, name FROM users WHERE email = ?	31 ms	32 ms	87	-
INSERT INTO posts (user_id, title, content, published, created_at, updated_at) VALUES (?, ?, ?, ?...	30 ms	32 ms	82	-
SELECT COUNT(*) FROM comments WHERE post_id = ?	31 ms	32 ms	93	-
DELETE FROM comments WHERE created_at < ?	30 ms	31 ms	78	-

Total of 22 record(s).

Rows per page

Page 2 of 3