From Bug 721934 and GCP… relevant info from Places db in Firefox/Fennec

Here's the instructions on how to get the relevant stats from your places.sqlite file (in your profile). I'm interested if it took more than 2 minutes to get your profile migrated to Native Fennec. If you're using Sync (I presume everybody who encountered this bug is), doing this on your desktop profile might already be enough.

Install https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

Go to Tools (Press ALT to get the menu)->SQLite Manager

Database->Connect New Database->places.sqlite
Left Window->Tables->moz_bookmarks
Right Window->Structure->More Info->No of Records  <- note down
Same for moz_favicons, moz_historyvisits and moz_places <- note down

Right Window->Execute SQL

Enter SQL:
SELECT places.url AS a_url, places.title AS a_title, MAX(history.visit_date) AS a_date, COUNT(*) AS a_visits, favicon.data AS a_favicon_data, favicon.mime_type AS a_favicon_mime FROM (moz_historyvisits AS history JOIN moz_places AS places ON places.id = history.place_id LEFT OUTER JOIN moz_favicons AS favicon ON places.favicon_id = favicon.id) WHERE places.hidden <> 1 GROUP BY a_url ORDER BY a_visits DESC LIMIT 300

Complete bottom right:  ET: xxxx ms <- note down

Right Window->Execute SQL

Enter SQL:
SELECT places.url AS a_url, places.title AS a_title FROM (moz_places as places JOIN moz_bookmarks as bookmarks ON places.id = bookmarks.fk) WHERE places.hidden <> 1 ORDER BY bookmarks.dateAdded

Complete bottom right: Number of Rows return: xxx ET: xxxx ms <- note down both