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