High Postgres CPU usage

High Postgres CPU usage

Today I have some queries (same query) that takes very long to finish (30+ minutes), which causes high CPU load.

Can someone explain what the query exactly does and why or how it was initiated?

  1. SELECT DISTINCT  "RESOURCEID","RESOURCENAME","RESOURCEDESC","DOMAINNAME","IPADDRESS","UDF_LONG1","UDF_LONG2","UDF_LONG3","UDF_LONG4","UDF_CHAR1","UDF_CHAR2","UDF_CHAR3","UDF_CHAR4","UDF_CHAR5","UDF_CHAR6","UDF_CHAR7","UDF_CHAR8","UDF_CHAR9","UDF_SCHAR1","UDF_SCHAR2","UDF_SCHAR3","UDF_DATE1","UDF_DATE2","UDF_DATE3","UDF_DATE4","UDF_FILE1","UDF_FILE2","UDF_FILE3","UDF_FILE4","DEPT","LOCATION","RESOURCEURL","OSID","OPERATINGSYSTEM","ICON" from ( select 7502 AS "USERID", Ptrx_Resource.RESOURCEID AS "RESOURCEID", decryptschar(Ptrx_Resource.RESOURCENAME,'xxxx)@') AS "RESOURCENAME",Ptrx_Resource.RESOURCEDESC AS "RESOURCEDESC",Ptrx_Resource.DOMAINNAME AS "DOMAINNAME",Ptrx_Resource.IPADDRESS AS "IPADDRESS",Ptrx_Resource.COLUMN_LONG1 AS "UDF_LONG1",Ptrx_Resource.COLUMN_LONG2 AS "UDF_LONG2",Ptrx_Resource.COLUMN_LONG3 AS "UDF_LONG3",Ptrx_Resource.COLUMN_LONG4 AS "UDF_LONG4",Ptrx_Resource.COLUMN_CHAR1 AS "UDF_CHAR1",Ptrx_Resource.COLUMN_CHAR2 AS "UDF_CHAR2",Ptrx_Resource.COLUMN_CHAR3 AS "UDF_CHAR3",Ptrx_Resource
                New to ADManager Plus?

                  New to ADSelfService Plus?