|
pg
|
NULL
|
NULL
|
NULL
|
|
but
|
NULL
|
NULL
|
NULL
|
|
also
|
NULL
|
NULL
|
NULL
|
|
mp
|
NULL
|
NULL
|
NULL
|
|
4
|
NULL
|
NULL
|
NULL
|
|
.
|
NULL
|
NULL
|
NULL
|
|
Exaplin the process
|
NULL
|
NULL
|
NULL
|
|
.
|
NULL
|
NULL
|
NULL
|
|
Wha
|
NULL
|
NULL
|
NULL
|
|
t
|
NULL
|
NULL
|
NULL
|
|
is each
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as SELECT
d.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 ui_events WHERE d.name = 'ui_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_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks','audio_transcriptions',
'memories','meetings','tags','pipe_executions'
)
GROUP BY d.name......
|
NULL
|
NULL
|
NULL
|
|
SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as SELECT
d.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 ui_events WHERE d.name = 'ui_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_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks','audio_transcriptions',
'memories','meetings','tags','pipe_executions'
)
GROUP BY d.name......
|
NULL
|
NULL
|
NULL
|
|
SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as SELECT
d.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 ui_events WHERE d.name = 'ui_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_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks','audio_transcriptions',
'memories','meetings','tags','pipe_executions'
)
GROUP BY d.name......
|
NULL
|
NULL
|
NULL
|
|
SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as SELECT
d.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 ui_events WHERE d.name = 'ui_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_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks','audio_transcriptions',
'memories','meetings','tags','pipe_executions'
)
GROUP BY d.name......
|
NULL
|
NULL
|
NULL
|
|
K
|
NULL
|
NULL
|
NULL
|
|
SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as SELECT
d.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 ui_events WHERE d.name = 'ui_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_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks','audio_transcriptions',
'memories','meetings','tags','pipe_executions'
)
GROUP BY d.name......
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
SELECT sql FROM sqlite_master
WHERE type='tab SELECT sql FROM sqlite_master
WHERE type='table'
AND name NOT LIKE '%_fts%'
AND name NOT LIKE 'sqlite_%'
AND name NOT LIKE '_sqlx%'
ORDER BY name;...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
SELECT frame_id, app_name, window_name, browser_ur SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screen lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
d.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 ui_events WHERE d.name = 'ui_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_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks',......
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screen lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
d.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 ui_events WHERE d.name = 'ui_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_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks',......
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screen lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
d.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 ui_events WHERE d.name = 'ui_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_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks',......
|
NULL
|
NULL
|
NULL
|
|
clear
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
ls ~/.screenpipe/data/ | head -20
|
NULL
|
NULL
|
NULL
|
|
ls ~/.screenpipe/data/ | head -20
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | h ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30...
|
NULL
|
NULL
|
NULL
|
|
ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | h ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
find ~/.screenpipe/data -name "*.jpg" | wc find ~/.screenpipe/data -name "*.jpg" | wc -l...
|
NULL
|
NULL
|
NULL
|
|
find ~/.screenpipe/data -name "*.jpg" | wc find ~/.screenpipe/data -name "*.jpg" | wc -l...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
find ~/.screenpipe/data -name "*.mp4" | wc find ~/.screenpipe/data -name "*.mp4" | wc -l...
|
NULL
|
NULL
|
NULL
|
|
find ~/.screenpipe/data -name "*.mp4" | wc find ~/.screenpipe/data -name "*.mp4" | wc -l...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
find ~/.screenpipe/data -name "*.jpg" -exe find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1...
|
NULL
|
NULL
|
NULL
|
|
find ~/.screenpipe/data -name "*.jpg" -exe find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -1...
|
NULL
|
NULL
|
NULL
|
|
du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -1...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screen lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -1
2.0M /Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4
lukas@Lukas-Kovaliks-MacBook-Pro-Jimin......
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screen lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -1
2.0M /Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4
lukas@Lukas-Kovaliks-MacBook-Pro-Jimin......
|
NULL
|
NULL
|
NULL
|
|
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
|
NULL
|
NULL
|
NULL
|
|
clear
|
NULL
|
NULL
|
NULL
|