|
24360
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→CSearch Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)Notion Helper (Renderer)claudeFirefoxCP Isolated Web ContentClaude Helper (Renderer)iTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 42 mA100% <47Wed 15 Apr 15:18:55CPUMemoryDiskMem...Threads1,15 GB961,2 MB942,2 MB843,1 MB772,8 MB747,7 MB549,3 MB544,3 MB542,6 MB496,9 MB458,8 MB447,6 MB424,1 MB393,2 MB385,7 MB381,0 MB372,1 MB345,0 MB329,1 MB326,1 MB290,3 MB288,6 MB257,9 MB238,9 MB214,3 MB213,4 MB198,7 MB192,9 MB21267384325312624241624252725232315211327152618282559EnergyPorts19 5561267291 20019 766125245251126122199124123126125120121172328721242181 789123239129124730PID407429748014146648424203080191467336713354804186335276358314365243016368984817326548114850910358336051948785613885340482987429560491Physical Memory:Memory Used:Cached Files:Swap Used:16,00 GB13,61 GB2,34 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,37 GB2,62 GB6,07 GB...
|
NULL
|
NULL
|
NULL
|
24360
|
|
24359
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→CSearch Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)Notion Helper (Renderer)claudeFirefoxCP Isolated Web ContentClaude Helper (Renderer)iTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 42 mA100% <47Wed 15 Apr 15:18:37CPUMemoryDiskMem...Threads1,15 GB961,2 MB943,4 MB843,0 MB772,8 MB747,9 MB549,4 MB544,3 MB542,6 MB496,9 MB455,6 MB445,9 MB424,1 MB393,1 MB385,7 MB381,0 MB372,1 MB345,0 MB327,3 MB326,1 MB290,3 MB275,3 MB257,7 MB238,8 MB213,7 MB213,4 MB198,3 MB192,8 MB20267484325292724231524252626232215201327152718282459EnergyPorts19 6251267331 20119 766125242253126120185124123124127120119172313721242151 792125233129122730PID407429748014146648424203080191467336713354804186335276358314365243016368984817326548114850910358336051948785613885340482987429560491Physical Memory:Memory Used:Cached Files:Swap Used:16,00 GB13,60 GB<2,36 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,37 GB2,58 GB6,10 GB...
|
NULL
|
NULL
|
NULL
|
24359
|
|
24358
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SASl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5", 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam— New |aomenoe c re crmlal vomuialieIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_..elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pgj Sprint Review • in 42 m100% C4"Wed 15 Apr 15:18:35•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter APl ...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ...Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaraver issue troublesnootingLukas KovalikPro nianChatCoworkCodeLinux SQLite Ul for NAS vlets run queries again I want to know what tables are used what data iscollected. want to know the size and count. A so what is stored indata/data/{date}. Seems there is jpg but also mp4. Exaplin the process. Whatis eachRun these 3 queries in the Query tab:Query 1 - size + row count combined:sqlSELECTd.name,SUM(d.pgsize) / 1024 / 1024 as size_mb,(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +(SELECI COUNT* FROM elements WHERE d.name ='elements' +(SELECT COUNT(*) FROM vi_events WHERE d.name = 'vi_events') +(SELECT COUNT(*) FROM video_chunks WHERE d. name = 'video_chunks') +(SELECT COUNT(*) FROM audio_chunks WHERE d. name = 'audio_chunks') +(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions')(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +(SELECT COUNT(*) FROM tags WHERE d. name ='tags') +(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_couFROM dbstat dWHERE d.name IN ('frames', 'ocr_text', 'elements', 'vi_events','video_chunks', 'audio_chunks','audio_transcriptions','memories', 'meetings', 'tags', 'pipe_executions'GROUP BY d.nameORDER BY SUM(d.pgsize) DESC;Query 2 - sample from each key table (schemas):SELECT sql FROM sqlite_masterWHERE type='table'AND name NOT LIKE"%_fts%'AND name NOT LIKE 'sqlite_%'AND name NOT LIKE '_sqlx%'ORDER BY name;Query 3 - what does actual data look like:SELECT frame_id, app_name, window_name, browser_url, focused,Reply...+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24358
|
|
24357
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)Notion Helper (Renderer)claudeFirefoxCP Isolated Web ContentClaude Helper (Renderer)iTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 42 mA100% <47Wed 15 Apr 15:18:34CPUMemoryDiskMem...Threads1,16 GB961,2 MB943,4 MB843,0 MB772,8 MB747,9 MB549,4 MB544,3 MB542,6 MB496,8 MB455,6 MB446,8 MB424,1 MB393,1 MB385,7 MB381,0 MB372,1 MB345,0 MB327,2 MB326,1 MB290,3 MB275,2 MB258,2 MB238,8 MB213,5 MB213,4 MB198,6 MB192,8 MB20257484325302624231524252626232215201328152718272459EnergyPorts19 6271247331 20119 766125245250126120185123123124127120119172313721262151 790125231127122730PID407429748014146648424203080191467336713354804186335276358314365243016368984817326548114850910358336051948785613885340482987429560491Physical Memory:Memory Used:Cached Files:Swap Used:16,00 GB13,60 GB2,35 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,37 GB2,56 GB6,11 GB...
|
NULL
|
NULL
|
NULL
|
24357
|
|
24356
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)Notion Helper (Renderer)claudeFirefoxCP Isolated Web ContentClaude Helper (Renderer)iTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 42 mA100% <47Wed 15 Apr 15:18:25CPUMemoryDiskMem...Threads1,16 GB961,2 MB943,4 MB843,0 MB772,8 MB747,9 MB549,4 MB544,3 MB542,6 MB496,5 MB456,8 MB445,7 MB424,1 MB393,1 MB385,7 MB381,0 MB372,1 MB345,0 MB327,2 MB326,1 MB290,5 MB275,1 MB258,2 MB238,8 MB213,9 MB213,4 MB198,6 MB192,8 MB20257584325302725231523262626242215201328152718272459EnergyPorts19 6281247341 20119 766125245253128120185122125124127122119172313721262151 789125229127122730PID407429748014146648424203080191467336713354804186335276358314365243016368984817326548114850910358336051948785613885340482987429560491Physical Memory:Memory Used:Cached Files:Swap Used:16,00 GB13,61 GB<2,36 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,26 GB2,56 GB6,24 GB...
|
NULL
|
NULL
|
NULL
|
24356
|
|
24355
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)Notion Helper (Renderer)claudeFirefoxCP Isolated Web ContentClaude Helper (Renderer)iTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 42 mA100% <47Wed 15 Apr 15:18:22CPUMemoryDiskMem...Threads1,15 GB961,2 MB943,4 MB842,9 MB772,8 MB747,9 MB549,4 MB544,3 MB542,6 MB496,5 MB457,3 MB444,3 MB424,1 MB393,1 MB385,7 MB381,0 MB372,1 MB345,0 MB327,4 MB326,1 MB290,5 MB275,0 MB258,1 MB238,7 MB213,7 MB213,4 MB198,6 MB197,5 MB21257584325302625241623262625242215201328152718272459EnergyPorts19 6271247351 20119 766125242251128122199122125124125122119172313721262151 789125225127122730PID407429748014146648424203080191467336713354804186335276358314365243016368984817326548114850910358336051948785613885340482987429560491Physical Memory:Memory Used:Cached Files:Swap Used:16,00 GB13,59 GB<2,36 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,20 GB2,58 GB6,26 GB...
|
NULL
|
NULL
|
NULL
|
24355
|
|
24354
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)Notion Helper (Renderer)claudeFirefoxCP Isolated Web ContentClaude Helper (Renderer)iTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 42 mA100% <47Wed 15 Apr 15:18:19CPUMemoryDiskMem...Threads1,15 GB961,2 MB943,4 MB842,9 MB772,8 MB747,9 MB549,4 MB544,3 MB542,6 MB496,5 MB457,3 MB444,3 MB424,1 MB393,1 MB385,7 MB381,0 MB372,1 MB345,0 MB327,4 MB326,1 MB290,5 MB275,0 MB258,1 MB238,7 MB213,7 MB213,4 MB198,6 MB197,5 MB21257584325302625241623262625242215201328152718272459EnergyPorts19 6271247351 20119 766125242251128122199122125124125122119172313721262151 789125225127122730PID407429748014146648424203080191467336713354804186335276358314365243016368984817326548114850910358336051948785613885340482987429560491Physical Memory:Memory Used:Cached Files:Swap Used:16,00 GB13,59 GB<2,36 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,24 GB2,56 GB6,24 GB...
|
NULL
|
NULL
|
NULL
|
24354
|
|
24353
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→CSearch Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)Notion Helper (Renderer)claudeFirefoxCP Isolated Web ContentClaude Helper (Renderer)iTerm2FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 42 mA100% <478Wed 15 Apr 15:18:13CPUMemoryDiskMem...Threads1,15 GB961,2 MB943,4 MB842,9 MB772,8 MB747,9 MB549,4 MB544,3 MB542,6 MB496,5 MB457,3 MB442,1 MB424,1 MB393,0 MB385,7 MB381,0 MB372,1 MB345,0 MB327,8 MB326,1 MB291,5 MB274,8 MB257,6 MB238,7 MB213,3 MB213,1 MB198,4 MB197,5 MB20267484325302725241623262725242315211328152627182559EnergyPorts19 6281267341 20119 766125244254128122199122125126125122121172328721262151 789123127221124730PID407429748014146648424203080191467336713354804186335276358314365243016368984817326548114850910358336051948785613848298853407429560491Physical Memory:Memory Used:Cached Files:Swap Used:16,00 GB13,59 GB<2,36 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,19 GB2,55 GB6,30 GB...
|
NULL
|
NULL
|
NULL
|
24353
|
|
24352
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SASl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5", 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam— New |aomenoe c ne crmmial vommmialleIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_..elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pgj Sprint Review • in 42 m100% C4"Wed 15 Apr 15:18:05•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter APl ...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaraver issue troublesnootingLukas KovalikPro nianChatCoworkCodeLinux SQLite Ul for NAS vlets run queries again I want to know what tables are used what data iscollected. want to know the size and count. A so what is stored indata/data/{date}. Seems there is jpg but also mp4. Exaplin the process. Whatis eachRun these 3 queries in the Query tab:Query 1 - size + row count combined:sqlSELECTd.name,SUM(d.pgsize) / 1024 / 1024 as size_mb,(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +(SELECT COUNT(*) FROM elements WHERE d.name = 'elements') +(SELECT COUNT(*) FROM vi_events WHERE d. name = 'vi_events') +(SELECT COUNT(*) FROM video_chunks WHERE d.name = 'video_chunks') +(SELECT COUNT(*) FROM audio_chunks WHERE d. name = 'audio_chunks') +(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions')(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +(SELECT COUNT(*) FROM tags WHERE d. name ='tags') +(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_couFROM dbstat dWHERE d.name IN ('frames', 'ocr_text', 'elements', 'vi_events','video_chunks', 'audio_chunks','audio_transcriptions','memories', 'meetings', 'tags', 'pipe_executions'GROUP BY d.nameORDER BY SUM(d.pgsize) DESC;Query 2 - sample from each key table (schemas):SELECT sql FROM sqlite_masterWHERE type='table'AND name NOT LIKE"%_fts%'AND name NOT LIKE 'sqlite_%'AND name NOT LIKE '_sqlx%'ORDER BY name;Query 3 - what does actual data look like:SELECT frame_id, app_name, window_name, browser_url, focused,Reply...+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24352
|
|
24351
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)Notion Helper (Renderer)claudeFirefoxCP Isolated Web ContentClaude Helper (Renderer)iTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review • in 43 mMem...1,16 GB961,2 MB941,3 MB842,9 MB772,7 MB747,9 MB549,4 MB544,3 MB542,6 MB496,5 MB457,3 MB439,7 MB424,1 MB392,9 MB385.7 MB381,0 MB372,1 MB343,3 MB327,7 MB326,1 MB291,9 MB274,8 MB257,4 MB238,6 MB214,0 MB213,3 MB198,3 MB197,5 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <47Wed 15 Apr 15:17:58CPUMemoryDiskNetworkThreads19267585325302725241624262725242315211327152618282560EnergyPorts19 6251267351 20119 766125247254128122199124125126125122121172328721242151 789123217129124732PID40742974801414664842420308019146733671335480418633527635831436524301636898481732654811485091035833605194878561388534048298742956049116,00 GB13,60 GB<2,36 GB2,78 GBApp Memory:Wired Memory:Compressed:User_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,15 GB2,58 GB6,31 GB...
|
NULL
|
NULL
|
NULL
|
24351
|
|
24350
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)Notion Helper (Renderer)claudeFirefoxCP Isolated Web ContentClaude Helper (Renderer)iTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review • in 43 mMem...1,16 GB961,2 MB941,2 MB842,9 MB772,7 MB747,9 MB549,4 MB544,3 MB542,6 MB496,4 MB457,2 MB437,4 MB424,1 MB392,7 MB385,7 MB381,0 MB372,1 MB343,3 MB327,6 MB326,1 MB297,4 MB275,8 MB257,9 MB238,6 MB213,5 MB213,3 MB198,3 MB197,0 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <47Wed 15 Apr 15:17:49CPUMemoryDiskThreads20267684325302624231625252726232215211327152718282459EnergyPorts19 6271267351 20019 766125245250126120199125123126127120119172328721242151 789125213129122731PID40742974801414664842420308019146733671335480418633527635831436524301636898481732654811485091035833605194878561388534048298742956049116,00 GB13,61 GB2,36 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,13 GB2,60 GB6,32 GB...
|
NULL
|
NULL
|
NULL
|
24350
|
|
24349
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SASl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5", 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam— New |aomenoe c re crmlal vomuialieIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_..elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pg•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter APl ...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ...Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaraver issue troublesnootingLukas KovalikPro nianChatCoworklablCodeSprint Review • in 43m100% C4"Wed 15 Apr 15:17:34Linux SQLite Ul for NAS vlets run queries again I want to know what tables are used what data iscollected. want to know the size and count. A so what is stored indata/data/{date}. Seems there is jpg but also mp4. Exaplin the process. Whatis eachRun these 3 queries in the Query tab:Query 1 - size + row count combined:sqlSELECTd.name,SUM(d.pgsize) / 1024 / 1024 as size_mb,(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +(SELECI COUNT* FROM elements WHERE d.name ='elements' +(SELECT COUNT(*) FROM vi_events WHERE d.name = 'vi_events') +(SELECT COUNT(*) FROM video_chunks WHERE d. name = 'video_chunks') +(SELECT COUNT(*) FROM audio_chunks WHERE d. name = 'audio_chunks') +(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions')(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +(SELECT COUNT(*) FROM tags WHERE d. name ='tags') +(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_couFROM dbstat dWHERE d.name IN ('frames', 'ocr_text', 'elements', 'vi_events','video_chunks', 'audio_chunks','audio_transcriptions','memories', 'meetings', 'tags', 'pipe_executions'GROUP BY d.nameORDER BY SUM(d.pgsize) DESC;Query 2 - sample from each key table (schemas):SELECT sql FROM sqlite_masterWHERE type='table'AND name NOT LIKE"%_fts%'AND name NOT LIKE 'sqlite_%'AND name NOT LIKE '_sqlx%'ORDER BY name;Query 3 - what does actual data look like:SELECT frame_id, app_name, window_name, browser_url, focused,Reply...+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24349
|
|
24348
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)Notion Helper (Renderer)claudeFirefoxCP Isolated Web ContentClaude Helper (Renderer)iTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review • in 43 mMem...1,15 GB961,2 MB941,8 MB842,8 MB772,7 MB747,7 MB549,4 MB544,3 MB542,6 MB496,6 MB453,8 MB434,2 MB424,1 MB392,7 MB385,6 MB381,0 MB372,1 MB343,3 MB326,2 MB326,1 MB289,6 MB275,7 MB258,0 MB238,6 MB213,6 MB213,3 MB198,4 MB196,7 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <47Wed 15 Apr 15:17:31CPUMemoryDiskNetworkThreads19257584325292724241625252626232215201328162718272459EnergyPorts19 5311247321 20019 764125244254126122199124123124127120119172313721262171 788125207127122729PID40742974801414664842420308019146733671335480418633527635831436524301636898481732654811485091035833605194878561388534048298742956049116,00 GB13,43 GB<2,54 GB2,78 GBApp Memory:Wired Memory:Compressed:User_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,50 GB2,40 GB5,98 GB...
|
NULL
|
NULL
|
NULL
|
24348
|
|
24347
|
+SlackFileEditViewGoEDHomeDMsActivityFilesLater..• +SlackFileEditViewGoEDHomeDMsActivityFilesLater..•More+→Jiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...HistoryWindowHelpSearch Jiminny Inc# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)Notion Helper (Renderer)claudeFirefoxCP Isolated Web ContentClaude Helper (Renderer)iTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review • in 43 mMem...1,16 GB961,2 MB941,7 MB842,8 MB772,7 MB747,7 MB549,4 MB544,3 MB542,6 MB496,5 MB453,8 MB431,7 MB424,1 MB392,7 MB385,6 MB381,0 MB372,1 MB343,3 MB326,4 MB326,1 MB289,6 MB275,5 MB258,0 MB238,6 MB213,1 MB212,8 MB198,3 MB196,6 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <47Wed 15 Apr 15:17:25CPUMemoryDiskThreads20257584325302725241623262626242215201328162718272459EnergyPorts19 5321247321 20019 764125247254128122199122125124127122119172313721262171 788125203127122729PID40742974801414664842420308019146733671335480418633527635831436524301636898481732654811485091035833605194878561388534048298742956049116,00 GB13,40 GB <2,54 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,45 GB2,42 GB5,98 GB...
|
NULL
|
NULL
|
NULL
|
24347
|
|
24346
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina Petrova0. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)Notion Helper (Renderer)claudeFirefoxCP Isolated Web ContentClaude Helper (Renderer)iTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review • in 43 mMem...1,15 GB961,2 MB941,6 MB842,8 MB772,7 MB747,7 MB549,4 MB544,3 MB542,6 MB496,5 MB452,3 MB429,5 MB424,1 MB392,6 MB385,6 MB381,0 MB372,1 MB343,3 MB326,8 MB326,1 MB289,6 MB278,8 MB258,0 MB238,5 MB213,4 MB212,7 MB198,0 MB196,5 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <47Wed 15 Apr 15:17:10CPUMemoryDiskThreads19257584325302625241523262725242315211328162618272559EnergyPorts19 5301247321 20019 764125247251128122185122125126125122121172328721262171 792123199127124729PID40742974801414664842420308019146733671335480418633527635831436524301636898481732654811485091035833605194878561388534048298742956049116,00 GB13,41 GB<2,54 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,52 GB2,42 GB5,92 GB...
|
NULL
|
NULL
|
NULL
|
24346
|
|
24345
|
+SlackFileEditViewGoEDHomeDMsActivityFilesLater..• +SlackFileEditViewGoEDHomeDMsActivityFilesLater..•More+→Jiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...HistoryWindowHelpSearch Jiminny Inc# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)Notion Helper (Renderer)claudeFirefoxCP Isolated Web ContentClaude Helper (Renderer)iTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review • in 43 mMem...1,15 GB961,2 MB941,3 MB842,8 MB772,7 MB747,7 MB549,4 MB544,3 MB542,6 MB496,1 MB452,3 MB428,3 MB424,1 MB392,6 MB385,6 MB381,0 MB372,1 MB343,3 MB326,8 MB326,1 MB289,6 MB278,0 MB258,3 MB238,5 MB217,2 MB212,7 MB198,0 MB197,3 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <47Wed 15 Apr 15:17:07CPUMemoryDiskThreads21257584325302725241523262725242315211328162618272559EnergyPorts19 5361247321 20019 764124245254128122185122125126125122121172328721262171 792123197127124729PID40742974801414664842420308019146733671335480418633527635831436524301636898481732654811485091035833605194878561388534048298742956049116,00 GB13,41 GB<2,54 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,44 GB2,36 GB6,05 GB...
|
NULL
|
NULL
|
NULL
|
24345
|
|
24344
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SASl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5", 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam— New |aomenoe c re crmlal vomuialieIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_..elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pg•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter APl ...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaraver issue troublesnootingLukas KovalikPro nianChatCoworklablCodeSprint Review • in 43m100% C4"Wed 15 Apr 15:17:03Linux SQLite Ul for NAS vlets run queries again I want to know what tables are used what data iscollected. want to know the size and count. A so what is stored indata/data/{date}. Seems there is jpg but also mp4. Exaplin the process. Whatis eachRun these 3 queries in the Query tab:Query 1 - size + row count combined:sqlSELECTd.name,SUM(d.pgsize) / 1024 / 1024 as size_mb,(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +(SELECI COUNT* FROM elements WHERE d.name ='elements' +(SELECT COUNT(*) FROM vi_events WHERE d.name = 'vi_events') +(SELECT COUNT(*) FROM video_chunks WHERE d. name = 'video_chunks') +(SELECT COUNT(*) FROM audio_chunks WHERE d. name = 'audio_chunks') +(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions')(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +(SELECT COUNT(*) FROM tags WHERE d. name ='tags') +(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_couFROM dbstat dWHERE d.name IN ('frames', 'ocr_text', 'elements', 'vi_events','video_chunks', 'audio_chunks','audio_transcriptions','memories', 'meetings', 'tags', 'pipe_executions'GROUP BY d.nameORDER BY SUM(d.pgsize) DESC;Query 2 - sample from each key table (schemas):SELECT sql FROM sqlite_masterWHERE type='table'AND name NOT LIKE"%_fts%'AND name NOT LIKE 'sqlite_%'AND name NOT LIKE '_sqlx%'ORDER BY name;Query 3 - what does actual data look like:SELECT frame_id, app_name, window_name, browser_url, focused,Reply...+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24344
|
|
24343
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→CSearch Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)Notion Helper (Renderer)claudeClaude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 44 mMem...1,15 GB961,2 MB941,1 MB843,0 MB772,7 MB747,7 MB549,4 MB544,3 MB542,6 MB496,0 MB450,9 MB425,2 MB424,1 MB392,6 MB385,6 MB380,9 MB372,1 MB343,7 MB326,6 MB326,1 MB325,5 MB289,5 MB257,9 MB238,5 MB216,6 MB212,5 MB198,1 MB197,0 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <478Wed 15 Apr 15:16:48CPUMemoryDiskThreads20267383325292624231524252726232315211316272617282559EnergyPorts19 5401267291 19919 764125244251126120185124123126127120121172328722171241 789123185129124729PID40742974801414664842420308019146733671335480418633527635831436524301636898481732654811485091060519358334878561388534048298742956049116,00 GB13,40 GB<2,54 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,42 GB2,41 GB6,02 GB...
|
NULL
|
NULL
|
NULL
|
24343
|
|
24342
|
+SlackFileEditViewGoEDHomeDMsActivityFilesLater..• +SlackFileEditViewGoEDHomeDMsActivityFilesLater..•More+→Jiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...HistoryWindowHelpSearch Jiminny Inc# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentClaude Helper (Renderer)FirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 44 mMem...1,15 GB961,2 MB941,1 MB842,2 MB772,7 MB747,6 MB549,4 MB544,3 MB542,6 MB541,3 MB496,0 MB450,9 MB424,2 MB424,1 MB392,6 MB385,6 MB380,9 MB372,1 MB343,7 MB326,1 MB325,1 MB289,1 MB258,0 MB238,4 MB220,1 MB212,5 MB198,1 MB197.0 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <478Wed 15 Apr 15:16:45CPUMemoryDiskThreads20267383325302624162315242526262322151320272718282459EnergyPorts19 5401267291 19919 764125245251126217120185124123124127120119172723131241 791125327129122729PID40742974801414664842420308019146733671360519354804186335276358314365243016368984817326548509101148358334878561388534048298742956049116,00 GB13,43 GB2,55 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,42 GB2,40 GB6,05 GB...
|
NULL
|
NULL
|
NULL
|
24342
|
|
24341
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→CSearch Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaude Helper (Renderer)Slack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 44 mA100% <478Wed 15 Apr 15:16:33CPUMemoryDiskMem...Threads1,15 GB961,2 MB941,4 MB842,2 MB772,7 MB747,6 MB549,4 MB544,3 MB542,6 MB496,0 MB474,1 MB450,8 MB424,1 MB422,5 MB392,6 MB385,6 MB380,9 MB372,1 MB343,7 MB326,1 MB324,9 MB288,9 MB258,2 MB238,4 MB219,4 MB212,5 MB197,9 MB197,5 MB20267384325302624231615252426262322151320282718282459EnergyPorts19 5421267291 20119 764125245250126120221185123124124127120119172723131261 790125323129122728PID407429748014146648424203080191467336713354806051941863358313527643652430163689848173265485091011483583348785613885340482987429560491Physical Memory:Memory Used:Cached Files:Swap Used:16,00 GB13,40 GB<2,54 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,32 GB2,46 GB6,07 GB...
|
NULL
|
NULL
|
NULL
|
24341
|
|
24340
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SASl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5", 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam— New |aomenoe c ne crmmial vommmialleIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_..elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pg•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter APl ...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ...Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaraver issue troublesnootingLukas KovalikPro nianChatCoworklablCodeSprint Review • in 44mA100% C•Wed 15 Apr 15:16:33Linux SQLite Ul for NAS vlets run queries again I want to know what tables are used what data iscollected. want to know the size and count. A so what is stored indata/data/{date}. Seems there is jpg but also mp4. Exaplin the process. Whatis eachRun these 3 queries in the Query tab:Query 1 - size + row count combined:sqlSELECTd.name,SUM(d.pgsize) / 1024 / 1024 as size_mb,(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +(SELECT COUNT(*) FROM elements WHERE d.name = 'elements') +(SELECT COUNT(*) FROM vi_events WHERE d. name = 'vi_events') +(SELECT COUNT(*) FROM video_chunks WHERE d.name = 'video_chunks') +(SELECT COUNT(*) FROM audio_chunks WHERE d. name = 'audio_chunks') +(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions')(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +(SELECT COUNT(*) FROM tags WHERE d. name ='tags') +(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_couFROM dbstat dWHERE d.name IN ('frames', 'ocr_text', 'elements', 'vi_events','video_chunks', 'audio_chunks','audio_transcriptions','memories', 'meetings', 'tags', 'pipe_executions'GROUP BY d.nameORDER BY SUM(d.pgsize) DESC;Query 2 - sample from each key table (schemas):SELECT sql FROM sqlite_masterWHERE type='table'AND name NOT LIKE"%_fts%'AND name NOT LIKE 'sqlite_%'AND name NOT LIKE '_sqlx%'ORDER BY name;Query 3 - what does actual data look like:SELECT frame_id, app_name, window_name, browser_url, focused,Reply...+Sonnet 46claude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24340
|
|
24339
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→CSearch Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaude Helper (Renderer)FirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentClaudeFirefoxCP Isolated Web ContentMEMORY PRESSURESprint Review - in 44 mMem...1,15 GB961,2 MB941,3 MB842,1 MB772,7 MB747,6 MB549,4 MB544,3 MB542,6 MB496,0 MB450,8 MB424,1 MB421,5 MB392,6 MB385,6 MB380,9 MB380,5 MB372,1 MB343,7 MB326,1 MB324,9 MB288,9 MB258,0 MB238,3 MB219,1 MB212,4 MB198,4 MB197,9 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <478Wed 15 Apr 15:16:30CPUMemoryDiskThreads21257484325302724231525242626231622151320282718276024EnergyPorts19 5441247301 20119 764125242253126120185123123124127120222119172723131261 789125321127732122PID40742974801414664842420308019146733671335480418633583135276436524301636898605194817326548509101148358334878561388534048298604917429516,00 GB13,43 GB2,54 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,38 GB2,42 GB6,08 GB...
|
NULL
|
NULL
|
NULL
|
24339
|
|
24338
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SASl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5", 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam- New laomenoe c ne crmmial vommmialleIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_..elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pg•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter APl ...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ...Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niormaron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaraver issue troublesnootingLukas KovalikPro nianChatCoworklablCodeSprint Review • in 44mA100% C•Wed 15 Apr 15:16:30Linux SQLite Ul for NAS vlets run queries again I want to know what tables are used what data iscollected. want to know the size and count. A so what is stored indata/data/{date}. Seems there is jpg but also mp4. Exaplin the process. Whatis eachRun these 3 queries in the Query tab:Query 1 - size + row count combined:sqlSELECTd.name,SUM(d.pgsize) / 1024 / 1024 as size_mb,(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +(SELECT COUNT(*) FROM elements WHERE d.name = 'elements') +(SELECT COUNT(*) FROM vi_events WHERE d. name = 'vi_events') +(SELECT COUNT(*) FROM video_chunks WHERE d.name = 'video_chunks') +(SELECT COUNT(*) FROM audio_chunks WHERE d. name = 'audio_chunks') +(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions')(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +(SELECT COUNT(*) FROM tags WHERE d. name ='tags') +(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_couFROM dbstat dWHERE d.name IN ('frames', 'ocr_text', 'elements', 'vi_events','video_chunks', 'audio_chunks','audio_transcriptions','memories', 'meetings', 'tags', 'pipe_executions'GROUP BY d.nameORDER BY SUM(d.pgsize) DESC;Query 2 - sample from each key table (schemas):SELECT sql FROM sqlite_masterWHERE type='table'AND name NOT LIKE "%_fts%'AND name NOT LIKE 'sqlite_%'AND name NOT LIKE '_sqlx%'ORDER BY name;Query 3 - what does actual data look like:SELECT frame_id, app_name, window_name, browser_url, focused,Reply...+Sonnet 46claude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24338
|
|
24337
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→CSearch Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaude Helper (Renderer)FirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentClaudeFirefoxCP Isolated Web ContentMEMORY PRESSURESprint Review - in 44 mMem...1,15 GB961,2 MB941,3 MB842,1 MB772,7 MB747,6 MB549,4 MB544,3 MB542,6 MB496,0 MB450,8 MB424,1 MB421,5 MB392,6 MB385,6 MB380,9 MB380,5 MB372,1 MB343,7 MB326,1 MB324,9 MB288,9 MB258,0 MB238,3 MB219,1 MB212,4 MB198,4 MB197,9 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <478Wed 15 Apr 15:16:27CPUMemoryDiskNetworkThreads21257484325302724231525242626231622151320282718276024EnergyPorts19 5441247301 20119 764125242253126120185123123124127120222119172723131261 789125321127732122PID40742974801414664842420308019146733671335480418633583135276436524301636898605194817326548509101148358334878561388534048298604917429516,00 GB13,42 GB <2,54 GB2,78 GBApp Memory:Wired Memory:Compressed:User_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,36 GB2,41 GB6,09 GB...
|
NULL
|
NULL
|
NULL
|
24337
|
|
24336
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SASl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5", 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam— New |aomenoe c re crmlal vomuialieIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_..elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pg•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ...Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niormaron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaraver issue troublesnootingLukas KovalikPro nian, 0ChatCoworklablCode# Sprint Review • in 44mA100% C•Linux SQLite Ul for NAS vlets run queries again I want to know what tables are used what data iscollected. want to know the size and count. A so what is stored indata/data/{date}. Seems there is jpg but also mp4. Exaplin the process. Whatis eachRun these 3 queries in the Query tab:Query 1 - size + row count combined:sqlSELECTd.name,SUM(d.pgsize) / 1024 / 1024 as size_mb,(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +(SELECI COUNT* FROM elements WHERE d.name ='elements' +(SELECT COUNT(*) FROM vi_events WHERE d.name = 'vi_events') +(SELECT COUNT(*) FROM video_chunks WHERE d. name = 'video_chunks') +(SELECT COUNT(*) FROM audio_chunks WHERE d. name = 'audio_chunks') +(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions')(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +(SELECT COUNT(*) FROM tags WHERE d. name = 'tags') +(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_couFROM dbstat dWHERE d. name IN ('frames', 'ocr_text', 'elements', 'vi_events','video_chunks', 'audio_chunksWed 15 Apr 15:16:27Reply...+Sonnet 46claude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24336
|
|
24335
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→CSearch Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 44 mMem...1,15 GB961,2 MB941,3 MB842,1 MB772,7 MB747,6 MB549,4 MB544,3 MB542,6 MB496,0 MB450,7 MB424,1 MB419,8 MB392,5 MB385,5 MB381,0 MB372,1 MB343,7 MB326,1 MB325,1 MB321,5 MB289,4 MB257,8 MB238,2 MB219,2 MB212,4 MB197,9 MB192,4 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <478Wed 15 Apr 15:16:21CPUMemoryDiskThreads21257484325302725241526232625242315132016282618272560EnergyPorts19 5481247311 20119 764125245253128122185125122124125122121172723132191261 791123317127124734PID40742974801414664842420308019146733671335480418633583135276436524301636898481732654850910114860519358334878561388534048298742956049116,00 GB13,42 GB <2,55 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,35 GB2,41 GB6,11 GB...
|
NULL
|
NULL
|
NULL
|
24335
|
|
24334
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5", 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam— New |aomenoe c ne crmuiar vomiualieIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_audio_transcriptions_.elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pgChatCoworkhohlCode& Sprint Review - in 44m100% C"8Wed 15 Apr 15:16:21•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ...Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niormaron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaraver issue troublesnootingLukas KovalikPro nianLinux SQLite Ul for NAS vlets run queries again I want to know what tables are used what data iscollected. want to now the size and count. A so what is stored indata/data/{date}. Seems there is jpg but also mp4. Exaplin the process. Whatis eachReply...+sonner4 vClaude is Al and can make mistakes. Please double-check responses....
|
NULL
|
NULL
|
NULL
|
24334
|
|
24333
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→CSearch Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 44 mMem...1,15 GB961,2 MB941,3 MB842,1 MB772,7 MB747,6 MB549,4 MB544,3 MB542,6 MB496,0 MB450,7 MB424,1 MB419,8 MB392,5 MB385,5 MB381,0 MB372,1 MB343,7 MB326,1 MB325,1 MB321,5 MB289,4 MB257,8 MB238,2 MB219,2 MB212,4 MB197,9 MB192,4 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <478Wed 15 Apr 15:16:18CPUMemoryDiskThreads21257484325302725241526232625242315132016282618272560EnergyPorts19 5481247311 20119 764125245253128122185125122124125122121172723132191261 791123317127124734PID40742974801414664842420308019146733671335480418633583135276436524301636898481732654850910114860519358334878561388534048298742956049116,00 GB13,40 GB<2,54 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,42 GB2,35 GB6,08 GB...
|
NULL
|
NULL
|
NULL
|
24333
|
|
24332
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→CSearch Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 44 mMem...1,15 GB961,2 MB941,7 MB842,1 MB772,7 MB747,6 MB549,6 MB544,3 MB542,6 MB496,0 MB450,6 MB424,1 MB419,0 MB392,5 MB385,5 MB381,0 MB372,1 MB343,7 MB326,1 MB325,6 MB320,8 MB289,4 MB257,1 MB238,2 MB219,0 MB212,4 MB197,9 MB192,2 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <478Wed 15 Apr 15:16:15CPUMemoryDiskThreads22257484325302625241526232725242315132116282618272560EnergyPorts19 5481247311 20119 764125243251128122185125122126125122121172723282191261 791123315127124732PID40742974801414664842420308019146733671335480418633583135276436524301636898481732654850910114860519358334878561388534048298742956049116,00 GB13,40 GB2,55 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,45 GB2,33 GB6,07 GB...
|
NULL
|
NULL
|
NULL
|
24332
|
|
24331
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5", 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam— New |aomenoe c ne crmmial vommmialleIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_..audio_transcriptions_…audio_transcriptions_.elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pg, 0ChatCoworklablCode#Sprint Review - in 44m100% C•Wed 15 Apr 15:16:11•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niormaron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaraver issue troublesnootingLukas KovalikPro nianLinux SQLite Ul for NAS vframes_fts_content is not here. Lets make the data againYou're right, the size query grouped by name includes index entries separately. Use theQuery tab in sqlite-web and run this — it will give clean per-table sizes only, no indexes:sqlSELECTWlallie,SUM(pgsize) / 1024 / 1024 as size_mbFROM dbstatWHERE name IN ('frames', 'ocr_text', 'elements', 'ui_events','video_chunks', 'audio_chunks', 'audio_transcriptions','memories', 'meetings', 'tags', 'vision_tags', 'audio_tags','speakers', 'speaker _embeddings', 'pipe_executions','frames_fts_data', 'frames_fts_content','elements_fts_data', 'audio_transcriptions_fts_data','memories_fts_data', 'ui_events_fts_data'GROUP BY nameORDER BY SUM(pgsize) DESC;And then also run this to get the actual schema for all real tables at once:sqlSELECT name, sqlFROM sqlite_masterWHERE type='table'AND name NOT LIKE"%_fts%'AND name NOT LIKE'sqlite_%'AND name NOT LIKE_sqlx%'ORDER BY name;Paste both outputs and I'll give you the full breakdown with proper explanations per table.lets run queries again I want to know what tables are used what data is collected. I want to knowthe size, and count. Also what is stored in data/data/{date}. Seems there is jpg but also mp4.Exapl+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24331
|
|
24330
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→CSearch Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 44 mMem...1,15 GB961,2 MB941,6 MB842,1 MB772,7 MB747,6 MB549,4 MB544,3 MB542,6 MB496,0 MB450,6 MB424,1 MB418,6 MB392,5 MB385,5 MB381,0 MB372,1 MB343,7 MB326,1 MB325,5 MB316,6 MB290,4 MB257,1 MB238,2 MB218,6 MB212,4 MB198,1 MB192,1 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <47Wed 15 Apr 15:16:06CPUMemoryDiskThreads21257484325302625241526232725242315132116282618272560EnergyPorts19 5371247301 20219 764124245251128122185125122126125122121172723282191261 791123313127124732PID40742974801414664842420308019146733671335480418633583135276436524301636898481732654850910114860519358334878561388534048298742956049116,00 GB13,42 GB <2,54 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,43 GB2,37 GB6,06 GB...
|
NULL
|
NULL
|
NULL
|
24330
|
|
24329
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→CSearch Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 44 mMem...1,15 GB961,2 MB941,7 MB842,2 MB772,8 MB747,8 MB549,6 MB544,3 MB542,6 MB496,0 MB450,6 MB424,6 MB418,1 MB392,5 MB385,5 MB380,9 MB372,1 MB347,2 MB326,1 MB325,4 MB315,4 MB290,4 MB262,3 MB238,1 MB218,5 MB212,4 MB197,8 MB191,9 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <478Wed 15 Apr 15:16:03CPUMemoryDiskThreads2126768525302725241526242726242315132116272618282560EnergyPorts19 5401267341 20419 768125243254128122185125124126127122121172723282161241 794123311129124730PID40742974801414664842420308019146733671335480418633583135276436524301636898481732654850910114860519358334878561388534048298742956049116,00 GB13,43 GB2,56 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,41 GB2,35 GB6,10 GB...
|
NULL
|
NULL
|
NULL
|
24329
|
|
24328
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam— New |aomenoe c ne crmmial vommmialleIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_.elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pg, 0ChatCoworklablCodeSprint Review • in 45m100% C•Wed 15 Apr 15:15:40•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter APl ...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niormaron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaravel issue troubleshootingLukas KovalikPro nianLinux SQLite Ul for NAS vframes_fts_content is not here. Lets make the data againYou're right, the size query grouped by name includes index entries separately. Use theQuery tab in sqlite-web and run this — it will give clean per-table sizes only, no indexes:sqlSELECTWlallie,SUM(pgsize) / 1024 / 1024 as size_mbFROM dbstatWHERE name IN ('frames', 'ocr_text', 'elements', 'ui_events','video_chunks','audio_chunks','audio_transcriptions','memories', 'meetings', 'tags', 'vision_tags', 'audio_tags','speakers', 'speaker _embeddings', 'pipe_executions','frames_fts_data', 'frames_fts_content','elements_fts_data', 'audio_transcriptions_fts_data','memories_fts_data', 'ui_events_fts_data'GROUP BY nameORDER BY SUM(pgsize) DESC;And then also run this to get the actual schema for all real tables at once:sqlSELECT name, sqlFROM sqlite masterWHERE type='table'AND name NOT LIKE"%_fts%'AND name NOT LIKE'sqlite_%'AND name NOT LIKE_sqlx%'ORDER BY name;Paste both outputs and I'll give you the full breakdown with proper explanations per table.lets run queries again I want to know what tables are used what data is collected. I want to knowthe size, and count. Also what is stored in data/data/{date}.|+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24328
|
|
24327
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 45 mA100% <47Wed 15 Apr 15:15:36CPUMemoryDiskMem...Threads1,15 GB961,2 MB941,4 MB842,1 MB772,7 MB747,9 MB549,4 MB544,3 MB542,6 MB496,0 MB450,7 MB423,8 MB415,3 MB392,3 MB385,5 MB380,9 MB372,1 MB347,2 MB326,1 MB323,9 MB315,8 MB291,3 MB258,1 MB238,0 MB217,6 MB212,4 MB197,7 MB192,4 MB20267384325302724231525252626232215132015272718282459EnergyPorts19 5301267301 20119 766125245254126120186123125124127120119172723132141241 792125299129122729PID407429748014146648424203080191467336713354804186335831352764365243016368984817326548509101148605193583348785613885340482987429560491Physical Memory:Memory Used:Cached Files:Swap Used:16,00 GB13,39 GB<2,56 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,43 GB2,35 GB6,06 GB...
|
NULL
|
NULL
|
NULL
|
24327
|
|
24326
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+Aa(allSprint Review - in 45 mA100% <47Activity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeWed 15 Apr 15:15:33CPUMemoryDiskMem...1,15 GB961,2 MB941,4 MB842,0 MB772,7 MB747,9 MB549,4 MB544,3 MB542,6 MB496,0 MB450,7 MB423,8 MB414,8 MB392,2 MB385,4 MB380,9 MB372,1 MB347,2 MB326,1 MB323,9 MB315,8 MB292,6 MB257,9 MB238,0 MB217,9 MB211,7 MB197,7 MB192,4 MBThreads20257384325302624231525252626232215132015282718272459MEMORY PRESSUREEnergyPorts19 5311247301 20119 766125245251126120186123124124127120119172723132141261 792125297127122729PID407429748014146648424203080191467336713354804186335831352764365243016368984817326548509101148605193583348785613885340482987429560491Physical Memory:Memory Used:Cached Files:Swap Used:16,00 GB13,41 GB <2,54 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,65 GB2,33 GB5,88 GB...
|
NULL
|
NULL
|
NULL
|
24326
|
|
24325
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 45 mA100% <47Wed 15 Apr 15:15:18CPUMemoryDiskMem...Threads1,15 GB961,2 MB941,5 MB842,1 MB772,8 MB748,0 MB549,4 MB544,3 MB542,6 MB496,0 MB451,3 MB423,8 MB414,3 MB392,1 MB385,4 MB380,9 MB372,1 MB347,2 MB326,1 MB324,2 MB315,9 MB288,5 MB257,9 MB237,9 MB217,4 MB211,7 MB197,4 MB192,4 MB1925748525292625241526232626242215132015282618272460EnergyPorts19 5301247321 20219 769125241251128122186125122124127122119172723132141261 799123293127122731PID407429748014146648424203080191467336713354804186335831352764365243016368984817326548509101148605193583348785613885340482987429560491Physical Memory:Memory Used:Cached Files:Swap Used:16,00 GB13,39 GB<2,55 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,55 GB2,35 GB5,94 GB...
|
NULL
|
NULL
|
NULL
|
24325
|
|
24324
|
+SlackFileEditViewGoEDHomeDMsActivityFilesLater..• +SlackFileEditViewGoEDHomeDMsActivityFilesLater..•More+→Jiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...HistoryWindowHelpSearch Jiminny Inc# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+Aa(allSprint Review - in 45 mA100% <47Activity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeWed 15 Apr 15:15:15CPUMemoryDiskMem...1,15 GB961,2 MB941,4 MB842,1 MB772,7 MB748,0 MB549,4 MB544,3 MB542,6 MB495,9 MB462,2 MB423,8 MB414,1 MB392,1 MB385,4 MB380,9 MB372,1 MB347,2 MB326,1 MB324,6 MB315,9 MB288,5 MB257,9 MB237,9 MB217,2 MB211,7 MB197,3 MB192,3 MBThreads21257384325302725241626232725242315132115282618272559MEMORY PRESSUREEnergyPorts19 5331247291 20019 764125244254128122199125122126125122121172723282141261 795123291127124729PID407429748014146648424203080191467336713354804186335831352764365243016368984817326548509101148605193583348785613885340482987429560491Physical Memory:Memory Used:Cached Files:Swap Used:16,00 GB13,37 GB <2,54 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,47 GB2,32 GB6,02 GB...
|
NULL
|
NULL
|
NULL
|
24324
|
|
24323
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam— New |aomenoe c ne crmmial vommmialleIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_.elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pg, 0ChatCoworklablCodeSprint Review • in 45m100% C•Wed 15 Apr 15:15:10•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter APl ...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niormaron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaravel issue troubleshootingLukas KovalikPro nianLinux SQLite Ul for NAS vframes_fts_content is not here. Lets make the data againYou're right, the size query grouped by name includes index entries separately. Use theQuery tab in sqlite-web and run this — it will give clean per-table sizes only, no indexes:sqlSELECTWlallie,SUM(pgsize) / 1024 / 1024 as size_mbFROM dbstatWHERE name IN ('frames', 'ocr_text', 'elements', 'ui_events','video_chunks','audio_chunks','audio_transcriptions','memories', 'meetings', 'tags', 'vision_tags', 'audio_tags','speakers', 'speaker _embeddings', 'pipe_executions','frames_fts_data', 'frames_fts_content','elements_fts_data', 'audio_transcriptions_fts_data','memories_fts_data', 'ui_events_fts_data'GROUP BY nameORDER BY SUM(pgsize) DESC;And then also run this to get the actual schema for all real tables at once:sqlSELECT name, sqlFROM sqlite masterWHERE type='table'AND name NOT LIKE"%_fts%'AND name NOT LIKE'sqlite_%'AND name NOT LIKE_sqlx%'ORDER BY name;Paste both outputs and I'll give you the full breakdown with proper explanations per table.lets run queries again I want to know what tables are used what data is collected. I want to knowthe size, and count. Also what is stored in data/data/{date}.|+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24323
|
|
24322
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+AaActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMEMORY PRESSURESprint Review - in 45 mMem...1,15 GB961,2 MB941,3 MB842,0 MB772,7 MB748,0 MB549,3 MB544,3 MB542,6 MB495,9 MB462,2 MB423,8 MB414,0 MB392,1 MB385,4 MB380,9 MB372,1 MB347,2 MB326,1 MB324,5 MB315,9 MB288,6 MB257,9 MB237,9 MB216,8 MB211,7 MB197,3 MB192,3 MBPhysical Memory:Memory Used:Cached Files:Swap Used:100% <47Wed 15 Apr 15:15:08CPUMemoryDiskThreads20257384325292625241626232725242315132115282618272559EnergyPorts19 5341247291 20019 764125242250128122199125122126125122121172723282141261 794123289127124729PID40742974801414664842420308019146733671335480418633583135276436524301636898481732654850910114860519358334878561388534048298742956049116,00 GB13,40 GB<2,54 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,51 GB2,35 GB5,99 GB...
|
NULL
|
NULL
|
NULL
|
24322
|
|
24321
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→CSearch Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+Aa(allSprint Review - in 45 mActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)Notion Calendar Helper (GPU)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentMem...1,15 GB961,2 MB941,3 MB842,0 MB772,7 MB747,9 MB549,3 MB544,3 MB542,6 MB495,9 MB462,1 MB423,8 MB413,9 MB392,0 MB385,4 MB380,9 MB372,1 MB347,4 MB326,1 MB324,4 MB315,9 MB288,6 MB258,2 MB237,8 MB217,6 MB211,9 MB211,7 MB197,3 MBMEMORY PRESSUREPhysical Memory:Memory Used:Cached Files:Swap Used:100% <47Wed 15 Apr 15:15:05CPUMemoryDiskThreads20257384325302625241626232725242315132115272618142725EnergyPorts19 5311247291 20019 764124245250128122199125122126125122121175723282141241 794123287172127124PID40742974801414664842420308019146733671335480418633583135276436524301636898481732654850910114860519358334878561388534026534482987429516,00 GB13,39 GB2,53 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,54 GB2,33 GB5,97 GB...
|
NULL
|
NULL
|
NULL
|
24321
|
|
24320
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+Aa(all• Support Daily • 1 m leftActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMem...1,15 GB961,2 MB941,3 MB842,0 MB772,7 MB747,9 MB549,4 MB544,3 MB542,6 MB495,9 MB462,1 MB423,9 MB417,2 MB392,0 MB385,4 MB380,9 MB372,1 MB346,6 MB326,1 MB324,4 MB315,9 MB288,6 MB258,1 MB237,8 MB217,3 MB211,7 MB197,6 MB192,3 MBMEMORY PRESSUREPhysical Memory:Memory Used:Cached Files:Swap Used:100% C7Wed 15 Apr 15:14:56CPUMemoryDiskThreads20267384325292724241626242725242315132115272618282559EnergyPorts19 5291267291 20019 764125242253126122199125124126125122121172723282141241 795123285129124729PID40742974801414664842420308019146733671335480418633583135276436524301636898481732654850910114860519358334878561388534048298742956049116,00 GB13,41 GB2,53 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,58 GB2,36 GB5,92 GB...
|
NULL
|
NULL
|
NULL
|
24320
|
|
24319
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+Aa(all• Support Daily • 1 m leftActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMem...1,16 GB961,2 MB941,3 MB842,0 MB772,7 MB747,7 MB549,4 MB544,3 MB542,6 MB495,9 MB462,1 MB450,8 MB423,9 MB391,9 MB385,4 MB380,9 MB372,1 MB346,6 MB326,1 MB324,3 MB315,9 MB288,6 MB258,1 MB237,8 MB217,0 MB211,7 MB197,6 MB192,3 MBMEMORY PRESSUREPhysical Memory:Memory Used:Cached Files:Swap Used:100% C7Wed 15 Apr 15:14:53CPUMemoryDiskThreads20267484325302624241624262725232315132115272618282559EnergyPorts19 5321267301 20019 764125245251126122199124124126125120121172723282141241 794123283129124729PID40742974801414664842420308019146733671335480418633527635831436524301636898481732654850910114860519358334878561388534048298742956049116,00 GB13,42 GB <2,53 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,61 GB2,33 GB5,93 GB...
|
NULL
|
NULL
|
NULL
|
24319
|
|
24318
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam- New laomenoe c ne crmmial vommmialleIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_.elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pgChatCoworkloblCodeSupport Daily • 1m left100% C4"Wed 15 Apr 15:14:39•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter APl ...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niormaron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaravel issue troubleshootingLukas KovalikPro nianLinux SQLite Ul for NAS vframes_fts_content is not here. Lets make the data againYou're right, the size query grouped by name includes index entries separately. Use theQuery tab in sqlite-web and run this — it will give clean per-table sizes only, no indexes:sqlSELECTWlallie,SUM(pgsize) / 1024 / 1024 as size_mbFROM dbstatWHERE name IN ('frames', 'ocr_text', 'elements', 'ui_events','video_chunks','audio_chunks','audio_transcriptions','memories', 'meetings', 'tags', 'vision_tags', 'audio_tags','speakers', 'speaker _embeddings', 'pipe_executions','frames_fts_data', 'frames_fts_content','elements_fts_data', 'audio_transcriptions_fts_data','memories_fts_data', 'ui_events_fts_data'GROUP BY nameORDER BY SUM(pgsize) DESC;And then also run this to get the actual schema for all real tables at once:sqlSELECT name, sqlFROM sqlite_masterWHERE type='table'AND name NOT LIKE"%_fts%'AND name NOT LIKE'sqlite_%'AND name NOT LIKE_sqlx%'ORDER BY name;Paste both outputs and I'll give you the full breakdown with proper explanations per table.lets run queries again I want to know what tables are used what data is collected. I want to knowthe size, and count. Also what is stored in data/data/{date}.+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24318
|
|
24317
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVesGalya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+Aa(all• Support Daily • 1 m leftActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMem...1,15 GB961,2 MB941,4 MB842,0 MB772,7 MB747,7 MB549,4 MB544,3 MB542,6 MB495,9 MB460,6 MB446,3 MB423,8 MB391,8 МB385,4 MB380,9 MB372,1 MB346,6 MB326,1 MB323,0 MB315,9 MB287,6 MB258,4 MB237,8 MB217,1 MB211,7 MB197,4 MB192,3 MBMEMORY PRESSUREPhysical Memory:Memory Used:Cached Files:Swap Used:100% C7Wed 15 Apr 15:14:35CPUMemoryDiskThreads21267584325302624241524262626232215132015272718282459EnergyPorts19 5341267321 20019 764125245250126122184124124124127120119172723132141241 795125277129122729PID40742974801414664842420308019146733671335480418633527635831436524301636898481732654850910114860519358334878561388534048298742956049116,00 GB13,43 GB<2,53 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,61 GB2,33 GB5,93 GB...
|
NULL
|
NULL
|
NULL
|
24317
|
|
24316
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVesGalya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+Aa(all• Support Daily • 1 m leftActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMem...1,16 GB961,1 MB941,7 MB841,9 MB772,7 MB747,8 MB549,4 MB544,3 MB542,6 MB495,9 MB459,1 MB446,2 MB423,8 MB391,7 MB385,4 MB380,9 MB372,1 MB346,6 MB326,1 MB323,6 MB316,1 MB288,1 MB258,2 MB237,8 MB216,1 MB211,6 MB197,2 MB193,2 MBMEMORY PRESSUREPhysical Memory:Memory Used:Cached Files:Swap Used:100% C7Wed 15 Apr 15:14:23CPUMemoryDiskNetworkThreads19257485325302725241523262626242215132016282718272459EnergyPorts19 5331247311 20119 764125242254128122184122125124127122119172723132161261 794125271127122729PID40742974801414664842420308019146733671335480418633527635831436524301636898481732654850910114860519358334878561388534048298742956049116,00 GB13,44 GB <2,51 GB2,78 GBApp Memory:Wired Memory:Compressed:User_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,68 GB2,33 GB5,88 GB...
|
NULL
|
NULL
|
NULL
|
24316
|
|
24315
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVesGalya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+Aa(all• Support Daily • 1 m leftActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMem...1,16 GB961,1 MB941,7 MB841,9 MB772,7 MB747,8 MB549,4 MB544,3 MB542,6 MB495,9 MB459,1 MB446,1 MB423,8 MB391,6 MB385,4 MB380,9 MB372,1 MB346,6 MB326,1 MB324,0 MB316,1 MB288,1 MB258,2 MB237,7 MB216,0 MB211,6 MB197,2 MB193,1 MBMEMORY PRESSUREPhysical Memory:Memory Used:Cached Files:Swap Used:100% C7Wed 15 Apr 15:14:14CPUMemoryDiskThreads20257485325292625241523262625242315132116282618272559EnergyPorts19 5381247311 20119 764125242250128122184122125124125122121172723282161261 794123269127124729PID40742974801414664842420308019146733671335480418633527635831436524301636898481732654850910114860519358334878561388534048298742956049116,00 GB13,41 GB<2,52 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,55 GB2,35 GB5,96 GB...
|
NULL
|
NULL
|
NULL
|
24315
|
|
24314
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVesGalya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+Aa(all• Support Daily • 1 m leftActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMem...1,16 GB961,1 MB941,8 MB841,9 MB772,7 MB747,8 MB549,4 MB544,3 MB542,6 MB495,8 MB459,6 MB443,7 MB423,8 MB391,6 MB385,4 MB380,9 MB372,1 MB346,6 MB326,1 MB323,9 MB316,1 MB288,0 MB258,1 MB237,7 MB215,5 MB211,6 MB197,1 MB193,1 MBMEMORY PRESSUREPhysical Memory:Memory Used:Cached Files:Swap Used:100% C7Wed 15 Apr 15:14:11CPUMemoryDiskThreads19257485325302625241523262725242315132116282618272559EnergyPorts19 5341247311 20119 764125245250128122184122125126125122121172723282161261 794123265127124729PID40742974801414664842420308019146733671335480418633527635831436524301636898481732654850910114860519358334878561388534048298742956049116,00 GB13,43 GB <2,51 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,63 GB2,29 GB5,96 GB...
|
NULL
|
NULL
|
NULL
|
24314
|
|
24313
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam— New |aomenoe c ne crmmial vommmialleIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_.elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pgChatCoworkloblCodeSupport Daily • 1m left100% C4"Wed 15 Apr 15:14:09•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter APl ...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niormaron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaravel issue troubleshootingLukas KovalikPro nianLinux SQLite Ul for NAS vframes_fts_content is not here. Lets make the data againYou're right, the size query grouped by name includes index entries separately. Use theQuery tab in sqlite-web and run this — it will give clean per-table sizes only, no indexes:sqlSELECTWlallie,SUM(pgsize) / 1024 / 1024 as size_mbFROM dbstatWHERE name IN ('frames', 'ocr_text', 'elements', 'ui_events','video_chunks','audio_chunks','audio_transcriptions','memories', 'meetings', 'tags', 'vision_tags', 'audio_tags','speakers', 'speaker _embeddings', 'pipe_executions','frames_fts_data', 'frames_fts_content','elements_fts_data', 'audio_transcriptions_fts_data','memories_fts_data', 'ui_events_fts_data'GROUP BY nameORDER BY SUM(pgsize) DESC;And then also run this to get the actual schema for all real tables at once:sqlSELECT name, sqlFROM sqlite masterWHERE type='table'AND name NOT LIKE"%_fts%'AND name NOT LIKE'sqlite_%'AND name NOT LIKE_sqlx%'ORDER BY name;Paste both outputs and I'll give you the full breakdown with proper explanations per table.lets run queries again I want to know what tables are used what data is collected. I want to knowthe size, and count. Also what is stored in data/data/{date}.|+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24313
|
|
24312
|
+SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActi +SlackFileEditViewGoHistoryWindowHelpEDHomeDMsActivityFilesLater..•More+→Search Jiminny IncJiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVes®. Galya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+Aa(all• Support Daily • 1 m leftActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMem...1,16 GB961,1 MB941,8 MB841,9 MB772,7 MB747,8 MB549,4 MB544,3 MB542,6 MB495,8 MB459,6 MB443,7 MB423,8 MB391,6 MB385,4 MB380,9 MB372,1 MB346,6 MB326,1 MB323,9 MB316,1 MB288,0 MB258,1 MB237,7 MB215,5 MB211,6 MB197,1 MB193,1 MBMEMORY PRESSUREPhysical Memory:Memory Used:Cached Files:Swap Used:100% C7Wed 15 Apr 15:14:08CPUMemoryDiskThreads1925748525302625241523262725242315132116282618272559EnergyPorts19 5341247311 20119 764125245250128122184122125126125122121172723282161261 794123265127124729PID40742974801414664842420308019146733671335480418633527635831436524301636898481732654850910114860519358334878561388534048298742956049116,00 GB13,41 GB<2,51 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,52 GB2,32 GB6,03 GB...
|
NULL
|
NULL
|
NULL
|
24312
|
|
24311
|
+SlackFileEditViewGoEDHomeDMsActivityFilesLater..• +SlackFileEditViewGoEDHomeDMsActivityFilesLater..•More+→Jiminny ...+# general# infra-changes# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...Direct messagesStoyan TanevVesGalya DimitrovaAneliya Angelova, ...Vasil VasilevSteliyan GeorgievAdelina Petrova, Ili...P. Adelina PetrovaD. Nikolay Nikolov2 Galya Dimitrova, Ni...ii: AppsJira CloudToastGoogle Cale...HistoryWindowHelpSearch Jiminny Inc# platform-tickets8 146 0MessagesAdd canvasO FilesHubSpot -ised withMonday, April 6thPlatform ttaur anu asaigricu tu Stoyan Tomov.The Priority is P2 MediumWednesday, April 8th~Automation for Jira APP12:02 PMSRD-6775 Jiminny creates duplicate event inHubspot has been raised with Platform teamand assigned to Stoyan Tomov. The Priority isP2 MediumThursday, April 9th~Automation for Jira APP11:22 AMSRD-6779 Unable to log in to Sidekick hasbeen raised with Platform team and assigned to**. The Priority is P2 MediumAutomation for Jira APP2:32 PMSRD-6780 Jiminny Voice issue has been raisedwith Platform team and assigned to **. ThePriority is **Today ~NewAutomation for Jira APP 2:56 PMSRD-6789 [Team insights] Filter gets resetautomatically has been raised with Platformteam and assigned to **. The Priority is **Message #platform-tickets+Aa(all• Support Daily • 1 m leftActivity MonitorAll ProcessesProcess NameWindowServerFirefoxCP Isolated Web ContentFirefoxFirefoxCursorUlViewService (Not Responding)FirefoxCP Isolated Web ContentFirefox GPU HelperFirefox GPU HelperFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentSlack Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentNotion Calendar Helper (Renderer)claudeNotion Helper (Renderer)Claude Helper (Renderer)FirefoxCP Isolated Web ContentiTerm2FirefoxCP Isolated Web ContentCode Helper (Renderer)FirefoxCP Isolated Web ContentFirefoxCP Isolated Web ContentClaudeMem...1,16 GB961,1 MB941,8 MB841,9 MB772,7 MB747,8 MB549,4 MB544,3 MB542,6 MB495,8 MB459,6 MB442,9 MB423,8 MB391,6 MB385,3 MB380,9 MB372,1 MB346,6 MB326,1 MB323,8 MB316,4 MB288,0 MB258,1 MB237,7 MB215,1 MB211,6 MB197,1 MB193,2 MBMEMORY PRESSUREPhysical Memory:Memory Used:Cached Files:Swap Used:100% C7Wed 15 Apr 15:14:05CPUMemoryDiskThreads2125748525292725241523262725242315132116282618272560EnergyPorts19 5401247311 20119 764124241253128122184122125126125122121172723282161261 794123263127124730PID40742974801414664842420308019146733671335480418633527635831436524301636898481732654850910114860519358334878561388534048298742956049116,00 GB13,44 GB <2,51 GB2,78 GBApp Memory:Wired Memory:Compressed:NetworkUser_windowserverlukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukaslukas4,62 GB2,28 GB5,99 GB...
|
NULL
|
NULL
|
NULL
|
24311
|