explain analyze SELECT * FROM highrate_log_entry WHERE test_seq_number > 26668670 and udc = '2424' AND (test_signal_number = 'D2030' ) ORDER BY test_seq_number LIMIT 11 QUERY PLAN Limit (cost=6694.14..6694.17 rows=11 width=61) (actual time=2.859..2.881 rows=11 loops=1) -> Sort (cost=6694.14..6695.82 rows=672 width=61) (actual time=2.856..2.863 rows=11 loops=1) Sort Key: public.highrate_log_entry.test_seq_number Sort Method: top-N heapsort Memory: 18kB -> Result (cost=0.00..6679.16 rows=672 width=61) (actual time=0.973..2.484 rows=254 loops=1) -> Append (cost=0.00..6679.16 rows=672 width=61) (actual time=0.970..2.046 rows=254 loops=1) -> Index Scan using high_rate_index on highrate_log_entry (cost=0.00..8.27 rows=1 width=145) (actual time=0.009..0.009 rows=0 loops=1) Index Cond: ((udc = 2424::numeric) AND ((test_signal_number)::text = 'D2030'::text)) Filter: (test_seq_number > 26668670::numeric) -> Index Scan using highrate_log_entry_2424_2009_pkey on highrate_log_entry_2424_2009 highrate_log_entry (cost=0.00..3734.01 rows=1 width=60) (actual time=0.020..0.020 rows=0 loops=1) Index Cond: ((udc = 2424::numeric) AND (test_seq_number > 26668670::numeric)) Filter: ((test_signal_number)::text = 'D2030'::text) -> Index Scan using highrate_log_entry_2424_2010_udc_key on highrate_log_entry_2424_2010 highrate_log_entry (cost=0.00..2936.88 rows=670 width=61) (actual time=0.935..1.620 rows=254 loops=1) Index Cond: ((udc = 2424::numeric) AND ((test_signal_number)::text = 'D2030'::text)) Filter: (test_seq_number > 26668670::numeric) Total runtime: 2.949 ms