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)