In [1]:
from oneflow.core.models.nonrel import *
from datetime import datetime

In [5]:
articles = Article.objects.all().count()
reads = Read.objects.all().count()
feeds = Feed.objects.all().count()
never_fetched = Feed.objects.filter(last_fetch=None).count()
subscriptions = Subscription.objects.all().count()
users = User.objects.all().count()

print '## Counters on', datetime.now()
print '- Articles:', articles
print '- Reads:', reads, 'merged:', reads - articles
print '- Feeds:', feeds, 'never fetched:', never_fetched
print '- Subscriptions:', subscriptions, 'merged:', subscriptions - feeds
print '- Users:', users


## Counters on 2013-07-12 13:20:51.470212
- Articles: 2402964
- Reads: 2566476 merged: 163512
- Feeds: 4156 never fetched: 107
- Subscriptions: 4416 merged: 260
- Users: 28

Counters on 2013-07-12 13:20:51.470212

  • Articles: 2402964
  • Reads: 2566476 merged: 163512
  • Feeds: 4156 never fetched: 107
  • Subscriptions: 4416 merged: 260
  • Users: 28

Counters on 2013-07-08 10:09:06.344617

  • Articles: 2353634
  • Reads: 2504054 merged: 150420
  • Feeds: 4156
  • Subscriptions: 4416 merged: 260
  • Users: 28

Counters on 2013-07-08 09:49:07.233766

  • Articles: 2353634
  • Reads: 2504054 merged: 150420
  • Feeds: 4156
  • Subscriptions: 4416 merged: 260
  • Users: 28

In [10]:
for feed in Feed.objects.filter(last_fetch=None):
    print u'- %s: %s %s' % (feed, feed.closed, feed.url)


- Silicon.fr (#51c66192e7a05b27f68ce7ae): False http://feeds.silicon.fr/silicon-news
- Google Alertes - "living social" (#51c71da2e7a05b27f691c7cc): False user/04815692813061125456/state/com.google/alerts/12091046853703696027
- Matthieu Chaignot (#51c71da2e7a05b27f691c7e8): False user/04815692813061125456/state/com.google/alerts/972818555282512107
- Crisp's Blog » Henrik Kniberg (#51c95b1ae7a05b27f6934ff9): False http://blog.crisp.se/author/henrikkniberg/feed
- Le Journal du Geek (#51c95b44e7a05b27f693ba0d): False user/03566763095546349187/source/com.google/link
- Gizmodo (#51c95b44e7a05b27f693ba16): False http://fr.gizmodo.com/rss20.xml
- Latest News (#51c95b45e7a05b27f693bab9): False http://www.huffingtonpost.com/feeds/verticals/france/news.xml
- Feed Auteurs 9 (#51c95e32e7a05b27f695da6b): False http://pipes.yahoo.com/pipes/pipe.run?_id=FitIfQVf3hGKElRs0j6skA&_render=rss
- mémoire de la librairie contemporaine (#51c95e35e7a05b27f695dcbf): False http://melico.org/feed/
- Observatoire français des médias (#51c95e35e7a05b27f695dcd6): False http://www.observatoire-medias.info/backend.php3
- Wikio Videos - litterature (#51c95e37e7a05b27f695df48): False http://rss.wikio.fr/videos/search/rss/litterature?sort=1
- wallpapers for your iPad 2 | Cole Rise (#51c95e3ae7a05b27f695e346): False user/16908316930142855185/source/com.google/link
- RobotImpact, toute l'actualité de la robotique (#51c95e3ae7a05b27f695e3f2): False http://www.robotimpact.com/index.php?format=feed&type=rss
- kottke.org (#51c95e57e7a05b27f696300d): False user/02212999699569579485/source/com.google/link
- obi.1flowapp.com (#51c969ebe7a05b27f6984802): False user/04815692813061125456/source/com.google/link
- Google Alertes - "dealissime" (#51c969ece7a05b27f6984862): False user/04815692813061125456/state/com.google/alerts/9762586931089336047
- [cmdshft] (#51c96bf9e7a05b27f698a88c): False http://www.cmdshft.ipwn.me/blog/?feed=rss2
- Linux for Devices - RSS Feeds (#51c97299e7a05b27f69921a6): False http://www.linuxdevices.com/backend/headlines.rss
- Underground Gamer (#51c9d5b3e7a05b27f69e7f18): False http://www.underground-gamer.com/rss.php?cat%5B%5D=43&cat%5B%5D=41&passkey=f284105dd74e27d9b4a0fd873b323833
- QC RSS (#51c9d5b4e7a05b27f69e80bc): False http://www.questionablecontent.net/QCRSS.xml
- Steve in a Speedo?! Gross! (#51c9d5b4e7a05b27f69e80ea): False user/16229851350779227226/source/com.google/link
- MediasSociaux.fr (#51c9d674e7a05b27f69fe2c4): False user/00273639889367660362/source/com.google/link
- (title unknown) (#51c9f2cde7a05b27f6a2335e): False http://monitorthis.77elements.com/
- "Top blogs - high-tech" via Prospere in Google Reader (#51c9f2cde7a05b27f6a23362): False user/09434610908095170909/label/Top blogs - high-tech
- AeroXperience News (#51c9f2cde7a05b27f6a2339a): False http://www.aeroxp.org/board/index.php?act=rssout&id=1
- Alertes Google - alkaraan (#51c9f2cde7a05b27f6a233a0): False user/07876269978575408312/state/com.google/alerts/8102560333088623639
- Alertes Google - FGRibreau (#51c9f2cde7a05b27f6a233a2): False user/07876269978575408312/state/com.google/alerts/18189143965595287670
- AllienSoft (#51c9f2cde7a05b27f6a233a6): False http://www.alliensoft.org/blog/feed
- Amistorique (Site entier) (#51c9f2cee7a05b27f6a233ae): False http://amistorique.fr/rss/index.php
- DailyApps (#51c9f2d2e7a05b27f6a23d7a): False http://feeds.dailyapps.net/posts-full
- DataLife Engine 9.0 FULL English by DLEVIET.COM (#51c9f2d2e7a05b27f6a23d7f): False http://www.area51warez.info/rss.xml
- Digital-in (#51c9f2d3e7a05b27f6a23db3): False http://www.foonikens.fr/?feed=rss2
- Francois Guillaume Ribreau (#51c9f2d3e7a05b27f6a23dd4): False http://blog.geekfg.net/feeds/posts/default
- lo-fi librarian (#51c9f2d6e7a05b27f6a23e6d): False http://www.lo-fi-librarian.co.uk/?feed=rss2
- milw0rm.com (#51c9f2d6e7a05b27f6a23e84): False http://www.milw0rm.com/rss.php
- Wikio - ces2011 (#51c9f2dae7a05b27f6a23f83): False http://rss.wikio.com/search/ces2011.rss
- Wikio - ipad2 (#51c9f2dae7a05b27f6a23f85): False http://rss.wikio.com/search/ipad2.rss
- Autoritatea Națională Pentru Protecția Consumatorilor (#51ca0086e7a05b27f6a32957): False http://www.anpc.gov.ro/anpc/index.php?format=feed&type=rss
- Create @ f.d.o (#51ca0086e7a05b27f6a32979): False http://create.freedesktop.org/rss20.xml
- Happypenguin (#51ca0087e7a05b27f6a329b7): False http://happypenguin.org/html/news.rdf
- User Friendly (#51ca008ae7a05b27f6a33105): False http://userfriendly.org/rss/uf.rss
- Gas 2.0 (#51ca008fe7a05b27f6a342ef): False user/05954924196419289162/source/com.google/link
- SayingImages.com (#51ca00cae7a05b27f6a3e931): False user/05691355481832359568/source/com.google/link
- Zen Habits (#51ca00fde7a05b27f6a475af): False user/08953860907503432511/source/com.google/link
- urban.log (#51ca0177e7a05b27f6a5a832): False http://www.urbanlog.org/rss.php?extended_titles=1
- Debian Package of the Day (#51ca0178e7a05b27f6a5a9e9): False http://debaday.debian.net/feed/
- Autoritatea Na?ional? pentru Protec?ia Consumatorilor (#51ca01efe7a05b27f6a6d9a6): False http://www.anpcnet.ro/ro/?feed=atom
- (title unknown) (#51ca07c6e7a05b27f6ae9eff): False http://www.unknownscreenwriter.com/feed/
- All (#51ca07dae7a05b27f6aeb959): False http://news.windingroad.com/feed/
- Amazing Agent Jennifer (#51ca07e0e7a05b27f6aeb981): False http://www.amazingagentjennifer.com/comic.rss
- Amazing Agent Luna (#51ca07e0e7a05b27f6aeb983): False http://www.amazingagentluna.com/comic.rss
- AniFREAK! - NarutoFan.com and BleachWorld.com Latest News and Updates (#51ca07e2e7a05b27f6aeb99d): False http://rss.narutofan.com/rss.xml
- Apple Hot News (#51ca07e4e7a05b27f6aeb9b7): False http://www.apple.com/main/rss/hotnews/hotnews.rss
- CareerBuilder Job Recommendations RSS (#51ca0803e7a05b27f6aebb23): False http://careerbuilder.com/RTQ/JobRecommendationsRSS.aspx?lr=&DossierDID=DNT8CN74808XXMHDKL3&DateStarted=2007-09-05T02%3A42%3A17&ff=27
- Catching the Sound (#51ca0806e7a05b27f6aebb39): False http://catchingthesound.com/rss.xml
- Circuits-Lab.com (#51ca080ae7a05b27f6aebb67): False http://www.circuits-lab.com/?feed=rss2
- Cisco Blog (#51ca080ae7a05b27f6aebb69): False http://www.ciscoblog.com/atom.xml
- Conceptualist.com, By Sahar Sarid (#51ca0810e7a05b27f6aebbb4): False http://www.conceptualist.com/rss.php
- Congress Blog (#51ca0811e7a05b27f6aebbb8): False http://blog.thehill.com/feed/
- Dattebayo Fansubs, LLC Newsfeed (#51ca081fe7a05b27f6aebc3c): False http://www.dattebayo.com/rss.xml
- ebookshare (#51ca082ce7a05b27f6aebcc5): False http://www.ebookshare.net/feed/
- für zwischendurch (#51ca0845e7a05b27f6aebdda): False http://pipes.yahoo.com/pipes/pipe.run?_id=da36c4daa3b1b4054c261d6267ec38bc&_render=rss
- Gawker (#51ca0846e7a05b27f6aebdea): False http://www.defamer.com/index.xml
- glumbert.com (#51ca084be7a05b27f6aebe1f): False http://www.glumbert.com/feed/
- Green on HuffingtonPost.com (#51ca084ee7a05b27f6aebe46): False http://www.huffingtonpost.com/feeds/verticals/green/index.xml
- Income.com Blog (#51ca0863e7a05b27f6aebecb): False http://feeds.income.com/incomedotcom
- Interesting about pills (#51ca0869e7a05b27f6aebef5): False http://tubbynerd.com/feed/
- JMLR (#51ca086ee7a05b27f6aebf33): False http://jmlr.csail.mit.edu/jmlr.xml
- JupiterResearch.com (#51ca0872e7a05b27f6aebf5e): False http://www.jupiterresearch.com/bin/item.pl/rss/jup/xml=1/
- LOL President (#51ca087ee7a05b27f6aebfdb): False http://lolpresident.com/feed/
- MediaPost | Online Media Daily (#51ca0886e7a05b27f6aec043): False http://blogs.mediapost.com/search_insider/?feed=rss2
- Metcheck.com UK Weather News (#51ca0889e7a05b27f6aec05b): False http://rss1.mediafed.com/feed/metcheck/News
- Moon Town (#51ca088ee7a05b27f6aec0a7): False http://acetripwire.com/moontown/feed/
- Movies Opening This Week (#51ca0890e7a05b27f6aec0b5): False http://rss.ent.yahoo.com/movies/thisweek.xml
- MUSIK ZWEI.PUNKT.NULL (#51ca0893e7a05b27f6aec0d9): False http://www.musikzweipunktnull.de/feed/
- National Weather Service (#51ca0896e7a05b27f6aec0fb): False http://www.weather.gov/nwsheadlines.xml
- Ovi Share Blog - Share Your Photos and Videos. Anytime. Anywhere. (#51ca08ade7a05b27f6aec1ed): False http://blog.twango.com/twango/rss.xml
- PayPal Mini Cart - PayPal Labs (#51ca08b0e7a05b27f6aec20b): False https://minicart.paypal-labs.com/?rss
- Psychology Today Features (#51ca08c3e7a05b27f6aec2da): False http://www.psychologytoday.com/articles/index.rss
- Quotiki - Recently Added Quotes (#51ca08c8e7a05b27f6aec2f5): False http://quotiki.com/rss/MostRecent.ashx
- Random Curiosity (#51ca08c8e7a05b27f6aec2f7): False http://randomc.animeblogger.net/feed/
- Recent Flash content (#51ca08cbe7a05b27f6aec313): False http://www.macromedia.com/go/rss_flash
- Rezensionen (#51ca08d1e7a05b27f6aec342): False http://pipes.yahoo.com/pipes/pipe.run?_id=3cebd93bfbfe7fb1f0d9f84246d493f3&_render=rss
- Rotoworld.com News for NFL (#51ca08d6e7a05b27f6aec360): False http://rss.rotoworld.com/rss/nfl.xml
- Sampa Blog (#51ca08d9e7a05b27f6aec370): False http://blog.sampa.com/feed.xml
- Stories (#51ca0900e7a05b27f6aec47c): False http://feeds.digg.com/digg/news/topic/environment/popular.rss
- Stories (#51ca0901e7a05b27f6aec47e): False http://feeds.digg.com/digg/topic/politics/popular.rss
- Technocrat (#51ca0913e7a05b27f6aec4c9): False http://syndication.technocrat.net/rss
- THAT Animeblog (#51ca0915e7a05b27f6aec4d5): False http://that.animeblogger.net/feed/
- The Chess Mind (#51ca091ae7a05b27f6aec500): False http://chessmind.powerblogs.com/rss.xml
- The Journal of Organic Chemistry: Latest Articles (ACS Publications) (#51ca0923e7a05b27f6aec540): False http://feeds.acs.org/acs/joceah
- The Sun BabelFish Blog (#51ca093ee7a05b27f6aec592): False http://blogs.sun.com/bblfish/feed/entries/atom
- Thomas Hennebert (#51ca094ce7a05b27f6aec5c8): False http://www.thenbrt.com/feed/
- Today Books - PDFCHM Online (#51ca094fe7a05b27f6aec5df): False http://feeds.pdfchm.com/pdfchm
- TPN :: The Cranky Middle Manager Show (#51ca0953e7a05b27f6aec5ff): False http://cmm.thepodcastnetwork.com/feed/
- twenty thousand hertz (#51ca0956e7a05b27f6aec619): False http://www.twentythousandhertz.com/feed/
- User Friendly RSS Feed (#51ca095ee7a05b27f6aec641): False http://www.userfriendly.org/rss/uf.rss
- What's Hot in Google Reader (#51ca0973e7a05b27f6aec6bb): False user/15650323335570657892/label/cool
- felipov / future is now (#51ca0b36e7a05b27f6aec874): False http://felipov.this.ro/?feed=rss2
- cathartic media - alternative mp3 blog (#51ca0cd8e7a05b27f6aec9ad): False http://www.catharticmedia.ro/feed
- Sod (#51ca0d2be7a05b27f6aecb65): False http://blog.uniques.ro/feed/
- Texas Startup Blog (#51ca23f2e7a05b27f6b67f46): False http://www.texasstartupblog.com/feed/atom/
- WordCamp Melbourne (#51ca2677e7a05b27f6ba8d94): False http://wcmelb.org/feed/
- Gawker: Tv (#51ca2686e7a05b27f6baa4a7): False http://tv.gawker.com/index.xml
- eurasian-sensation.blogspot.com (#51ca26dde7a05b27f6bb2104): False user/08479141264317288136/source/com.google/link
- businesslife (#51ca27a8e7a05b27f6bc60c4): False http://life.ducttapemarketing.com/atom.xml
- Indieducky.Com (#51ca0863e7a05b27f6aebed1): False http://www.regnyouth.com/?feed=rss2

In [ ]: