Re: [Maposmatic-dev] Number of renderings per day

[Thomas Petazzoni]

Le Thu, 26 Apr 2012 13:14:26 +0200,
David MENTRE <address@hidden> a écrit :

> For learning purpose, which SQL query are you using?

I did:

echo "select count(*) as count, date_trunc('day', submission_time) as
day from maposmatic_maprenderingjob group by day;" | psql -d
maposmatic-prod -A -t > /tmp/stats.txt

> Maybe you can count rendering in the state 2 or 3:
>   
> http://git.savannah.gnu.org/cgit/maposmatic.git/tree/www/maposmatic/models.py#n75

Yes, that's one of the possible improvements.

> > I guess we should add a "Stats" page on maposmatic.org with some nice
> > and shiny graphs.
> 
> Yes, that would be nice. We could also put on this page the number of
> bugs and task features that are queued. :-)

And solved :-)

Thomas
-- 
Thomas Petazzoni                http://thomas.enix.org
MapOSMatic                      http://www.maposmatic.org
Logiciels Libres à Toulouse     http://www.toulibre.org
Embedded Linux                  http://www.free-electrons.com