Hmm... The author is filling a combo-box (probably just one column), yet the query is selecting all columns (SELECT *). I would have tried selecting just the n

Hmm... The author is filling a combo-box (probably just one column), yet the query is selecting all columns (SELECT *). I would have tried selecting just the needed column (let's call it "foo"), with following indexes: event_types (app, id) prop_keys (event_id, foo) This should cover the entire query with indexes (i.e. allow for index-only scan).