Connor

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)