explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KFCu

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 352,284.778 ↑ 1.0 1 1

Aggregate (cost=294,217.06..294,217.07 rows=1 width=8) (actual time=352,284.777..352,284.778 rows=1 loops=1)

  • Buffers: shared hit=5,390,712 read=60,995, temp read=9,173 written=9,173
  • (actual time=1.041..396.913 rows=135,232 loops=1)
  • (actual time=0.498..2.139 rows=693 loops=1)
  • 54kB
  • time=0.111..0.111 rows=276 loops=1)
  • (actual time=0.004..0.004 rows=0 loops=1)
  • Batches: 4 Memory Usage: 8,950kB
  • (((v_4.vessel_visit_c)::text = (a_4.vessel_visit_c)::text) AND (v_4.vessel_call_nr = a_4.vessel_call_nr))
  • (((a_5.vessel_visit_c)::text = (v_5.vessel_visit_c)::text) AND (a_5.vessel_call_nr = v_5.vessel_call_nr))
  • 73kB
  • ch.from_out_vessel_visit_c))::text)
  • ch.from_out_vessel_visit_c))::text)
  • time=0.003..0.003 rows=0 loops=10)
  • ch.from_out_vessel_visit_c))::text)
  • ch.from_out_vessel_visit_c))::text)
  • time=0.020..0.020 rows=0 loops=10)
  • ch.from_out_vessel_visit_c))::text)
  • ch.from_out_vessel_visit_c))::text)
  • ch.from_out_vessel_visit_c))::text)
  • time=0.002..0.002 rows=0 loops=10)
  • ch.from_out_vessel_visit_c))::text)
  • ch.from_out_vessel_visit_c))::text)
  • ch.from_out_vessel_visit_c))::text)
  • time=0.003..0.003 rows=0 loops=10)
  • ch.from_out_vessel_visit_c))::text)
  • ch.from_out_vessel_visit_c))::text)
  • ch.from_out_vessel_visit_c))::text)
  • time=0.003..0.003 rows=0 loops=10)
  • ch.from_out_vessel_visit_c))::text)
2. 2,571.038 352,271.203 ↓ 60.9 3,652 1

Subquery Scan on h (cost=99,975.85..294,216.31 rows=60 width=4,866) (actual time=4,148.717..352,271.203 rows=3,652 loops=1)

  • Buffers: shared hit=5,390,712 read=60,995, temp read=9,173 written=9,173
3. 42,907.338 349,700.165 ↓ 60.9 3,652 1

Subquery Scan on g (cost=99,975.85..294,185.71 rows=60 width=4,798) (actual time=4,140.682..349,700.165 rows=3,652 loops=1)

  • Buffers: shared hit=5,354,003 read=60,995, temp read=9,173 written=9,173
4. 4,271.202 306,792.827 ↓ 60.9 3,652 1

Subquery Scan on e (cost=99,975.85..294,170.11 rows=60 width=4,766) (actual time=4,131.368..306,792.827 rows=3,652 loops=1)

  • Buffers: shared hit=3,633,773 read=60,995, temp read=9,173 written=9,173
5. 1,290.838 302,521.625 ↓ 60.9 3,652 1

Subquery Scan on d (cost=99,975.85..294,124.36 rows=60 width=4,579) (actual time=4,128.351..302,521.625 rows=3,652 loops=1)

  • Buffers: shared hit=3,605,957 read=60,995, temp read=9,173 written=9,173
6. 282,716.223 301,230.787 ↓ 60.9 3,652 1

Subquery Scan on c (cost=99,975.85..294,093.76 rows=60 width=4,396) (actual time=4,121.563..301,230.787 rows=3,652 loops=1)

  • Buffers: shared hit=3,594,861 read=60,995, temp read=9,173 written=9,173
7. 2,531.473 18,514.564 ↓ 60.9 3,652 1

Subquery Scan on b (cost=99,975.85..294,048.16 rows=60 width=4,243) (actual time=3,950.846..18,514.564 rows=3,652 loops=1)

  • Buffers: shared hit=1,032,174 read=60,995, temp read=9,173 written=9,173
8. 6,298.409 15,983.091 ↓ 60.9 3,652 1

Result (cost=99,975.85..294,002.26 rows=60 width=4,041) (actual time=3,943.040..15,983.091 rows=3,652 loops=1)

  • Buffers: shared hit=998,991 read=60,995, temp read=9,173 written=9,173
9. 3,068.856 9,684.682 ↓ 60.9 3,652 1

Append (cost=99,975.85..293,881.66 rows=60 width=584) (actual time=3,930.095..9,684.682 rows=3,652 loops=1)

  • Buffers: shared hit=587,705 read=60,995, temp read=9,173 written=9,173
10. 22.780 6,615.826 ↓ 99.2 3,572 1

Subquery Scan on *SELECT* 1 (cost=99,975.85..148,037.84 rows=36 width=584) (actual time=3,930.094..6,615.826 rows=3,572 loops=1)

  • Buffers: shared hit=73,441 read=60,995, temp read=7,282 written=7,282
11. 5,282.936 6,593.046 ↓ 99.2 3,572 1

Hash Join (cost=99,975.85..148,037.48 rows=36 width=3,750) (actual time=3,930.090..6,593.046 rows=3,572 loops=1)

  • Hash Cond: (c_1.departure_cntr_seq = h_1.cntr_seq)
  • Buffers: shared hit=73,441 read=60,995, temp read=7,282 written=7,282
12. 296.630 1,310.110 ↑ 2.4 135,232 1

Hash Left Join (cost=10,484.63..50,717.71 rows=321,458 width=333) (actual time=428.266..1,310.110 rows=135,232 loops=1)

  • Hash Cond: ((c_1.in_vessel_visit_c)::text = ("*SELECT* 1_1".vessel_visit_c)::text)
  • Buffers: shared hit=21,208
13. 223.504 1,013.480 ↑ 1.0 135,232 1

Hash Left Join (cost=9,991.64..34,978.13 rows=135,572 width=237) (actual time=320.644..1,013.480 rows=135,232 loops=1)

  • Hash Cond: ((c_1.out_vessel_visit_c)::text = ("*SELECT* 1_2".vessel_visit_c)::text)
  • Buffers: shared hit=18,171
14. 87.755 789.976 ↑ 1.0 135,232 1

Hash Left Join (cost=9,498.65..21,137.38 rows=135,572 width=157) (actual time=198.274..789.976 rows=135,232 loops=1)

  • Hash Cond: (c_1.departure_traf_actv_id = dt.actv_seq_n)
  • Buffers: shared hit=14,623
15. 505.635 613.845 ↑ 1.0 135,232 1

Hash Left Join (cost=4,789.03..15,902.97 rows=135,572 width=137) (actual time=109.569..613.845 rows=135,232 loops=1)

  • Hash Cond: (c_1.arrival_traf_actv_id = at.actv_seq_n)
  • Buffers: shared hit=10,770
16. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=79.41..10,588.42 rows=135,572 width=110) (actual rows= loops=)

  • Hash Cond: (c_1.cntr_cycle_id = tdv.before_cntr_cycle_id)
  • Buffers: shared hit=6,917
17. 127.991 293.435 ↑ 1.0 135,232 1

Hash Left Join (cost=39.70..10,031.70 rows=135,572 width=103) (actual time=0.621..293.435 rows=135,232 loops=1)

  • Hash Cond: (c_1.cntr_cycle_id = tav.after_cntr_cycle_id)
  • Buffers: shared hit=6,902
18. 164.874 164.874 ↑ 1.0 135,232 1

Seq Scan on tms_cntr_cycle c_1 (cost=0.00..9,474.98 rows=135,572 width=95) (actual time=0.016..164.874 rows=135,232 loops=1)

  • Filter: ((cycle_status_code)::text <> ALL ('{BS,BC,BV,V}'::text[]))
  • Rows Removed by Filter: 37,500
  • Buffers: shared hit=6,884
19. 0.318 0.570 ↑ 1.0 1,098 1

Hash (cost=25.98..25.98 rows=1,098 width=22) (actual time=0.570..0.570 rows=1,098 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 75kB
  • Buffers: shared hit=15
20. 0.252 0.252 ↑ 1.0 1,098 1

Seq Scan on tms_cntr_operation tav (cost=0.00..25.98 rows=1,098 width=22) (actual time=0.012..0.252 rows=1,098 loops=1)

  • Buffers: shared hit=15
21. 0.266 0.403 ↑ 1.0 1,098 1

Hash (cost=25.98..25.98 rows=1,098 width=14) (actual time=0.403..0.403 rows=1,098 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 66kB
  • Buffers: shared hit=15
22. 0.137 0.137 ↑ 1.0 1,098 1

Seq Scan on tms_cntr_operation tdv (cost=0.00..25.98 rows=1,098 width=14) (actual time=0.003..0.137 rows=1,098 loops=1)

  • Buffers: shared hit=15
23. 31.580 108.210 ↑ 1.0 38,072 1

Hash (cost=4,233.72..4,233.72 rows=38,072 width=39) (actual time=108.210..108.210 rows=38,072 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 3,164kB
  • Buffers: shared hit=3,853
24. 76.630 76.630 ↑ 1.0 38,072 1

Seq Scan on tms_traf_hist at (cost=0.00..4,233.72 rows=38,072 width=39) (actual time=0.071..76.630 rows=38,072 loops=1)

  • Buffers: shared hit=3,853
25. 88.376 88.376 ↑ 1.0 38,072 1

Hash (cost=4,233.72..4,233.72 rows=38,072 width=33) (actual time=88.375..88.376 rows=38,072 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 3,151kB
  • Buffers: shared hit=3,853
  • -> Seq Scan on tms_traf_hist dt (cost=0.00..4233.72 rows=38,072
26. 0.000 65.230 ↓ 0.0 38,072 1

width=33) (cost=0..0 rows=0 width=0) (actual time=0.025..65.230 rows=38,072 loops=1)

  • Buffers: shared hit=3,853
27. 0.557 122.315 ↑ 1.0 693 1

Hash (cost=484.32..484.32 rows=694 width=87) (actual time=122.314..122.315 rows=693 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 72kB
  • Buffers: shared hit=3,545
28. 0.109 121.758 ↑ 1.0 693 1

Append (cost=43.54..484.32 rows=694 width=87) (actual time=8.028..121.758 rows=693 loops=1)

  • Buffers: shared hit=3,545
29. 0.217 121.645 ↑ 1.0 693 1

Subquery Scan on *SELECT* 1_2 (cost=43.54..454.40 rows=693 width=87) (actual time=8.026..121.645 rows=693 loops=1)

  • Buffers: shared hit=3,545
30. 121.428 121.428 ↑ 1.0 693 1

Hash Left Join (cost=43.54..447.47 rows=693 width=5,861) (actual time=8.024..121.428 rows=693 loops=1)

  • Hash Cond: ((v.svc_c)::text = (s.svc_c)::text)
  • Buffers: shared hit=3,545
  • -> Hash (cost=5.76..5.76 rows=276 width=6) (actual
31. 0.000 0.000 ↓ 0.0

Hash Join (cost=34.33..89.91 rows=693 width=85) (actual rows= loops=)

  • Hash Cond: (((v.vessel_visit_c)::text = (a.vessel_visit_c)::text) AND (v.vessel_call_nr = a.vessel_call_nr))
  • Buffers: shared hit=62
  • Buckets: 1,024 Batches: 1 Memory Usage: 19kB
  • Buffers: shared hit=3
32. 0.336 0.336 ↑ 1.0 693 1

Seq Scan on tms_vessel_visit v (cost=0.00..51.93 rows=693 width=42) (actual time=0.012..0.336 rows=693 loops=1)

  • Buffers: shared hit=45
33. 0.247 0.461 ↑ 1.0 693 1

Hash (cost=23.93..23.93 rows=693 width=60) (actual time=0.461..0.461 rows=693 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage:
  • Buffers: shared hit=17
34. 0.214 0.214 ↑ 1.0 693 1

Seq Scan on tms_vessel_visit_aggregate a (cost=0.00..23.93 rows=693 width=60) (actual time=0.020..0.214 rows=693 loops=1)

  • Buffers: shared hit=17
35. 0.051 0.051 ↑ 1.0 276 1

Seq Scan on tms_vsl_svc s (cost=0.00..5.76 rows=276 width=6) (actual time=0.010..0.051 rows=276 loops=1)

  • Buffers: shared hit=3
36. 0.000 0.004 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_2 (cost=10.40..26.45 rows=1 width=274) (actual time=0.004..0.004 rows=0 loops=1)

37. 0.004 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=10.40..26.44 rows=1 width=6,034) (actual time=0.004..0.004 rows=0 loops=1)

  • -> Hash Join (cost=10.25..23.76 rows=1 width=272)(actual time=0.003..0.003 rows=0 loops=1)
  • Hash Cond: (((a_1.vessel_visit_c)::text = (v_1.vessel_visit_c)::text) AND (a_1.vessel_call_nr = v_1.vessel_call_nr))
  • -> Seq Scan on tms_vessel_visit_aggregate_bak
38. 0.000 0.003 ↓ 0.0 0 1

a_1 (cost=0.00..12.30 rows=230 width=108) (actual time=0.002..0.003 rows=0 loops=1)

  • Buffers: shared hit=17
39. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.10..10.10 rows=10 width=234) (never executed)

  • -> Seq Scan on tms_vessel_visit_bak v_1
40. 0.000 0.000 ↓ 0.0 0

(cost=0.00..10.10 rows=10 width=234) (cost=0..0 rows=0 width=0) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Index Scan using tms_vsl_svc_pk on tms_vsl_svc s_1 (cost=0.15..2.16 rows=1 width=6) (never executed)

  • Index Cond: ((v_1.svc_c)::text = (svc_c)::text)
42. 0.634 107.613 ↑ 1.0 693 1

Hash (cost=484.32..484.32 rows=694 width=103) (actual time=107.613..107.613 rows=693 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 73kB
  • Buffers: shared hit=3,037
43. 0.141 106.979 ↑ 1.0 693 1

Append (cost=43.54..484.32 rows=694 width=103) (actual time=0.728..106.979 rows=693 loops=1)

  • Buffers: shared hit=3,037
44. 0.242 106.838 ↑ 1.0 693 1

Subquery Scan on *SELECT* 1_1 (cost=43.54..454.40 rows=693 width=103) (actual time=0.727..106.838 rows=693 loops=1)

  • Buffers: shared hit=3,037
45. 104.523 106.596 ↑ 1.0 693 1

Hash Left Join (cost=43.54..447.47 rows=693 width=5,861) (actual time=0.726..106.596 rows=693 loops=1)

  • Hash Cond: ((v_2.svc_c)::text = (s_2.svc_c)::text)
  • Buffers: shared hit=3,037
46. 1.399 2.073 ↑ 1.0 693 1

Hash Join (cost=34.33..89.91 rows=693 width=101) (actual time=0.509..2.073 rows=693 loops=1)

  • Hash Cond: (((v_2.vessel_visit_c)::text = (a_2.vessel_visit_c)::text) AND (v_2.vessel_call_nr = a_2.vessel_call_nr))
  • Buffers: shared hit=62
47. 0.179 0.179 ↑ 1.0 693 1

Seq Scan on tms_vessel_visit v_2 (cost=0.00..51.93 rows=693 width=42) (actual time=0.005..0.179 rows=693 loops=1)

  • Buffers: shared hit=45
48. 0.495 0.495 ↑ 1.0 693 1

Hash (cost=23.93..23.93 rows=693 width=76) (actual time=0.495..0.495 rows=693 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 60kB
  • Buffers: shared hit=17
  • -> Seq Scan on tms_vessel_visit_aggregate a_2
49. 0.000 0.178 ↓ 0.0 693 1

(cost=0.00..23.93 rows=693 width=76) (cost=0..0 rows=0 width=0) (actual time=0.009..0.178 rows=693 loops=1)

  • Buffers: shared hit=17
  • -> Hash (cost=89,446.01..89446.01 rows=3,617 width=102) (actual time=3,494.001..3494.001rows=723,555 loops=1)
  • Buckets: 131,072 (originally 4096) Batches: 8 (originally 1) Memory Usage: 9,462kB
  • Buffers: shared hit=17,580 read=60,995, temp written=5,419
50. 0.061 0.109 ↑ 1.0 276 1

Hash (cost=5.76..5.76 rows=276 width=6) (actual time=0.109..0.109 rows=276 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 19kB
  • Buffers: shared hit=3
51. 0.048 0.048 ↑ 1.0 276 1

Seq Scan on tms_vsl_svc s_2 (cost=0.00..5.76 rows=276 width=6) (actual time=0.006..0.048 rows=276 loops=1)

  • Buffers: shared hit=3
52. 0.005 0.005 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_1 (cost=10.40..26.45 rows=1 width=290) (actual time=0.005..0.005 rows=0 loops=1)

53. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=10.40..26.44 rows=1 width=6,034) (actual rows= loops=)

54. 0.001 0.004 ↓ 0.0 0 1

Hash Join (cost=10.25..23.76 rows=1 width=288) (actual time=0.004..0.004 rows=0 loops=1)

  • Hash Cond: (((a_3.vessel_visit_c)::text = (v_3.vessel_visit_c)::text) AND (a_3.vessel_call_nr = v_3.vessel_call_nr))
55. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on tms_vessel_visit_aggregate_bak a_3(cost=0.00..12.30 rows=230 width=124) (cost=0..0 rows=0 width=0) (actual time=0.003..0.003 rows=0 loops=1)

56. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.10..10.10 rows=10 width=234) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Seq Scan on tms_vessel_visit_bak v_3 (cost=0.00..10.10 rows=10 width=234) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Index Scan using tms_vsl_svc_pk on tms_vsl_svc s_3 (cost=0.15..2.16 rows=1 width=6) (never executed)

  • Index Cond: ((v_3.svc_c)::text = (svc_c)::text)
59. 2,581.415 2,581.415 ↓ 200.0 723,555 1

Seq Scan on tms_cntr_hist h_1 (cost=0.00..89,446.01 rows=3,617 width=102) (actual time=251.877..2,581.415 rows=723,555 loops=1)

  • Filter: ((category <> ALL ('{RS,CC}'::bpchar[])) AND ((cntr_an)::text = (COALESCE(master_cntr_an, cntr_an))::text))
  • Rows Removed by Filter: 2,152
  • Buffers: shared hit=17,580 read=60,995
60. 0.160 3,066.182 ↓ 3.3 80 1

Subquery Scan on *SELECT* 2 (cost=83,170.55..145,843.52 rows=24 width=584) (actual time=1,792.913..3,066.182 rows=80 loops=1)

  • Buffers: shared hit=514,264, temp read=1,891 written=1,891
61. 50.006 3,066.022 ↓ 3.3 80 1

Result (cost=83,170.55..145,843.28 rows=24 width=3,750) (actual time=1,792.909..3,066.022 rows=80 loops=1)

  • One-Time Filter: (COALESCE($20, '0'::numeric) >= '0'::numeric)
  • Buffers: shared hit=514,264, temp read=1,891 written=1,891
62.          

Initplan (for Result)

63. 0.040 0.040 ↑ 1.0 1 1

Seq Scan on bis_service_type (cost=0.00..4.45 rows=1 width=3) (actual time=0.027..0.040 rows=1 loops=1)

  • Filter: ((service_type_code)::text = 'ST'::text)
  • Rows Removed by Filter: 115
  • Buffers: shared hit=3
64. 6.411 3,015.976 ↓ 3.3 80 1

Nested Loop Left Join (cost=83,166.10..141,182.35 rows=24 width=423) (actual time=1,792.512..3,015.976 rows=80 loops=1)

  • Buffers: shared hit=513,931, temp read=1,891 written=1,891
65. 5.524 3,009.565 ↓ 3.3 80 1

Nested Loop Left Join (cost=83,165.82..141,175.03 rows=24 width=422) (actual time=1,786.692..3,009.565 rows=80 loops=1)

  • Buffers: shared hit=513,771, temp read=1,891 written=1,891
66. 2.140 3,004.041 ↓ 3.3 80 1

Nested Loop (cost=83,165.55..141,167.70 rows=24 width=407) (actual time=1,786.682..3,004.041 rows=80 loops=1)

  • Buffers: shared hit=513,610, temp read=1,891 written=1,891
  • -> Nested Loop (cost=83,165.13..141153.15 rows=30 width=389) (actualtime=1,786.666..3003.073 rows=80 loops=1)
  • Buffers: shared hit=513,290, temp read=1,891 written=1,891
67. 6.872 3,001.901 ↓ 2.7 80 1

Nested Loop (cost=83,164.70..140,944.72 rows=30 width=294) (actual time=1,786.640..3,001.901 rows=80 loops=1)

  • Buffers: shared hit=512,970, temp read=1,891 written=1,891
68. 33.554 2,995.029 ↑ 72.0 80 1

Hash Join (cost=83,164.28..131,880.82 rows=5,763 width=307) (actual time=1,786.613..2,995.029 rows=80 loops=1)

  • Hash Cond: (mc.departure_cntr_seq = bh.master_cntr_seq)
  • Buffers: shared hit=512,642, temp read=1,891 written=1,891
69. 162.830 2,961.475 ↑ 2.4 135,430 1

Hash Left Join (cost=83,043.96..128,484.22 rows=321,866 width=293) (actual time=1,752.437..2,961.475 rows=135,430 loops=1)

  • Hash Cond: ((mc.in_vessel_visit_c)::text = ("*SELECT* 1_3".vessel_visit_c)::text)
  • Buffers: shared hit=512,598, temp read=1,891 written=1,891
70. 86.938 2,685.025 ↓ 0.0 135,430 1

Hash Left Join (cost=82550.97..112725.29rows=135744 width=197) (cost=0..0 rows=0 width=0) (actual time=1,638.807..2,685.025 rows=135,430 loops=1)

  • Hash Cond: ((mc.out_vessel_visit_c)::text = ("*SELECT* 1_4".vessel_visit_c)::text)
  • Buffers: shared hit=509,561, temp read=1,891 written=1,891
71. 82.146 2,482.845 ↑ 1.0 135,430 1

Hash Left Join (cost=82,057.98..98,867.61 rows=135,744 width=117) (actual time=1,523.550..2,482.845 rows=135,430 loops=1)

  • Hash Cond: (mc.departure_traf_actv_id = dt_1.actv_seq_n)
  • Buffers: shared hit=506,524, temp read=1,891 written=1,891
72. 66.374 2,313.416 ↑ 1.0 135,430 1

Hash Left Join (cost=77,348.36..93,632.53 rows=135,744 width=97) (actual time=1,430.481..2,313.416 rows=135,430 loops=1)

  • Hash Cond: (mc.arrival_traf_actv_id = at_1.actv_seq_n)
  • Buffers: shared hit=502,671,temp read=1,891 written=1,891
73. 670.278 2,160.625 ↑ 1.0 135,430 1

Hash Left Join (cost=72,638.74..88,317.22 rows=135,744 width=70) (actual time=1,343.746..2,160.625 rows=135,430 loops=1)

  • Hash Cond: (mc.arrival_from_cntr_seq = afh.cntr_seq)
  • Buffers: shared hit=498,818, temp read=1,891 written=1,891
74. 146.969 146.969 ↑ 1.0 135,430 1

Seq Scan on tms_cntr_cycle mc (cost=0.00..9,043.15 rows=135,744 width=77) (actual time=0.007..146.969 rows=135,430 loops=1)

  • Filter: ((cycle_status_code)::text <> ALL ('{BV,V}'::text[]))
  • Rows Removed by
  • Buffers: sharedhit=6,884
75. 451.017 1,343.378 ↓ 1.0 725,707 1

Hash (cost=60,748.57..60,748.57 rows=724,734 width=6) (actual time=1,343.378..1,343.378 rows=725,707 loops=1)

  • Buckets: 262,144
  • Buffers: sharedhit=491,934, temp written=1,793
76. 892.361 892.361 ↓ 1.0 725,707 1

Index Only Scan using tms_cntr_hist_pk on tms_cntr_hist afh (cost=0.42..60,748.57 rows=724,734 width=6) (actual time=0.020..892.361 rows=725,707 loops=1)

  • Heap Fetches: 725,707
  • Buffers: shared hit=491,934
77. 30.374 86.417 ↑ 1.0 38,072 1

Hash (cost=4,233.72..4,233.72 rows=38,072 width=39) (actual time=86.417..86.417 rows=38,072 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 3,164kB
  • Buffers: shared hit=3,853
78. 56.043 56.043 ↑ 1.0 38,072 1

Seq Scan on tms_traf_hist at_1 (cost=0.00..4,233.72 rows=38,072 width=39) (actual time=0.026..56.043 rows=38,072 loops=1)

  • Buffers: sharedhit=3,853
79. 25.237 87.283 ↑ 1.0 38,072 1

Hash (cost=4,233.72..4,233.72 rows=38,072 width=33) (actual time=87.283..87.283 rows=38,072 loops=1)

  • Buckets: 65,536 Batches: 1Memory Usage: 3,151kB
  • Buffers: shared hit=3,853
80. 62.046 62.046 ↑ 1.0 38,072 1

Seq Scan on tms_traf_hist dt_1 (cost=0.00..4,233.72 rows=38,072 width=33) (actual time=0.043..62.046 rows=38,072 loops=1)

  • Buffers: shared hit=3,853
81. 0.689 115.242 ↓ 0.0 693 1

Hash (cost=484.32..484.32 rows=694width=87) (cost=0..0 rows=0 width=0) (actual time=115.241..115.242 rows=693 loops=1)

  • Buckets: 1,024 Batches: 1 MemoryUsage: 72kB
  • Buffers: shared hit=3,037
82. 0.113 114.553 ↑ 1.0 693 1

Append (cost=43.54..484.32 rows=694 width=87) (actual time=0.937..114.553 rows=693 loops=1)

  • Buffers: shared hit=3,037
83. 0.239 114.435 ↑ 1.0 693 1

Subquery Scan on *SELECT* 1_4 (cost=43.54..454.40 rows=693 width=87) (actual time=0.934..114.435 rows=693 loops=1)

  • Buffers: shared hit=3,037
84. 111.945 114.196 ↑ 1.0 693 1

Hash Left Join (cost=43.54..447.47 rows=693 width=5,861) (actual time=0.933..114.196 rows=693 loops=1)

  • Hash Cond: ((v_4.svc_c)::text = (s_4.svc_c)::text)
  • Buffers: sharedhit=3,037
85. 1.390 2.052 ↑ 1.0 693 1

Hash Join (cost=34.33..89.91 rows=693 width=85) (actual time=0.490..2.052 rows=693 loops=1)

  • Hash Cond:
  • Buffers: shared hit=62
86. 0.194 0.194 ↑ 1.0 693 1

Seq Scan on tms_vessel_visit v_4 (cost=0.00..51.93 rows=693 width=42) (actual time=0.009..0.194 rows=693 loops=1)

  • Buffers: shared hit=45
87. 0.295 0.468 ↓ 0.0 693 1

Hash(cost=23.93..23.93 rows=693 width=60) (cost=0..0 rows=0 width=0) (actual time=0.468..0.468 rows=693 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 54kB
  • Buffers: shared hit=17
88. 0.173 0.173 ↑ 1.0 693 1

Seq Scan on tms_vessel_visit_aggregate a_4 (cost=0.00..23.93 rows=693 width=60) (actual time=0.009..0.173 rows=693 loops=1)

89. 0.141 0.199 ↑ 1.0 276 1

Hash (cost=5.76..5.76 rows=276 width=6) (actual time=0.199..0.199 rows=276 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 19kB
  • Buffers: shared hit=3
90. 0.058 0.058 ↑ 1.0 276 1

Seq Scan on tms_vsl_svc s_4 (cost=0.00..5.76 rows=276 width=6) (actual time=0.010..0.058 rows=276 loops=1)

  • Buffers: shared hit=3
91. 0.001 0.005 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_4 (cost=10.40..26.45 rows=1 width=274) (actual time=0.005..0.005 rows=0 loops=1)

92. 0.001 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=10.40..26.44 rows=1 width=6,034) (actual time=0.004..0.004 rows=0 loops=1)

93. 0.000 0.003 ↓ 0.0 0 1

Hash Join (cost=10.25..23.76 rows=1 width=272) (actual time=0.003..0.003 rows=0 loops=1)

  • Hash Cond:
94. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on tms_vessel_visit_aggregate_bak a_5 (cost=0.00..12.30 rows=230 width=108) (actual time=0.003..0.003 rows=0 loops=1)

95. 0.000 0.000 ↓ 0.0 0

Hash(cost=10.10..10.10 rows=10 width=234) (cost=0..0 rows=0 width=0) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Seq Scan on tms_vessel_visit_bak v_5 (cost=0.00..10.10 rows=10 width=234) (never executed)

97. 0.000 0.000 ↓ 0.0 0

Index Scan using tms_vsl_svc_pk on tms_vsl_svc s_5 (cost=0.15..2.16 rows=1 width=6) (never executed)

  • Index Cond: ((v_5.svc_c)::text = (svc_c)::text)
98. 113.620 113.620 ↑ 1.0 693 1

Hash (cost=484.32..484.32 rows=694 width=103) (actual time=113.619..113.620 rows=693 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage:
  • Buffers: shared hit=3,037
  • -> Append (cost=43.54..484.32 rows=694
99.          

SubPlan (for (cost=0.00..23.93 rows=693 width=76))

100. 28.236 122.718 ↓ 0.0 0 1,086

Append (cost=0.55..35.96 rows=2 width=22) (actual time=0.112..0.113 rows=0 loops=1,086)

  • Buffers: shared hit=3,841
  • -> Subquery Scan on "*SELECT* 2_5" (cost=0.14..18.84 rows=1 width=38) (actualtime=0.018..0.018 rows=0 loops=1,086)
101. 0.000 94.482 ↓ 0.0 0 1,086

Subquery Scan on *SELECT* 1_5 (cost=0.55..17.11 rows=1 width=5) (actual time=0.087..0.087 rows=0 loops=1,086)

  • Buffers: shared hit=3,442
  • Buffers: shared hit=399
102. 78.390 92.310 ↓ 0.0 0 1,086

Nested Loop (cost=0.55..17.10 rows=1 width=6,021) (actual time=0.085..0.085 rows=0 loops=1,086)

  • Join Filter: (a_8.vessel_call_nr = v_8.vessel_call_nr)
  • Buffers: shared hit=3,442
103. 4.344 4.344 ↓ 0.0 0 1,086

Index Scan using tms_vessel_visit_aggregate_pk on tms_vessel_visit_aggregate a_8 (cost=0.28..8.29 rows=1 width=12) (actual time=0.004..0.004 rows=0 loops=1,086)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text)
  • Buffers: shared hit=1,205
104. 9.576 9.576 ↑ 1.0 1 399

Index Scan using tms_vessel_visit_pk on tms_vessel_visit v_8 (cost=0.28..8.29 rows=1 width=17) (actual time=0.024..0.024 rows=1 loops=399)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text)
  • Filter: ((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[]))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1,197
105. 6.516 13.032 ↓ 0.0 0 1,086

Nested Loop (cost=0.14..18.82 rows=1 width=6,040) (actual time=0.012..0.012 rows=0 loops=1,086)

  • Join Filter: (a_9.vessel_call_nr = v_9.vessel_call_nr)
  • Buffers: shared hit=399
106. 6.516 6.516 ↓ 0.0 0 1,086

Index Scan using tms_vessel_visit_agg_bak_pk on tms_vessel_visit_aggregate_bak a_9 (cost=0.14..8.16 rows=1 width=60) (actual time=0.006..0.006 rows=0 loops=1,086)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text)
  • Buffers: shared hit=399
107. 0.000 0.000 ↓ 0.0 0

Seq Scan on tms_vessel_visit_bak v_9 (cost=0.00..10.15 rows=1 width=98) (never executed)

  • Filter: (((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[])) AND ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text))
108. 51.042 188.964 ↓ 0.0 0 1,086

Append (cost=8.58..49.59 rows=2 width=2) (actual time=0.143..0.174 rows=0 loops=1,086)

  • Buffers: shared hit=4,621
  • -> Subquery Scan on "*SELECT* 2_6" (cost=10.31..25.65 rows=1 width=2) (actualtime=0.040..0.040 rows=0 loops=1,086)
109. 0.000 137.922 ↓ 0.0 0 1,086

Subquery Scan on *SELECT* 1_6 (cost=8.58..23.93 rows=1 width=2) (actual time=0.106..0.127 rows=0 loops=1,086)

  • Buffers: shared hit=3,535
  • Buffers: shared hit=1,086
110. 60.852 135.750 ↓ 0.0 0 1,086

Nested Loop (cost=8.58..23.92 rows=1 width=6,048) (actual time=0.105..0.125 rows=0 loops=1,086)

  • Join Filter: (v_10.vessel_call_nr = a_10.vessel_call_nr)
  • Buffers: shared hit=3,535
111. 40.746 68.418 ↓ 0.0 0 1,086

Hash Right Join (cost=8.31..15.11 rows=1 width=14) (actual time=0.042..0.063 rows=0 loops=1,086)

  • Hash Cond: ((s_8.svc_c)::text = (v_10.svc_c)::text)
  • Buffers: shared hit=1,847
112. 23.328 23.328 ↑ 1.0 276 216

Seq Scan on tms_vsl_svc s_8 (cost=0.00..5.76 rows=276 width=6) (actual time=0.004..0.108 rows=276 loops=216)

  • Buffers: shared hit=648
113. 1.086 4.344 ↓ 0.0 0 1,086

Hash (cost=8.29..8.29 rows=1 width=17) (actual time=0.004..0.004 rows=0 loops=1,086)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=1,199
114. 3.258 3.258 ↓ 0.0 0 1,086

Index Scan using tms_vessel_visit_pk on tms_vessel_visit v_10 (cost=0.28..8.29 rows=1 width=17) (actual time=0.003..0.003 rows=0 loops=1,086)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text)
  • Filter: ((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[]))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1,199
115. 6.480 6.480 ↑ 1.0 1 216

Index Scan using tms_vessel_visit_aggregate_pk on tms_vessel_visit_aggregate a_10 (cost=0.28..8.29 rows=1 width=12) (actual time=0.030..0.030 rows=1 loops=216)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text)
  • Buffers: shared hit=648
116. 7.602 42.354 ↓ 0.0 0 1,086

Nested Loop (cost=10.31..25.64 rows=1 width=6,034) (actual time=0.039..0.039 rows=0 loops=1,086)

  • Join Filter: (v_11.vessel_call_nr = a_11.vessel_call_nr)
  • Buffers: shared hit=1,086
117. 3.258 34.752 ↓ 0.0 0 1,086

Hash Right Join (cost=10.16..16.97 rows=1 width=62) (actual time=0.032..0.032 rows=0 loops=1,086)

  • Hash Cond: ((s_9.svc_c)::text = (v_11.svc_c)::text)
  • Buffers: shared hit=1,086
118. 0.000 0.000 ↓ 0.0 0

Seq Scan on tms_vsl_svc s_9 (cost=0.00..5.76 rows=276 width=6) (never executed)

119. 2.172 31.494 ↓ 0.0 0 1,086

Hash (cost=10.15..10.15 rows=1 width=98) (actual time=0.029..0.029 rows=0 loops=1,086)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=1,086
120. 29.322 29.322 ↓ 0.0 0 1,086

Seq Scan on tms_vessel_visit_bak v_11 (cost=0.00..10.15 rows=1 width=98) (actual time=0.027..0.027 rows=0 loops=1,086)

  • Filter: (((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[])) AND ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text))
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1,086
121. 0.000 0.000 ↓ 0.0 0

Index Scan using tms_vessel_visit_agg_bak_pk on tms_vessel_visit_aggregate_bak a_11 (cost=0.14..8.16 rows=1 width=60) (never executed)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text)
122. 9.774 62.988 ↓ 0.0 0 1,086

Append (cost=0.55..35.96 rows=2 width=19) (actual time=0.056..0.058 rows=0 loops=1,086)

  • Buffers: shared hit=3,841
  • -> Subquery Scan on "*SELECT* 2_7" (cost=0.14..18.84 rows=1 width=34) (actualtime=0.008..0.008 rows=0 loops=1,086)
123. 0.000 53.214 ↓ 0.0 0 1,086

Subquery Scan on *SELECT* 1_7 (cost=0.55..17.11 rows=1 width=4) (actual time=0.048..0.049 rows=0 loops=1,086)

  • Buffers: shared hit=3,442
  • Buffers: shared hit=399
124. 36.015 51.042 ↓ 0.0 0 1,086

Nested Loop (cost=0.55..17.10 rows=1 width=6,024) (actual time=0.047..0.047 rows=0 loops=1,086)

  • Join Filter: (a_12.vessel_call_nr = v_12.vessel_call_nr)
  • Buffers: shared hit=3,442
125. 13.032 13.032 ↓ 0.0 0 1,086

Index Scan using tms_vessel_visit_aggregate_pk on tms_vessel_visit_aggregate a_12 (cost=0.28..8.29 rows=1 width=12) (actual time=0.012..0.012 rows=0 loops=1,086)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text)
  • Buffers: shared hit=1,205
126. 1.995 1.995 ↑ 1.0 1 399

Index Scan using tms_vessel_visit_pk on tms_vessel_visit v_12 (cost=0.28..8.29 rows=1 width=21) (actual time=0.005..0.005 rows=1 loops=399)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text)
  • Filter: ((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[]))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1,197
127. 2.172 2.172 ↓ 0.0 0 1,086

Nested Loop (cost=0.14..18.82 rows=1 width=6,040) (actual time=0.002..0.002 rows=0 loops=1,086)

  • Join Filter: (a_13.vessel_call_nr = v_13.vessel_call_nr)
  • Buffers: shared hit=399
128. 0.000 0.000 ↓ 0.0 0 1,086

Index Scan using tms_vessel_visit_agg_bak_pk on tms_vessel_visit_aggregate_bak a_13 (cost=0.14..8.16 rows=1 width=60) (actual time=0.000..0.000 rows=0 loops=1,086)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text)
  • Buffers: shared hit=399
129. 0.000 0.000 ↓ 0.0 0

Seq Scan on tms_vessel_visit_bak v_13 (cost=0.00..10.15 rows=1width=132) (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[])) AND ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text))
130. 4.344 64.074 ↓ 0.0 0 1,086

Append (cost=0.55..35.96 rows=2 width=16) (actual time=0.058..0.059 rows=0 loops=1,086)

  • Buffers: shared hit=3,841
  • -> Subquery Scan on "*SELECT* 2_8" (cost=0.14..18.84 rows=1 width=28) (actualtime=0.003..0.003 rows=0 loops=1,086)
131. 0.000 59.730 ↓ 0.0 0 1,086

Subquery Scan on *SELECT* 1_8 (cost=0.55..17.11 rows=1 width=4) (actual time=0.055..0.055 rows=0 loops=1,086)

  • Buffers: shared hit=3,442
  • Buffers: shared hit=399
132. 49.290 58.644 ↓ 0.0 0 1,086

Nested Loop (cost=0.55..17.10 rows=1 width=6,030) (actual time=0.054..0.054 rows=0 loops=1,086)

  • Join Filter: (a_14.vessel_call_nr = v_14.vessel_call_nr)
  • Buffers: shared hit=3,442
133. 2.172 2.172 ↓ 0.0 0 1,086

Index Scan using tms_vessel_visit_aggregate_pk on tms_vessel_visit_aggregate a_14 (cost=0.28..8.29 rows=1 width=12) (actual time=0.001..0.002 rows=0 loops=1,086)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text)
  • Buffers: shared hit=1,205
134. 7.182 7.182 ↑ 1.0 1 399

Index Scan using tms_vessel_visit_pk on tms_vessel_visit v_14 (cost=0.28..8.29 rows=1 width=21) (actual time=0.018..0.018 rows=1 loops=399)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text)
  • Filter: ((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[]))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1,197
135. 1.086 1.086 ↓ 0.0 0 1,086

Nested Loop (cost=0.14..18.82 rows=1 width=6,040) (actual time=0.001..0.001 rows=0 loops=1,086)

  • Join Filter: (a_15.vessel_call_nr = v_15.vessel_call_nr)
  • Buffers: shared hit=399
136. 0.000 0.000 ↓ 0.0 0 1,086

Index Scan using tms_vessel_visit_agg_bak_pk on tms_vessel_visit_aggregate_bak a_15 (cost=0.14..8.16 rows=1 width=60) (actual time=0.000..0.000 rows=0 loops=1,086)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text)
  • Buffers: shared hit=399
137. 0.000 0.000 ↓ 0.0 0

Seq Scan on tms_vessel_visit_bak v_15 (cost=0.00..10.15 rows=1width=126) (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[])) AND ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text))
138. 4.344 56.472 ↓ 0.0 0 1,086

Append (cost=0.55..35.96 rows=2 width=16) (actual time=0.051..0.052 rows=0 loops=1,086)

  • Buffers: shared hit=3,841
  • -> Subquery Scan on "*SELECT* 2_9" (cost=0.14..18.84 rows=1 width=28) (actualtime=0.003..0.003 rows=0 loops=1,086)
139. 0.000 52.128 ↓ 0.0 0 1,086

Subquery Scan on *SELECT* 1_9 (cost=0.55..17.11 rows=1 width=4) (actual time=0.048..0.048 rows=0 loops=1,086)

  • Buffers: shared hit=3,442
  • Buffers: shared hit=399
140. 41.688 51.042 ↓ 0.0 0 1,086

Nested Loop (cost=0.55..17.10 rows=1 width=6,030) (actual time=0.047..0.047 rows=0 loops=1,086)

  • Join Filter: (a_16.vessel_call_nr = v_16.vessel_call_nr)
  • Buffers: shared hit=3,442
141. 2.172 2.172 ↓ 0.0 0 1,086

Index Scan using tms_vessel_visit_aggregate_pk on tms_vessel_visit_aggregate a_16 (cost=0.28..8.29 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=1,086)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text)
  • Buffers: shared hit=1,205
142. 7.182 7.182 ↑ 1.0 1 399

Index Scan using tms_vessel_visit_pk on tms_vessel_visit v_16 (cost=0.28..8.29 rows=1 width=21) (actual time=0.018..0.018 rows=1 loops=399)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text)
  • Filter: ((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[]))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1,197
143. 1.086 1.086 ↓ 0.0 0 1,086

Nested Loop (cost=0.14..18.82 rows=1 width=6,040) (actual time=0.001..0.001 rows=0 loops=1,086)

  • Join Filter: (a_17.vessel_call_nr = v_17.vessel_call_nr)
  • Buffers: shared hit=399
144. 0.000 0.000 ↓ 0.0 0 1,086

Index Scan using tms_vessel_visit_agg_bak_pk on tms_vessel_visit_aggregate_bak a_17 (cost=0.14..8.16 rows=1 width=60) (actual time=0.000..0.000 rows=0 loops=1,086)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text)
  • Buffers: shared hit=399
145. 0.000 0.000 ↓ 0.0 0

Seq Scan on tms_vessel_visit_bak v_17 (cost=0.00..10.15 rows=1width=126) (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[])) AND ((vessel_visit_c)::text = (COALESCE(h_1.trgt_vvd_n, h_1.from_out_vessel_visit_c))::text))
146. 0.000 108.361 ↓ 0.0 693 1

width=103) (cost=0..0 rows=0 width=0) (actual time=0.810..108.361 rows=693 loops=1)

  • Buffers: shared hit=3,037
147. 0.241 108.249 ↑ 1.0 693 1

Subquery Scan on *SELECT* 1_3 (cost=43.54..454.40 rows=693 width=103) (actual time=0.809..108.249 rows=693 loops=1)

  • Buffers: shared hit=3,037
148. 105.772 108.008 ↑ 1.0 693 1

Hash Left Join (cost=43.54..447.47 rows=693 width=5,861) (actual time=0.807..108.008 rows=693 loops=1)

  • Hash Cond: ((v_6.svc_c)::text = (s_6.svc_c)::text)
  • Buffers: shared hit=3,037
149. 1.411 2.125 ↑ 1.0 693 1

Hash Join (cost=34.33..89.91 rows=693 width=101) (actual time=0.552..2.125 rows=693 loops=1)

  • Hash Cond: (((v_6.vessel_visit_c)::text = (a_6.vessel_visit_c)::text) AND (v_6.vessel_call_nr = a_6.vessel_call_nr))
  • Buffers: sharedhit=62
150. 0.178 0.178 ↑ 1.0 693 1

Seq Scan ontms_vessel_visit v_6 (cost=0.00..51.93 rows=693 width=42) (actual time=0.004..0.178 rows=693 loops=1)

  • Buffers: shared hit=45
151. 0.357 0.536 ↑ 1.0 693 1

Hash (cost=23.93..23.93 rows=693 width=76) (actual time=0.536..0.536 rows=693 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 60kB
  • Buffers: shared hit=17
152. 0.179 0.179 ↑ 1.0 693 1

Seq Scan on tms_vessel_visit_aggregate a_6 (cost=0.00..23.93 rows=693 width=76) (actual time=0.009..0.179 rows=693 loops=1)

  • Buffers: shared hit=17
153. 0.060 0.111 ↑ 1.0 276 1

Hash (cost=5.76..5.76 rows=276 width=6) (actual time=0.111..0.111 rows=276 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 19kB
  • Buffers: sharedhit=3
154. 0.051 0.051 ↑ 1.0 276 1

Seq Scan ontms_vsl_svc s_6 (cost=0.00..5.76 rows=276 width=6) (actual time=0.007..0.051 rows=276 loops=1)

  • Buffers: shared hit=3
155. 0.000 0.004 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_3 (cost=10.40..26.45 rows=1 width=290) (actual time=0.004..0.004 rows=0 loops=1)

156. 0.001 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=10.40..26.44 rows=1 width=6,034) (actual time=0.004..0.004 rows=0 loops=1)

157. 0.000 0.003 ↓ 0.0 0 1

Hash Join (cost=10.25..23.76 rows=1 width=288) (actual time=0.003..0.003 rows=0 loops=1)

  • Hash Cond: (((a_7.vessel_visit_c)::text = (v_7.vessel_visit_c)::text) AND (a_7.vessel_call_nr = v_7.vessel_call_nr))
158. 0.003 0.003 ↓ 0.0 0 1

Seq Scan ontms_vessel_visit_aggregate_bak a_7 (cost=0.00..12.30 rows=230 width=124) (actual time=0.003..0.003 rows=0 loops=1)

159. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.10..10.10 rows=10 width=234) (never executed)

160. 0.000 0.000 ↓ 0.0 0

Seq Scan on tms_vessel_visit_bak v_7 (cost=0.00..10.10 rows=10 width=234) (never executed)

161. 0.000 0.000 ↓ 0.0 0

Index Scan using tms_vsl_svc_pk on tms_vsl_svc s_7 (cost=0.15..2.16 rows=1 width=6) (never executed)

  • Index Cond: ((v_7.svc_c)::text = (svc_c)::text)
162. 0.451 1.131 ↑ 1.4 2,105 1

Hash (cost=82.25..82.25 rows=3,045 width=14) (actual time=1.131..1.131 rows=2,105 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 127kB
  • Buffers: shared hit=44
163. 0.680 0.680 ↑ 1.4 2,105 1

Seq Scan on tms_cntr_bundle_hist bh (cost=0.00..82.25 rows=3,045 width=14) (actual time=0.016..0.680 rows=2,105 loops=1)

  • Filter: ((master_cntr_an)::text <> (child_cntr_an)::text)
  • Rows Removed by Filter: 955
  • Buffers: shared hit=44
164. 6.400 6.400 ↑ 1.0 1 80

Index Only Scan using tms_cntr_hist_pk on tms_cntr_hist mh (cost=0.42..1.57 rows=1 width=6) (actual time=0.080..0.080 rows=1 loops=80)

  • Index Cond: (cntr_seq = mc.departure_cntr_seq)
  • Heap Fetches: 80
  • Buffers: shared hit=328
165. 0.720 0.720 ↑ 1.0 1 80

Index Scan using tms_cntr_hist_pk on tms_cntr_hist ch (cost=0.42..6.95 rows=1 width=108) (actual time=0.009..0.009 rows=1 loops=80)

  • Index Cond: (cntr_seq = bh.child_bundle_cntr_seq)
  • Filter: (category <> ALL ('{RS,CC}'::bpchar[]))
  • Buffers: shared hit=320
166. 0.640 0.640 ↑ 1.0 1 80

Index Scan using tms_cntr_cycle_pk on tms_cntr_cycle cc (cost=0.42..0.49 rows=1 width=18) (actual time=0.008..0.008 rows=1 loops=80)

  • Index Cond: (cntr_cycle_id = ch.cntr_cycle_id)
  • Filter: ((cycle_status_code)::text <> ALL ('{BV,V}'::text[]))
  • Buffers: shared hit=320
167. 0.400 0.400 ↓ 0.0 0 80

Index Scan using tms_cntr_operation_idx03 on tms_cntr_operation tav_1 (cost=0.28..0.30 rows=1 width=22) (actual time=0.005..0.005 rows=0 loops=80)

  • Index Cond: (ch.cntr_cycle_id = after_cntr_cycle_id)
  • Buffers: shared hit=161
168. 0.320 0.320 ↓ 0.0 0 80

Index Scan using tms_cntr_operation_idx02 on tms_cntr_operation tdv_1 (cost=0.28..0.30 rows=1 width=14) (actual time=0.004..0.004 rows=0 loops=80)

  • Index Cond: (ch.cntr_cycle_id = before_cntr_cycle_id)
  • Buffers: shared hit=160
169.          

SubPlan (for width=103))

170. 0.040 0.090 ↓ 0.0 0 10

Append (cost=0.55..35.96 rows=2 width=22) (actual time=0.009..0.009 rows=0 loops=10)

  • -> Subquery Scan on "*SELECT* 1_10" (cost=0.55..17.11 rows=1 width=5) (actualtime=0.004..0.004 rows=0 loops=10)
  • -> Subquery Scan on "*SELECT* 2_10" (cost=0.14..18.84 rows=1 width=38) (actual
171. 0.020 0.030 ↓ 0.0 0 10

Nested Loop (cost=0.55..17.10 rows=1 width=6,021) (actual time=0.003..0.003 rows=0 loops=10)

  • Join Filter: (a_18.vessel_call_nr = v_18.vessel_call_nr)
172. 0.010 0.010 ↓ 0.0 0 10

Index Scan using tms_vessel_visit_aggregate_pk on tms_vessel_visit_aggregate a_18 (cost=0.28..8.29 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n,
173. 0.000 0.000 ↓ 0.0 0

Index Scan using tms_vessel_visit_pk on tms_vessel_visit v_18 (cost=0.28..8.29 rows=1 width=17) (never executed)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n,
  • Filter: ((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[]))
174. 0.010 0.020 ↓ 0.0 0 10

Nested Loop (cost=0.14..18.82 rows=1 width=6,040) (actual time=0.002..0.002 rows=0 loops=10)

  • Join Filter: (a_19.vessel_call_nr = v_19.vessel_call_nr)
175. 0.010 0.010 ↓ 0.0 0 10

Index Scan using tms_vessel_visit_agg_bak_pk on tms_vessel_visit_aggregate_bak a_19 (cost=0.14..8.16 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n,
176. 0.000 0.000 ↓ 0.0 0

Seq Scan on tms_vessel_visit_bak v_19 (cost=0.00..10.15 rows=1width=98) (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[])) AND ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n, ch.from_out_vessel_visit_c))::text))
177. 0.030 0.320 ↓ 0.0 0 10

Append (cost=8.58..49.59 rows=2 width=2) (actual time=0.032..0.032 rows=0 loops=10)

  • Buffers: shared hit=10
  • -> Subquery Scan on "*SELECT* 1_11" (cost=8.58..23.93 rows=1 width=2) (actualtime=0.011..0.011 rows=0 loops=10)
  • -> Subquery Scan on "*SELECT* 2_11" (cost=10.31..25.65 rows=1 width=2) (actual
  • Buffers: shared hit=10
178. 0.020 0.100 ↓ 0.0 0 10

Nested Loop (cost=8.58..23.92 rows=1 width=6,048) (actual time=0.010..0.010 rows=0 loops=10)

  • Join Filter: (v_20.vessel_call_nr = a_20.vessel_call_nr)
179. 0.060 0.080 ↓ 0.0 0 10

Hash Right Join (cost=8.31..15.11 rows=1 width=14) (actual time=0.008..0.008 rows=0 loops=10)

  • Hash Cond: ((s_10.svc_c)::text = (v_20.svc_c)::text)
180. 0.000 0.000 ↓ 0.0 0

Seq Scan on tms_vsl_svc s_10 (cost=0.00..5.76 rows=276 width=6) (never executed)

181. 0.010 0.020 ↓ 0.0 0 10

Hash (cost=8.29..8.29 rows=1 width=17) (actual time=0.002..0.002 rows=0 loops=10)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
182. 0.010 0.010 ↓ 0.0 0 10

Index Scan using tms_vessel_visit_pk on tms_vessel_visit v_20 (cost=0.28..8.29 rows=1 width=17) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n, ch.from_out_vessel_visit_c))::text)
  • Filter: ((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[]))
183. 0.000 0.000 ↓ 0.0 0

Index Scan using tms_vessel_visit_aggregate_pk on tms_vessel_visit_aggregate a_20 (cost=0.28..8.29 rows=1 width=12) (never executed)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n,
184. 0.020 0.190 ↓ 0.0 0 10

Nested Loop (cost=10.31..25.64 rows=1 width=6,034) (actual time=0.019..0.019 rows=0 loops=10)

  • Join Filter: (v_21.vessel_call_nr = a_21.vessel_call_nr)
  • Buffers: shared hit=10
185. 0.040 0.170 ↓ 0.0 0 10

Hash Right Join (cost=10.16..16.97 rows=1 width=62) (actual time=0.017..0.017 rows=0 loops=10)

  • Hash Cond: ((s_11.svc_c)::text = (v_21.svc_c)::text)
  • Buffers: shared hit=10
186. 0.000 0.000 ↓ 0.0 0

Seq Scan on tms_vsl_svc s_11 (cost=0.00..5.76 rows=276 width=6) (never executed)

187. 0.020 0.130 ↓ 0.0 0 10

Hash (cost=10.15..10.15 rows=1 width=98) (actual time=0.013..0.013 rows=0 loops=10)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=10
188. 0.110 0.110 ↓ 0.0 0 10

Seq Scan on tms_vessel_visit_bak v_21 (cost=0.00..10.15 rows=1 width=98) (actual time=0.011..0.011 rows=0 loops=10)

  • Filter: (((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[])) AND ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n, ch.from_out_vessel_visit_c))::text))
  • Rows Removed by Filter: 14
  • Buffers: shared hit=10
189. 0.000 0.000 ↓ 0.0 0

Index Scan using tms_vessel_visit_agg_bak_pk on tms_vessel_visit_aggregate_bak a_21 (cost=0.14..8.16 rows=1 width=60) (never executed)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n,
190. 0.030 0.070 ↓ 0.0 0 10

Append (cost=0.55..35.96 rows=2 width=19) (actual time=0.007..0.007 rows=0 loops=10)

  • -> Subquery Scan on "*SELECT* 1_12" (cost=0.55..17.11 rows=1 width=4) (actualtime=0.003..0.003 rows=0 loops=10)
  • -> Subquery Scan on "*SELECT* 2_12" (cost=0.14..18.84 rows=1 width=34) (actual
191. 0.010 0.020 ↓ 0.0 0 10

Nested Loop (cost=0.55..17.10 rows=1 width=6,024) (actual time=0.002..0.002 rows=0 loops=10)

  • Join Filter: (a_22.vessel_call_nr = v_22.vessel_call_nr)
192. 0.010 0.010 ↓ 0.0 0 10

Index Scan using tms_vessel_visit_aggregate_pk on tms_vessel_visit_aggregate a_22 (cost=0.28..8.29 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n,
193. 0.000 0.000 ↓ 0.0 0

Index Scan using tms_vessel_visit_pk on tms_vessel_visit v_22 (cost=0.28..8.29 rows=1 width=21) (never executed)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n,
  • Filter: ((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[]))
194. 0.010 0.020 ↓ 0.0 0 10

Nested Loop (cost=0.14..18.82 rows=1 width=6,040) (actual time=0.002..0.002 rows=0 loops=10)

  • Join Filter: (a_23.vessel_call_nr = v_23.vessel_call_nr)
195. 0.010 0.010 ↓ 0.0 0 10

Index Scan using tms_vessel_visit_agg_bak_pk on tms_vessel_visit_aggregate_bak a_23 (cost=0.14..8.16 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n,
196. 0.000 0.000 ↓ 0.0 0

Seq Scan on tms_vessel_visit_bak v_23 (cost=0.00..10.15 rows=1width=132) (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[])) AND ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n, ch.from_out_vessel_visit_c))::text))
197. 5.010 5.050 ↓ 0.0 0 10

Append (cost=0.55..35.96 rows=2 width=16) (actual time=0.505..0.505 rows=0 loops=10)

  • -> Subquery Scan on "*SELECT* 1_13" (cost=0.55..17.11 rows=1 width=4) (actualtime=0.501..0.501 rows=0 loops=10)
  • -> Subquery Scan on "*SELECT* 2_13" (cost=0.14..18.84 rows=1 width=28) (actual
198. 0.010 0.020 ↓ 0.0 0 10

Nested Loop (cost=0.55..17.10 rows=1 width=6,030) (actual time=0.002..0.002 rows=0 loops=10)

  • Join Filter: (a_24.vessel_call_nr = v_24.vessel_call_nr)
199. 0.010 0.010 ↓ 0.0 0 10

Index Scan using tms_vessel_visit_aggregate_pk on tms_vessel_visit_aggregate a_24 (cost=0.28..8.29 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n,
200. 0.000 0.000 ↓ 0.0 0

Index Scan using tms_vessel_visit_pk on tms_vessel_visit v_24 (cost=0.28..8.29 rows=1 width=21) (never executed)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n,
  • Filter: ((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[]))
201. 0.010 0.020 ↓ 0.0 0 10

Nested Loop (cost=0.14..18.82 rows=1 width=6,040) (actual time=0.002..0.002 rows=0 loops=10)

  • Join Filter: (a_25.vessel_call_nr = v_25.vessel_call_nr)
202. 0.010 0.010 ↓ 0.0 0 10

Index Scan using tms_vessel_visit_agg_bak_pk on tms_vessel_visit_aggregate_bak a_25 (cost=0.14..8.16 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n,
203. 0.000 0.000 ↓ 0.0 0

Seq Scan on tms_vessel_visit_bak v_25 (cost=0.00..10.15 rows=1width=126) (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[])) AND ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n, ch.from_out_vessel_visit_c))::text))
204. 0.030 0.070 ↓ 0.0 0 10

Append (cost=0.55..35.96 rows=2 width=16) (actual time=0.007..0.007 rows=0 loops=10)

  • -> Subquery Scan on "*SELECT* 1_14" (cost=0.55..17.11 rows=1 width=4) (actualtime=0.003..0.003 rows=0 loops=10)
  • -> Subquery Scan on "*SELECT* 2_14" (cost=0.14..18.84 rows=1 width=28) (actual
205. 0.010 0.020 ↓ 0.0 0 10

Nested Loop (cost=0.55..17.10 rows=1 width=6,030) (actual time=0.002..0.002 rows=0 loops=10)

  • Join Filter: (a_26.vessel_call_nr = v_26.vessel_call_nr)
206. 0.010 0.010 ↓ 0.0 0 10

Index Scan using tms_vessel_visit_aggregate_pk on tms_vessel_visit_aggregate a_26 (cost=0.28..8.29 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n,
207. 0.000 0.000 ↓ 0.0 0

Index Scan using tms_vessel_visit_pk on tms_vessel_visit v_26 (cost=0.28..8.29 rows=1 width=21) (never executed)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n,
  • Filter: ((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[]))
208. 0.010 0.020 ↓ 0.0 0 10

Nested Loop (cost=0.14..18.82 rows=1 width=6,040) (actual time=0.002..0.002 rows=0 loops=10)

  • Join Filter: (a_27.vessel_call_nr = v_27.vessel_call_nr)
209. 0.010 0.010 ↓ 0.0 0 10

Index Scan using tms_vessel_visit_agg_bak_pk on tms_vessel_visit_aggregate_bak a_27 (cost=0.14..8.16 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n,
210. 0.000 0.000 ↓ 0.0 0

Seq Scan on tms_vessel_visit_bak v_27 (cost=0.00..10.15 rows=1width=126) (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((visit_vsl_type_c)::text = ANY ('{RORO,LOLO}'::text[])) AND ((vessel_visit_c)::text = (COALESCE(ch.trgt_vvd_n, ch.from_out_vessel_visit_c))::text))