akramarev

SELECT
    slot_name,
    plugin,
    slot_type,
    active,
    restart_lsn,
    confirmed_flush_lsn,
    pg_wal_lsn_diff(pg_current_wal_lsn(), confirmed_flush_lsn) as lag_size_raw,
    pg_size_pretty(pg_wal_lsn_diff(pg_current_wal_lsn(), confirmed_flush_lsn)) AS lag_size,
    age(xmin) AS xmin_age

akramarev

SELECT
    usename,
    application_name,
    client_addr,
    COUNT(*) as connection_count,
    MIN(backend_start) as first_connection,
    MAX(backend_start) as latest_connection
FROM pg_stat_activity
GROUP BY usename, application_name, client_addr
ORDER BY connection_count DESC;

akramarev

gh pr list --author "@me" --state all --search "created:>=$(date '+%Y-%m-%d')T00:00:00$(date '+%z' | sed 's/\([0-9][0-9]\)$/:\1/')"

akramarev

git commit --amend --reset-author

akramarev

docker ps -q | xargs -L 1 -P `docker ps | wc -l` docker logs --since 30s -f

akramarev

SELECT pg_database.datname,
       pg_database_size(pg_database.datname),
       pg_size_pretty(pg_database_size(pg_database.datname)) AS size
FROM pg_database

akramarev

SELECT
    pid
     ,datname
     ,usename
--      ,application_name
--      ,client_hostname
--      ,client_port
--      ,backend_start
--      ,query_start
     ,query

akramarev

lsof -p 66298

akramarev

-- If SET (or equivalently SET SESSION) is issued within a transaction that is later aborted, the effects of the SET command disappear when the transaction is rolled back. Once the surrounding transaction is committed, the effects will persist until the end of the session, unless overridden by another SET.

SET session_replication_role = 'replica';
...
SET session_replication_role = 'origin';

akramarev

# https://earthly.dev/blog/convert-to-from-json/
cat simple.json| jq -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @csv'