0,0 → 1,29 |
select extract(month from stamp) as month, round((base + delta) / 1024 / 1024) |
from tcount |
where source = 'tun0_out' |
and host = 'sun' |
and stamp in ( |
select max(stamp) from tcount |
where source = 'tun0_out' |
and host = 'sun' |
and extract(year from stamp) = 2003 |
group by extract(month from stamp) |
) |
order by month; |
|
|
select extract(day from stamp) as day, round((base + delta) / 1024 / 1024) |
from tcount |
where source = 'tun0_out' |
and host = 'sun' |
and stamp in ( |
select max(stamp) from tcount |
where source = 'tun0_out' |
and host = 'sun' |
and extract(year from stamp) = 2003 |
and extract(month from stamp) = 8 |
group by extract(day from stamp) |
) |
order by day; |
|
|