No long running queries
Connections healthy 19
Vacuuming healthy
No columns near integer overflow
No invalid indexes
2 duplicate indexes
No suggested indexes
1 slow query

Duplicate Indexes

These indexes exist, but aren’t needed. Remove them with a migration for faster writes.

On ahoy_events
index_ahoy_events_on_user_id (user_id)
is covered by
index_ahoy_events_on_user_id_and_name (user_id, name)
On ahoy_events
index_ahoy_events_on_visit_id (visit_id)
is covered by
index_ahoy_events_on_visit_id_and_name (visit_id, name)

Slow Queries

Slow queries take 20 ms or more on average and have been called at least 100 times.

Explain queries to see where to add indexes.

Total Time Average Time Calls
0 min 73% 83 ms 255 datakick · details
SELECT  $3 AS one FROM "users" WHERE LOWER("users"."username") = LOWER($1) LIMIT $2 /*application:Datakick,controller:devise/registrations,action:create*/