Skip to content

Instantly share code, notes, and snippets.

View nickmacavoy's full-sized avatar

Nick MacAvoy nickmacavoy

View GitHub Profile
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active July 27, 2024 16:50
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
@djflux
djflux / ds1-audio-dropouts-macos-console.txt
Last active May 8, 2023 14:57
DS1 audio dropout console logs MacBook Pro T2
DS1 audio errors
default 21:07:04.724255-0500 kernel + IOAudioEngine[<private>]::pauseAudioEngine()
default 21:07:04.726351-0500 kernel +-IOAudioEngine[<private>]::setState(0x2. oldState=0x1)
default 21:07:04.726613-0500 kernel + IOAudioStream[<private>]::removeClient(<private>)
error 21:07:04.726641-0500 coreaudiod HALS_IOA1Engine::EndWriting: got an error from the kernel trap, Error: 0xE00002D7
default 21:07:04.726632-0500 kernel +-IOAudioStream[<private>]::safeLogError kErrorLogDumpCounters mStreamErrorCountsUpdated=0
default 21:07:04.726736-0500 Music HALC_ProxyIOContext::IOWorkLoop: skipping cycle due to overload
default 21:07:04.726634-0500 kernel - IOAudioStream[<private>]::removeClient(<private>)
default 21:07:04.726639-0500 kernel +- IOAudioEngine[<private>]::decrementActiveUserClients() - 0 returns 0x0