Unnamed

planet2-v76=# explain analyze 
SELECT gcms_rels.related_item_id AS item_id, gcms_rels.title as title 
FROM gcms_rels 
JOIN cr_items ON (cr_items.item_id = gcms_rels.related_item_id) 
JOIN cr_revisions ON (cr_revisions.revision_id = cr_items.live_revision) 
WHERE gcms_rels.revision_id = '85179' 
ORDER BY gcms_rels.position 
LIMIT 1;
                                                                            QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------------ 
Limit  (cost=107.24..107.24 rows=1 width=108) (actual time=0.629..0.629 rows=1 loops=1)
   ->  Sort  (cost=107.24..107.26 rows=9 width=108) (actual time=0.626..0.626 rows=1 loops=1)
         Sort Key: gcms_rels."position"
         ->  Nested Loop  (cost=0.00..107.10 rows=9 width=108) (actual time=0.083..0.541 rows=13 loops=1)
               ->  Nested Loop  (cost=0.00..72.99 rows=10 width=112) (actual time=0.062..0.251 rows=13 loops=1)
                     ->  Index Scan using gcms_rels_revision_id_key on gcms_rels  (cost=0.00..21.21 rows=10 width=108) (actual time=0.037..0.058 rows=13 loops=1)
                           Index Cond: (revision_id = 85179)
                     ->  Index Scan using cr_items_pk on cr_items  (cost=0.00..5.17 rows=1 width=8) (actual time=0.009..0.010 rows=1 loops=13)
                           Index Cond: (cr_items.item_id = "outer".related_item_id)
               ->  Index Scan using cr_revisions_pk on cr_revisions  (cost=0.00..3.40 rows=1 width=4) (actual time=0.017..0.019 rows=1 loops=13)
                     Index Cond: (cr_revisions.revision_id = "outer".live_revision)
 Total runtime: 0.869 ms
(12 rows)