Generating Benchmarking data with Postgres

generate_series.sql

-- creating example tables
CREATE TABLE audits(id SERIAL PRIMARY KEY, title VARCHAR(255) NOT NULL, created_at timestamp NOT NULL);
CREATE TABLE objectives(id SERIAL PRIMARY KEY, title VARCHAR(255) NOT NULL, created_at timestamp NOT NULL, audit_id integer REFERENCES audits(id) NOT NULL);

-- generating 1000 audits
INSERT INTO audits(title, created_at) SELECT format('Audit #%s', id), current_timestamp FROM generate_series(1, 1000) AS id;

-- generating 100 objectives for each existing audits
INSERT INTO objectives(title, created_at, audit_id) SELECT format('Objective #%s', objective_id), current_timestamp, audits.id FROM audits, generate_series(1, 100) as objective_id;