Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How can I count how many webpages were loaded on a single day of Google Chrome use? I know it's saved because it lists all of them in history, but it'd take forever to count by hand!

I wanted to see this for bandwidth purposes. My ISP imposes a low limit (30GB per month, and we're a five person family). I wanted to see this and compare with what they think is "average" and what I view. I think they're way too low.

share|improve this question

2 Answers 2

up vote 5 down vote accepted

This answer is probably overkill but you did say you were curious.

Chrome running in Windows 7 stores its history in an SQLite database file:

C:\Users\[username]\AppData\Local\Google\Chrome\User Data\Default\History

which you can open with an SQLite manager such as SQLite Expert or SQLiteStudio. Make sure Chrome is closed first.

You can query the database as follows:

select
  date(visit_time/1000000-11644473600, 'unixepoch', 'localtime') as [Date],
  count(url) as [Pages]
from visits
group by [Date]
order by [Date] desc;

and get results such as:

Date         Pages
-----------  ----------
2011-11-15   23
2011-11-14   17
2011-11-13   46
2011-11-12   54
2011-11-11   29
...

Note: Date arithmetic calculations taken from this answer on Stack Overflow.

share|improve this answer
    
Now that's really nifty! I'm a programmer too so this isn't too advanced for me. –  Bubby4j Nov 16 '11 at 2:51

Super easy method: I guess you could copy and paste your history into a word document, and look at what line your cursor is on.


1337 method:

  • Install the History 2 extension.

  • Copy the data into your favourite "programmer's" editor. (Notepad++, for me.)

  • Use the following regexes:

    [^\s]*\s\[
    \]
    

    Replace all matches with absolutely nothing.

  • Copy the data into a spreadsheet program (Microsoft Excel). Sum the data.

share|improve this answer
    
This works if it fits on one history page, if there's another page you'd need to copy it too. It will still work, I'm just noting it. –  Bubby4j Nov 15 '11 at 1:09
    
Ah, just tried it, it seems that when you paste it, it puts the time of access on a different line, so that won't work. BUT you could just divide the count by 2, and it'll work like that. –  Bubby4j Nov 15 '11 at 1:10
1  
@Bubby4j Maybe use an extension? History 2, copy the data, paste it into Notepad++, use a regex, copy the remaining numbers into Excel, and add them up. –  muntoo Nov 15 '11 at 1:13
    
There are other extensions, too. You could try installing them, and seeing which displays a full page of the day's history. –  muntoo Nov 15 '11 at 1:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.