|
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
(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
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
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 ' 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 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 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 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 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, 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 ".schema frame sqlite3 ~/.screenpipe/db.sqlite ".schema frames"...
|
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 meeti sqlite3 ~/.screenpipe/db.sqlite ".schema meetings"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite ".schema ocr_t sqlite3 ~/.screenpipe/db.sqlite ".schema ocr_text"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT * FROM sqlite3 ~/.screenpipe/db.sqlite "SELECT * FROM meetings LIMIT 5;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT * FROM sqlite3 ~/.screenpipe/db.sqlite "SELECT * FROM meetings LIMIT 5;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT * FROM sqlite3 ~/.screenpipe/db.sqlite "SELECT * FROM meetings LIMIT 5;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) FROM frames WHERE app_name = 'Boosteroid' AND timestamp >= '2026-04-16T17:21:45';"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) FROM frames WHERE app_name = 'Boosteroid' AND timestamp >= '2026-04-16T17:21:45';"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) FROM frames WHERE app_name = 'Boosteroid' AND timestamp >= datetime('now', '-1 hour');"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) FROM frames WHERE timestamp >= datetime('now', '-1 day');"
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) FROM ui_events WHERE timestamp >= datetime('now', '-1 day');"
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE timestamp >= datetime('now', '-1 day'));"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) FROM frames;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) FROM ocr_text;"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) || ' elements for ' || '$DATE' FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '$DATE');"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) || ' elements for ' || '$DATE' FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '$DATE');"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) || ' frames for ' || '$DATE' FROM frames WHERE date(timestamp) = '$DATE';"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) || ' frames for ' || '$DATE'"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) || ' frames for ' || '$DATE'"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) || ' frames for ' || '$DATE'"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) || ' meetings for ' || '$DATE' FROM meetings WHERE date(meeting_start) = '$DATE';"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) || ' meetings for ' || '$DATE' FROM meetings WHERE date(meeting_start) = '$DATE';"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) || ' ui_events for ' || '$DATE' FROM ui_events WHERE date(timestamp) = '$DATE';"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*) || ' ui_events for ' || '$DATE' FROM ui_events WHERE date(timestamp) = '$DATE';"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*), MIN(timestamp), MAX(timestamp) FROM frames WHERE app_name = 'Boosteroid' AND timestamp >= date('now', '-1 day');"...
|
NULL
|
NULL
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT( sqlite3 ~/.screenpipe/db.sqlite "SELECT COUNT(*), MIN(timestamp), MAX(timestamp) FROM frames WHERE app_name = 'Boosteroid' AND timestamp >= datetime('now', '-1 hour');"...
|
NULL
|
NULL
|
NULL
|