[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:

Yes, that's one of the possible improvements.

> > I guess we should add a "Stats" page on 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 Petazzoni      
Logiciels Libres à Toulouse
Embedded Linux        

reply via email to

[Prev in Thread] Current Thread [Next in Thread]