[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Maposmatic-dev] Number of renderings per day
From: |
Thomas Petazzoni |
Subject: |
Re: [Maposmatic-dev] Number of renderings per day |
Date: |
Thu, 26 Apr 2012 15:59:43 +0200 |
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