explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H8ei

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=8,056,564.06..8,056,564.31 rows=100 width=357) (actual rows= loops=)

  • "ascode" : "'::text || (COALESCE(sa15.ascode, ''::character varying))::text) || '",
  • "color" : "'::text) || (COALESCE((SubPlan 92), ''::character varying))::text) || '",
  • "full_line" : "'::text) || (COALESCE((SubPlan 93), false))::text) || '",
  • "pickup_id" : "'::text) || (p.id)::text) || '",
  • "ascode_desc" : "'::text) || COALESCE((SubPlan 94), ''::text)) || '"}'::text)), ((((((((((('{
  • "service" : "'::text || (COALESCE(sa15.socode, sa15.service, ''::character varying))::text) || '",
  • "color" : "'::text) || (COALESCE((SubPlan 95), ''::character varying))::text) || '",
  • "full_line" : "'::text) || (COALESCE((SubPlan 96), false))::text) || '",
  • "pickup_id" : "'::text) || (p.id)::text) || '",
  • "service_desc" : "'::text) || COALESCE((SubPlan 97), ''::text)) || '"}'::text)), ((((((((((('{"statusname":"'::text || (ps.shortname)::text) || '","color":"'::text) || (COALESCE(psc.color, ''::character varying))::text) || '","full_line":"'::text) || (COALESCE(psc.full_line_color, false))::text) || '","pickup_id":"'::text) || (p.id)::text) || '","status_desc":"'::text) || (ps.name)::text) || '"}'::text)), ((((((((('{"add_code":"'::text || (COALESCE((SubPlan 98), ''::character varying))::text) || ''::text) || (COALESCE((SubPlan 99), ''::character varying))::text) || '","pickup_id":"'::text) || (p.id)::text) || '","add_code_desc":"'::text) || (COALESCE((SubPlan 101), ''::character varying))::text) || '"}'::text)), (''::text), ((((COALESCE((SubPlan 102), ''::character varying))::text || ' '::text) || (COALESCE((SubPlan 103), ''::character varying))::text)), p.contact_name, ((((((((((((('{"pickup_id":"'::text || (p.id)::text) || '","comment":"'::text) || CASE WHEN ((length((p.comment)::te (...)
  • "lorry":"'::text) || (COALESCE(p.tour, ''::character varying))::text) || '",
  • "has_customer":"'::text) || CASE WHEN (length(btrim((p.customerno)::text)) > 0) THEN 'OK'::text ELSE ''::text END) || '"}'::text)), ((SubPlan 105)), (0)
2. 0.000 0.000 ↓ 0.0

Sort (cost=8,056,564.06..8,056,569.62 rows=2,224 width=357) (actual rows= loops=)

  • Sort Key: ((SubPlan 74))
3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,056,456.82..8,056,479.06 rows=2,224 width=357) (actual rows= loops=)

  • Group Key: ((p.id)::text), ((p.pickup_date)::text), ((SubPlan 74)), ((((((((((('{"ptype_id":"'::text || (pt.id)::text) || '","ptype_name":"'::text) || (getlangtext('EN'::character varying, pt.shortname))::text) || '","pickup_id":"'::text) || (p.id)::text) || '","ptype_desc":"'::text) || (getlangtext('HU'::character varying, pt.name))::text) || '","ptype_color":"'::text) || (COALESCE(pt.color, ''::character varying))::text) || '"}'::text)), ((('{"otype":"P","odesc":"Pickup","pickup_id":"'::text || (p.id)::text) || '"}'::text)), p.customerno, cus.name1, ('N/A'::text), p.name, p.name2, p.postal_code, p.city, (((p.address)::text || COALESCE((' '::text || (p.houseno)::text), ''::text))), (COALESCE(p.tel, p.mtel, ''::character varying)), ((p.number_of_parcels)::text), ((SubPlan 75)), ((('{"time_critical":"'::text || (CASE WHEN (((SubPlan 76) IS NULL) AND (p.pickup_time_till < ((now())::time without time zone + ((($173)::text || ' minutes'::text))::interval))) THEN 1 ELSE 0 END) (...)
4. 0.000 0.000 ↓ 0.0

Append (cost=67,777.47..8,056,223.30 rows=2,224 width=357) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=67,777.47..7,262,965.11 rows=2,165 width=336) (actual rows= loops=)

  • Hash Cond: ((p.customerno)::text = (cus.customerno)::text)
6.          

Initplan (forHash Join)

7. 0.000 0.000 ↓ 0.0

Seq Scan on time_critical (cost=0.00..1.02 rows=1 width=4) (actual rows= loops=)

  • Filter: ((critical_type)::text = 'P'::text)
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=60,387.88..78,518.79 rows=2,165 width=285) (actual rows= loops=)

  • Hash Cond: (p.pickup_type = pt.id)
9. 0.000 0.000 ↓ 0.0

Hash Join (cost=60,386.66..78,487.80 rows=2,165 width=261) (actual rows= loops=)

  • Hash Cond: (p.pickup_status = ps.id)
10. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=60,383.09..78,454.47 rows=2,165 width=240) (actual rows= loops=)

  • Hash Cond: ((varchar_clean_to_int(sa15.dispref) = p.id) AND (sa15.id = (SubPlan 106)))
11. 0.000 0.000 ↓ 0.0

Append (cost=0.00..52.90 rows=191 width=67) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15 sa15 (cost=0.00..0.00 rows=1 width=112) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2013 sa15_1 (cost=0.00..10.20 rows=20 width=112) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2014 sa15_2 (cost=0.00..10.20 rows=20 width=112) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2015 sa15_3 (cost=0.00..10.50 rows=50 width=58) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2016 sa15_4 (cost=0.00..10.50 rows=50 width=58) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2017 sa15_5 (cost=0.00..10.40 rows=40 width=59) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2018 sa15_6 (cost=0.00..1.10 rows=10 width=14) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Hash (cost=60,350.62..60,350.62 rows=2,165 width=188) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on pickups p (cost=446.71..60,350.62 rows=2,165 width=188) (actual rows= loops=)

  • Recheck Cond: ((pickup_date >= '2018-11-26'::date) AND (pickup_date <= '2018-11-30'::date))
  • Filter: (((postal_code)::text ~~ '%%'::text) AND ((translate(upper((name)::text), 'öüóőúéáűíčšžđć'::text, 'ÖÜÓŐÚÉÁŰÍČŠŽĐĆ'::text))::text ~~ '%%'::text) AND ((translate(upper((city)::text), 'öüóőúéáűíčšžđć'::text, 'ÖÜÓŐÚÉÁŰÍČŠŽĐĆ'::text))::text ~~ '%%'::text) AND ((translate(upper((address)::text), 'öüóőúéáűíčšžđć'::text, 'ÖÜÓŐÚÉÁŰÍČŠŽĐĆ'::text))::text ~~ '%%'::text) AND ((SubPlan 107) IS NOT NULL) AND ((SubPlan 108) IS NOT NULL))
21. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pickup_date (cost=0.00..446.17 rows=2,188 width=0) (actual rows= loops=)

  • Index Cond: ((pickup_date >= '2018-11-26'::date) AND (pickup_date <= '2018-11-30'::date))
22.          

SubPlan (forBitmap Heap Scan)

23. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_3 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (p.depo)::text)
24. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_4 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (p.depo)::text)
25.          

SubPlan (forHash Right Join)

26. 0.000 0.000 ↓ 0.0

Limit (cost=94.08..94.08 rows=1 width=4) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Sort (cost=94.08..94.10 rows=9 width=4) (actual rows= loops=)

  • Sort Key: s15.id
28. 0.000 0.000 ↓ 0.0

Append (cost=0.00..94.03 rows=9 width=4) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15 s15 (cost=0.00..0.00 rows=1 width=4) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
30. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2013 s15_1 (cost=0.00..15.25 rows=1 width=4) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
31. 0.000 0.000 ↓ 0.0

Index Scan using sa15_scandata15_2014_dispref_int on scandata15_2014 s15_2 (cost=0.39..8.40 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
32. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2015 s15_3 (cost=0.00..23.12 rows=1 width=4) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
33. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2016 s15_4 (cost=0.00..23.12 rows=1 width=4) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
34. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2017 s15_5 (cost=0.00..20.50 rows=3 width=4) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
35. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2018 s15_6 (cost=0.00..3.62 rows=1 width=4) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
36. 0.000 0.000 ↓ 0.0

Hash (cost=3.42..3.42 rows=11 width=25) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2.26..3.42 rows=11 width=25) (actual rows= loops=)

  • Hash Cond: (ps.id = psc.pickup_statuses_id)
38. 0.000 0.000 ↓ 0.0

Seq Scan on pickup_statuses ps (cost=0.00..1.11 rows=11 width=17) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Hash (cost=2.25..2.25 rows=1 width=12) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Seq Scan on pickup_statuses_colors psc (cost=0.00..2.25 rows=1 width=12) (actual rows= loops=)

  • Filter: (lupd_user = 563)
41. 0.000 0.000 ↓ 0.0

Hash (cost=1.10..1.10 rows=10 width=28) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Seq Scan on pickup_types pt (cost=0.00..1.10 rows=10 width=28) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Hash (cost=5,952.14..5,952.14 rows=114,914 width=69) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Seq Scan on customers_dsw cus (cost=0.00..5,952.14 rows=114,914 width=69) (actual rows= loops=)

45.          

SubPlan (forHash Join)

46. 0.000 0.000 ↓ 0.0

Limit (cost=13.99..14.00 rows=1 width=8) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Sort (cost=13.99..14.00 rows=1 width=8) (actual rows= loops=)

  • Sort Key: so_6.stoporder
48. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..13.98 rows=1 width=8) (actual rows= loops=)

  • Join Filter: (so_6.id = soe_6.stoporder_id)
49. 0.000 0.000 ↓ 0.0

Index Scan using stoporder_elements_idx on stoporder_elements soe_6 (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((reference)::text = (p.id)::text)
  • Filter: ((reference_type)::text = 'PI'::text)
50. 0.000 0.000 ↓ 0.0

Seq Scan on stoporder so_6 (cost=0.00..5.63 rows=2 width=12) (actual rows= loops=)

  • Filter: ((date = p.pickup_date) AND ((tour)::text = (p.tour)::text))
51. 0.000 0.000 ↓ 0.0

Aggregate (cost=94.05..94.07 rows=1 width=25) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Append (cost=0.00..94.03 rows=9 width=25) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15 (cost=0.00..0.00 rows=1 width=46) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
54. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2013 (cost=0.00..15.25 rows=1 width=46) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
55. 0.000 0.000 ↓ 0.0

Index Scan using sa15_scandata15_2014_dispref_int on scandata15_2014 (cost=0.39..8.40 rows=1 width=46) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
56. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2015 (cost=0.00..23.12 rows=1 width=15) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
57. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2016 (cost=0.00..23.12 rows=1 width=15) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
58. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2017 (cost=0.00..20.50 rows=3 width=15) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
59. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2018 (cost=0.00..3.62 rows=1 width=15) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
60. 0.000 0.000 ↓ 0.0

Aggregate (cost=94.05..94.06 rows=1 width=8) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Append (cost=0.00..94.03 rows=9 width=8) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15 scandata15_1 (cost=0.00..0.00 rows=1 width=8) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
63. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2013 scandata15_2013_1 (cost=0.00..15.25 rows=1 width=8) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
64. 0.000 0.000 ↓ 0.0

Index Scan using sa15_scandata15_2014_dispref_int on scandata15_2014 scandata15_2014_1 (cost=0.39..8.40 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
65. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2015 scandata15_2015_1 (cost=0.00..23.12 rows=1 width=8) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
66. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2016 scandata15_2016_1 (cost=0.00..23.12 rows=1 width=8) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
67. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2017 scandata15_2017_1 (cost=0.00..20.50 rows=3 width=8) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
68. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2018 scandata15_2018_1 (cost=0.00..3.62 rows=1 width=8) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
69. 0.000 0.000 ↓ 0.0

Limit (cost=13.98..13.99 rows=1 width=9) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Sort (cost=13.98..13.99 rows=1 width=9) (actual rows= loops=)

  • Sort Key: so_7.stoporder
71. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..13.97 rows=1 width=9) (actual rows= loops=)

  • Join Filter: (so_7.id = soe_7.stoporder_id)
72. 0.000 0.000 ↓ 0.0

Index Scan using stoporder_elements_idx on stoporder_elements soe_7 (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((reference)::text = (p.id)::text)
  • Filter: ((reference_type)::text = 'PI'::text)
73. 0.000 0.000 ↓ 0.0

Seq Scan on stoporder so_7 (cost=0.00..5.63 rows=2 width=13) (actual rows= loops=)

  • Filter: ((date = p.pickup_date) AND ((tour)::text = (p.tour)::text))
74. 0.000 0.000 ↓ 0.0

Limit (cost=13.98..13.99 rows=1 width=9) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Sort (cost=13.98..13.99 rows=1 width=9) (actual rows= loops=)

  • Sort Key: so_8.stoporder
76. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..13.97 rows=1 width=9) (actual rows= loops=)

  • Join Filter: (so_8.id = soe_8.stoporder_id)
77. 0.000 0.000 ↓ 0.0

Index Scan using stoporder_elements_idx on stoporder_elements soe_8 (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((reference)::text = (p.id)::text)
  • Filter: ((reference_type)::text = 'PI'::text)
78. 0.000 0.000 ↓ 0.0

Seq Scan on stoporder so_8 (cost=0.00..5.63 rows=2 width=13) (actual rows= loops=)

  • Filter: ((date = p.pickup_date) AND ((tour)::text = (p.tour)::text))
79. 0.000 0.000 ↓ 0.0

Aggregate (cost=87.58..87.59 rows=1 width=8) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Append (cost=0.00..87.56 rows=7 width=8) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15 scandata15_2 (cost=0.00..0.00 rows=1 width=8) (actual rows= loops=)

  • Filter: ((sdate = p.pickup_date) AND (varchar_clean_to_int(dispref) = p.id))
82. 0.000 0.000 ↓ 0.0

Index Scan using scandata15_2013_sdate_idx on scandata15_2013 scandata15_2013_2 (cost=0.14..8.41 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (sdate = p.pickup_date)
  • Filter: (varchar_clean_to_int(dispref) = p.id)
83. 0.000 0.000 ↓ 0.0

Index Scan using scandata15_2014_sdate_lorry_idx on scandata15_2014 scandata15_2014_2 (cost=0.14..8.41 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (sdate = p.pickup_date)
  • Filter: (varchar_clean_to_int(dispref) = p.id)
84. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2015 scandata15_2015_2 (cost=0.00..23.25 rows=1 width=8) (actual rows= loops=)

  • Filter: ((sdate = p.pickup_date) AND (varchar_clean_to_int(dispref) = p.id))
85. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2016 scandata15_2016_2 (cost=0.00..23.25 rows=1 width=8) (actual rows= loops=)

  • Filter: ((sdate = p.pickup_date) AND (varchar_clean_to_int(dispref) = p.id))
86. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2017 scandata15_2017_2 (cost=0.00..20.60 rows=1 width=8) (actual rows= loops=)

  • Filter: ((sdate = p.pickup_date) AND (varchar_clean_to_int(dispref) = p.id))
87. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2018 scandata15_2018_2 (cost=0.00..3.65 rows=1 width=8) (actual rows= loops=)

  • Filter: ((sdate = p.pickup_date) AND (varchar_clean_to_int(dispref) = p.id))
88. 0.000 0.000 ↓ 0.0

Aggregate (cost=64.29..64.30 rows=1 width=8) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Append (cost=0.00..64.28 rows=7 width=8) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Seq Scan on scandata18 (cost=0.00..0.00 rows=1 width=8) (actual rows= loops=)

  • Filter: ((sdate = p.pickup_date) AND (varchar_clean_to_int(dispref) = p.id))
91. 0.000 0.000 ↓ 0.0

Index Scan using scandata18_2013_sdate_idx on scandata18_2013 (cost=0.14..8.41 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (sdate = p.pickup_date)
  • Filter: (varchar_clean_to_int(dispref) = p.id)
92. 0.000 0.000 ↓ 0.0

Index Scan using scandata18_2014_sdate_lorry_idx on scandata18_2014 (cost=0.14..8.41 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (sdate = p.pickup_date)
  • Filter: (varchar_clean_to_int(dispref) = p.id)
93. 0.000 0.000 ↓ 0.0

Index Scan using scandata18_2015_sdate_lorry_idx on scandata18_2015 (cost=0.14..8.41 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (sdate = p.pickup_date)
  • Filter: (varchar_clean_to_int(dispref) = p.id)
94. 0.000 0.000 ↓ 0.0

Index Scan using scandata18_2016_sdate_idx on scandata18_2016 (cost=0.14..12.41 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (sdate = p.pickup_date)
  • Filter: (varchar_clean_to_int(dispref) = p.id)
95. 0.000 0.000 ↓ 0.0

Seq Scan on scandata18_2017 (cost=0.00..17.95 rows=1 width=8) (actual rows= loops=)

  • Filter: ((sdate = p.pickup_date) AND (varchar_clean_to_int(dispref) = p.id))
96. 0.000 0.000 ↓ 0.0

Index Scan using sa18_scandata18_2018_dispref_int_idx on scandata18_2018 (cost=0.67..8.69 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
  • Filter: (sdate = p.pickup_date)
97. 0.000 0.000 ↓ 0.0

Limit (cost=13.98..13.99 rows=1 width=9) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

Sort (cost=13.98..13.99 rows=1 width=9) (actual rows= loops=)

  • Sort Key: so_9.stoporder
99. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..13.97 rows=1 width=9) (actual rows= loops=)

  • Join Filter: (so_9.id = soe_9.stoporder_id)
100. 0.000 0.000 ↓ 0.0

Index Scan using stoporder_elements_idx on stoporder_elements soe_9 (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((reference)::text = (p.id)::text)
  • Filter: ((reference_type)::text = 'PI'::text)
101. 0.000 0.000 ↓ 0.0

Seq Scan on stoporder so_9 (cost=0.00..5.63 rows=2 width=13) (actual rows= loops=)

  • Filter: ((date = p.pickup_date) AND ((tour)::text = (p.tour)::text))
102. 0.000 0.000 ↓ 0.0

Aggregate (cost=87.58..87.59 rows=1 width=8) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Append (cost=0.00..87.56 rows=7 width=8) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15 scandata15_3 (cost=0.00..0.00 rows=1 width=8) (actual rows= loops=)

  • Filter: ((sdate = p.pickup_date) AND (varchar_clean_to_int(dispref) = p.id))
105. 0.000 0.000 ↓ 0.0

Index Scan using scandata15_2013_sdate_idx on scandata15_2013 scandata15_2013_3 (cost=0.14..8.41 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (sdate = p.pickup_date)
  • Filter: (varchar_clean_to_int(dispref) = p.id)
106. 0.000 0.000 ↓ 0.0

Index Scan using scandata15_2014_sdate_lorry_idx on scandata15_2014 scandata15_2014_3 (cost=0.14..8.41 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (sdate = p.pickup_date)
  • Filter: (varchar_clean_to_int(dispref) = p.id)
107. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2015 scandata15_2015_3 (cost=0.00..23.25 rows=1 width=8) (actual rows= loops=)

  • Filter: ((sdate = p.pickup_date) AND (varchar_clean_to_int(dispref) = p.id))
108. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2016 scandata15_2016_3 (cost=0.00..23.25 rows=1 width=8) (actual rows= loops=)

  • Filter: ((sdate = p.pickup_date) AND (varchar_clean_to_int(dispref) = p.id))
109. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2017 scandata15_2017_3 (cost=0.00..20.60 rows=1 width=8) (actual rows= loops=)

  • Filter: ((sdate = p.pickup_date) AND (varchar_clean_to_int(dispref) = p.id))
110. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2018 scandata15_2018_3 (cost=0.00..3.65 rows=1 width=8) (actual rows= loops=)

  • Filter: ((sdate = p.pickup_date) AND (varchar_clean_to_int(dispref) = p.id))
111. 0.000 0.000 ↓ 0.0

Aggregate (cost=64.29..64.30 rows=1 width=8) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Append (cost=0.00..64.28 rows=7 width=8) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Seq Scan on scandata18 scandata18_1 (cost=0.00..0.00 rows=1 width=8) (actual rows= loops=)

  • Filter: ((sdate = p.pickup_date) AND (varchar_clean_to_int(dispref) = p.id))
114. 0.000 0.000 ↓ 0.0

Index Scan using scandata18_2013_sdate_idx on scandata18_2013 scandata18_2013_1 (cost=0.14..8.41 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (sdate = p.pickup_date)
  • Filter: (varchar_clean_to_int(dispref) = p.id)
115. 0.000 0.000 ↓ 0.0

Index Scan using scandata18_2014_sdate_lorry_idx on scandata18_2014 scandata18_2014_1 (cost=0.14..8.41 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (sdate = p.pickup_date)
  • Filter: (varchar_clean_to_int(dispref) = p.id)
116. 0.000 0.000 ↓ 0.0

Index Scan using scandata18_2015_sdate_lorry_idx on scandata18_2015 scandata18_2015_1 (cost=0.14..8.41 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (sdate = p.pickup_date)
  • Filter: (varchar_clean_to_int(dispref) = p.id)
117. 0.000 0.000 ↓ 0.0

Index Scan using scandata18_2016_sdate_idx on scandata18_2016 scandata18_2016_1 (cost=0.14..12.41 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (sdate = p.pickup_date)
  • Filter: (varchar_clean_to_int(dispref) = p.id)
118. 0.000 0.000 ↓ 0.0

Seq Scan on scandata18_2017 scandata18_2017_1 (cost=0.00..17.95 rows=1 width=8) (actual rows= loops=)

  • Filter: ((sdate = p.pickup_date) AND (varchar_clean_to_int(dispref) = p.id))
119. 0.000 0.000 ↓ 0.0

Index Scan using sa18_scandata18_2018_dispref_int_idx on scandata18_2018 scandata18_2018_1 (cost=0.67..8.69 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
  • Filter: (sdate = p.pickup_date)
120. 0.000 0.000 ↓ 0.0

Limit (cost=13.98..13.99 rows=1 width=9) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Sort (cost=13.98..13.99 rows=1 width=9) (actual rows= loops=)

  • Sort Key: so_10.stoporder
122. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..13.97 rows=1 width=9) (actual rows= loops=)

  • Join Filter: (so_10.id = soe_10.stoporder_id)
123. 0.000 0.000 ↓ 0.0

Index Scan using stoporder_elements_idx on stoporder_elements soe_10 (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((reference)::text = (p.id)::text)
  • Filter: ((reference_type)::text = 'PI'::text)
124. 0.000 0.000 ↓ 0.0

Seq Scan on stoporder so_10 (cost=0.00..5.63 rows=2 width=13) (actual rows= loops=)

  • Filter: ((date = p.pickup_date) AND ((tour)::text = (p.tour)::text))
125. 0.000 0.000 ↓ 0.0

Limit (cost=13.98..13.99 rows=1 width=9) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Sort (cost=13.98..13.99 rows=1 width=9) (actual rows= loops=)

  • Sort Key: so_11.stoporder
127. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..13.97 rows=1 width=9) (actual rows= loops=)

  • Join Filter: (so_11.id = soe_11.stoporder_id)
128. 0.000 0.000 ↓ 0.0

Index Scan using stoporder_elements_idx on stoporder_elements soe_11 (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((reference)::text = (p.id)::text)
  • Filter: ((reference_type)::text = 'PI'::text)
129. 0.000 0.000 ↓ 0.0

Seq Scan on stoporder so_11 (cost=0.00..5.63 rows=2 width=13) (actual rows= loops=)

  • Filter: ((date = p.pickup_date) AND ((tour)::text = (p.tour)::text))
130. 0.000 0.000 ↓ 0.0

Aggregate (cost=94.05..94.06 rows=1 width=8) (actual rows= loops=)

131. 0.000 0.000 ↓ 0.0

Append (cost=0.00..94.03 rows=9 width=8) (actual rows= loops=)

132. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15 scandata15_4 (cost=0.00..0.00 rows=1 width=8) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
133. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2013 scandata15_2013_4 (cost=0.00..15.25 rows=1 width=8) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
134. 0.000 0.000 ↓ 0.0

Index Scan using sa15_scandata15_2014_dispref_int on scandata15_2014 scandata15_2014_4 (cost=0.39..8.40 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
135. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2015 scandata15_2015_4 (cost=0.00..23.12 rows=1 width=8) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
136. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2016 scandata15_2016_4 (cost=0.00..23.12 rows=1 width=8) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
137. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2017 scandata15_2017_4 (cost=0.00..20.50 rows=3 width=8) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
138. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2018 scandata15_2018_4 (cost=0.00..3.62 rows=1 width=8) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
139. 0.000 0.000 ↓ 0.0

Aggregate (cost=94.10..94.11 rows=1 width=25) (actual rows= loops=)

140. 0.000 0.000 ↓ 0.0

Append (cost=0.00..94.03 rows=9 width=25) (actual rows= loops=)

141. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15 scandata15_5 (cost=0.00..0.00 rows=1 width=46) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
142. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2013 scandata15_2013_5 (cost=0.00..15.25 rows=1 width=46) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
143. 0.000 0.000 ↓ 0.0

Index Scan using sa15_scandata15_2014_dispref_int on scandata15_2014 scandata15_2014_5 (cost=0.39..8.40 rows=1 width=46) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
144. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2015 scandata15_2015_5 (cost=0.00..23.12 rows=1 width=15) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
145. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2016 scandata15_2016_5 (cost=0.00..23.12 rows=1 width=15) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
146. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2017 scandata15_2017_5 (cost=0.00..20.50 rows=3 width=15) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
147. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2018 scandata15_2018_5 (cost=0.00..3.62 rows=1 width=15) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
148. 0.000 0.000 ↓ 0.0

Aggregate (cost=540.72..540.73 rows=1 width=8) (actual rows= loops=)

149. 0.000 0.000 ↓ 0.0

Nested Loop (cost=528.68..540.72 rows=1 width=8) (actual rows= loops=)

150. 0.000 0.000 ↓ 0.0

Index Scan using adh_pickups_id_idx on pickups_ad_hoc_mapping ad_hoc (cost=0.29..8.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (pickups_id = p.id)
151. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ad_hoc_parcels ahp (cost=528.39..532.40 rows=1 width=12) (actual rows= loops=)

  • Recheck Cond: (id = ad_hoc.ad_hoc_parcels_id)
152. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ad_hoc_parcels_ind2 (cost=0.00..528.39 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (id = ad_hoc.ad_hoc_parcels_id)
153. 0.000 0.000 ↓ 0.0

Aggregate (cost=94.12..94.13 rows=1 width=12) (actual rows= loops=)

154. 0.000 0.000 ↓ 0.0

Append (cost=0.00..94.03 rows=9 width=12) (actual rows= loops=)

155. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15 scandata15_6 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
156. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2013 scandata15_2013_6 (cost=0.00..15.25 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
157. 0.000 0.000 ↓ 0.0

Index Scan using sa15_scandata15_2014_dispref_int on scandata15_2014 scandata15_2014_6 (cost=0.39..8.40 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
158. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2015 scandata15_2015_6 (cost=0.00..23.12 rows=1 width=2) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
159. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2016 scandata15_2016_6 (cost=0.00..23.12 rows=1 width=2) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
160. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2017 scandata15_2017_6 (cost=0.00..20.50 rows=3 width=2) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
161. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2018 scandata15_2018_6 (cost=0.00..3.62 rows=1 width=1) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
162. 0.000 0.000 ↓ 0.0

Aggregate (cost=94.12..94.13 rows=1 width=12) (actual rows= loops=)

163. 0.000 0.000 ↓ 0.0

Append (cost=0.00..94.03 rows=9 width=12) (actual rows= loops=)

164. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15 scandata15_7 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
165. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2013 scandata15_2013_7 (cost=0.00..15.25 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
166. 0.000 0.000 ↓ 0.0

Index Scan using sa15_scandata15_2014_dispref_int on scandata15_2014 scandata15_2014_7 (cost=0.39..8.40 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
167. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2015 scandata15_2015_7 (cost=0.00..23.12 rows=1 width=2) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
168. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2016 scandata15_2016_7 (cost=0.00..23.12 rows=1 width=2) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
169. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2017 scandata15_2017_7 (cost=0.00..20.50 rows=3 width=2) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
170. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2018 scandata15_2018_7 (cost=0.00..3.62 rows=1 width=1) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
171. 0.000 0.000 ↓ 0.0

Seq Scan on service_code_colors service_code_colors_4 (cost=0.00..1.08 rows=1 width=7) (actual rows= loops=)

  • Filter: ((lupd_user = 563) AND ((service_code)::text = (sa15.ascode)::text))
172. 0.000 0.000 ↓ 0.0

Seq Scan on service_code_colors service_code_colors_5 (cost=0.00..1.08 rows=1 width=1) (actual rows= loops=)

  • Filter: ((lupd_user = 563) AND ((service_code)::text = (sa15.ascode)::text))
173. 0.000 0.000 ↓ 0.0

Aggregate (cost=8.29..8.30 rows=1 width=40) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

Index Scan using servicecode_idx on service service_2 (cost=0.27..8.29 rows=1 width=40) (actual rows= loops=)

  • Index Cond: ((servicecode)::text = (sa15.ascode)::text)
175. 0.000 0.000 ↓ 0.0

Seq Scan on service_code_colors service_code_colors_6 (cost=0.00..1.08 rows=1 width=7) (actual rows= loops=)

  • Filter: ((lupd_user = 563) AND ((service_code)::text = (COALESCE(sa15.socode, sa15.service, ''::character varying))::text))
176. 0.000 0.000 ↓ 0.0

Seq Scan on service_code_colors service_code_colors_7 (cost=0.00..1.08 rows=1 width=1) (actual rows= loops=)

  • Filter: ((lupd_user = 563) AND ((service_code)::text = (COALESCE(sa15.socode, sa15.service, ''::character varying))::text))
177. 0.000 0.000 ↓ 0.0

Aggregate (cost=8.29..8.30 rows=1 width=40) (actual rows= loops=)

178. 0.000 0.000 ↓ 0.0

Index Scan using servicecode_idx on service service_3 (cost=0.27..8.29 rows=1 width=40) (actual rows= loops=)

  • Index Cond: ((servicecode)::text = (COALESCE(sa15.socode, sa15.service, ''::character varying))::text)
179. 0.000 0.000 ↓ 0.0

Aggregate (cost=96.28..96.29 rows=1 width=12) (actual rows= loops=)

180. 0.000 0.000 ↓ 0.0

Append (cost=0.00..94.03 rows=9 width=12) (actual rows= loops=)

181. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15 scandata15_8 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
182. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2013 scandata15_2013_8 (cost=0.00..15.25 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
183. 0.000 0.000 ↓ 0.0

Index Scan using sa15_scandata15_2014_dispref_int on scandata15_2014 scandata15_2014_8 (cost=0.39..8.40 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
184. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2015 scandata15_2015_8 (cost=0.00..23.12 rows=1 width=1) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
185. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2016 scandata15_2016_8 (cost=0.00..23.12 rows=1 width=1) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
186. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2017 scandata15_2017_8 (cost=0.00..20.50 rows=3 width=1) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
187. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2018 scandata15_2018_8 (cost=0.00..3.62 rows=1 width=5) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
188. 0.000 0.000 ↓ 0.0

Aggregate (cost=72.78..72.80 rows=1 width=15) (actual rows= loops=)

189. 0.000 0.000 ↓ 0.0

Append (cost=0.00..71.03 rows=7 width=15) (actual rows= loops=)

190. 0.000 0.000 ↓ 0.0

Seq Scan on scandata18 scandata18_2 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
191. 0.000 0.000 ↓ 0.0

Seq Scan on scandata18_2013 scandata18_3 (cost=0.00..15.25 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
192. 0.000 0.000 ↓ 0.0

Index Scan using sa18_scandata18_2014_dispref_int_idx on scandata18_2014 scandata18_4 (cost=0.39..8.40 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
193. 0.000 0.000 ↓ 0.0

Index Scan using sa18_scandata18_2015_dispref_int_idx on scandata18_2015 scandata18_5 (cost=0.39..8.41 rows=1 width=3) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
194. 0.000 0.000 ↓ 0.0

Index Scan using sa18_scandata18_2016_dispref_int_idx on scandata18_2016 scandata18_6 (cost=0.39..12.41 rows=1 width=3) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
195. 0.000 0.000 ↓ 0.0

Seq Scan on scandata18_2017 scandata18_7 (cost=0.00..17.88 rows=1 width=1) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
196. 0.000 0.000 ↓ 0.0

Index Scan using sa18_scandata18_2018_dispref_int_idx on scandata18_2018 scandata18_8 (cost=0.67..8.69 rows=1 width=1) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
197. 0.000 0.000 ↓ 0.0

Aggregate (cost=102.23..102.24 rows=1 width=25) (actual rows= loops=)

198.          

Initplan (forAggregate)

199. 0.000 0.000 ↓ 0.0

Aggregate (cost=96.28..96.29 rows=1 width=12) (actual rows= loops=)

200. 0.000 0.000 ↓ 0.0

Append (cost=0.00..94.03 rows=9 width=12) (actual rows= loops=)

201. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15 scandata15_9 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
202. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2013 scandata15_2013_9 (cost=0.00..15.25 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
203. 0.000 0.000 ↓ 0.0

Index Scan using sa15_scandata15_2014_dispref_int on scandata15_2014 scandata15_2014_9 (cost=0.39..8.40 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
204. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2015 scandata15_2015_9 (cost=0.00..23.12 rows=1 width=1) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
205. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2016 scandata15_2016_9 (cost=0.00..23.12 rows=1 width=1) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
206. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2017 scandata15_2017_9 (cost=0.00..20.50 rows=3 width=1) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
207. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2018 scandata15_2018_9 (cost=0.00..3.62 rows=1 width=5) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
208. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.25..3.44 rows=10 width=25) (actual rows= loops=)

  • Hash Cond: (ad_1.add_code = (split.split)::bpchar)
209. 0.000 0.000 ↓ 0.0

Seq Scan on additional_codes ad_1 (cost=0.00..2.79 rows=79 width=29) (actual rows= loops=)

210. 0.000 0.000 ↓ 0.0

Hash (cost=0.12..0.12 rows=10 width=32) (actual rows= loops=)

211. 0.000 0.000 ↓ 0.0

Function Scan on split (cost=0.03..0.12 rows=10 width=32) (actual rows= loops=)

212. 0.000 0.000 ↓ 0.0

Aggregate (cost=96.28..96.29 rows=1 width=11) (actual rows= loops=)

213. 0.000 0.000 ↓ 0.0

Append (cost=0.00..94.03 rows=9 width=11) (actual rows= loops=)

214. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15 scandata15_10 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
215. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2013 scandata15_2013_10 (cost=0.00..15.25 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
216. 0.000 0.000 ↓ 0.0

Index Scan using sa15_scandata15_2014_dispref_int on scandata15_2014 scandata15_2014_10 (cost=0.39..8.40 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
217. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2015 scandata15_2015_10 (cost=0.00..23.12 rows=1 width=1) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
218. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2016 scandata15_2016_10 (cost=0.00..23.12 rows=1 width=1) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
219. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2017 scandata15_2017_10 (cost=0.00..20.50 rows=3 width=1) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
220. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2018 scandata15_2018_10 (cost=0.00..3.62 rows=1 width=1) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
221. 0.000 0.000 ↓ 0.0

Aggregate (cost=72.78..72.80 rows=1 width=21) (actual rows= loops=)

222. 0.000 0.000 ↓ 0.0

Append (cost=0.00..71.03 rows=7 width=21) (actual rows= loops=)

223. 0.000 0.000 ↓ 0.0

Seq Scan on scandata18 scandata18_9 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
224. 0.000 0.000 ↓ 0.0

Seq Scan on scandata18_2013 scandata18_2013_2 (cost=0.00..15.25 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
225. 0.000 0.000 ↓ 0.0

Index Scan using sa18_scandata18_2014_dispref_int_idx on scandata18_2014 scandata18_2014_2 (cost=0.39..8.40 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
226. 0.000 0.000 ↓ 0.0

Index Scan using sa18_scandata18_2015_dispref_int_idx on scandata18_2015 scandata18_2015_2 (cost=0.39..8.41 rows=1 width=5) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
227. 0.000 0.000 ↓ 0.0

Index Scan using sa18_scandata18_2016_dispref_int_idx on scandata18_2016 scandata18_2016_2 (cost=0.39..12.41 rows=1 width=6) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
228. 0.000 0.000 ↓ 0.0

Seq Scan on scandata18_2017 scandata18_2017_2 (cost=0.00..17.88 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
229. 0.000 0.000 ↓ 0.0

Index Scan using sa18_scandata18_2018_dispref_int_idx on scandata18_2018 scandata18_2018_2 (cost=0.67..8.69 rows=1 width=9) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
230. 0.000 0.000 ↓ 0.0

Aggregate (cost=96.28..96.29 rows=1 width=14) (actual rows= loops=)

231. 0.000 0.000 ↓ 0.0

Append (cost=0.00..94.03 rows=9 width=14) (actual rows= loops=)

232. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15 scandata15_11 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
233. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2013 scandata15_2013_11 (cost=0.00..15.25 rows=1 width=32) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
234. 0.000 0.000 ↓ 0.0

Index Scan using sa15_scandata15_2014_dispref_int on scandata15_2014 scandata15_2014_11 (cost=0.39..8.40 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (varchar_clean_to_int(dispref) = p.id)
235. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2015 scandata15_2015_11 (cost=0.00..23.12 rows=1 width=9) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
236. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2016 scandata15_2016_11 (cost=0.00..23.12 rows=1 width=10) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
237. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2017 scandata15_2017_11 (cost=0.00..20.50 rows=3 width=3) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
238. 0.000 0.000 ↓ 0.0

Seq Scan on scandata15_2018 scandata15_2018_11 (cost=0.00..3.62 rows=1 width=6) (actual rows= loops=)

  • Filter: (varchar_clean_to_int(dispref) = p.id)
239. 0.000 0.000 ↓ 0.0

Limit (cost=13.97..13.98 rows=1 width=4) (actual rows= loops=)

240. 0.000 0.000 ↓ 0.0

Sort (cost=13.97..13.98 rows=1 width=4) (actual rows= loops=)

  • Sort Key: so_12.stoporder
241. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..13.96 rows=1 width=4) (actual rows= loops=)

  • Join Filter: (so_12.id = soe_12.stoporder_id)
242. 0.000 0.000 ↓ 0.0

Index Scan using stoporder_elements_idx on stoporder_elements soe_12 (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((reference)::text = (p.id)::text)
  • Filter: ((reference_type)::text = 'PI'::text)
243. 0.000 0.000 ↓ 0.0

Seq Scan on stoporder so_12 (cost=0.00..5.63 rows=2 width=8) (actual rows= loops=)

  • Filter: ((date = p.pickup_date) AND ((tour)::text = (p.tour)::text))
244. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=791,503.90..793,236.44 rows=58 width=1,148) (actual rows= loops=)

245. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=791,503.90..793,235.86 rows=58 width=1,148) (actual rows= loops=)

  • Group Key: a.sdate, a.consignee, a.name2, a.pcode, a.city, a.street, a.tour, a.status, a.phone, a.sorder, a.changedc, a.round_sorder
246.          

Initplan (forGroupAggregate)

247. 0.000 0.000 ↓ 0.0

Seq Scan on service_code_colors (cost=0.00..1.08 rows=1 width=7) (actual rows= loops=)

  • Filter: ((lupd_user = 563) AND ((service_code)::text = (ascode)::text))
248. 0.000 0.000 ↓ 0.0

Seq Scan on service_code_colors service_code_colors_1 (cost=0.00..1.08 rows=1 width=1) (actual rows= loops=)

  • Filter: ((lupd_user = 563) AND ((service_code)::text = (ascode)::text))
249. 0.000 0.000 ↓ 0.0

Sort (cost=791,501.74..791,501.89 rows=58 width=1,148) (actual rows= loops=)

  • Sort Key: a.sdate, a.consignee, a.name2, a.pcode, a.city, a.street, a.tour, a.status, a.phone, a.sorder, a.changedc, a.round_sorder
250. 0.000 0.000 ↓ 0.0

Subquery Scan on a (cost=791,498.89..791,500.05 rows=58 width=1,148) (actual rows= loops=)

251. 0.000 0.000 ↓ 0.0

HashAggregate (cost=791,498.89..791,499.47 rows=58 width=290) (actual rows= loops=)

  • Group Key: ('03'::text), (('SA03_'::text || (s03.id)::text)), s03.sdate, ((SubPlan 54)), s03.ascode, (COALESCE(s03.socode, s03.service)), cus_1.customerno, cus_1.name1, (CASE WHEN (((s03.emplz)::text = (s14.emplz)::text) AND ((s03.emcity)::text = (s14.emcity)::text) AND ((s03.emhno)::text = (s14.emhno)::text) AND ((s03.emstr)::text = (s14.emstr)::text) AND ((s03.emadr1)::text = (s14.emadr1)::text) AND ((s03.emadr2)::text = (s14.emadr2)::text)) THEN 'NO'::text ELSE 'YES'::text END), s03.emadr1, s03.emadr2, s03.emplz, s03.emcity, ((((s03.emstr)::text || ' '::text) || (s03.emhno)::text)), s03.emphone, ((SubPlan 55)), (CASE WHEN dispatcher.pl_is_critical(s03.parcelno, s03.service, s03.sdate) THEN 1 ELSE 0 END), ((dispatcher.pl_is_delay_v2(s03.parcelno, s03.service, s03.sdate, s03.lorry))::text), s03.lorry, s03.stime, s14.stime, s13.stime, s03.parcelno, s03.id, ((SubPlan 56)), ((SubPlan 57)), ((SubPlan 58)), (CASE WHEN ((SubPlan 60) IS NOT N (...)
252. 0.000 0.000 ↓ 0.0

Append (cost=79.95..791,492.94 rows=58 width=290) (actual rows= loops=)

253. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=79.95..768,482.07 rows=1 width=309) (actual rows= loops=)

254. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=79.54..768,139.31 rows=1 width=258) (actual rows= loops=)

255. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=78.97..768,131.41 rows=1 width=240) (actual rows= loops=)

  • Filter: (s23.id IS NULL)
256. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=78.97..768,130.23 rows=1 width=240) (actual rows= loops=)

257. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=78.97..768,129.13 rows=1 width=134) (actual rows= loops=)

  • Hash Cond: (((s03.lorry)::text = (s13.lorry)::text) AND ((s03.parcelno)::text = (s13.parcelno)::text) AND (s03.sdate = s13.sdate))
  • Filter: (s13.id IS NULL)
258. 0.000 0.000 ↓ 0.0

Append (cost=0.00..766,794.87 rows=55,790 width=122) (actual rows= loops=)

259. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03 s03 (cost=0.00..0.00 rows=1 width=514) (actual rows= loops=)

  • Filter: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date) AND ((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 73) IS NOT NULL))
260.          

SubPlan (forSeq Scan)

261. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_2 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03.depot)::text)
262. 0.000 0.000 ↓ 0.0

Index Scan using sc03_sdate_lorry_idx on scandata03_2013 s03_1 (cost=0.14..21.16 rows=1 width=514) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 73) IS NOT NULL))
263.          

SubPlan (forIndex Scan)

264. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_2 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_1.depot)::text)
265. 0.000 0.000 ↓ 0.0

Index Scan using sc03_sdate_lorry_scandata03_2014_idx on scandata03_2014 s03_2 (cost=0.14..21.16 rows=1 width=514) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 73) IS NOT NULL))
266.          

SubPlan (forIndex Scan)

267. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_2 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_2.depot)::text)
268. 0.000 0.000 ↓ 0.0

Index Scan using sc03_2015_sdate_lorry_idx on scandata03_2015 s03_3 (cost=0.14..69.16 rows=1 width=152) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 73) IS NOT NULL))
269.          

SubPlan (forIndex Scan)

270. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_2 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_3.depot)::text)
271. 0.000 0.000 ↓ 0.0

Index Scan using sc03_2016_sdate_lorry_idx on scandata03_2016 s03_4 (cost=0.14..317.16 rows=1 width=154) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 73) IS NOT NULL))
272.          

SubPlan (forIndex Scan)

273. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_2 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_4.depot)::text)
274. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2017 s03_5 (cost=0.00..530.80 rows=1 width=154) (actual rows= loops=)

  • Filter: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date) AND ((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 73) IS NOT NULL))
275.          

SubPlan (forSeq Scan)

276. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_2 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_5.depot)::text)
277. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on scandata03_2018 s03_6 (cost=1,455.12..765,835.42 rows=55,784 width=122) (actual rows= loops=)

  • Recheck Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 73) IS NOT NULL))
278. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on scandata03_2018_sdate_idx (cost=0.00..1,441.17 rows=56,075 width=0) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
279.          

SubPlan (forBitmap Heap Scan)

280. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_2 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_6.depot)::text)
281. 0.000 0.000 ↓ 0.0

Hash (cost=70.71..70.71 rows=472 width=41) (actual rows= loops=)

282. 0.000 0.000 ↓ 0.0

Append (cost=0.00..70.71 rows=472 width=41) (actual rows= loops=)

283. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13 s13 (cost=0.00..0.00 rows=1 width=110) (actual rows= loops=)

284. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2013 s13_1 (cost=0.00..10.10 rows=10 width=110) (actual rows= loops=)

285. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2014 s13_2 (cost=0.00..10.10 rows=10 width=110) (actual rows= loops=)

286. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2015 s13_3 (cost=0.00..10.60 rows=60 width=36) (actual rows= loops=)

287. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2016 s13_4 (cost=0.00..10.60 rows=60 width=36) (actual rows= loops=)

288. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2017 s13_5 (cost=0.00..10.60 rows=60 width=36) (actual rows= loops=)

289. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2018 s13_6 (cost=0.00..18.71 rows=271 width=39) (actual rows= loops=)

290. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1.04 rows=7 width=211) (actual rows= loops=)

291. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14 s14 (cost=0.00..0.00 rows=1 width=362) (actual rows= loops=)

  • Filter: (((s03.lorry)::text = (lorry)::text) AND ((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate))
292. 0.000 0.000 ↓ 0.0

Index Scan using scandata14_2013_sdate_idx on scandata14_2013 s14_1 (cost=0.14..0.16 rows=1 width=362) (actual rows= loops=)

  • Index Cond: (sdate = s03.sdate)
  • Filter: (((s03.lorry)::text = (lorry)::text) AND ((parcelno)::text = (s03.parcelno)::text))
293. 0.000 0.000 ↓ 0.0

Index Scan using scandata14_2014_sdate_lorry_idx on scandata14_2014 s14_2 (cost=0.14..0.16 rows=1 width=362) (actual rows= loops=)

  • Index Cond: ((sdate = s03.sdate) AND ((s03.lorry)::text = (lorry)::text))
  • Filter: ((parcelno)::text = (s03.parcelno)::text)
294. 0.000 0.000 ↓ 0.0

Index Scan using scandata14_2015_sdate_lorry_idx on scandata14_2015 s14_3 (cost=0.14..0.17 rows=1 width=99) (actual rows= loops=)

  • Index Cond: ((sdate = s03.sdate) AND ((s03.lorry)::text = (lorry)::text))
  • Filter: ((parcelno)::text = (s03.parcelno)::text)
295. 0.000 0.000 ↓ 0.0

Index Scan using scandata14_2016_sdate_idx on scandata14_2016 s14_4 (cost=0.14..0.19 rows=1 width=105) (actual rows= loops=)

  • Index Cond: (sdate = s03.sdate)
  • Filter: (((s03.lorry)::text = (lorry)::text) AND ((parcelno)::text = (s03.parcelno)::text))
296. 0.000 0.000 ↓ 0.0

Index Scan using scandata14_2017_sdate_lorry_idx on scandata14_2017 s14_5 (cost=0.14..0.19 rows=1 width=94) (actual rows= loops=)

  • Index Cond: ((sdate = s03.sdate) AND ((s03.lorry)::text = (lorry)::text))
  • Filter: ((parcelno)::text = (s03.parcelno)::text)
297. 0.000 0.000 ↓ 0.0

Index Scan using scandata14_2018_sdate_lorry_idx on scandata14_2018 s14_6 (cost=0.14..0.17 rows=1 width=95) (actual rows= loops=)

  • Index Cond: ((sdate = s03.sdate) AND ((s03.lorry)::text = (lorry)::text))
  • Filter: ((parcelno)::text = (s03.parcelno)::text)
298. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1.12 rows=6 width=41) (actual rows= loops=)

299. 0.000 0.000 ↓ 0.0

Seq Scan on scandata23 s23 (cost=0.00..0.00 rows=1 width=70) (actual rows= loops=)

  • Filter: (((s03.lorry)::text = (lorry)::text) AND ((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate))
300. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2014_sdate_idx on scandata23_2014 s23_1 (cost=0.14..0.16 rows=1 width=70) (actual rows= loops=)

  • Index Cond: (sdate = s03.sdate)
  • Filter: (((s03.lorry)::text = (lorry)::text) AND ((parcelno)::text = (s03.parcelno)::text))
301. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2015_sdate_idx on scandata23_2015 s23_2 (cost=0.13..0.15 rows=1 width=27) (actual rows= loops=)

  • Index Cond: (sdate = s03.sdate)
  • Filter: (((s03.lorry)::text = (lorry)::text) AND ((parcelno)::text = (s03.parcelno)::text))
302. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2016_pl_indx on scandata23_2016 s23_3 (cost=0.28..0.31 rows=1 width=27) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
  • Filter: (((s03.lorry)::text = (lorry)::text) AND (sdate = s03.sdate))
303. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2017_pl_indx on scandata23_2017 s23_4 (cost=0.28..0.33 rows=1 width=27) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
  • Filter: (((s03.lorry)::text = (lorry)::text) AND (sdate = s03.sdate))
304. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2018_pl_indx on scandata23_2018 s23_5 (cost=0.14..0.16 rows=1 width=27) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
  • Filter: (((s03.lorry)::text = (lorry)::text) AND (sdate = s03.sdate))
305. 0.000 0.000 ↓ 0.0

Index Scan using plnum_customerno_pkey on plnum_customerno plcus (cost=0.56..7.89 rows=1 width=33) (actual rows= loops=)

  • Index Cond: ((pl_number)::text = (s03.parcelno)::text)
306. 0.000 0.000 ↓ 0.0

Index Scan using customers_dsw_pri_key on customers_dsw cus_1 (cost=0.42..0.44 rows=1 width=69) (actual rows= loops=)

  • Index Cond: ((customerno)::text = (plcus.customerno)::text)
307.          

SubPlan (forNested Loop Left Join)

308. 0.000 0.000 ↓ 0.0

Limit (cost=13.99..13.99 rows=1 width=8) (actual rows= loops=)

309. 0.000 0.000 ↓ 0.0

Sort (cost=13.99..13.99 rows=1 width=8) (actual rows= loops=)

  • Sort Key: so_4.stoporder
310. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..13.98 rows=1 width=8) (actual rows= loops=)

  • Join Filter: (so_4.id = soe_4.stoporder_id)
311. 0.000 0.000 ↓ 0.0

Index Scan using stoporder_elements_idx on stoporder_elements soe_4 (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((reference)::text = (s03.parcelno)::text)
  • Filter: ((reference_type)::text = 'SA'::text)
312. 0.000 0.000 ↓ 0.0

Seq Scan on stoporder so_4 (cost=0.00..5.63 rows=2 width=12) (actual rows= loops=)

  • Filter: ((date = s03.sdate) AND ((tour)::text = (s03.lorry)::text))
313. 0.000 0.000 ↓ 0.0

Aggregate (cost=26.89..26.90 rows=1 width=15) (actual rows= loops=)

314. 0.000 0.000 ↓ 0.0

Append (cost=0.00..26.87 rows=5 width=15) (actual rows= loops=)

315. 0.000 0.000 ↓ 0.0

Seq Scan on bericht bericht_2 (cost=0.00..1.01 rows=1 width=15) (actual rows= loops=)

  • Filter: ((type_of_scan = ANY ('{13,14}'::bpchar[])) AND ((pl_number)::text = (s03.parcelno)::text))
316. 0.000 0.000 ↓ 0.0

Index Only Scan using index_bericht_2015_sa_pl_year on bericht_2015 bericht_2015_2 (cost=0.38..8.39 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (pl_number = (s03.parcelno)::text)
  • Filter: (type_of_scan = ANY ('{13,14}'::bpchar[]))
317. 0.000 0.000 ↓ 0.0

Index Only Scan using index_bericht_2016_sa_pl_year on bericht_2016 bericht_2016_2 (cost=0.12..4.15 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (pl_number = (s03.parcelno)::text)
  • Filter: (type_of_scan = ANY ('{13,14}'::bpchar[]))
318. 0.000 0.000 ↓ 0.0

Index Only Scan using index_bericht_2017_sa_pl_year on bericht_2017 bericht_2017_2 (cost=0.56..4.68 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (pl_number = (s03.parcelno)::text)
  • Filter: (type_of_scan = ANY ('{13,14}'::bpchar[]))
319. 0.000 0.000 ↓ 0.0

Index Only Scan using index_bericht_2018_sa_pl_year on bericht_2018 bericht_2018_2 (cost=0.56..8.64 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (pl_number = (s03.parcelno)::text)
  • Filter: (type_of_scan = ANY ('{13,14}'::bpchar[]))
320. 0.000 0.000 ↓ 0.0

Aggregate (cost=24.80..24.81 rows=1 width=8) (actual rows= loops=)

321. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.72..24.80 rows=1 width=8) (actual rows= loops=)

  • Filter: (s.id IS NULL)
322. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.57..16.62 rows=1 width=12) (actual rows= loops=)

  • Filter: (rs.id IS NULL)
323. 0.000 0.000 ↓ 0.0

Index Scan using self_bk_lists_pl_number_index on self_bk_lists bk (cost=0.42..8.45 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((pl_number)::text = (s03.parcelno)::text)
  • Filter: (insert_date > (('now'::cstring)::date - 180))
324. 0.000 0.000 ↓ 0.0

Index Scan using return_to_sender__self_bk_lists_id on return_to_sender rs (cost=0.15..8.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (self_bk_lists_id = bk.id)
325. 0.000 0.000 ↓ 0.0

Index Scan using storno__self_bk_lists_id_idx on storno s (cost=0.15..8.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (self_bk_lists_id = bk.id)
326. 0.000 0.000 ↓ 0.0

Aggregate (cost=56.79..56.80 rows=1 width=14) (actual rows= loops=)

327. 0.000 0.000 ↓ 0.0

Append (cost=0.00..56.72 rows=7 width=14) (actual rows= loops=)

328. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13 scandata13_4 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03.parcelno)::text)
329. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2013_pl_indx on scandata13_2013 scandata13_2013_4 (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
330. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2014_pl_indx on scandata13_2014 scandata13_2014_4 (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
331. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2015 scandata13_2015_4 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03.parcelno)::text)
332. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2016 scandata13_2016_4 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03.parcelno)::text)
333. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2017 scandata13_2017_4 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03.parcelno)::text)
334. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2018_pl_indx on scandata13_2018 scandata13_2018_4 (cost=0.15..8.17 rows=1 width=1) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
335. 0.000 0.000 ↓ 0.0

Aggregate (cost=56.79..56.80 rows=1 width=14) (actual rows= loops=)

336. 0.000 0.000 ↓ 0.0

Append (cost=0.00..56.72 rows=7 width=14) (actual rows= loops=)

337. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13 scandata13_5 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03.parcelno)::text)
338. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2013_pl_indx on scandata13_2013 scandata13_2013_5 (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
339. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2014_pl_indx on scandata13_2014 scandata13_2014_5 (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
340. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2015 scandata13_2015_5 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03.parcelno)::text)
341. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2016 scandata13_2016_5 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03.parcelno)::text)
342. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2017 scandata13_2017_5 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03.parcelno)::text)
343. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2018_pl_indx on scandata13_2018 scandata13_2018_5 (cost=0.15..8.17 rows=1 width=1) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
344. 0.000 0.000 ↓ 0.0

Result (cost=8.23..8.24 rows=1 width=0) (actual rows= loops=)

345.          

Initplan (forResult)

346. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..8.23 rows=1 width=28) (actual rows= loops=)

347. 0.000 0.000 ↓ 0.0

Result (cost=0.00..57.64 rows=7 width=28) (actual rows= loops=)

348. 0.000 0.000 ↓ 0.0

Append (cost=0.00..57.64 rows=7 width=28) (actual rows= loops=)

349. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13 scandata13_6 (cost=0.00..0.00 rows=1 width=46) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate) AND ((s03.lorry)::text = (lorry)::text))
350. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2013_sdate_idx on scandata13_2013 scandata13_2013_6 (cost=0.14..8.16 rows=1 width=46) (actual rows= loops=)

  • Index Cond: (sdate = s03.sdate)
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03.parcelno)::text) AND ((s03.lorry)::text = (lorry)::text))
351. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2014_sdate_idx on scandata13_2014 scandata13_2014_6 (cost=0.14..8.16 rows=1 width=46) (actual rows= loops=)

  • Index Cond: (sdate = s03.sdate)
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03.parcelno)::text) AND ((s03.lorry)::text = (lorry)::text))
352. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2015 scandata13_2015_6 (cost=0.00..11.05 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate) AND ((s03.lorry)::text = (lorry)::text))
353. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2016 scandata13_2016_6 (cost=0.00..11.05 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate) AND ((s03.lorry)::text = (lorry)::text))
354. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2017 scandata13_2017_6 (cost=0.00..11.05 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate) AND ((s03.lorry)::text = (lorry)::text))
355. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2018_sdate_lorry_idx on scandata13_2018 scandata13_2018_6 (cost=0.15..8.17 rows=1 width=15) (actual rows= loops=)

  • Index Cond: ((sdate = s03.sdate) AND ((s03.lorry)::text = (lorry)::text))
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03.parcelno)::text))
356. 0.000 0.000 ↓ 0.0

Result (cost=7.39..7.40 rows=1 width=0) (actual rows= loops=)

357.          

Initplan (forResult)

358. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..7.39 rows=1 width=28) (actual rows= loops=)

359. 0.000 0.000 ↓ 0.0

Result (cost=0.00..51.74 rows=7 width=28) (actual rows= loops=)

360. 0.000 0.000 ↓ 0.0

Append (cost=0.00..51.74 rows=7 width=28) (actual rows= loops=)

361. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14 scandata14_2 (cost=0.00..0.00 rows=1 width=46) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate) AND ((s03.lorry)::text = (lorry)::text))
362. 0.000 0.000 ↓ 0.0

Index Scan using scandata14_2013_sdate_idx on scandata14_2013 scandata14_2013_2 (cost=0.14..8.16 rows=1 width=46) (actual rows= loops=)

  • Index Cond: (sdate = s03.sdate)
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03.parcelno)::text) AND ((s03.lorry)::text = (lorry)::text))
363. 0.000 0.000 ↓ 0.0

Index Scan using scandata14_2014_sdate_lorry_idx on scandata14_2014 scandata14_2014_2 (cost=0.14..8.16 rows=1 width=46) (actual rows= loops=)

  • Index Cond: ((sdate = s03.sdate) AND ((s03.lorry)::text = (lorry)::text))
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03.parcelno)::text))
364. 0.000 0.000 ↓ 0.0

Index Scan using scandata14_2015_sdate_lorry_idx on scandata14_2015 scandata14_2015_2 (cost=0.14..8.16 rows=1 width=15) (actual rows= loops=)

  • Index Cond: ((sdate = s03.sdate) AND ((s03.lorry)::text = (lorry)::text))
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03.parcelno)::text))
365. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2016 scandata14_2016_2 (cost=0.00..11.22 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate) AND ((s03.lorry)::text = (lorry)::text))
366. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2017 scandata14_2017_2 (cost=0.00..10.88 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate) AND ((s03.lorry)::text = (lorry)::text))
367. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2018 scandata14_2018_2 (cost=0.00..5.16 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate) AND ((s03.lorry)::text = (lorry)::text))
368. 0.000 0.000 ↓ 0.0

Aggregate (cost=56.74..56.75 rows=1 width=14) (actual rows= loops=)

369. 0.000 0.000 ↓ 0.0

Append (cost=0.00..56.72 rows=7 width=14) (actual rows= loops=)

370. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13 scandata13_7 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03.parcelno)::text)
371. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2013_pl_indx on scandata13_2013 scandata13_2013_7 (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
372. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2014_pl_indx on scandata13_2014 scandata13_2014_7 (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
373. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2015 scandata13_2015_7 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03.parcelno)::text)
374. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2016 scandata13_2016_7 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03.parcelno)::text)
375. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2017 scandata13_2017_7 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03.parcelno)::text)
376. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2018_pl_indx on scandata13_2018 scandata13_2018_7 (cost=0.15..8.17 rows=1 width=1) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
377. 0.000 0.000 ↓ 0.0

Aggregate (cost=19.58..19.59 rows=1 width=13) (actual rows= loops=)

378. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.55..19.33 rows=1 width=13) (actual rows= loops=)

379. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.12..18.70 rows=1 width=4) (actual rows= loops=)

380. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.69..18.10 rows=1 width=4) (actual rows= loops=)

381. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.40..17.76 rows=1 width=8) (actual rows= loops=)

382. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..16.90 rows=1 width=25) (actual rows= loops=)

383. 0.000 0.000 ↓ 0.0

Index Scan using parcel_parcelnumber_idx on parcel pa_4 (cost=0.42..8.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((parcelnumber)::text = (s03.parcelno)::text)
384. 0.000 0.000 ↓ 0.0

Index Scan using shipment_id_idx on shipment sh_8 (cost=0.42..8.45 rows=1 width=29) (actual rows= loops=)

  • Index Cond: (id = pa_4.shipment_id)
385. 0.000 0.000 ↓ 0.0

Index Scan using shipment_mps_mpsid_idx on shipment sh_9 (cost=0.55..0.86 rows=1 width=33) (actual rows= loops=)

  • Index Cond: ((mps_mpsid)::text = (sh_8.mps_mpsid)::text)
386. 0.000 0.000 ↓ 0.0

Index Only Scan using header_id_idx on header h_2 (cost=0.29..0.33 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = sh_9.header_id)
387. 0.000 0.000 ↓ 0.0

Index Only Scan using sender_shipment_id_idx on sender se_2 (cost=0.43..0.59 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (shipment_id = (sh_9.id)::bigint)
388. 0.000 0.000 ↓ 0.0

Index Scan using receiver_shipment_id_int_idx on receiver re_2 (cost=0.43..0.62 rows=1 width=21) (actual rows= loops=)

  • Index Cond: ((shipment_id)::integer = sh_9.id)
389. 0.000 0.000 ↓ 0.0

Aggregate (cost=18.32..18.33 rows=1 width=6) (actual rows= loops=)

390. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.67..18.07 rows=1 width=6) (actual rows= loops=)

391. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.40..17.76 rows=1 width=4) (actual rows= loops=)

392. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..16.90 rows=1 width=25) (actual rows= loops=)

393. 0.000 0.000 ↓ 0.0

Index Scan using parcel_parcelnumber_idx on parcel pa_5 (cost=0.42..8.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((parcelnumber)::text = (s03.parcelno)::text)
394. 0.000 0.000 ↓ 0.0

Index Scan using shipment_id_idx on shipment sh_10 (cost=0.42..8.45 rows=1 width=29) (actual rows= loops=)

  • Index Cond: (id = pa_5.shipment_id)
395. 0.000 0.000 ↓ 0.0

Index Scan using shipment_mps_mpsid_idx on shipment sh_11 (cost=0.55..0.86 rows=1 width=29) (actual rows= loops=)

  • Index Cond: ((mps_mpsid)::text = (sh_10.mps_mpsid)::text)
396. 0.000 0.000 ↓ 0.0

Index Scan using pers_shipment_id_idx on pers pe_2 (cost=0.28..0.30 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (shipment_id = sh_11.id)
397. 0.000 0.000 ↓ 0.0

Limit (cost=0.25..0.26 rows=1 width=8) (actual rows= loops=)

398. 0.000 0.000 ↓ 0.0

Function Scan on pl_timeframe pl_timeframe_4 (cost=0.25..10.25 rows=1,000 width=8) (actual rows= loops=)

399. 0.000 0.000 ↓ 0.0

Limit (cost=0.25..0.26 rows=1 width=8) (actual rows= loops=)

400. 0.000 0.000 ↓ 0.0

Function Scan on pl_timeframe pl_timeframe_5 (cost=0.25..10.25 rows=1,000 width=8) (actual rows= loops=)

401. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..8.17 rows=1 width=20) (actual rows= loops=)

402. 0.000 0.000 ↓ 0.0

Append (cost=0.00..57.16 rows=7 width=20) (actual rows= loops=)

403. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03 scandata03_6 (cost=0.00..0.00 rows=1 width=36) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate))
404. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2013_sdate_idx on scandata03_2013 scandata03_2013_6 (cost=0.14..8.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (sdate = s03.sdate)
  • Filter: ((parcelno)::text = (s03.parcelno)::text)
405. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2014_pl_indx on scandata03_2014 scandata03_2014_6 (cost=0.14..8.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
  • Filter: (sdate = s03.sdate)
406. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2015 scandata03_2015_6 (cost=0.00..10.90 rows=1 width=7) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate))
407. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2016 scandata03_2016_6 (cost=0.00..10.90 rows=1 width=7) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate))
408. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2017 scandata03_2017_6 (cost=0.00..10.60 rows=1 width=9) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate))
409. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2018_pl_indx on scandata03_2018 scandata03_2018_6 (cost=0.42..8.45 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
  • Filter: (sdate = s03.sdate)
410. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..8.17 rows=1 width=20) (actual rows= loops=)

411. 0.000 0.000 ↓ 0.0

Append (cost=0.00..57.16 rows=7 width=20) (actual rows= loops=)

412. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03 scandata03_7 (cost=0.00..0.00 rows=1 width=36) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate))
413. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2013_sdate_idx on scandata03_2013 scandata03_2013_7 (cost=0.14..8.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (sdate = s03.sdate)
  • Filter: ((parcelno)::text = (s03.parcelno)::text)
414. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2014_pl_indx on scandata03_2014 scandata03_2014_7 (cost=0.14..8.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
  • Filter: (sdate = s03.sdate)
415. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2015 scandata03_2015_7 (cost=0.00..10.90 rows=1 width=7) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate))
416. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2016 scandata03_2016_7 (cost=0.00..10.90 rows=1 width=7) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate))
417. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2017 scandata03_2017_7 (cost=0.00..10.60 rows=1 width=9) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03.parcelno)::text) AND (sdate = s03.sdate))
418. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2018_pl_indx on scandata03_2018 scandata03_2018_7 (cost=0.42..8.45 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
  • Filter: (sdate = s03.sdate)
419. 0.000 0.000 ↓ 0.0

Aggregate (cost=12.88..12.89 rows=1 width=4) (actual rows= loops=)

420. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..12.88 rows=1 width=4) (actual rows= loops=)

421. 0.000 0.000 ↓ 0.0

Index Only Scan using event_pri_key on event e_2 (cost=0.68..4.70 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = varchar_clean_to_int(COALESCE(s14.eventid, s03.eventid)))
422. 0.000 0.000 ↓ 0.0

Index Scan using mdu_media_id_idx on media m_2 (cost=0.14..8.16 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = e_2.media_id)
423. 0.000 0.000 ↓ 0.0

Limit (cost=8.45..8.46 rows=1 width=12) (actual rows= loops=)

424. 0.000 0.000 ↓ 0.0

Sort (cost=8.45..8.46 rows=1 width=12) (actual rows= loops=)

  • Sort Key: detour_avis_2.insert_date
425. 0.000 0.000 ↓ 0.0

Index Scan using dta_plno_idx on detour_avis detour_avis_2 (cost=0.42..8.44 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03.parcelno)::text)
426. 0.000 0.000 ↓ 0.0

Limit (cost=13.97..13.97 rows=1 width=4) (actual rows= loops=)

427. 0.000 0.000 ↓ 0.0

Sort (cost=13.97..13.97 rows=1 width=4) (actual rows= loops=)

  • Sort Key: so_5.stoporder
428. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..13.96 rows=1 width=4) (actual rows= loops=)

  • Join Filter: (so_5.id = soe_5.stoporder_id)
429. 0.000 0.000 ↓ 0.0

Index Scan using stoporder_elements_idx on stoporder_elements soe_5 (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((reference)::text = (s03.parcelno)::text)
  • Filter: ((reference_type)::text = 'SA'::text)
430. 0.000 0.000 ↓ 0.0

Seq Scan on stoporder so_5 (cost=0.00..5.63 rows=2 width=8) (actual rows= loops=)

  • Filter: ((date = s03.sdate) AND ((tour)::text = (s03.lorry)::text))
431. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2_1 (cost=63.14..20,976.58 rows=51 width=276) (actual rows= loops=)

432. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=63.14..20,976.07 rows=51 width=276) (actual rows= loops=)

433. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=63.14..1,724.04 rows=51 width=212) (actual rows= loops=)

434. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=62.72..1,701.32 rows=51 width=161) (actual rows= loops=)

435. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=62.16..1,263.10 rows=51 width=143) (actual rows= loops=)

  • Hash Cond: (((s03_7.lorry)::text = (s14_7.lorry)::text) AND ((s03_7.parcelno)::text = (s14_7.parcelno)::text) AND (s03_7.sdate = s14_7.sdate))
436. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1,196.32 rows=51 width=116) (actual rows= loops=)

437. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13 s03_7 (cost=0.00..0.00 rows=1 width=442) (actual rows= loops=)

  • Filter: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date) AND ((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 53) IS NOT NULL))
438.          

SubPlan (forSeq Scan)

439. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_1 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_7.depot)::text)
440. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2013_sdate_idx on scandata13_2013 s03_8 (cost=0.14..21.16 rows=1 width=442) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 53) IS NOT NULL))
441.          

SubPlan (forIndex Scan)

442. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_1 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_8.depot)::text)
443. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2014_sdate_lorry_idx on scandata13_2014 s03_9 (cost=0.14..21.16 rows=1 width=442) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 53) IS NOT NULL))
444.          

SubPlan (forIndex Scan)

445. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_1 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_9.depot)::text)
446. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2015_sdate_lorry_idx on scandata13_2015 s03_10 (cost=0.14..61.16 rows=1 width=146) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 53) IS NOT NULL))
447.          

SubPlan (forIndex Scan)

448. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_1 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_10.depot)::text)
449. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2016_sdate_lorry_idx on scandata13_2016 s03_11 (cost=0.14..237.16 rows=1 width=149) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 53) IS NOT NULL))
450.          

SubPlan (forIndex Scan)

451. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_1 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_11.depot)::text)
452. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2017_sdate_lorry_idx on scandata13_2017 s03_12 (cost=0.14..249.16 rows=1 width=151) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 53) IS NOT NULL))
453.          

SubPlan (forIndex Scan)

454. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_1 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_12.depot)::text)
455. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on scandata13_2018 s03_13 (cost=4.61..606.51 rows=45 width=92) (actual rows= loops=)

  • Recheck Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 53) IS NOT NULL))
456. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on scandata13_2018_sdate_lorry_idx (cost=0.00..4.60 rows=45 width=0) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
457.          

SubPlan (forBitmap Heap Scan)

458. 0.000 0.000 ↓ 0.0

Function Scan on depo_right depo_right_1 (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_13.depot)::text)
459. 0.000 0.000 ↓ 0.0

Hash (cost=56.96..56.96 rows=297 width=55) (actual rows= loops=)

460. 0.000 0.000 ↓ 0.0

Append (cost=0.00..56.96 rows=297 width=55) (actual rows= loops=)

461. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14 s14_7 (cost=0.00..0.00 rows=1 width=138) (actual rows= loops=)

462. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2013 s14_8 (cost=0.00..10.20 rows=20 width=138) (actual rows= loops=)

463. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2014 s14_9 (cost=0.00..10.20 rows=20 width=138) (actual rows= loops=)

464. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2015 s14_10 (cost=0.00..10.70 rows=70 width=40) (actual rows= loops=)

465. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2016 s14_11 (cost=0.00..10.70 rows=70 width=41) (actual rows= loops=)

466. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2017 s14_12 (cost=0.00..10.50 rows=50 width=45) (actual rows= loops=)

467. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2018 s14_13 (cost=0.00..4.66 rows=66 width=41) (actual rows= loops=)

468. 0.000 0.000 ↓ 0.0

Index Scan using plnum_customerno_pkey on plnum_customerno plcus_1 (cost=0.56..8.58 rows=1 width=33) (actual rows= loops=)

  • Index Cond: ((pl_number)::text = (s03_7.parcelno)::text)
469. 0.000 0.000 ↓ 0.0

Index Scan using customers_dsw_pri_key on customers_dsw cus_2 (cost=0.42..0.44 rows=1 width=69) (actual rows= loops=)

  • Index Cond: ((customerno)::text = (plcus_1.customerno)::text)
470. 0.000 0.000 ↓ 0.0

Append (cost=0.00..43.29 rows=7 width=172) (actual rows= loops=)

471. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03 rs03 (cost=0.00..0.00 rows=1 width=290) (actual rows= loops=)

  • Filter: (((lorry)::text = (s03_7.lorry)::text) AND ((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
472. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2013_sdate_idx on scandata03_2013 rs03_1 (cost=0.14..1.02 rows=1 width=290) (actual rows= loops=)

  • Index Cond: (sdate = s03_7.sdate)
  • Filter: (((lorry)::text = (s03_7.lorry)::text) AND ((parcelno)::text = (s03_7.parcelno)::text))
473. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2014_pl_indx on scandata03_2014 rs03_2 (cost=0.14..1.02 rows=1 width=290) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
  • Filter: (((lorry)::text = (s03_7.lorry)::text) AND (sdate = s03_7.sdate))
474. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2015 rs03_3 (cost=0.00..11.05 rows=1 width=82) (actual rows= loops=)

  • Filter: (((lorry)::text = (s03_7.lorry)::text) AND ((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
475. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2016 rs03_4 (cost=0.00..11.05 rows=1 width=84) (actual rows= loops=)

  • Filter: (((lorry)::text = (s03_7.lorry)::text) AND ((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
476. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2017 rs03_5 (cost=0.00..10.70 rows=1 width=81) (actual rows= loops=)

  • Filter: (((lorry)::text = (s03_7.lorry)::text) AND ((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
477. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2018_pl_indx on scandata03_2018 rs03_6 (cost=0.42..8.45 rows=1 width=87) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
  • Filter: (((lorry)::text = (s03_7.lorry)::text) AND (sdate = s03_7.sdate))
478.          

SubPlan (forNested Loop Left Join)

479. 0.000 0.000 ↓ 0.0

Limit (cost=13.99..13.99 rows=1 width=8) (actual rows= loops=)

480. 0.000 0.000 ↓ 0.0

Sort (cost=13.99..13.99 rows=1 width=8) (actual rows= loops=)

  • Sort Key: so_2.stoporder
481. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..13.98 rows=1 width=8) (actual rows= loops=)

  • Join Filter: (so_2.id = soe_2.stoporder_id)
482. 0.000 0.000 ↓ 0.0

Index Scan using stoporder_elements_idx on stoporder_elements soe_2 (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((reference)::text = (s03_7.parcelno)::text)
  • Filter: ((reference_type)::text = 'SA'::text)
483. 0.000 0.000 ↓ 0.0

Seq Scan on stoporder so_2 (cost=0.00..5.63 rows=2 width=12) (actual rows= loops=)

  • Filter: ((date = s03_7.sdate) AND ((tour)::text = (s03_7.lorry)::text))
484. 0.000 0.000 ↓ 0.0

Aggregate (cost=26.89..26.90 rows=1 width=15) (actual rows= loops=)

485. 0.000 0.000 ↓ 0.0

Append (cost=0.00..26.87 rows=5 width=15) (actual rows= loops=)

486. 0.000 0.000 ↓ 0.0

Seq Scan on bericht bericht_1 (cost=0.00..1.01 rows=1 width=15) (actual rows= loops=)

  • Filter: ((type_of_scan = ANY ('{13,14}'::bpchar[])) AND ((pl_number)::text = (s03_7.parcelno)::text))
487. 0.000 0.000 ↓ 0.0

Index Only Scan using index_bericht_2015_sa_pl_year on bericht_2015 bericht_2015_1 (cost=0.38..8.39 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (pl_number = (s03_7.parcelno)::text)
  • Filter: (type_of_scan = ANY ('{13,14}'::bpchar[]))
488. 0.000 0.000 ↓ 0.0

Index Only Scan using index_bericht_2016_sa_pl_year on bericht_2016 bericht_2016_1 (cost=0.12..4.15 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (pl_number = (s03_7.parcelno)::text)
  • Filter: (type_of_scan = ANY ('{13,14}'::bpchar[]))
489. 0.000 0.000 ↓ 0.0

Index Only Scan using index_bericht_2017_sa_pl_year on bericht_2017 bericht_2017_1 (cost=0.56..4.68 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (pl_number = (s03_7.parcelno)::text)
  • Filter: (type_of_scan = ANY ('{13,14}'::bpchar[]))
490. 0.000 0.000 ↓ 0.0

Index Only Scan using index_bericht_2018_sa_pl_year on bericht_2018 bericht_2018_1 (cost=0.56..8.64 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (pl_number = (s03_7.parcelno)::text)
  • Filter: (type_of_scan = ANY ('{13,14}'::bpchar[]))
491. 0.000 0.000 ↓ 0.0

Aggregate (cost=8.45..8.46 rows=1 width=8) (actual rows= loops=)

492. 0.000 0.000 ↓ 0.0

Index Scan using self_bk_lists_pl_number_index on self_bk_lists self_bk_lists_1 (cost=0.42..8.45 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((pl_number)::text = (s03_7.parcelno)::text)
  • Filter: (insert_date > (('now'::cstring)::date - 180))
493. 0.000 0.000 ↓ 0.0

Aggregate (cost=56.79..56.80 rows=1 width=14) (actual rows= loops=)

494. 0.000 0.000 ↓ 0.0

Append (cost=0.00..56.72 rows=7 width=14) (actual rows= loops=)

495. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_7.parcelno)::text)
496. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2013_pl_indx on scandata13_2013 (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
497. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2014_pl_indx on scandata13_2014 (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
498. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2015 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_7.parcelno)::text)
499. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2016 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_7.parcelno)::text)
500. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2017 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_7.parcelno)::text)
501. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2018_pl_indx on scandata13_2018 (cost=0.15..8.17 rows=1 width=1) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
502. 0.000 0.000 ↓ 0.0

Aggregate (cost=56.79..56.80 rows=1 width=14) (actual rows= loops=)

503. 0.000 0.000 ↓ 0.0

Append (cost=0.00..56.72 rows=7 width=14) (actual rows= loops=)

504. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13 scandata13_1 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_7.parcelno)::text)
505. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2013_pl_indx on scandata13_2013 scandata13_2013_1 (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
506. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2014_pl_indx on scandata13_2014 scandata13_2014_1 (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
507. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2015 scandata13_2015_1 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_7.parcelno)::text)
508. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2016 scandata13_2016_1 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_7.parcelno)::text)
509. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2017 scandata13_2017_1 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_7.parcelno)::text)
510. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2018_pl_indx on scandata13_2018 scandata13_2018_1 (cost=0.15..8.17 rows=1 width=1) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
511. 0.000 0.000 ↓ 0.0

Result (cost=8.23..8.24 rows=1 width=0) (actual rows= loops=)

512.          

Initplan (forResult)

513. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..8.23 rows=1 width=28) (actual rows= loops=)

514. 0.000 0.000 ↓ 0.0

Result (cost=0.00..57.64 rows=7 width=28) (actual rows= loops=)

515. 0.000 0.000 ↓ 0.0

Append (cost=0.00..57.64 rows=7 width=28) (actual rows= loops=)

516. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13 scandata13_2 (cost=0.00..0.00 rows=1 width=46) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate) AND ((s03_7.lorry)::text = (lorry)::text))
517. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2013_sdate_idx on scandata13_2013 scandata13_2013_2 (cost=0.14..8.16 rows=1 width=46) (actual rows= loops=)

  • Index Cond: (sdate = s03_7.sdate)
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_7.parcelno)::text) AND ((s03_7.lorry)::text = (lorry)::text))
518. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2014_sdate_idx on scandata13_2014 scandata13_2014_2 (cost=0.14..8.16 rows=1 width=46) (actual rows= loops=)

  • Index Cond: (sdate = s03_7.sdate)
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_7.parcelno)::text) AND ((s03_7.lorry)::text = (lorry)::text))
519. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2015 scandata13_2015_2 (cost=0.00..11.05 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate) AND ((s03_7.lorry)::text = (lorry)::text))
520. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2016 scandata13_2016_2 (cost=0.00..11.05 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate) AND ((s03_7.lorry)::text = (lorry)::text))
521. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2017 scandata13_2017_2 (cost=0.00..11.05 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate) AND ((s03_7.lorry)::text = (lorry)::text))
522. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2018_sdate_lorry_idx on scandata13_2018 scandata13_2018_2 (cost=0.15..8.17 rows=1 width=15) (actual rows= loops=)

  • Index Cond: ((sdate = s03_7.sdate) AND ((s03_7.lorry)::text = (lorry)::text))
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_7.parcelno)::text))
523. 0.000 0.000 ↓ 0.0

Result (cost=7.39..7.40 rows=1 width=0) (actual rows= loops=)

524.          

Initplan (forResult)

525. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..7.39 rows=1 width=28) (actual rows= loops=)

526. 0.000 0.000 ↓ 0.0

Result (cost=0.00..51.74 rows=7 width=28) (actual rows= loops=)

527. 0.000 0.000 ↓ 0.0

Append (cost=0.00..51.74 rows=7 width=28) (actual rows= loops=)

528. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14 scandata14_1 (cost=0.00..0.00 rows=1 width=46) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate) AND ((s03_7.lorry)::text = (lorry)::text))
529. 0.000 0.000 ↓ 0.0

Index Scan using scandata14_2013_sdate_idx on scandata14_2013 scandata14_2013_1 (cost=0.14..8.16 rows=1 width=46) (actual rows= loops=)

  • Index Cond: (sdate = s03_7.sdate)
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_7.parcelno)::text) AND ((s03_7.lorry)::text = (lorry)::text))
530. 0.000 0.000 ↓ 0.0

Index Scan using scandata14_2014_sdate_lorry_idx on scandata14_2014 scandata14_2014_1 (cost=0.14..8.16 rows=1 width=46) (actual rows= loops=)

  • Index Cond: ((sdate = s03_7.sdate) AND ((s03_7.lorry)::text = (lorry)::text))
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_7.parcelno)::text))
531. 0.000 0.000 ↓ 0.0

Index Scan using scandata14_2015_sdate_lorry_idx on scandata14_2015 scandata14_2015_1 (cost=0.14..8.16 rows=1 width=15) (actual rows= loops=)

  • Index Cond: ((sdate = s03_7.sdate) AND ((s03_7.lorry)::text = (lorry)::text))
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_7.parcelno)::text))
532. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2016 scandata14_2016_1 (cost=0.00..11.22 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate) AND ((s03_7.lorry)::text = (lorry)::text))
533. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2017 scandata14_2017_1 (cost=0.00..10.88 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate) AND ((s03_7.lorry)::text = (lorry)::text))
534. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2018 scandata14_2018_1 (cost=0.00..5.16 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate) AND ((s03_7.lorry)::text = (lorry)::text))
535. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..8.17 rows=1 width=19) (actual rows= loops=)

536. 0.000 0.000 ↓ 0.0

Append (cost=0.00..57.16 rows=7 width=19) (actual rows= loops=)

537. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03 scandata03_3 (cost=0.00..0.00 rows=1 width=36) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
538. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2013_sdate_idx on scandata03_2013 scandata03_2013_3 (cost=0.14..8.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (sdate = s03_7.sdate)
  • Filter: ((parcelno)::text = (s03_7.parcelno)::text)
539. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2014_pl_indx on scandata03_2014 scandata03_2014_3 (cost=0.14..8.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
  • Filter: (sdate = s03_7.sdate)
540. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2015 scandata03_2015_3 (cost=0.00..10.90 rows=1 width=5) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
541. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2016 scandata03_2016_3 (cost=0.00..10.90 rows=1 width=5) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
542. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2017 scandata03_2017_3 (cost=0.00..10.60 rows=1 width=8) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
543. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2018_pl_indx on scandata03_2018 scandata03_2018_3 (cost=0.42..8.45 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
  • Filter: (sdate = s03_7.sdate)
544. 0.000 0.000 ↓ 0.0

Aggregate (cost=56.74..56.75 rows=1 width=14) (actual rows= loops=)

545. 0.000 0.000 ↓ 0.0

Append (cost=0.00..56.72 rows=7 width=14) (actual rows= loops=)

546. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13 scandata13_3 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_7.parcelno)::text)
547. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2013_pl_indx on scandata13_2013 scandata13_2013_3 (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
548. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2014_pl_indx on scandata13_2014 scandata13_2014_3 (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
549. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2015 scandata13_2015_3 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_7.parcelno)::text)
550. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2016 scandata13_2016_3 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_7.parcelno)::text)
551. 0.000 0.000 ↓ 0.0

Seq Scan on scandata13_2017 scandata13_2017_3 (cost=0.00..10.75 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_7.parcelno)::text)
552. 0.000 0.000 ↓ 0.0

Index Scan using scandata13_2018_pl_indx on scandata13_2018 scandata13_2018_3 (cost=0.15..8.17 rows=1 width=1) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
553. 0.000 0.000 ↓ 0.0

Aggregate (cost=19.58..19.59 rows=1 width=13) (actual rows= loops=)

554. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.55..19.33 rows=1 width=13) (actual rows= loops=)

555. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.12..18.70 rows=1 width=4) (actual rows= loops=)

556. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.69..18.10 rows=1 width=4) (actual rows= loops=)

557. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.40..17.76 rows=1 width=8) (actual rows= loops=)

558. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..16.90 rows=1 width=25) (actual rows= loops=)

559. 0.000 0.000 ↓ 0.0

Index Scan using parcel_parcelnumber_idx on parcel pa_2 (cost=0.42..8.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((parcelnumber)::text = (s03_7.parcelno)::text)
560. 0.000 0.000 ↓ 0.0

Index Scan using shipment_id_idx on shipment sh_4 (cost=0.42..8.45 rows=1 width=29) (actual rows= loops=)

  • Index Cond: (id = pa_2.shipment_id)
561. 0.000 0.000 ↓ 0.0

Index Scan using shipment_mps_mpsid_idx on shipment sh_5 (cost=0.55..0.86 rows=1 width=33) (actual rows= loops=)

  • Index Cond: ((mps_mpsid)::text = (sh_4.mps_mpsid)::text)
562. 0.000 0.000 ↓ 0.0

Index Only Scan using header_id_idx on header h_1 (cost=0.29..0.33 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = sh_5.header_id)
563. 0.000 0.000 ↓ 0.0

Index Only Scan using sender_shipment_id_idx on sender se_1 (cost=0.43..0.59 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (shipment_id = (sh_5.id)::bigint)
564. 0.000 0.000 ↓ 0.0

Index Scan using receiver_shipment_id_int_idx on receiver re_1 (cost=0.43..0.62 rows=1 width=21) (actual rows= loops=)

  • Index Cond: ((shipment_id)::integer = sh_5.id)
565. 0.000 0.000 ↓ 0.0

Aggregate (cost=18.32..18.33 rows=1 width=6) (actual rows= loops=)

566. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.67..18.07 rows=1 width=6) (actual rows= loops=)

567. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.40..17.76 rows=1 width=4) (actual rows= loops=)

568. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..16.90 rows=1 width=25) (actual rows= loops=)

569. 0.000 0.000 ↓ 0.0

Index Scan using parcel_parcelnumber_idx on parcel pa_3 (cost=0.42..8.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((parcelnumber)::text = (s03_7.parcelno)::text)
570. 0.000 0.000 ↓ 0.0

Index Scan using shipment_id_idx on shipment sh_6 (cost=0.42..8.45 rows=1 width=29) (actual rows= loops=)

  • Index Cond: (id = pa_3.shipment_id)
571. 0.000 0.000 ↓ 0.0

Index Scan using shipment_mps_mpsid_idx on shipment sh_7 (cost=0.55..0.86 rows=1 width=29) (actual rows= loops=)

  • Index Cond: ((mps_mpsid)::text = (sh_6.mps_mpsid)::text)
572. 0.000 0.000 ↓ 0.0

Index Scan using pers_shipment_id_idx on pers pe_1 (cost=0.28..0.30 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (shipment_id = sh_7.id)
573. 0.000 0.000 ↓ 0.0

Limit (cost=0.25..0.26 rows=1 width=8) (actual rows= loops=)

574. 0.000 0.000 ↓ 0.0

Function Scan on pl_timeframe pl_timeframe_2 (cost=0.25..10.25 rows=1,000 width=8) (actual rows= loops=)

575. 0.000 0.000 ↓ 0.0

Limit (cost=0.25..0.26 rows=1 width=8) (actual rows= loops=)

576. 0.000 0.000 ↓ 0.0

Function Scan on pl_timeframe pl_timeframe_3 (cost=0.25..10.25 rows=1,000 width=8) (actual rows= loops=)

577. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..8.17 rows=1 width=20) (actual rows= loops=)

578. 0.000 0.000 ↓ 0.0

Append (cost=0.00..57.16 rows=7 width=20) (actual rows= loops=)

579. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03 scandata03_4 (cost=0.00..0.00 rows=1 width=36) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
580. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2013_sdate_idx on scandata03_2013 scandata03_2013_4 (cost=0.14..8.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (sdate = s03_7.sdate)
  • Filter: ((parcelno)::text = (s03_7.parcelno)::text)
581. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2014_pl_indx on scandata03_2014 scandata03_2014_4 (cost=0.14..8.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
  • Filter: (sdate = s03_7.sdate)
582. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2015 scandata03_2015_4 (cost=0.00..10.90 rows=1 width=7) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
583. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2016 scandata03_2016_4 (cost=0.00..10.90 rows=1 width=7) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
584. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2017 scandata03_2017_4 (cost=0.00..10.60 rows=1 width=9) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
585. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2018_pl_indx on scandata03_2018 scandata03_2018_4 (cost=0.42..8.45 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
  • Filter: (sdate = s03_7.sdate)
586. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..8.17 rows=1 width=20) (actual rows= loops=)

587. 0.000 0.000 ↓ 0.0

Append (cost=0.00..57.16 rows=7 width=20) (actual rows= loops=)

588. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03 scandata03_5 (cost=0.00..0.00 rows=1 width=36) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
589. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2013_sdate_idx on scandata03_2013 scandata03_2013_5 (cost=0.14..8.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (sdate = s03_7.sdate)
  • Filter: ((parcelno)::text = (s03_7.parcelno)::text)
590. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2014_pl_indx on scandata03_2014 scandata03_2014_5 (cost=0.14..8.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
  • Filter: (sdate = s03_7.sdate)
591. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2015 scandata03_2015_5 (cost=0.00..10.90 rows=1 width=7) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
592. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2016 scandata03_2016_5 (cost=0.00..10.90 rows=1 width=7) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
593. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2017 scandata03_2017_5 (cost=0.00..10.60 rows=1 width=9) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_7.parcelno)::text) AND (sdate = s03_7.sdate))
594. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2018_pl_indx on scandata03_2018 scandata03_2018_5 (cost=0.42..8.45 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
  • Filter: (sdate = s03_7.sdate)
595. 0.000 0.000 ↓ 0.0

Aggregate (cost=12.88..12.89 rows=1 width=4) (actual rows= loops=)

596. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..12.88 rows=1 width=4) (actual rows= loops=)

597. 0.000 0.000 ↓ 0.0

Index Only Scan using event_pri_key on event e_1 (cost=0.68..4.70 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = varchar_clean_to_int(COALESCE(s14_7.eventid, s03_7.eventid)))
598. 0.000 0.000 ↓ 0.0

Index Scan using mdu_media_id_idx on media m_1 (cost=0.14..8.16 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = e_1.media_id)
599. 0.000 0.000 ↓ 0.0

Limit (cost=8.45..8.46 rows=1 width=12) (actual rows= loops=)

600. 0.000 0.000 ↓ 0.0

Sort (cost=8.45..8.46 rows=1 width=12) (actual rows= loops=)

  • Sort Key: detour_avis_1.insert_date
601. 0.000 0.000 ↓ 0.0

Index Scan using dta_plno_idx on detour_avis detour_avis_1 (cost=0.42..8.44 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_7.parcelno)::text)
602. 0.000 0.000 ↓ 0.0

Limit (cost=13.97..13.97 rows=1 width=4) (actual rows= loops=)

603. 0.000 0.000 ↓ 0.0

Sort (cost=13.97..13.97 rows=1 width=4) (actual rows= loops=)

  • Sort Key: so_3.stoporder
604. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..13.96 rows=1 width=4) (actual rows= loops=)

  • Join Filter: (so_3.id = soe_3.stoporder_id)
605. 0.000 0.000 ↓ 0.0

Index Scan using stoporder_elements_idx on stoporder_elements soe_3 (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((reference)::text = (s03_7.parcelno)::text)
  • Filter: ((reference_type)::text = 'SA'::text)
606. 0.000 0.000 ↓ 0.0

Seq Scan on stoporder so_3 (cost=0.00..5.63 rows=2 width=8) (actual rows= loops=)

  • Filter: ((date = s03_7.sdate) AND ((tour)::text = (s03_7.lorry)::text))
607. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 3 (cost=63.14..2,034.28 rows=6 width=404) (actual rows= loops=)

608. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=63.14..2,034.22 rows=6 width=404) (actual rows= loops=)

609. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=62.72..518.18 rows=6 width=353) (actual rows= loops=)

610. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=62.16..466.62 rows=6 width=335) (actual rows= loops=)

  • Hash Cond: (((s03_14.lorry)::text = (s14_14.lorry)::text) AND ((s03_14.parcelno)::text = (s14_14.parcelno)::text) AND (s03_14.sdate = s14_14.sdate))
611. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..403.92 rows=6 width=309) (actual rows= loops=)

612. 0.000 0.000 ↓ 0.0

Append (cost=0.00..106.09 rows=6 width=246) (actual rows= loops=)

613. 0.000 0.000 ↓ 0.0

Seq Scan on scandata23 s03_14 (cost=0.00..0.00 rows=1 width=442) (actual rows= loops=)

  • Filter: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date) AND ((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 32) IS NOT NULL))
614.          

SubPlan (forSeq Scan)

615. 0.000 0.000 ↓ 0.0

Function Scan on depo_right (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_14.depot)::text)
616. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2014_sdate_idx on scandata23_2014 s03_15 (cost=0.14..21.16 rows=1 width=442) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 32) IS NOT NULL))
617.          

SubPlan (forIndex Scan)

618. 0.000 0.000 ↓ 0.0

Function Scan on depo_right (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_15.depot)::text)
619. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2015_sdate_idx on scandata23_2015 s03_16 (cost=0.13..21.15 rows=1 width=152) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 32) IS NOT NULL))
620.          

SubPlan (forIndex Scan)

621. 0.000 0.000 ↓ 0.0

Function Scan on depo_right (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_16.depot)::text)
622. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2016_sdate_idx on scandata23_2016 s03_17 (cost=0.28..21.30 rows=1 width=159) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 32) IS NOT NULL))
623.          

SubPlan (forIndex Scan)

624. 0.000 0.000 ↓ 0.0

Function Scan on depo_right (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_17.depot)::text)
625. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2017_sdate_idx on scandata23_2017 s03_18 (cost=0.28..21.31 rows=1 width=159) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 32) IS NOT NULL))
626.          

SubPlan (forIndex Scan)

627. 0.000 0.000 ↓ 0.0

Function Scan on depo_right (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_18.depot)::text)
628. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2018_sdate_idx on scandata23_2018 s03_19 (cost=0.14..21.16 rows=1 width=119) (actual rows= loops=)

  • Index Cond: ((sdate >= '2018-11-26'::date) AND (sdate <= '2018-11-30'::date))
  • Filter: (((parcelno)::text ~~ '%%'::text) AND (pl_consignee(parcelno) ~~ '%%'::text) AND ((SubPlan 32) IS NOT NULL))
629.          

SubPlan (forIndex Scan)

630. 0.000 0.000 ↓ 0.0

Function Scan on depo_right (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: ((depo)::text = (s03_19.depot)::text)
631. 0.000 0.000 ↓ 0.0

Append (cost=0.00..49.57 rows=7 width=172) (actual rows= loops=)

632. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03 rs03_7 (cost=0.00..0.00 rows=1 width=290) (actual rows= loops=)

  • Filter: (((lorry)::text = (s03_14.lorry)::text) AND ((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate))
633. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2013_sdate_idx on scandata03_2013 rs03_8 (cost=0.14..4.16 rows=1 width=290) (actual rows= loops=)

  • Index Cond: (sdate = s03_14.sdate)
  • Filter: (((lorry)::text = (s03_14.lorry)::text) AND ((parcelno)::text = (s03_14.parcelno)::text))
634. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2014_pl_indx on scandata03_2014 rs03_9 (cost=0.14..4.16 rows=1 width=290) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_14.parcelno)::text)
  • Filter: (((lorry)::text = (s03_14.lorry)::text) AND (sdate = s03_14.sdate))
635. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2015 rs03_10 (cost=0.00..11.05 rows=1 width=82) (actual rows= loops=)

  • Filter: (((lorry)::text = (s03_14.lorry)::text) AND ((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate))
636. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2016 rs03_11 (cost=0.00..11.05 rows=1 width=84) (actual rows= loops=)

  • Filter: (((lorry)::text = (s03_14.lorry)::text) AND ((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate))
637. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2017 rs03_12 (cost=0.00..10.70 rows=1 width=81) (actual rows= loops=)

  • Filter: (((lorry)::text = (s03_14.lorry)::text) AND ((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate))
638. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2018_pl_indx on scandata03_2018 rs03_13 (cost=0.42..8.45 rows=1 width=87) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_14.parcelno)::text)
  • Filter: (((lorry)::text = (s03_14.lorry)::text) AND (sdate = s03_14.sdate))
639. 0.000 0.000 ↓ 0.0

Hash (cost=56.96..56.96 rows=297 width=55) (actual rows= loops=)

640. 0.000 0.000 ↓ 0.0

Append (cost=0.00..56.96 rows=297 width=55) (actual rows= loops=)

641. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14 s14_14 (cost=0.00..0.00 rows=1 width=138) (actual rows= loops=)

642. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2013 s14_15 (cost=0.00..10.20 rows=20 width=138) (actual rows= loops=)

643. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2014 s14_16 (cost=0.00..10.20 rows=20 width=138) (actual rows= loops=)

644. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2015 s14_17 (cost=0.00..10.70 rows=70 width=40) (actual rows= loops=)

645. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2016 s14_18 (cost=0.00..10.70 rows=70 width=41) (actual rows= loops=)

646. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2017 s14_19 (cost=0.00..10.50 rows=50 width=45) (actual rows= loops=)

647. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2018 s14_20 (cost=0.00..4.66 rows=66 width=41) (actual rows= loops=)

648. 0.000 0.000 ↓ 0.0

Index Scan using plnum_customerno_pkey on plnum_customerno plcus_2 (cost=0.56..8.58 rows=1 width=33) (actual rows= loops=)

  • Index Cond: ((pl_number)::text = (s03_14.parcelno)::text)
649. 0.000 0.000 ↓ 0.0

Index Scan using customers_dsw_pri_key on customers_dsw cus_3 (cost=0.42..0.44 rows=1 width=69) (actual rows= loops=)

  • Index Cond: ((customerno)::text = (plcus_2.customerno)::text)
650.          

SubPlan (forNested Loop Left Join)

651. 0.000 0.000 ↓ 0.0

Limit (cost=13.99..13.99 rows=1 width=8) (actual rows= loops=)

652. 0.000 0.000 ↓ 0.0

Sort (cost=13.99..13.99 rows=1 width=8) (actual rows= loops=)

  • Sort Key: so.stoporder
653. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..13.98 rows=1 width=8) (actual rows= loops=)

  • Join Filter: (so.id = soe.stoporder_id)
654. 0.000 0.000 ↓ 0.0

Index Scan using stoporder_elements_idx on stoporder_elements soe (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((reference)::text = (s03_14.parcelno)::text)
  • Filter: ((reference_type)::text = 'SA'::text)
655. 0.000 0.000 ↓ 0.0

Seq Scan on stoporder so (cost=0.00..5.63 rows=2 width=12) (actual rows= loops=)

  • Filter: ((date = s03_14.sdate) AND ((tour)::text = (s03_14.lorry)::text))
656. 0.000 0.000 ↓ 0.0

Aggregate (cost=26.89..26.90 rows=1 width=15) (actual rows= loops=)

657. 0.000 0.000 ↓ 0.0

Append (cost=0.00..26.87 rows=5 width=15) (actual rows= loops=)

658. 0.000 0.000 ↓ 0.0

Seq Scan on bericht (cost=0.00..1.01 rows=1 width=15) (actual rows= loops=)

  • Filter: ((type_of_scan = ANY ('{23,14}'::bpchar[])) AND ((pl_number)::text = (s03_14.parcelno)::text))
659. 0.000 0.000 ↓ 0.0

Index Only Scan using index_bericht_2015_sa_pl_year on bericht_2015 (cost=0.38..8.39 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (pl_number = (s03_14.parcelno)::text)
  • Filter: (type_of_scan = ANY ('{23,14}'::bpchar[]))
660. 0.000 0.000 ↓ 0.0

Index Only Scan using index_bericht_2016_sa_pl_year on bericht_2016 (cost=0.12..4.15 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (pl_number = (s03_14.parcelno)::text)
  • Filter: (type_of_scan = ANY ('{23,14}'::bpchar[]))
661. 0.000 0.000 ↓ 0.0

Index Only Scan using index_bericht_2017_sa_pl_year on bericht_2017 (cost=0.56..4.68 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (pl_number = (s03_14.parcelno)::text)
  • Filter: (type_of_scan = ANY ('{23,14}'::bpchar[]))
662. 0.000 0.000 ↓ 0.0

Index Only Scan using index_bericht_2018_sa_pl_year on bericht_2018 (cost=0.56..8.64 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (pl_number = (s03_14.parcelno)::text)
  • Filter: (type_of_scan = ANY ('{23,14}'::bpchar[]))
663. 0.000 0.000 ↓ 0.0

Aggregate (cost=8.45..8.46 rows=1 width=8) (actual rows= loops=)

664. 0.000 0.000 ↓ 0.0

Index Scan using self_bk_lists_pl_number_index on self_bk_lists (cost=0.42..8.45 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((pl_number)::text = (s03_14.parcelno)::text)
  • Filter: (insert_date > (('now'::cstring)::date - 180))
665. 0.000 0.000 ↓ 0.0

Aggregate (cost=30.52..30.53 rows=1 width=12) (actual rows= loops=)

666. 0.000 0.000 ↓ 0.0

Append (cost=0.00..30.46 rows=6 width=12) (actual rows= loops=)

667. 0.000 0.000 ↓ 0.0

Seq Scan on scandata23 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_14.parcelno)::text)
668. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2014_pl_indx on scandata23_2014 (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_14.parcelno)::text)
669. 0.000 0.000 ↓ 0.0

Seq Scan on scandata23_2015 (cost=0.00..1.05 rows=1 width=2) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_14.parcelno)::text)
670. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2016_pl_indx on scandata23_2016 (cost=0.28..8.29 rows=1 width=2) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_14.parcelno)::text)
671. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2017_pl_indx on scandata23_2017 (cost=0.28..8.30 rows=1 width=1) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_14.parcelno)::text)
672. 0.000 0.000 ↓ 0.0

Seq Scan on scandata23_2018 (cost=0.00..4.66 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_14.parcelno)::text)
673. 0.000 0.000 ↓ 0.0

Aggregate (cost=30.52..30.53 rows=1 width=12) (actual rows= loops=)

674. 0.000 0.000 ↓ 0.0

Append (cost=0.00..30.46 rows=6 width=12) (actual rows= loops=)

675. 0.000 0.000 ↓ 0.0

Seq Scan on scandata23 scandata23_1 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_14.parcelno)::text)
676. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2014_pl_indx on scandata23_2014 scandata23_2014_1 (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_14.parcelno)::text)
677. 0.000 0.000 ↓ 0.0

Seq Scan on scandata23_2015 scandata23_2015_1 (cost=0.00..1.05 rows=1 width=2) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_14.parcelno)::text)
678. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2016_pl_indx on scandata23_2016 scandata23_2016_1 (cost=0.28..8.29 rows=1 width=2) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_14.parcelno)::text)
679. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2017_pl_indx on scandata23_2017 scandata23_2017_1 (cost=0.28..8.30 rows=1 width=1) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_14.parcelno)::text)
680. 0.000 0.000 ↓ 0.0

Seq Scan on scandata23_2018 scandata23_2018_1 (cost=0.00..4.66 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_14.parcelno)::text)
681. 0.000 0.000 ↓ 0.0

Result (cost=5.13..5.14 rows=1 width=0) (actual rows= loops=)

682.          

Initplan (forResult)

683. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..5.13 rows=1 width=25) (actual rows= loops=)

684. 0.000 0.000 ↓ 0.0

Result (cost=0.00..30.77 rows=6 width=25) (actual rows= loops=)

685. 0.000 0.000 ↓ 0.0

Append (cost=0.00..30.77 rows=6 width=25) (actual rows= loops=)

686. 0.000 0.000 ↓ 0.0

Seq Scan on scandata23 scandata23_2 (cost=0.00..0.00 rows=1 width=46) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate) AND ((s03_14.lorry)::text = (lorry)::text))
687. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2014_sdate_idx on scandata23_2014 scandata23_2014_2 (cost=0.14..8.16 rows=1 width=46) (actual rows= loops=)

  • Index Cond: (sdate = s03_14.sdate)
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_14.parcelno)::text) AND ((s03_14.lorry)::text = (lorry)::text))
688. 0.000 0.000 ↓ 0.0

Seq Scan on scandata23_2015 scandata23_2015_2 (cost=0.00..1.07 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate) AND ((s03_14.lorry)::text = (lorry)::text))
689. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2016_pl_indx on scandata23_2016 scandata23_2016_2 (cost=0.28..8.30 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_14.parcelno)::text))
  • Filter: ((sdate = s03_14.sdate) AND ((s03_14.lorry)::text = (lorry)::text))
690. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2017_pl_indx on scandata23_2017 scandata23_2017_2 (cost=0.28..8.31 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_14.parcelno)::text))
  • Filter: ((sdate = s03_14.sdate) AND ((s03_14.lorry)::text = (lorry)::text))
691. 0.000 0.000 ↓ 0.0

Seq Scan on scandata23_2018 scandata23_2018_2 (cost=0.00..4.93 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate) AND ((s03_14.lorry)::text = (lorry)::text))
692. 0.000 0.000 ↓ 0.0

Result (cost=7.39..7.40 rows=1 width=0) (actual rows= loops=)

693.          

Initplan (forResult)

694. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..7.39 rows=1 width=28) (actual rows= loops=)

695. 0.000 0.000 ↓ 0.0

Result (cost=0.00..51.74 rows=7 width=28) (actual rows= loops=)

696. 0.000 0.000 ↓ 0.0

Append (cost=0.00..51.74 rows=7 width=28) (actual rows= loops=)

697. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14 (cost=0.00..0.00 rows=1 width=46) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate) AND ((s03_14.lorry)::text = (lorry)::text))
698. 0.000 0.000 ↓ 0.0

Index Scan using scandata14_2013_sdate_idx on scandata14_2013 (cost=0.14..8.16 rows=1 width=46) (actual rows= loops=)

  • Index Cond: (sdate = s03_14.sdate)
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_14.parcelno)::text) AND ((s03_14.lorry)::text = (lorry)::text))
699. 0.000 0.000 ↓ 0.0

Index Scan using scandata14_2014_sdate_lorry_idx on scandata14_2014 (cost=0.14..8.16 rows=1 width=46) (actual rows= loops=)

  • Index Cond: ((sdate = s03_14.sdate) AND ((s03_14.lorry)::text = (lorry)::text))
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_14.parcelno)::text))
700. 0.000 0.000 ↓ 0.0

Index Scan using scandata14_2015_sdate_lorry_idx on scandata14_2015 (cost=0.14..8.16 rows=1 width=15) (actual rows= loops=)

  • Index Cond: ((sdate = s03_14.sdate) AND ((s03_14.lorry)::text = (lorry)::text))
  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_14.parcelno)::text))
701. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2016 (cost=0.00..11.22 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate) AND ((s03_14.lorry)::text = (lorry)::text))
702. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2017 (cost=0.00..10.88 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate) AND ((s03_14.lorry)::text = (lorry)::text))
703. 0.000 0.000 ↓ 0.0

Seq Scan on scandata14_2018 (cost=0.00..5.16 rows=1 width=15) (actual rows= loops=)

  • Filter: (((parcelno)::text IS NOT NULL) AND ((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate) AND ((s03_14.lorry)::text = (lorry)::text))
704. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..8.17 rows=1 width=19) (actual rows= loops=)

705. 0.000 0.000 ↓ 0.0

Append (cost=0.00..57.16 rows=7 width=19) (actual rows= loops=)

706. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03 (cost=0.00..0.00 rows=1 width=36) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate))
707. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2013_sdate_idx on scandata03_2013 (cost=0.14..8.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (sdate = s03_14.sdate)
  • Filter: ((parcelno)::text = (s03_14.parcelno)::text)
708. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2014_pl_indx on scandata03_2014 (cost=0.14..8.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_14.parcelno)::text)
  • Filter: (sdate = s03_14.sdate)
709. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2015 (cost=0.00..10.90 rows=1 width=5) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate))
710. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2016 (cost=0.00..10.90 rows=1 width=5) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate))
711. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2017 (cost=0.00..10.60 rows=1 width=8) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate))
712. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2018_pl_indx on scandata03_2018 (cost=0.42..8.45 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_14.parcelno)::text)
  • Filter: (sdate = s03_14.sdate)
713. 0.000 0.000 ↓ 0.0

Aggregate (cost=30.48..30.49 rows=1 width=11) (actual rows= loops=)

714. 0.000 0.000 ↓ 0.0

Append (cost=0.00..30.46 rows=6 width=11) (actual rows= loops=)

715. 0.000 0.000 ↓ 0.0

Seq Scan on scandata23 scandata23_3 (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_14.parcelno)::text)
716. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2014_pl_indx on scandata23_2014 scandata23_2014_3 (cost=0.14..8.15 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_14.parcelno)::text)
717. 0.000 0.000 ↓ 0.0

Seq Scan on scandata23_2015 scandata23_2015_3 (cost=0.00..1.05 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_14.parcelno)::text)
718. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2016_pl_indx on scandata23_2016 scandata23_2016_3 (cost=0.28..8.29 rows=1 width=1) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_14.parcelno)::text)
719. 0.000 0.000 ↓ 0.0

Index Scan using scandata23_2017_pl_indx on scandata23_2017 scandata23_2017_3 (cost=0.28..8.30 rows=1 width=1) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_14.parcelno)::text)
720. 0.000 0.000 ↓ 0.0

Seq Scan on scandata23_2018 scandata23_2018_3 (cost=0.00..4.66 rows=1 width=1) (actual rows= loops=)

  • Filter: ((parcelno)::text = (s03_14.parcelno)::text)
721. 0.000 0.000 ↓ 0.0

Aggregate (cost=19.58..19.59 rows=1 width=13) (actual rows= loops=)

722. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.55..19.33 rows=1 width=13) (actual rows= loops=)

723. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.12..18.70 rows=1 width=4) (actual rows= loops=)

724. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.69..18.10 rows=1 width=4) (actual rows= loops=)

725. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.40..17.76 rows=1 width=8) (actual rows= loops=)

726. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..16.90 rows=1 width=25) (actual rows= loops=)

727. 0.000 0.000 ↓ 0.0

Index Scan using parcel_parcelnumber_idx on parcel pa (cost=0.42..8.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((parcelnumber)::text = (s03_14.parcelno)::text)
728. 0.000 0.000 ↓ 0.0

Index Scan using shipment_id_idx on shipment sh (cost=0.42..8.45 rows=1 width=29) (actual rows= loops=)

  • Index Cond: (id = pa.shipment_id)
729. 0.000 0.000 ↓ 0.0

Index Scan using shipment_mps_mpsid_idx on shipment sh_1 (cost=0.55..0.86 rows=1 width=33) (actual rows= loops=)

  • Index Cond: ((mps_mpsid)::text = (sh.mps_mpsid)::text)
730. 0.000 0.000 ↓ 0.0

Index Only Scan using header_id_idx on header h (cost=0.29..0.33 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = sh_1.header_id)
731. 0.000 0.000 ↓ 0.0

Index Only Scan using sender_shipment_id_idx on sender se (cost=0.43..0.59 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (shipment_id = (sh_1.id)::bigint)
732. 0.000 0.000 ↓ 0.0

Index Scan using receiver_shipment_id_int_idx on receiver re (cost=0.43..0.62 rows=1 width=21) (actual rows= loops=)

  • Index Cond: ((shipment_id)::integer = sh_1.id)
733. 0.000 0.000 ↓ 0.0

Aggregate (cost=18.32..18.33 rows=1 width=6) (actual rows= loops=)

734. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.67..18.07 rows=1 width=6) (actual rows= loops=)

735. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.40..17.76 rows=1 width=4) (actual rows= loops=)

736. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..16.90 rows=1 width=25) (actual rows= loops=)

737. 0.000 0.000 ↓ 0.0

Index Scan using parcel_parcelnumber_idx on parcel pa_1 (cost=0.42..8.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((parcelnumber)::text = (s03_14.parcelno)::text)
738. 0.000 0.000 ↓ 0.0

Index Scan using shipment_id_idx on shipment sh_2 (cost=0.42..8.45 rows=1 width=29) (actual rows= loops=)

  • Index Cond: (id = pa_1.shipment_id)
739. 0.000 0.000 ↓ 0.0

Index Scan using shipment_mps_mpsid_idx on shipment sh_3 (cost=0.55..0.86 rows=1 width=29) (actual rows= loops=)

  • Index Cond: ((mps_mpsid)::text = (sh_2.mps_mpsid)::text)
740. 0.000 0.000 ↓ 0.0

Index Scan using pers_shipment_id_idx on pers pe (cost=0.28..0.30 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (shipment_id = sh_3.id)
741. 0.000 0.000 ↓ 0.0

Limit (cost=0.25..0.26 rows=1 width=8) (actual rows= loops=)

742. 0.000 0.000 ↓ 0.0

Function Scan on pl_timeframe (cost=0.25..10.25 rows=1,000 width=8) (actual rows= loops=)

743. 0.000 0.000 ↓ 0.0

Limit (cost=0.25..0.26 rows=1 width=8) (actual rows= loops=)

744. 0.000 0.000 ↓ 0.0

Function Scan on pl_timeframe pl_timeframe_1 (cost=0.25..10.25 rows=1,000 width=8) (actual rows= loops=)

745. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..8.17 rows=1 width=20) (actual rows= loops=)

746. 0.000 0.000 ↓ 0.0

Append (cost=0.00..57.16 rows=7 width=20) (actual rows= loops=)

747. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03 scandata03_1 (cost=0.00..0.00 rows=1 width=36) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate))
748. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2013_sdate_idx on scandata03_2013 scandata03_2013_1 (cost=0.14..8.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (sdate = s03_14.sdate)
  • Filter: ((parcelno)::text = (s03_14.parcelno)::text)
749. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2014_pl_indx on scandata03_2014 scandata03_2014_1 (cost=0.14..8.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_14.parcelno)::text)
  • Filter: (sdate = s03_14.sdate)
750. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2015 scandata03_2015_1 (cost=0.00..10.90 rows=1 width=7) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate))
751. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2016 scandata03_2016_1 (cost=0.00..10.90 rows=1 width=7) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate))
752. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03_2017 scandata03_2017_1 (cost=0.00..10.60 rows=1 width=9) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate))
753. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2018_pl_indx on scandata03_2018 scandata03_2018_1 (cost=0.42..8.45 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((parcelno)::text = (s03_14.parcelno)::text)
  • Filter: (sdate = s03_14.sdate)
754. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..8.17 rows=1 width=20) (actual rows= loops=)

755. 0.000 0.000 ↓ 0.0

Append (cost=0.00..57.16 rows=7 width=20) (actual rows= loops=)

756. 0.000 0.000 ↓ 0.0

Seq Scan on scandata03 scandata03_2 (cost=0.00..0.00 rows=1 width=36) (actual rows= loops=)

  • Filter: (((parcelno)::text = (s03_14.parcelno)::text) AND (sdate = s03_14.sdate))
757. 0.000 0.000 ↓ 0.0

Index Scan using scandata03_2013_sdate_idx on scandata03_2013 scandata03_2013_2 (cost=0.14..8.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (sdate = s03_14.sdate)
  • Filter: ((parcelno)::text = (s03_14.parcelno)::text)
758.