Kullanisli Postgresql Sorgulari

postgresql.md

https://gist.github.com/rgreenjr/3637525

5DK'dan fazla zamandir calisan queryleri bulma:

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

Postgresql PID'ini cancel etme ve öldürme:

SELECT pg_cancel_backend(__pid__);
SELECT pg_terminate_backend(__pid__);

cancel/terimate farki

5DK'dan uzun suredir calisan tum queryleri iptal et:

SELECT pg_cancel_backend(pid) FROM pg_stat_activity 
WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes';

Iki tarih araligi ile kesisen kayitlari bulmaca:

• OVERLAPS operator, bak

Guzel yazilar

• https://hakibenita.com/postgresql-unknown-features: zero downtime migration, OVERLAPS operator ve buyuk tabloya hizli index atmak gibi guzel trickler var.

psql.md

Komut	Açıklama
\l	Databaseleri listeleme
\c	Database degistirme
\dt	Tabloları listele
\x	Sonuçları dikey gösterme aç/kapa