PostgreSQL tips

March 16, 2019

How to kill long running PostgreSQL task ?

PostgreSQL stores the information about, among others, the running tasks in the pg_stat_activity table: postgres=# \x on Expanded display is on. postgres=# select datid, datname, pid, usename, ap...

Continue Reading →