Re: Pg_locks and pg_stat_activity - Mailing list pgsql-performance
| From | aditya desai |
|---|---|
| Subject | Re: Pg_locks and pg_stat_activity |
| Date | |
| Msg-id | CAN0SRDFXrOSP896-w3p4odrNhg2c+pswfE2L2XpXRsU4qfx9hg@mail.gmail.com Whole thread Raw |
| In response to | Re: Pg_locks and pg_stat_activity (Justin Pryzby <pryzby@telsasoft.com>) |
| Responses |
Re: Pg_locks and pg_stat_activity
|
| List | pgsql-performance |
Hi Justin,
Many thanks for your response. Please see my response below.
What do you mean by API ? If it's a different client, how does it connect ?
Queries are getting called from Web UI built in Microservices spring boot. It connected to Database with JDBC driver. Developers have handled connection pooling at the Application side.
What db driver ?
Driver is JDBC
What does Query 3 have to do with anything ?
Query 3 find counts of each jobstatuses that are listed in Query1 and 2
I have tried running VACUUM FULL/ANALYZE and REINDEX. Queries run fine when executed from psql/pgadmin. However when called through Application Web ,same queries take more than 5-6 seconds to load and cosumnes Database CPU. During load test of this particular module CPU spike to 100%. This is Postgres on AWS RDS. Shared_buffers=16 GB,work_mem=4MB,effective_cache_size=32GB. I have tried increasing work_mem till 16 MB effective_cache_size till 48 GB. Server configuration is 16 Core vCPU 64 GB RAM AWS RDS instance.db.m4.4xlarge.
Please see explain analyze plan of all three queries below.
-----SELECT Ids------
lmp_jobs=> explain analyze select j.id from job j where 1=1 and j.internaljobcode in ('002','004','005','006','007','009','010','001','003','011','012') and j.countrycode = 'TH' and j.facilitycode in ('THBKK1') and j.jobstatuscode in ('101','102','103','104','105','106','107','108') and j.internaljobcode in ('002','004','005','006','007','009','010','001','003','011','012') and ((j.jobstartdatetime between '2020-10-04 00:00:00' and '2020-12-03 23:59:59') or j.jobstartdatetime IS NULL) ORDER BY createddate DESC limit 10;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=192322.57..192323.73 rows=10 width=16) (actual time=3.645..4.458 rows=10 loops=1)
-> Gather Merge (cost=192322.57..198660.11 rows=54318 width=16) (actual time=3.644..4.449 rows=10 loops=1)
Workers Planned: 2
Workers Launched: 2
-> Sort (cost=191322.54..191390.44 rows=27159 width=16) (actual time=0.314..0.315 rows=3 loops=3)
Sort Key: createddate DESC
Sort Method: top-N heapsort Memory: 25kB
Worker 0: Sort Method: quicksort Memory: 25kB
Worker 1: Sort Method: quicksort Memory: 25kB
-> Parallel Bitmap Heap Scan on job j (cost=3341.17..190735.65 rows=27159 width=16) (actual time=0.130..0.268 rows=86 loops=3)
Recheck Cond: ((((countrycode)::text = 'TH'::text) AND ((facilitycode)::text = 'THBKK1'::text) AND ((internaljobcode)::text = ANY ('{002,004,005,006,007,009,010,001,003,011,012}'::text[])) AND ((internaljobcode)::text = ANY ('{002,004,005,006,007,009,010,001,003,011,012}'::text[])) AND (jobstartdatetime >= '2020-10-04 00:00:00'::timestamp without time zone) AND (jobstartdatetime <= '2020-12-03 23:59:59'::timestamp without time zone)) OR (jobstartdatetime IS NULL))
Filter: (((countrycode)::text = 'TH'::text) AND ((facilitycode)::text = 'THBKK1'::text) AND ((jobstatuscode)::text = ANY ('{101,102,103,104,105,106,107,108}'::text[])) AND ((internaljobcode)::text = ANY ('{002,004,005,006,007,009,010,001,003,011,012}'::text[])) AND ((internaljobcode)::text = ANY ('{002,004,005,006,007,009,010,001,003,011,012}'::text[])))
Rows Removed by Filter: 1
Heap Blocks: exact=179
-> BitmapOr (cost=3341.17..3341.17 rows=65216 width=0) (actual time=0.326..0.327 rows=0 loops=1)
-> Bitmap Index Scan on job_list9_idx (cost=0.00..3304.14 rows=65216 width=0) (actual time=0.322..0.322 rows=258 loops=1)
Index Cond: (((countrycode)::text = 'TH'::text) AND ((facilitycode)::text = 'THBKK1'::text) AND ((internaljobcode)::text = ANY ('{002,004,005,006,007,009,010,001,003,011,012}'::text[])) AND ((internaljobcode)::text = ANY ('{002,004,005,006,007,009,010,001,003,011,012}'::text[])) AND (jobstartdatetime >= '2020-10-04 00:00:00'::timestamp without time zone) AND (jobstartdatetime <= '2020-12-03 23:59:59'::timestamp without time zone))
-> Bitmap Index Scan on job_list10_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.003..0.003 rows=3 loops=1)
Index Cond: (jobstartdatetime IS NULL)
Planning Time: 0.706 ms
Execution Time: 4.523 ms
(21 rows)
--------------------SELECT Jobs from ids------------------------
lmp_jobs=> explain analyze with JobData AS ( select * from job where id in (15776192,15776182,15776181,15776178,15776173,11283984,11283974,11283973,11283971,11283969) )
lmp_jobs-> select j.id,j.jobcategory,j.internaljobcode,j.jobname,j.jobstatuscode,j.jobreferencenumber,
lmp_jobs-> vws.vascodes,j.createddate,j.facilitycode,j.countrycode,j.sladate,j.codamount,j.jobstartdatetime,j.jobenddatetime,j.attemptcount,
lmp_jobs-> j.primeindicator,j.rescheduleddatetime,j.jobproductcode, j.tour_id, j.pickupaccount, j.connoterequired,j.expectedbags,j.expectedparcels,j.isservicepointpickup,
lmp_jobs-> 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,
lmp_jobs-> ja.addressline1, ja.addressline2, ja.addressline3,ja.addresstype, ja.state
lmp_jobs-> from JobData j join jobaddress ja on ja.job_id=j.id join jobstatus js on js.jobstatuscode=j.jobstatuscode
lmp_jobs-> join jobtype jt on j.internaljobcode=jt.internaljobcode left join
lmp_jobs-> (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 ;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Nested Loop Left Join (cost=144.77..312.40 rows=10 width=934) (actual time=0.276..0.331 rows=10 loops=1)
Join Filter: ((((j.internaljobcode)::text = ANY ('{003,012}'::text[])) AND ((ja.addresstype)::text = 'RETURN'::text)) OR ((j.internaljobcode)::text <> ALL ('{003,012}'::text[])))
CTE jobdata
-> Index Scan using job_id_idx on job (cost=0.43..48.65 rows=10 width=853) (actual time=0.046..0.066 rows=10 loops=1)
Index Cond: (id = ANY ('{15776192,15776182,15776181,15776178,15776173,11283984,11283974,11283973,11283971,11283969}'::bigint[]))
-> Nested Loop (cost=95.83..180.50 rows=10 width=879) (actual time=0.269..0.314 rows=10 loops=1)
-> Merge Left Join (cost=95.40..95.88 rows=10 width=811) (actual time=0.258..0.268 rows=10 loops=1)
Merge Cond: (j.id = vws.job_id)
-> Sort (cost=2.94..2.96 rows=10 width=779) (actual time=0.181..0.183 rows=10 loops=1)
Sort Key: j.id DESC
Sort Method: quicksort Memory: 27kB
-> Hash Join (cost=2.50..2.77 rows=10 width=779) (actual time=0.112..0.157 rows=10 loops=1)
Hash Cond: ((j.internaljobcode)::text = (jt.internaljobcode)::text)
-> Hash Join (cost=1.23..1.46 rows=10 width=775) (actual time=0.077..0.116 rows=10 loops=1)
Hash Cond: ((j.jobstatuscode)::text = (js.jobstatuscode)::text)
-> CTE Scan on jobdata j (cost=0.00..0.20 rows=10 width=767) (actual time=0.049..0.077 rows=10 loops=1)
-> Hash (cost=1.10..1.10 rows=10 width=12) (actual time=0.013..0.013 rows=10 loops=1)
Buckets: 1024 Batches: 1 Memory Usage: 9kB
-> Seq Scan on jobstatus js (cost=0.00..1.10 rows=10 width=12) (actual time=0.003..0.006 rows=10 loops=1)
-> Hash (cost=1.12..1.12 rows=12 width=8) (actual time=0.018..0.018 rows=12 loops=1)
Buckets: 1024 Batches: 1 Memory Usage: 9kB
-> Seq Scan on jobtype jt (cost=0.00..1.12 rows=12 width=8) (actual time=0.005..0.009 rows=12 loops=1)
-> Sort (cost=92.46..92.63 rows=66 width=40) (actual time=0.073..0.073 rows=0 loops=1)
Sort Key: vws.job_id DESC
Sort Method: quicksort Memory: 25kB
-> Subquery Scan on vws (cost=88.49..90.47 rows=66 width=40) (actual time=0.063..0.063 rows=0 loops=1)
-> GroupAggregate (cost=88.49..89.81 rows=66 width=40) (actual time=0.063..0.063 rows=0 loops=1)
Group Key: v.job_id
-> Sort (cost=88.49..88.65 rows=66 width=13) (actual time=0.062..0.062 rows=0 loops=1)
Sort Key: v.job_id
Sort Method: quicksort Memory: 25kB
-> Nested Loop (cost=0.43..86.49 rows=66 width=13) (actual time=0.056..0.056 rows=0 loops=1)
-> CTE Scan on jobdata j_1 (cost=0.00..0.20 rows=10 width=8) (actual time=0.000..0.005 rows=10 loops=1)
-> Index Scan using vas_job_id on valueaddedservices v (cost=0.43..8.56 rows=7 width=13) (actual time=0.004..0.004 rows=0 loops=10)
Index Cond: (job_id = j_1.id)
-> Index Scan using address_job_list12_idx on jobaddress ja (cost=0.43..8.45 rows=1 width=76) (actual time=0.003..0.003 rows=1 loops=10)
Index Cond: (job_id = j.id)
-> Index Scan using tour_job_list9_idx on tour t (cost=0.29..8.31 rows=1 width=63) (actual time=0.001..0.001 rows=0 loops=10)
Index Cond: (id = j.tour_id)
Planning Time: 2.520 ms
Execution Time: 0.598 ms
(41 rows)
------------select jobcount-----------------------------
lmp_jobs=> explain analyze with JobCount as ( select jobstatuscode,count(1) stat_count from job j where 1=1 and j.countrycode = 'TH' and j.facilitycode in ('THBKK1') and j.internaljobcode in ('002','004','005','006','007','009','010','001','003','011','012') and ((j.jobstartdatetime between '2020-10-04 00:00:00' and '2020-12-03 23:59:59') or j.jobstartdatetime IS NULL) group by j.jobstatuscode)
lmp_jobs-> select js.jobstatuscode,COALESCE(stat_count,0) stat_count from JobCount jc right outer join jobstatus js on jc.jobstatuscode=js.jobstatuscode;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Hash Left Join (cost=381087.24..381088.42 rows=10 width=12) (actual time=276.630..276.641 rows=10 loops=1)
Hash Cond: ((js.jobstatuscode)::text = (jc.jobstatuscode)::text)
CTE jobcount
-> HashAggregate (cost=381087.02..381087.07 rows=5 width=12) (actual time=276.606..276.607 rows=1 loops=1)
Group Key: j.jobstatuscode
-> Index Scan using job_list7_idx on job j (cost=0.56..380630.38 rows=91329 width=4) (actual time=194.250..276.504 rows=258 loops=1)
Index Cond: (((countrycode)::text = 'TH'::text) AND ((facilitycode)::text = 'THBKK1'::text) AND ((internaljobcode)::text = ANY ('{002,004,005,006,007,009,010,001,003,011,012}'::text[])))
Filter: (((jobstartdatetime >= '2020-10-04 00:00:00'::timestamp without time zone) AND (jobstartdatetime <= '2020-12-03 23:59:59'::timestamp without time zone)) OR (jobstartdatetime IS NULL))
Rows Removed by Filter: 409437
-> Seq Scan on jobstatus js (cost=0.00..1.10 rows=10 width=4) (actual time=0.004..0.008 rows=10 loops=1)
-> Hash (cost=0.10..0.10 rows=5 width=24) (actual time=276.616..276.617 rows=1 loops=1)
Buckets: 1024 Batches: 1 Memory Usage: 9kB
-> CTE Scan on jobcount jc (cost=0.00..0.10 rows=5 width=24) (actual time=276.610..276.611 rows=1 loops=1)
Planning Time: 0.745 ms
Execution Time: 276.708 ms
(15 rows)
On Fri, Dec 4, 2020 at 12:18 PM Justin Pryzby <pryzby@telsasoft.com> wrote:
Your message is very long but hard to follow.
What do you mean by API ? If it's a different client, how does it connect ?
What db driver ?
What does Query 3 have to do with anything ?
Could you start again and include answers to questions from here ?
https://wiki.postgresql.org/wiki/Slow_Query_Questions
On Tue, Dec 01, 2020 at 09:41:49PM +0530, aditya desai 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"
--
Justin Pryzby
System Administrator
Telsasoft
+1-952-707-8581
pgsql-performance by date: