> netacc=> EXPLAIN (SELECT SUM(counterfrom) AS from,
> SUM(counterto) AS to,
> floor((985098900 - date_part('epoch', counterstamp)) / 300)
> AS sequence
> FROM counters WHERE line='absolonll' AND date_part('epoch',
> ) counterstamp > 984978900 GROUP BY sequence, line) ...
I would guess the problem is the restriction on counterstamp, because
written like that, it probably can't use the index.
try something where you avoid the use of the date_part function e.g.:
AND counterstamp > '2001-07-26 00:00:00.0'
Andreas