PostgreSQL logging + pgagent

Currently I'm struggling to assess if long running queries are completing correctly. Here is an idea regarding setting up logging - https://martianwabbit.com/2015/06/10/postgres-checking-queries-in-realtime.html. And also look at pgagent