andreyshuster

SELECT
  pid,
  now() - pg_stat_activity.query_start AS duration,
  query,
  state
FROM pg_stat_activity
WHERE query like '%<condition>%' AND (now() - pg_stat_activity.query_start) > interval '5 minutes';

andreyshuster

There is two commands to kill query Soft kill: pg_cancel_backend(pid) Hard kill pg_terminate_backend(pid)

SELECT
	pg_terminate_backend(pid)
FROM
	pg_stat_activity
WHERE

andreyshuster

#!/usr/bin/env python

import os
from shutil import move

translation_table = {
    "А": "A",
    "а": "a",
    "Б": "B",
    "б": "b",

andreyshuster

# delete first echo for real results
for file in *; do echo mv "$file" "$(echo $file | sed 's/ - /_/g ; s/ /-/g')" ; done