koji=# explain SELECT filename, filemd5, filesize, fileflags FROM rpmfiles WHERE (rpm_id = 180315) order by filename limit 50;
                                           QUERY PLAN
------------------------------------------------------------------------------------------------
 Limit  (cost=0.00..3102.68 rows=50 width=105)
   ->  Index Scan using rpmfiles_pkey on rpmfiles  (cost=0.00..1762507.48 rows=28403 width=105)
         Index Cond: (rpm_id = 180315)
(3 rows)

koji=# explain SELECT filename, filemd5, filesize, fileflags FROM rpmfiles WHERE (rpm_id = 180315) order by filename;
                                            QUERY PLAN
--------------------------------------------------------------------------------------------------
 Sort  (cost=3672.48..3743.49 rows=28403 width=105)
   Sort Key: filename
   ->  Index Scan using rpmfiles_by_rpm_id on rpmfiles  (cost=0.00..1571.55 rows=28403 width=105)
         Index Cond: (rpm_id = 180315)
(4 rows)

koji=# explain SELECT filename, filemd5, filesize, fileflags FROM rpmfiles WHERE (rpm_id = 180315) limit 50;                                                             QUERY PLAN
--------------------------------------------------------------------------------------------------
 Limit  (cost=0.00..2.77 rows=50 width=105)
   ->  Index Scan using rpmfiles_by_rpm_id on rpmfiles  (cost=0.00..1571.55 rows=28403 width=105)
         Index Cond: (rpm_id = 180315)
(3 rows)