Is there any way to inform user that your query has been running more than x minutes, so admin has killed your session. This is especially to the query or read only user.
I have a function which will do exactly what I want (Im running the function periodically). But, I couldn't notice the user that their connection being killed by admin.
Users are using PgAdmin/psql/DBeaver as client. I am not sure, how can I show the message to them. Is there anyway at all notify the user in their session window?
(Initially I tried to do kind of logon trigger. Unfortunately, postgres doesn't have the feature yet)