cdr=# explain analyze select * from cdr where cdr.acctid = 196933 and uniqueid = 1104850819.7400; QUERY PLAN --------------------------------------------------------------------------------------------------------- Seq Scan on cdr (cost=0.00..20763.61 rows=1 width=229) (actual time=1760.794..1760.936 rows=1 loops=1) Filter: ((acctid = 196933) AND ((uniqueid)::text = '1104850819.7400'::text)) Total runtime: 1761.124 ms (3 rows) cdr=# explain analyze select * from cdr where cdr.acctid = 196933; QUERY PLAN --------------------------------------------------------------------------------------------------------- Seq Scan on cdr (cost=0.00..20272.17 rows=2 width=229) (actual time=1762.215..1762.347 rows=1 loops=1) Filter: (acctid = 196933) Total runtime: 1762.540 ms (3 rows)