|
sqlite3 ~/.screenpipe/db.sqlite ".schema meeti sqlite3 ~/.screenpipe/db.sqlite ".schema meetings"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite ".schema meeti sqlite3 ~/.screenpipe/db.sqlite ".schema meetings"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite ".schema meeti sqlite3 ~/.screenpipe/db.sqlite ".schema meetings"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite ".schema meeti sqlite3 ~/.screenpipe/db.sqlite ".schema meetings"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite ".schema frame sqlite3 ~/.screenpipe/db.sqlite ".schema frames"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT name, sqlite3 ~/.screenpipe/db.sqlite "
SELECT name, SUM(payload) as bytes, COUNT(*) as pages
FROM dbstat WHERE name IN ('frames','elements','ui_events','ocr_text')
GROUP BY name;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT name, sqlite3 ~/.screenpipe/db.sqlite "
SELECT name, SUM(payload) as bytes, COUNT(*) as pages
FROM dbstat WHERE name IN ('frames','elements','ui_events','ocr_text')
GROUP BY name;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT name, sqlite3 ~/.screenpipe/db.sqlite "
SELECT name, SUM(payload) as bytes
FROM dbstat
WHERE name IN ('elements_fts_data','frames_fts_data','ui_events_fts_data')
GROUP BY name;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT name sqlite3 ~/.screenpipe/db.sqlite "
SELECT name FROM sqlite_master WHERE type='table'
ORDER BY name;" | while read t; do
count=$(sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) FROM $t;")
echo "$t: $count"
done...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT app_n sqlite3 ~/.screenpipe/db.sqlite "
SELECT app_name, COUNT(*) as frames
FROM frames
GROUP BY app_name
ORDER BY frames DESC
LIMIT 15;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT app_n sqlite3 ~/.screenpipe/db.sqlite "
SELECT app_name, COUNT(*) as frames
FROM frames
GROUP BY app_name
ORDER BY frames DESC
LIMIT 15;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT app_n sqlite3 ~/.screenpipe/db.sqlite "
SELECT app_name, COUNT(*) as frames
FROM frames
GROUP BY app_name
ORDER BY frames DESC
LIMIT 15;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT MIN(t sqlite3 ~/.screenpipe/db.sqlite "
SELECT MIN(timestamp) FROM frames;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT MIN(t sqlite3 ~/.screenpipe/db.sqlite "
SELECT MIN(timestamp) FROM frames;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT MIN(t sqlite3 ~/.screenpipe/db.sqlite "
SELECT MIN(timestamp) FROM frames;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT ' sqlite3 ~/.screenpipe/db.sqlite "
SELECT 'frames', COUNT(*) FROM frames
UNION ALL SELECT 'elements', COUNT(*) FROM elements
UNION ALL SELECT 'ui_events', COUNT(*) FROM ui_events
UNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_text;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT ' sqlite3 ~/.screenpipe/db.sqlite "
SELECT 'frames', COUNT(*) FROM frames
UNION ALL SELECT 'elements', COUNT(*) FROM elements
UNION ALL SELECT 'ui_events', COUNT(*) FROM ui_events
UNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_text;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT ' sqlite3 ~/.screenpipe/db.sqlite "
SELECT 'frames', COUNT(*) FROM frames
UNION ALL SELECT 'elements', COUNT(*) FROM elements
UNION ALL SELECT 'ui_events', COUNT(*) FROM ui_events
UNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_text;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
f. sqlite3 ~/.screenpipe/db.sqlite "
SELECT
f.app_name,
COUNT(*) as rows,
AVG(LENGTH(o.text)) as avg_text_len,
SUM(LENGTH(o.text))/1024/1024 as total_mb
FROM ocr_text o
JOIN frames f ON o.frame_id = f.id
GROUP BY f.app_name
ORDER BY total_mb DESC
LIMIT 15;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
ap sqlite3 ~/.screenpipe/db.sqlite "
SELECT
app_name,
COUNT(*) as rows,
AVG(LENGTH(text)) as avg_text_len,
SUM(LENGTH(text))/1024/1024 as total_mb
FROM ocr_text
JOIN frames ON ocr_text.frame_id = frames.id
GROUP BY app_name
ORDER BY total_mb DESC
LIMIT 15;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
ap sqlite3 ~/.screenpipe/db.sqlite "
SELECT
app_name,
COUNT(*) as rows,
AVG(LENGTH(text)) as avg_text_len,
SUM(LENGTH(text))/1024/1024 as total_mb
FROM ocr_text
JOIN frames ON ocr_text.frame_id = frames.id
GROUP BY app_name
ORDER BY total_mb DESC
LIMIT 15;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
ap sqlite3 ~/.screenpipe/db.sqlite "
SELECT
app_name,
COUNT(*) as rows,
AVG(LENGTH(text)) as avg_text_len,
SUM(LENGTH(text))/1024/1024 as total_mb
FROM ocr_text
JOIN frames ON ocr_text.frame_id = frames.id
GROUP BY app_name
ORDER BY total_mb DESC
LIMIT 15;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
ap sqlite3 ~/.screenpipe/db.sqlite "
SELECT
app_name,
COUNT(*) as rows,
AVG(LENGTH(text)) as avg_text_len,
SUM(LENGTH(text))/1024/1024 as total_mb
FROM ocr_text
JOIN frames ON ocr_text.frame_id = frames.id
GROUP BY app_name
ORDER BY total_mb DESC
LIMIT 15;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
(S sqlite3 ~/.screenpipe/db.sqlite "
SELECT
(SELECT COUNT(*) FROM frames) as frames,
(SELECT COUNT(*) FROM ocr_text) as ocr_rows,
(SELECT COUNT(*) FROM ui_monitoring) as ui_rows;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
(S sqlite3 ~/.screenpipe/db.sqlite "
SELECT
(SELECT COUNT(*) FROM frames) as frames,
(SELECT COUNT(*) FROM ocr_text) as ocr_rows,
(SELECT COUNT(*) FROM ui_monitoring) as ui_rows;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
&# sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl, SUM(payload) as bytes FROM dbstat WHERE name = 'frames'
UNION ALL SELECT 'elements', SUM(payload) FROM dbstat WHERE name = 'elements'
UNION ALL SELECT 'ui_events', SUM(payload) FROM dbstat WHERE name = 'ui_events'
UNION ALL SELECT 'ocr_text', SUM(payload) FROM dbstat WHERE name = 'ocr_text';"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
&# sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl, SUM(payload) as bytes FROM dbstat WHERE name = 'frames'
UNION ALL SELECT 'elements', SUM(payload) FROM dbstat WHERE name = 'elements'
UNION ALL SELECT 'ui_events', SUM(payload) FROM dbstat WHERE name = 'ui_events'
UNION ALL SELECT 'ocr_text', SUM(payload) FROM dbstat WHERE name = 'ocr_text';"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
&# sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl, SUM(payload) as bytes FROM dbstat WHERE name = 'frames'
UNION ALL SELECT 'elements', SUM(payload) FROM dbstat WHERE name = 'elements'
UNION ALL SELECT 'ui_events', SUM(payload) FROM dbstat WHERE name = 'ui_events'
UNION ALL SELECT 'ocr_text', SUM(payload) FROM dbstat WHERE name = 'ocr_text';"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
&# sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl, SUM(payload) as bytes FROM dbstat WHERE name = 'frames'
UNION ALL SELECT 'elements', SUM(payload) FROM dbstat WHERE name = 'elements'
UNION ALL SELECT 'ui_events', SUM(payload) FROM dbstat WHERE name = 'ui_events'
UNION ALL SELECT 'ocr_text', SUM(payload) FROM dbstat WHERE name = 'ocr_text';"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
&# sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl, SUM(payload) as bytes FROM dbstat WHERE name = 'frames'
UNION ALL SELECT 'elements', SUM(payload) FROM dbstat WHERE name = 'elements'
UNION ALL SELECT 'ui_events', SUM(payload) FROM dbstat WHERE name = 'ui_events'
UNION ALL SELECT 'ocr_text', SUM(payload) FROM dbstat WHERE name = 'ocr_text';"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
&# sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'elements_fts' as name, COUNT(*) as rows FROM elements_fts
UNION ALL SELECT 'frames_fts', COUNT(*) FROM frames_fts
UNION ALL SELECT 'ui_events_fts', COUNT(*) FROM ui_events_fts
UNION ALL SELECT 'audio_transcriptions_fts', COUNT(*) FROM audio_transcriptions_fts;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
SUM(payload)/COUNT(*),
(SELECT COUNT(*) FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '2026-04-15'))
FROM dbstat d, elements e
WHERE d.name = 'elements'
UNION ALL
SELECT 'ui_events',
COUNT(*),
SUM(payload),
SUM(payload)/COUNT(*),
(SELECT COUNT(*) FROM ui_events WHERE date(timestamp) = '2026-04-15')
FROM dbstat d, ui_events e
WHERE d.name = 'ui_events';"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite
|
NULL
|
NULL
|
NULL
|
|
sqlite3 /volume1/screenpipe/db.sqlite "PRAGMA sqlite3 /volume1/screenpipe/db.sqlite "PRAGMA wal_checkpoint(TRUNCATE);"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 /volume1/screenpipe/db.sqlite "PRAGMA sqlite3 /volume1/screenpipe/db.sqlite "PRAGMA wal_checkpoint(TRUNCATE);"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 /Volumes/screenpipe/archive.db ".table sqlite3 /Volumes/screenpipe/archive.db ".tables"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 /Volumes/screenpipe/archive.db ".table sqlite3 /Volumes/screenpipe/archive.db ".tables"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 "$NAS_DB" "SELECT COUNT(*) || sqlite3 "$NAS_DB" "SELECT COUNT(*) || ' frames in archive' FROM frames;"
...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 "$NAS_DB" "SELECT COUNT(*) || sqlite3 "$NAS_DB" "SELECT COUNT(*) || ' frames in archive' FROM frames;"
...
|
NULL
|
NULL
|
NULL
|
|
sqlite
|
NULL
|
NULL
|
NULL
|
|
sql
|
NULL
|
NULL
|
NULL
|
|
spqh da si
|
NULL
|
NULL
|
NULL
|
|
spot
|
NULL
|
NULL
|
NULL
|
|
spot
|
NULL
|
NULL
|
NULL
|
|
spored men e
|
NULL
|
NULL
|
NULL
|