{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 Emotional °昔 的问题《Is there a way to get pg_stat_activity information》','https://www.manongdao.com/q-1283467.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
pg_stat_activity holds extremely useful information for post-mortem analysis of various issues, especially concurrency-related, and so augmenting errors or logging with this data (properly filtered and correlated) is invaluable. However querying it requires getting a database connection which might be in short supply at the very moment it's most needed.
Is there a side-channel of some sort which would allow getting that information without the additional database connection?
Not really, but the parameter
superuser_reserved_connectionswill help you. It defines the number of connections that are reserved for superusers precisely so that they can still connect, even if the connection limit is exhausted.Set the value high enough and have your monitoring process connect as superuser.