SELECT r.name, r.code 
FROM rubrics AS r, quot_prepared AS item, quot_rubric AS qr  
WHERE item.quot_id =  120363  AND qr.rubric_id = r.id 
                            AND qr.quot_prepared_id=item.id

CREATE UNIQUE INDEX rubrics_pkey ON rubrics USING btree (id)
CREATE INDEX quot_prepared_quot_id_idx ON quot_prepared USING btree (quot_id)
CREATE UNIQUE INDEX quot_prepared_pkey ON quot_prepared USING btree (id)
CREATE INDEX quot_rubric_qpi_ri ON quot_rubric USING btree (rubric_id, quot_prepared_id)

Merge Join (cost= 24112 . 18 .. 25889 . 50  rows= 11  width= 77 ) 
Merge Cond: ("outer".id = "inner".rubric_id) 
-> Index Scan using rubrics_pkey on rubrics r (cost= 0 . 00 .. 1723 . 93  rows= 21285  width= 57 ) 
-> Sort (cost= 24112 . 18 .. 24112 . 20  rows= 11  width= 20 ) 
Sort Key: qr.rubric_id 
-> Merge Join (cost= 23012 . 89 .. 24112 . 00  rows= 11  width= 20 ) 
Merge Cond: ("outer".id = "inner".quot_prepared_id) 
-> Sort (cost= 15 . 92 .. 15 . 94  rows= 10  width= 4 ) 
Sort Key: item.id 
-> Index Scan using quot_prepared_quot_id_idx on quot_prepared item (cost= 0 . 00 .. 15 . 74  rows= 10  width= 4 ) 
Index Cond: (quot_id =  120363 ) 
-> Sort (cost= 22996 . 97 .. 23546 . 43  rows= 219784  width= 16 ) 
Sort Key: qr.quot_prepared_id 
-> Seq Scan on quot_rubric qr (cost= 0 . 00 .. 3495 . 84  rows= 219784  width= 16 )