Skip to content

Instantly share code, notes, and snippets.

View vitalsourcemark's full-sized avatar

Mark Franciose vitalsourcemark

View GitHub Profile
@vitalsourcemark
vitalsourcemark / events.jsonl
Created March 17, 2026 22:29
Copilot CLI Session Backup
{"type":"session.start","data":{"sessionId":"e23771e2-ef6a-4485-852e-b1a5a72d90ac","version":1,"producer":"copilot-agent","copilotVersion":"1.0.7","startTime":"2026-03-17T22:23:09.317Z","context":{"cwd":"/Users/mark"},"alreadyInUse":false},"id":"8a39e07e-478f-478e-8788-47d7bdb035cf","timestamp":"2026-03-17T22:23:09.319Z","parentId":null}
{"type":"user.message","data":{"content":"What just happened? Did you create the gist?","transformedContent":"<current_datetime>2026-03-17T22:23:24.624Z</current_datetime>\n\nWhat just happened? Did you create the gist?\n\n<reminder>\n<sql_tables>No tables currently exist. Default tables (todos, todo_deps) will be created automatically when you first use the SQL tool.</sql_tables>\n</reminder>","attachments":[],"interactionId":"fb80f29c-eedb-4053-87ec-53775a6577f3"},"id":"9f72f81b-76fc-4e60-9922-fd51e9ef7cd3","timestamp":"2026-03-17T22:23:24.624Z","parentId":"42ae2878-f042-491d-b3c5-24321831a282"}
{"type":"assistant.turn_start","data":{"turnId":"0","interactionId":"fb80f29c-e
@vitalsourcemark
vitalsourcemark / naughty_query.sql
Last active January 18, 2024 18:39
Get long running queries
SELECT
pid,
now() - pg_stat_activity.query_start AS duration,
query,
state
FROM pg_stat_activity
WHERE (now() - pg_stat_activity.query_start) > interval '2 minutes'; # change this guy for different intervals