Re: Pg_locks and pg_stat_activity

Hi,
pg_stat_activity -- Providers the active and ideal connection for our
database
Pg_locks -- Provider the queries/procedure/function details if
any object is locked at the current in our database.

On Fri, Dec 4, 2020 at 11:43 AM aditya desai <admad123(at)gmail(dot)com> wrote:

> Hi Postgres Experts,
> Requesting for advice on below. I am new to postgres :(
>
> Regards,
> Aditya.
>
> On Tue, Dec 1, 2020 at 9:41 PM aditya desai <admad123(at)gmail(dot)com> wrote:
>
>> Hi,
>> One of the API is calling three of the below queries. Output(jobids) of
>> 1st query gets fed to 2nd query in API.
>>
>> Query 1:
>>
>> select j.id from job j where $19=$20 and j.internaljobcode in
>> ($21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31) and j.countrycode = $1 and
>> j.facilitycode in ($2) and j.jobstatuscode in ($3, $4, $5, $6) and
>> j.internaljobcode in ($7, $8, $9, $10, $11, $12, $13, $14, $15) and
>> ((j.jobstartdatetime between $16 and $17) or j.jobstartdatetime IS NULL)
>> ORDER BY createddate DESC limit $18"
>>
>> Query 2
>>
>> with JobData AS ( select * from job where id in ($1, $2, $3, $4, $5, $6,
>> $7, $8, $9, $10) )
>> select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),'PPOD') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id
>> group by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> and ((j.internaljobcode in ('003','012') and ja.addresstype='RETURN') or
>> j.internaljobcode not in ('003','012')) ORDER BY id DESC ;
>>
>> Query3:
>>
>> "with JobCount as ( select jobstatuscode,count($14) stat_count from job j
>> where $15=$16 and j.countrycode = $1 and j.facilitycode in ($2) and
>> j.internaljobcode in ($3, $4, $5, $6, $7, $8, $9, $10, $11) and
>> ((j.jobstartdatetime between $12 and $13) or j.jobstartdatetime IS NULL)
>> group by j.jobstatuscode)
>> select js.jobstatuscode,COALESCE(stat_count,$17) stat_count from JobCount
>> jc right outer join jobstatus js on jc.jobstatuscode=js.jobstatuscode"
>>
>>
>> When I run explain analyze for 1st two queries Execution Time is below 1
>> milliseconds for these queries. Basically queries run fast and with low
>> cost when ran from Database 'psql' or pgadmin. However when called from API
>> Average Time in pg_stat_statements shows more than 1 second. When Load test
>> runs these queries get concurrently called ,response time beomes poor with
>> more load. Could this be due to Lockings.
>>
>>
>> I checked pg_locks and I see the below records. Query that I used is also
>> given below. I could see few ExclusiveLocks for "virtualxid" records and
>> for queries with CTEs(WITH Clause). Please advise
>>
>>
>>
>> SELECT * FROM pg_locks pl LEFT JOIN pg_stat_activity psa
>> ON pl.pid = psa.pid;
>>
>> "relation" 16411 34969 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34968 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34494 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34492 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34435 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 33840 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 25340 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 25338 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 25336 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 25335 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18864 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 33631 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18846 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18838 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18912 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18887 "89/29338" 3727 "AccessShareLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "virtualxid" "89/29338" "89/29338" 3727 "ExclusiveLock" true true 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34969 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34968 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34494 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34492 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34435 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 33840 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 25340 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 25338 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 25336 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 25335 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18864 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 33631 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18846 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18838 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18912 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18887 "88/27040" 5038 "AccessShareLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "virtualxid" "88/27040" "88/27040" 5038 "ExclusiveLock" true true 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16409 11750 "157/432090" 107171 "AccessShareLock" true true
>> "relation" 16409 11645 "157/432090" 107171 "AccessShareLock" true true
>> "virtualxid" "157/432090" "157/432090" 107171 "ExclusiveLock" true true
>> "relation" 16411 18887 "187/352070" 56674 "AccessShareLock" true true
>> 16411 "lmp_jobs" 56674 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver" "2020-12-01
>> 15:02:16.376204+00" "2020-12-01 15:02:16.367626+00" "2020-12-01
>> 15:02:16.373158+00" "2020-12-01 15:02:16.376788+00" "active" "26772613" "with
>> JobData AS ( select * from job where id in ($1, $2, $3, $4, $5, $6, $7, $8,
>> $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "parallel worker"
>> "virtualxid" "187/352070" "187/352070" 56674 "ExclusiveLock" true true
>> 16411 "lmp_jobs" 56674 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver" "2020-12-01
>> 15:02:16.376204+00" "2020-12-01 15:02:16.367626+00" "2020-12-01
>> 15:02:16.373158+00" "2020-12-01 15:02:16.376788+00" "active" "26772613" "with
>> JobData AS ( select * from job where id in ($1, $2, $3, $4, $5, $6, $7, $8,
>> $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "parallel worker"
>> "relation" 16411 18887 "185/343175" 56673 "AccessShareLock" true true
>> 16411 "lmp_jobs" 56673 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver" "2020-12-01
>> 15:02:16.375699+00" "2020-12-01 15:02:16.367626+00" "2020-12-01
>> 15:02:16.373158+00" "2020-12-01 15:02:16.37628+00" "active" "26772613" "with
>> JobData AS ( select * from job where id in ($1, $2, $3, $4, $5, $6, $7, $8,
>> $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "parallel worker"
>> "virtualxid" "185/343175" "185/343175" 56673 "ExclusiveLock" true true
>> 16411 "lmp_jobs" 56673 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver" "2020-12-01
>> 15:02:16.375699+00" "2020-12-01 15:02:16.367626+00" "2020-12-01
>> 15:02:16.373158+00" "2020-12-01 15:02:16.37628+00" "active" "26772613" "with
>> JobData AS ( select * from job where id in ($1, $2, $3, $4, $5, $6, $7, $8,
>> $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "parallel worker"
>> "relation" 16411 18887 "184/361201" 56672 "AccessShareLock" true true
>> 16411 "lmp_jobs" 56672 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver" "2020-12-01
>> 15:02:16.346116+00" "2020-12-01 15:02:16.340113+00" "2020-12-01
>> 15:02:16.3436+00" "2020-12-01 15:02:16.346719+00" "active" "26772613" "with
>> JobData AS ( select * from job where id in ($1, $2, $3, $4, $5, $6, $7, $8,
>> $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "parallel worker"
>> "virtualxid" "184/361201" "184/361201" 56672 "ExclusiveLock" true true
>> 16411 "lmp_jobs" 56672 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver" "2020-12-01
>> 15:02:16.346116+00" "2020-12-01 15:02:16.340113+00" "2020-12-01
>> 15:02:16.3436+00" "2020-12-01 15:02:16.346719+00" "active" "26772613" "with
>> JobData AS ( select * from job where id in ($1, $2, $3, $4, $5, $6, $7, $8,
>> $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "parallel worker"
>> "relation" 16411 18887 "174/608774" 56671 "AccessShareLock" true true
>> 16411 "lmp_jobs" 56671 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver" "2020-12-01
>> 15:02:16.345648+00" "2020-12-01 15:02:16.340113+00" "2020-12-01
>> 15:02:16.3436+00" "2020-12-01 15:02:16.346236+00" "active" "26772613" "with
>> JobData AS ( select * from job where id in ($1, $2, $3, $4, $5, $6, $7, $8,
>> $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "parallel worker"
>> "virtualxid" "174/608774" "174/608774" 56671 "ExclusiveLock" true true
>> 16411 "lmp_jobs" 56671 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver" "2020-12-01
>> 15:02:16.345648+00" "2020-12-01 15:02:16.340113+00" "2020-12-01
>> 15:02:16.3436+00" "2020-12-01 15:02:16.346236+00" "active" "26772613" "with
>> JobData AS ( select * from job where id in ($1, $2, $3, $4, $5, $6, $7, $8,
>> $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "parallel worker"
>> "relation" 16411 34977 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18844 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35004 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34981 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34979 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34890 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34975 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34667 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34974 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35006 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18852 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35013 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34733 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35041 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34978 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35006 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18852 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35013 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34733 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35041 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34978 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34975 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34667 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 0 1262 "157/432090" 107171 "AccessShareLock" true false
>> "relation" 16411 34974 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18844 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35004 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34981 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34979 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 0 2671 "157/432090" 107171 "AccessShareLock" true false
>> "relation" 16411 34890 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34977 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35032 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35036 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34752 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34980 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35035 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34976 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35034 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34984 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35003 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35014 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 0 2676 "157/432090" 107171 "AccessShareLock" true false
>> "relation" 16411 34837 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34983 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35033 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35037 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18870 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35038 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34971 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35031 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34982 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34970 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34973 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35005 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34970 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34973 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35005 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 18870 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35037 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35038 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34971 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 0 1260 "157/432090" 107171 "AccessShareLock" true false
>> "relation" 0 2672 "157/432090" 107171 "AccessShareLock" true false
>> "relation" 0 2677 "157/432090" 107171 "AccessShareLock" true false
>> "relation" 16411 35031 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34982 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35014 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34983 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34837 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35033 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35036 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35032 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34752 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34980 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35035 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35034 "88/27040" 5038 "AccessShareLock" true false 16411
>> "lmp_jobs" 5038 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.60" 48308 "2020-12-01 14:39:02.469711+00" "2020-12-01
>> 15:02:16.367626+00" "2020-12-01 15:02:16.373158+00" "2020-12-01
>> 15:02:16.373159+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34976 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 34984 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>> "relation" 16411 35003 "89/29338" 3727 "AccessShareLock" true false 16411
>> "lmp_jobs" 3727 16408 "lmp_cloud_pst" "PostgreSQL JDBC Driver"
>> "192.168.19.85" 51360 "2020-12-01 14:37:51.110243+00" "2020-12-01
>> 15:02:16.340113+00" "2020-12-01 15:02:16.3436+00" "2020-12-01
>> 15:02:16.343601+00" "active" "26772613" "with JobData AS ( select * from
>> job where id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ) select j.id
>> ,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
>>
>> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
>> j.primeindicator,j.rescheduleddatetime,j.jobproductcode,
>> j.tour_id, j.pickupaccount,
>> j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
>>
>> j.estimateddeliverydatetime,j.currency,j.paymentmethod,j.paymentamount,j.missorted,j.pickupcustomername,j.mps,j.parcelcount,j.jobcontactpersonname,t.courier_id,t.tourid,
>> js.jobstatusname, jt.externaljobcode, ja.city, ja.postalcode,
>> ja.addressline1, ja.addressline2,
>> ja.addressline3,ja.addresstype, ja.state
>> from JobData j join jobaddress ja on ja.job_id=j.id join
>> jobstatus js on js.jobstatuscode=j.jobstatuscode
>> join jobtype jt on j.internaljobcode=jt.internaljobcode left
>> join
>> (select v.job_id, string_agg(distinct(v.code),',') as
>> vascodes from JobData j join valueaddedservices v on j.id=v.job_id group
>> by v.job_id) AS vws on vws.job_id=j.id left join tour t on t.id=j.tour_id
>> where 1=1 and ((j.internaljobcode in ('003','012') and
>> ja.addresstype='RETURN') or j.internaljobcode not in ('003','012')) ORDER
>> BY id DESC" "client backend"
>>
>>
>>

--
*Regards,*
*Ravikumar S,*
*Ph: 8106741263*