v1.0.0 -> No index

learning query optimization by building a simple event analytics server

v1.1.0 -> Full index

CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_events_site_name_ts_inc_url
ON events (site_id, name, timestamp)
INCLUDE (url);

CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_events_pv_site_ts_inc_url
ON events (site_id, timestamp)
INCLUDE (url)
WHERE name = 'page_view';

CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_events_ts_brin
ON events USING brin (timestamp);