a.sql

CREATE INDEX on logs (source);
CREATE INDEX on logs (process);
CREATE INDEX on logs (drain);
CREATE INDEX on logs (timestamp);
CREATE INDEX on logs (severity);
CREATE INDEX on logs (facility);

b.sql

CREATE INDEX on logs (source, process, drain, timestamp, severity, facility);