backendgym backendgym · reps Sign in with GitHubSign in

01Read the first plan

sql-optimizing / reps/01/README.md

Find the movie titled exactly The Quiet Harbor, with EXPLAIN (ANALYZE, BUFFERS) in front of the query. Don't create an index yet.

Expected: a Parallel Seq Scan on movies under a Gather node (a plain Seq Scan if parallel workers are off). The Gather line reports rows=1; with two workers, the scan node shows rows=0 loops=3. Write down the execution time. You'll compare it in rep 2.

After the rep
  1. 1 How many buffers did the sequential scan read, and how many does rep 2's index scan read for the same movie?