Question library
Questions from real interviews. Drill any of them by voice in a couple of minutes, with an interviewer, a score and feedback.
Imagine a query against a large table is running very slowly. Where would you start investigating?JuniorAn analytical query against Postgres that used to run in a couple of seconds now takes ten minutes. How would you investigate, and what can you do about it?Mid-levelYou have a query with window functions over a billion-row events table, and it takes forty minutes. How would you investigate, and what would you optimize?Senior