Query optimization with EXPLAIN in Supabase - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to show the query plan for selecting all users.

Supabase

EXPLAIN [1] * FROM users;

Drag options to blanks, or click blank then click option'

ASELECT

BANALYZE

CDELETE

DINSERT

Attempts:

3 left

💡 Hint

Common Mistakes

Using DELETE or INSERT after EXPLAIN instead of SELECT.

Omitting the SELECT keyword.

The EXPLAIN SELECT statement shows the query plan for a SELECT query.

2fill in blank

medium

Complete the code to get detailed execution statistics for a query.

Supabase

EXPLAIN [1] SELECT * FROM orders WHERE amount > 100;

Drag options to blanks, or click blank then click option'

AANALYZE

BCOSTS

CBUFFERS

DVERBOSE

Attempts:

3 left

💡 Hint

Common Mistakes

Using VERBOSE which only adds detail to the plan but does not run the query.

Using COSTS or BUFFERS without ANALYZE.

The ANALYZE option runs the query and shows actual execution statistics.

3fill in blank

hard

Fix the error in the EXPLAIN statement to correctly show the query plan with buffers.

Supabase

EXPLAIN ANALYZE [1] BUFFERS SELECT * FROM products;

Drag options to blanks, or click blank then click option'

AON

BAND

COR

DWITH

Attempts:

3 left

💡 Hint

Common Mistakes

Using AND or OR instead of WITH.

Placing BUFFERS before ANALYZE.

The correct syntax is EXPLAIN ANALYZE WITH BUFFERS to include buffer usage.

4fill in blank

hard

Fill both blanks to create a query that explains the plan with costs and verbose output.

Supabase

EXPLAIN [1] [2] SELECT * FROM customers WHERE city = 'Paris';

Drag options to blanks, or click blank then click option'

ACOSTS

BANALYZE

CVERBOSE

DBUFFERS

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing ANALYZE with COSTS and VERBOSE incorrectly.

Using BUFFERS when not running the query.

Using COSTS VERBOSE shows estimated costs and detailed plan info without running the query.

5fill in blank

hard

Fill all three blanks to explain and analyze a query with costs, buffers, and verbose output.

Supabase

EXPLAIN [1] WITH [2] [3] SELECT * FROM sales WHERE total > 500;

Drag options to blanks, or click blank then click option'

AANALYZE

BBUFFERS

CVERBOSE

DCOSTS

Attempts:

3 left

💡 Hint

Common Mistakes

Placing VERBOSE instead of COSTS or BUFFERS.

Omitting WITH before options.

The correct order is ANALYZE WITH COSTS BUFFERS to run the query and show costs and buffer usage.