Seq Scan on sensor (cost=0.00..1.25 rows=1 width=6) (actual time=0.055..0.068 rows=1 loops=1)
   Filter: (sensor_id = 12)
 Total runtime: 801641.333 ms
(3 rows)

Can anybody help me out?  Thanks so much!

Does your table have millions of dead rows? Do you vacuum once an hour? Run VACUUM FULL ANALYE sensor;

Chris


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to