Scenario design

Set up the slow-report scenario and write skeleton queries.

Scenario design

The performance project starts here. In the first step you design the orders table with id, customer_id, amount, created_at columns. This table feeds every following lesson.

CREATE TABLE orders (
  id SERIAL PRIMARY KEY,
  customer_id INT,
  amount NUMERIC,
  created_at TIMESTAMP
);

The base table is the performance scenario.

The table orders is created.

Scenario design — details

This table is the base for performance experiments. Each lesson takes the previous solution as its starting point: add an index, read the plan, rewrite the query, compare.

Exercise Scenario design

Create the orders table with id SERIAL PRIMARY KEY, customer_id INT, amount NUMERIC, created_at TIMESTAMP.

Show example solution

CREATE TABLE orders (
  id SERIAL PRIMARY KEY,
  customer_id INT,
  amount NUMERIC,
  created_at TIMESTAMP
);

Test yourself

Base table of the performance project?
- orders
- users
- logs
- audit
Show answer

orders — The orders table is the base of the performance project.

Primary key

id ____ PRIMARY KEY

Show answer

id SERIAL PRIMARY KEY

Scenario design: match the terms

orders

orders
id

id
customer_id

customer
amount

amount

Next lesson: Reading plans

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies