Query Stuck in running server - Mailing list pgsql-admin

From Shams Khan
Subject Query Stuck in running server
Date
Msg-id CAM42boo6h1fmBZ4tLXv_VOux1r_DSFZSrg319vpcz1fMxQQ+rQ@mail.gmail.com
Whole thread Raw
Responses Re: Query Stuck in running server
List pgsql-admin
Hi,
 
There are few query I found at the time of monitoring below
 
00:54:43.574338 |   26952 |   select a.actno,MAX(b.actid) as actid,MAX(b.actname) as name,MAX(b.phone) as phone,MAX(b.email) as mail,MAX(a.subsno) as subs,MAX(t.pkgid
) as svcid,MAX(a.expirydt)  as expirydt,MAX(d.domid) as domid,MAX(d.domname) as domname from actbal a  inner join subs s on a.subsno=s.subsno   inner join packages t on s.svcno=t.pkgno inner join account b on b.actno=a.actno  inner join ssgdom d on b.domno=d.domno  where a.actno not in ( select a.actno from actbal a inner join subs s on a.actno=s.actno where s.status <= 15 and  a.expirydt > $1) and a.expirydt <= $2 and b.domno=$ group by a.actno order by MAX(d.domname),MAX(b.actname)
 
can somebody help me to understand it

pgsql-admin by date:

Previous
From: Fernando Hevia
Date:
Subject: Re: Postgre Eating Up Too Much RAM
Next
From: Lukasz Brodziak
Date:
Subject: Re: Failed Login Attempts parameter