PostgreSQL tips

I'm the author of Data Engineering Design Patterns (O'Reilly), a Databricks MVP, and a freelance data engineer specializing in Apache Spark and Databricks. I help teams move from working pipelines to resilient architectures.
I'm currently accepting new projects for May 2026. Whether you need a 2-day architectural audit, a hands-on lead for a complex data engineering problem, or a workshop let's discuss your project here.

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 β†’