PostgreSQL: Long running query detection

I am writing this post as a note to myself. Every time I want to find slow running queries, I search and open this medium post. It is a well written short post which helps me every day. But I wanted to improve that query.

As mentioned these are pretty helpful too.

SELECT pg_cancel_backend(pid);
SELECT pg_terminate_backend(pid);
· postgres, performance issue