Zeitgeist logs your activity in Unity. Is there a way to look at the raw logs it creates?


The logs are stored in ~/.local/share/zeitgeist/activity.sqlite. They are stored in an SQLite database, so you will need an SQLite database browser to view them.

  • Thanks. Can you recommend one? – con-f-use Aug 3 '12 at 15:41
  • I like SQLite Database Browser sudo apt-get install sqlitebrowser. – reverendj1 Aug 3 '12 at 15:48

Yes, Zeitgeist stores its data in sqlite. I'm using Ubuntu 12.04 (Precise Pangolin) and my zeitgeist usage data is in


In order to access the raw logs, you'll need to know some SQL, which I'll leave up to you. However, if you have not installed sqlite3 Install sqlite3, the command line interface for SQLite Version 3, then do so

sudo apt-get install sqlite3

Then, you may interogate the raw data as follows

[11:33:50 oyrm zeitgeist]$ pwd # Just to show where we are
[11:33:54 oyrm zeitgeist]$ sqlite3 -interactive activity.sqlite
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
actor            extensions_conf  mimetype         storage        
event            interpretation   payload          text           
event_view       manifestation    schema_version   uri            

As you can see, I have access to the activity.sqlite database at this point and may execute SQL to my hearts content. Now, figuring out how these are all related will be a puzzle for you, but you can use sqlite3 to determine useful things like db and table schemas.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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