EXPLAIN
You can examine the execution plan of a query.
Schema
The schema from Assignment 5:
create table member(
member_id serial primary key,
name varchar not null,
birth_date date);
create table message(
message_id serial primary key,
message_date date not null,
message_text varchar not null);
create table routing(
from_member_id int not null references member,
to_member_id int not null references member,
message_id int not null references message);
|