explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 05Ep : Sampling

Settings
# exclusive inclusive rows x rows loops node
1. 43.983 3,200.606 ↑ 2.5 4 1

Gather Motion 4:1 (slice92; segments: 4) (cost=20,542.29..54,165.25 rows=10 width=17) (actual time=2,558.927..3,200.606 rows=4 loops=1)

  • (slice0) Executor memory: 71155K bytes._ (slice1) Workers: Workers: 4 not dispatched;. Executor memory: 82K bytes avg x 4 workers, 82K bytes max (seg0).
  • (slice2) Executor memory: 342K bytes avg x 4 workers, 346K bytes max (seg0).
  • (slice3) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice4) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice5) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice6) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice7) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice8) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice9) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice10) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice11) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice12) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice13) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice14) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice15) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice16) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice17) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice18) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice19) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice20) Executor memory: 362K bytes avg x 4 workers, 363K bytes max (seg3).
  • (slice21) Executor memory: 394K bytes avg x 4 workers, 394K bytes max (seg0).
  • (slice22) Executor memory: 394K bytes avg x 4 workers, 394K bytes max (seg0).
  • (slice23) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice24) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice25) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice26) Executor memory: 346K bytes avg x 4 workers, 346K bytes max (seg1).
  • (slice27) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice28) Executor memory: 346K bytes avg x 4 workers, 346K bytes max (seg0).
  • (slice29) Executor memory: 394K bytes avg x 4 workers, 394K bytes max (seg0).
  • (slice30) Executor memory: 394K bytes avg x 4 workers, 394K bytes max (seg0).
  • (slice31) Executor memory: 362K bytes avg x 4 workers, 363K bytes max (seg3).
  • (slice32) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice33) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice34) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice35) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice36) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice37) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice38) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice39) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice40) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice41) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice42) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice43) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice44) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice45) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice46) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice47) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice48) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice49) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice50) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice51) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice52) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice53) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice54) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice55) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice56) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice57) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice58) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice59) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice60) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice61) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice62) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice63) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice64) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice65) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice66) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice67) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice68) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice69) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice70) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice71) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice72) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice73) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice74) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice75) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice76) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice77) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice78) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice79) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice80) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice81) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice82) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice83) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice84) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice85) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0).
  • (slice86) Executor memory: 314K bytes avg x 4 workers, 314K bytes max (seg0)._ (slice87) Workers: Workers: 4 not dispatched;. Executor memory: 50K bytes avg x 4 workers, 50K bytes max (seg0).
  • (slice88) Executor memory: 20304K bytes avg x 4 workers, 20308K bytes max (seg0).
  • (slice89) Executor memory: 114K bytes avg x 4 workers, 114K bytes max (seg0).
  • (slice90) Executor memory: 20318K bytes avg x 4 workers, 20322K bytes max (seg0)._ (slice91) Workers: Workers: 4 not dispatched;. Executor memory: 50K bytes avg x 4 workers, 50K bytes max (seg0).* (slice92) Executor memory: 10707K bytes avg x 4 workers, 12817K bytes max (seg2). Work_mem: 1252K bytes max, 60224K bytes wanted.
  • (slice93) Executor memory: 62169K bytes.
  • (slice94) Executor memory: 62433K bytes.
  • (slice95) Executor memory: 62698K bytes.Memory used: 126976kBMemory wanted: 5283488kBOptimizer: Postgres query optimizer
2. 2,946.836 3,156.623 ↑ 1.5 2 1

Hash Anti Join (cost=20,542.29..54,165.25 rows=3 width=17) (actual time=2,510.008..3,156.623 rows=2 loops=1)

  • Hash Cond: (co.barcode = co_op.barcode)
  • Extra Text: (seg2) Initial batch 0:(seg2) Wrote 1756K bytes to inner workfile.(seg2) Wrote 1K bytes to outer workfile.(seg2) Overflow batches 1..3:(seg2) Read 2184K bytes from inner workfile: 728K avg x 3 nonempty batches, 1021K max.(seg2) Wrote 429K bytes to inner workfile.(seg2) Read 1K bytes from outer workfile.(seg2) Hash chain length 5.3 avg, 17 max, using 16267 of 16384 buckets.
  • Extra Text: (seg3) Initial batch 0:(seg3) Wrote 1754K bytes to inner workfile.(seg3) Wrote 1K bytes to outer workfile.(seg3) Overflow batches 1..3:(seg3) Read 2186K bytes from inner workfile: 729K avg x 3 nonempty batches, 1020K max.(seg3) Wrote 433K bytes to inner workfile.(seg3) Read 1K bytes from outer workfile.(seg3) Hash chain length 5.3 avg, 18 max, using 16292 of 16384 buckets.Initial batch 0:
  • SubPlan 2 (slice92; segments: 4)
  • SubPlan 4 (slice92; segments: 4)
3.          

Initplan (for Hash Anti Join)

4. 0.000 0.000 ↑ 1.0 1 1

Gather Motion 4:1 (slice91; segments: 4) (cost=0.00..4.83 rows=1 width=4) (actual time=1.308..0.000 rows=1 loops=1)

5. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on operation_type ope_typ_2 (cost=0.00..4.83 rows=1 width=4) (actual time=0.008..0.010 rows=1 loops=1)

  • Filter: (code = 'OPENING'::text)
6. 0.000 0.041 ↓ 2.0 2 1

Redistribute Motion 4:4 (slice89; segments: 4) (cost=0.00..30,904.94 rows=1 width=17) (actual time=0.029..0.041 rows=2 loops=1)

  • Hash Key: co.barcode
7. 61.531 61.531 ↑ 1.0 1 1

Seq Scan on container co (cost=0.00..30,904.92 rows=1 width=17) (actual time=61.529..61.531 rows=1 loops=1)

  • Filter: ((im_formation_date >= '2019-01-01 00:00:00+00'::timestamp with time zone) AND (im_formation_date <= '2019-12-31 00:00:00+00'::timestamp with time zone) AND (im_origin_impc_code = 'SDWHFA'::text) AND (im_destination_impc_code = 'UACOPE'::text) AND (im_category = 'C'::text) AND (date_part('year'::text, im_formation_date) = 2019::double precision) AND ((im_format ~~* 'X'::text) OR (im_format ~~* 'P'::text) OR (im_format ~~* 'S'::text) OR (im_format ~~* 'G'::text) OR (im_format ~~* 'E'::text)))
8. 51.917 209.746 ↓ 355.5 85,683 1

Hash (cost=20,525.46..20,525.46 rows=241 width=32) (actual time=209.746..209.746 rows=85,683 loops=1)

9. 15.377 157.829 ↓ 355.5 85,683 1

Redistribute Motion 4:4 (slice90; segments: 4) (cost=0.00..20,525.46 rows=241 width=32) (actual time=11.132..157.829 rows=85,683 loops=1)

  • Hash Key: co_op.barcode
10. 7.103 142.452 ↓ 355.3 85,619 1

Append (cost=0.00..20,506.25 rows=241 width=32) (actual time=0.632..142.452 rows=85,619 loops=1)

11. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_other_periods co_op (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_2 co_op_1 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
13. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_3 co_op_2 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
14. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_4 co_op_3 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
15. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_5 co_op_4 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_6 co_op_5 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
17. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_7 co_op_6 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
18. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_8 co_op_7 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
19. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_9 co_op_8 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
20. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_10 co_op_9 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
21. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_11 co_op_10 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
22. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_12 co_op_11 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
23. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_13 co_op_12 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
24. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_14 co_op_13 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
25. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_15 co_op_14 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
26. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_16 co_op_15 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
27. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_17 co_op_16 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
28. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_18 co_op_17 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
29. 1.351 1.351 ↓ 216.7 650 1

Seq Scan on container_operation_1_prt_19 co_op_18 (cost=0.00..241.25 rows=3 width=32) (actual time=0.318..1.351 rows=650 loops=1)

  • Filter: (type_id = $4)
30. 58.258 58.258 ↓ 8,571.3 25,714 1

Seq Scan on container_operation_1_prt_20 co_op_19 (cost=0.00..241.25 rows=3 width=32) (actual time=0.436..58.258 rows=25,714 loops=1)

  • Filter: (type_id = $4)
31. 48.876 48.876 ↓ 6,980.0 20,940 1

Seq Scan on container_operation_1_prt_21 co_op_20 (cost=0.00..241.25 rows=3 width=32) (actual time=0.539..48.876 rows=20,940 loops=1)

  • Filter: (type_id = $4)
32. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_22 co_op_21 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
33. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_23 co_op_22 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
34. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_24 co_op_23 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
35. 0.343 0.343 ↓ 14.0 42 1

Seq Scan on container_operation_1_prt_25 co_op_24 (cost=0.00..241.25 rows=3 width=32) (actual time=0.192..0.343 rows=42 loops=1)

  • Filter: (type_id = $4)
36. 0.077 0.077 ↓ 2.0 6 1

Seq Scan on container_operation_1_prt_26 co_op_25 (cost=0.00..241.25 rows=3 width=32) (actual time=0.074..0.077 rows=6 loops=1)

  • Filter: (type_id = $4)
37. 0.581 0.581 ↑ 3.0 1 1

Seq Scan on container_operation_1_prt_27 co_op_26 (cost=0.00..241.25 rows=3 width=32) (actual time=0.576..0.581 rows=1 loops=1)

  • Filter: (type_id = $4)
38. 19.671 19.671 ↓ 12,874.3 38,623 1

Seq Scan on container_operation_1_prt_28 co_op_27 (cost=0.00..241.25 rows=3 width=32) (actual time=0.411..19.671 rows=38,623 loops=1)

  • Filter: (type_id = $4)
39. 6.192 6.192 ↓ 27.3 82 1

Seq Scan on container_operation_1_prt_29 co_op_28 (cost=0.00..241.25 rows=3 width=32) (actual time=1.448..6.192 rows=82 loops=1)

  • Filter: (type_id = $4)
40. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_30 co_op_29 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
41. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_31 co_op_30 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
42. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_32 co_op_31 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
43. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_33 co_op_32 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
44. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_34 co_op_33 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
45. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_35 co_op_34 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
46. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_36 co_op_35 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
47. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_37 co_op_36 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
48. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_38 co_op_37 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
49. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_39 co_op_38 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
50. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_40 co_op_39 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
51. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_41 co_op_40 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
52. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_42 co_op_41 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
53. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_43 co_op_42 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
54. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_44 co_op_43 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
55. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_45 co_op_44 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
56. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_46 co_op_45 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
57. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_47 co_op_46 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
58. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_48 co_op_47 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
59. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_49 co_op_48 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
60. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_50 co_op_49 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
61. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_51 co_op_50 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
62. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_52 co_op_51 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
63. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_53 co_op_52 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
64. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_54 co_op_53 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
65. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_55 co_op_54 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
66. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_56 co_op_55 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
67. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_57 co_op_56 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
68. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_58 co_op_57 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
69. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_59 co_op_58 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
70. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_60 co_op_59 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
71. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_61 co_op_60 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
72. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_62 co_op_61 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
73. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_63 co_op_62 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
74. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_64 co_op_63 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
75. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_65 co_op_64 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
76. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_66 co_op_65 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
77. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_67 co_op_66 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
78. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_68 co_op_67 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
79. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_69 co_op_68 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
80. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_70 co_op_69 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
81. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_71 co_op_70 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
82. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_72 co_op_71 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
83. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_73 co_op_72 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
84. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_74 co_op_73 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
85. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_75 co_op_74 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
86. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_76 co_op_75 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
87. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_77 co_op_76 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
88. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_78 co_op_77 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
89. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_79 co_op_78 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
90. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_80 co_op_79 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
91. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_81 co_op_80 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
92. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_82 co_op_81 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
93. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_83 co_op_82 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
94. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_84 co_op_83 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
95. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_85 co_op_84 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $4)
96. 0.000 0.000 ↓ 0.0 0

Append (cost=4.83..22,912.33 rows=22 width=0) (never executed)

97.          

Initplan (for Append)

98. 0.000 0.000 ↓ 0.0 0 1

Gather Motion 4:1 (slice1; segments: 4) (cost=0.00..4.83 rows=1 width=4) (actual time=3.453..0.000 rows=0 loops=1)

99. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_type ope_typ (cost=0.00..4.83 rows=1 width=4) (never executed)

  • Filter: (code = 'IM_CONTAINER_RECALCULATING'::text)
100. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_85.barcode) AND (co_op_85.type_id = $0))
101. 1.391 2.742 ↓ 4,089.0 4,089 2

Materialize (cost=0.00..269.50 rows=1 width=0) (actual time=1.108..1.371 rows=4,089 loops=2)

102. 0.971 1.351 ↓ 4,089.0 4,089 1

Broadcast Motion 4:4 (slice2; segments: 4) (cost=0.00..269.50 rows=1 width=0) (actual time=0.147..1.351 rows=4,089 loops=1)

103. 0.380 0.380 ↓ 1,230.0 1,230 1

Seq Scan on container_operation_1_prt_other_periods co_op_85 (cost=0.00..269.50 rows=1 width=0) (actual time=0.161..0.380 rows=1,230 loops=1)

104. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_86.barcode) AND (co_op_86.type_id = $0))
105. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

106. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice3; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

107. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_2 co_op_86 (cost=0.00..269.50 rows=1 width=0) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_87.barcode) AND (co_op_87.type_id = $0))
109. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

110. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice4; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

111. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_3 co_op_87 (cost=0.00..269.50 rows=1 width=0) (never executed)

112. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_88.barcode) AND (co_op_88.type_id = $0))
113. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

114. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice5; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

115. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_4 co_op_88 (cost=0.00..269.50 rows=1 width=0) (never executed)

116. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_89.barcode) AND (co_op_89.type_id = $0))
117. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

118. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice6; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

119. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_5 co_op_89 (cost=0.00..269.50 rows=1 width=0) (never executed)

120. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_90.barcode) AND (co_op_90.type_id = $0))
121. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

122. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice7; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

123. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_6 co_op_90 (cost=0.00..269.50 rows=1 width=0) (never executed)

124. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_91.barcode) AND (co_op_91.type_id = $0))
125. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

126. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice8; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

127. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_7 co_op_91 (cost=0.00..269.50 rows=1 width=0) (never executed)

128. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_92.barcode) AND (co_op_92.type_id = $0))
129. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

130. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice9; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

131. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_8 co_op_92 (cost=0.00..269.50 rows=1 width=0) (never executed)

132. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_93.barcode) AND (co_op_93.type_id = $0))
133. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

134. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice10; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_9 co_op_93 (cost=0.00..269.50 rows=1 width=0) (never executed)

136. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_94.barcode) AND (co_op_94.type_id = $0))
137. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

138. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice11; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

139. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_10 co_op_94 (cost=0.00..269.50 rows=1 width=0) (never executed)

140. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_95.barcode) AND (co_op_95.type_id = $0))
141. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

142. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice12; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

143. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_11 co_op_95 (cost=0.00..269.50 rows=1 width=0) (never executed)

144. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_96.barcode) AND (co_op_96.type_id = $0))
145. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

146. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice13; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

147. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_12 co_op_96 (cost=0.00..269.50 rows=1 width=0) (never executed)

148. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_97.barcode) AND (co_op_97.type_id = $0))
149. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

150. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice14; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

151. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_13 co_op_97 (cost=0.00..269.50 rows=1 width=0) (never executed)

152. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_98.barcode) AND (co_op_98.type_id = $0))
153. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

154. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice15; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

155. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_14 co_op_98 (cost=0.00..269.50 rows=1 width=0) (never executed)

156. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_99.barcode) AND (co_op_99.type_id = $0))
157. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

158. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice16; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

159. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_15 co_op_99 (cost=0.00..269.50 rows=1 width=0) (never executed)

160. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_100.barcode) AND (co_op_100.type_id = $0))
161. 0.021 0.124 ↓ 270.0 270 2

Materialize (cost=0.00..269.50 rows=1 width=0) (actual time=0.043..0.062 rows=270 loops=2)

162. 0.000 0.103 ↓ 270.0 270 1

Broadcast Motion 4:4 (slice17; segments: 4) (cost=0.00..269.50 rows=1 width=0) (actual time=0.021..0.103 rows=270 loops=1)

163. 0.155 0.155 ↓ 81.0 81 1

Seq Scan on container_operation_1_prt_16 co_op_100 (cost=0.00..269.50 rows=1 width=0) (actual time=0.123..0.155 rows=81 loops=1)

164. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_101.barcode) AND (co_op_101.type_id = $0))
165. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

166. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice18; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

167. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_17 co_op_101 (cost=0.00..269.50 rows=1 width=0) (never executed)

168. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_102.barcode) AND (co_op_102.type_id = $0))
169. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

170. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice19; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

171. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_18 co_op_102 (cost=0.00..269.50 rows=1 width=0) (never executed)

172. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_103.barcode) AND (co_op_103.type_id = $0))
173. 8.707 46.496 ↓ 31,969.0 31,969 2

Materialize (cost=0.00..269.50 rows=1 width=0) (actual time=21.019..23.248 rows=31,969 loops=2)

174. 35.589 37.789 ↓ 31,969.0 31,969 1

Broadcast Motion 4:4 (slice20; segments: 4) (cost=0.00..269.50 rows=1 width=0) (actual time=0.045..37.789 rows=31,969 loops=1)

175. 2.200 2.200 ↓ 8,572.0 8,572 1

Seq Scan on container_operation_1_prt_19 co_op_103 (cost=0.00..269.50 rows=1 width=0) (actual time=0.347..2.200 rows=8,572 loops=1)

176. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_104.barcode) AND (co_op_104.type_id = $0))
177. 504.934 983.384 ↓ 1,708,266.0 1,708,266 2

Materialize (cost=0.00..269.50 rows=1 width=0) (actual time=349.806..491.692 rows=1,708,266 loops=2)

178. 385.674 478.450 ↓ 1,708,266.0 1,708,266 1

Broadcast Motion 4:4 (slice21; segments: 4) (cost=0.00..269.50 rows=1 width=0) (actual time=0.056..478.450 rows=1,708,266 loops=1)

179. 92.776 92.776 ↓ 428,977.0 428,977 1

Seq Scan on container_operation_1_prt_20 co_op_104 (cost=0.00..269.50 rows=1 width=0) (actual time=0.535..92.776 rows=428,977 loops=1)

180. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_105.barcode) AND (co_op_105.type_id = $0))
181. 404.246 839.532 ↓ 1,396,895.0 1,396,895 2

Materialize (cost=0.00..269.50 rows=1 width=0) (actual time=309.091..419.766 rows=1,396,895 loops=2)

182. 364.893 435.286 ↓ 1,396,895.0 1,396,895 1

Broadcast Motion 4:4 (slice22; segments: 4) (cost=0.00..269.50 rows=1 width=0) (actual time=0.048..435.286 rows=1,396,895 loops=1)

183. 70.393 70.393 ↓ 351,678.0 351,678 1

Seq Scan on container_operation_1_prt_21 co_op_105 (cost=0.00..269.50 rows=1 width=0) (actual time=0.578..70.393 rows=351,678 loops=1)

184. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_106.barcode) AND (co_op_106.type_id = $0))
185. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

186. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice23; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

187. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_22 co_op_106 (cost=0.00..269.50 rows=1 width=0) (never executed)

188. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_107.barcode) AND (co_op_107.type_id = $0))
189. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

190. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice24; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

191. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_23 co_op_107 (cost=0.00..269.50 rows=1 width=0) (never executed)

192. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_108.barcode) AND (co_op_108.type_id = $0))
193. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

194. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice25; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

195. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_24 co_op_108 (cost=0.00..269.50 rows=1 width=0) (never executed)

196. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_109.barcode) AND (co_op_109.type_id = $0))
197. 0.000 3.626 ↓ 7,669.0 7,669 2

Materialize (cost=0.00..269.50 rows=1 width=0) (actual time=1.301..1.813 rows=7,669 loops=2)

198. 8.277 9.005 ↓ 7,669.0 7,669 1

Broadcast Motion 4:4 (slice26; segments: 4) (cost=0.00..269.50 rows=1 width=0) (actual time=0.052..9.005 rows=7,669 loops=1)

199. 0.728 0.728 ↓ 2,088.0 2,088 1

Seq Scan on container_operation_1_prt_25 co_op_109 (cost=0.00..269.50 rows=1 width=0) (actual time=0.288..0.728 rows=2,088 loops=1)

200. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_110.barcode) AND (co_op_110.type_id = $0))
201. 0.053 0.092 ↓ 166.0 166 2

Materialize (cost=0.00..269.50 rows=1 width=0) (actual time=0.033..0.046 rows=166 loops=2)

202. 0.000 0.039 ↓ 166.0 166 1

Broadcast Motion 4:4 (slice27; segments: 4) (cost=0.00..269.50 rows=1 width=0) (actual time=0.012..0.039 rows=166 loops=1)

203. 0.113 0.113 ↓ 48.0 48 1

Seq Scan on container_operation_1_prt_26 co_op_110 (cost=0.00..269.50 rows=1 width=0) (actual time=0.064..0.113 rows=48 loops=1)

204. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_111.barcode) AND (co_op_111.type_id = $0))
205. 3.023 6.536 ↓ 14,799.0 14,799 2

Materialize (cost=0.00..269.50 rows=1 width=0) (actual time=2.212..3.268 rows=14,799 loops=2)

206. 2.420 3.513 ↓ 14,799.0 14,799 1

Broadcast Motion 4:4 (slice28; segments: 4) (cost=0.00..269.50 rows=1 width=0) (actual time=0.029..3.513 rows=14,799 loops=1)

207. 1.093 1.093 ↓ 3,726.0 3,726 1

Seq Scan on container_operation_1_prt_27 co_op_111 (cost=0.00..269.50 rows=1 width=0) (actual time=0.323..1.093 rows=3,726 loops=1)

208. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_112.barcode) AND (co_op_112.type_id = $0))
209. 113.037 211.128 ↓ 364,972.0 364,972 2

Materialize (cost=0.00..269.50 rows=1 width=0) (actual time=72.681..105.564 rows=364,972 loops=2)

210. 60.813 98.091 ↓ 364,972.0 364,972 1

Broadcast Motion 4:4 (slice29; segments: 4) (cost=0.00..269.50 rows=1 width=0) (actual time=0.029..98.091 rows=364,972 loops=1)

211. 37.278 37.278 ↓ 92,085.0 92,085 1

Seq Scan on container_operation_1_prt_28 co_op_112 (cost=0.00..269.50 rows=1 width=0) (actual time=5.414..37.278 rows=92,085 loops=1)

212. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_113.barcode) AND (co_op_113.type_id = $0))
213. 34.155 82.052 ↓ 147,750.0 147,750 2

Materialize (cost=0.00..269.50 rows=1 width=0) (actual time=28.119..41.026 rows=147,750 loops=2)

214. 38.031 47.897 ↓ 147,750.0 147,750 1

Broadcast Motion 4:4 (slice30; segments: 4) (cost=0.00..269.50 rows=1 width=0) (actual time=0.086..47.897 rows=147,750 loops=1)

215. 9.866 9.866 ↓ 37,285.0 37,285 1

Seq Scan on container_operation_1_prt_29 co_op_113 (cost=0.00..269.50 rows=1 width=0) (actual time=0.358..9.866 rows=37,285 loops=1)

216. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_114.barcode) AND (co_op_114.type_id = $0))
217. 5.167 21.786 ↓ 32,788.0 32,788 2

Materialize (cost=0.00..269.50 rows=1 width=0) (actual time=8.329..10.893 rows=32,788 loops=2)

218. 13.656 16.619 ↓ 32,788.0 32,788 1

Broadcast Motion 4:4 (slice31; segments: 4) (cost=0.00..269.50 rows=1 width=0) (actual time=0.077..16.619 rows=32,788 loops=1)

219. 2.963 2.963 ↓ 8,364.0 8,364 1

Seq Scan on container_operation_1_prt_30 co_op_114 (cost=0.00..269.50 rows=1 width=0) (actual time=0.395..2.963 rows=8,364 loops=1)

220. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_115.barcode) AND (co_op_115.type_id = $0))
221. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

222. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice32; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

223. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_31 co_op_115 (cost=0.00..269.50 rows=1 width=0) (never executed)

224. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_116.barcode) AND (co_op_116.type_id = $0))
225. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

226. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice33; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

227. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_32 co_op_116 (cost=0.00..269.50 rows=1 width=0) (never executed)

228. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_117.barcode) AND (co_op_117.type_id = $0))
229. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

230. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice34; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

231. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_33 co_op_117 (cost=0.00..269.50 rows=1 width=0) (never executed)

232. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_118.barcode) AND (co_op_118.type_id = $0))
233. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

234. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice35; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

235. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_34 co_op_118 (cost=0.00..269.50 rows=1 width=0) (never executed)

236. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_119.barcode) AND (co_op_119.type_id = $0))
237. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

238. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice36; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

239. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_35 co_op_119 (cost=0.00..269.50 rows=1 width=0) (never executed)

240. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_120.barcode) AND (co_op_120.type_id = $0))
241. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

242. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice37; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

243. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_36 co_op_120 (cost=0.00..269.50 rows=1 width=0) (never executed)

244. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_121.barcode) AND (co_op_121.type_id = $0))
245. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

246. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice38; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

247. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_37 co_op_121 (cost=0.00..269.50 rows=1 width=0) (never executed)

248. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_122.barcode) AND (co_op_122.type_id = $0))
249. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

250. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice39; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

251. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_38 co_op_122 (cost=0.00..269.50 rows=1 width=0) (never executed)

252. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_123.barcode) AND (co_op_123.type_id = $0))
253. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

254. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice40; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

255. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_39 co_op_123 (cost=0.00..269.50 rows=1 width=0) (never executed)

256. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_124.barcode) AND (co_op_124.type_id = $0))
257. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

258. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice41; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

259. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_40 co_op_124 (cost=0.00..269.50 rows=1 width=0) (never executed)

260. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_125.barcode) AND (co_op_125.type_id = $0))
261. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

262. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice42; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

263. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_41 co_op_125 (cost=0.00..269.50 rows=1 width=0) (never executed)

264. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_126.barcode) AND (co_op_126.type_id = $0))
265. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

266. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice43; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

267. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_42 co_op_126 (cost=0.00..269.50 rows=1 width=0) (never executed)

268. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_127.barcode) AND (co_op_127.type_id = $0))
269. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

270. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice44; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

271. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_43 co_op_127 (cost=0.00..269.50 rows=1 width=0) (never executed)

272. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_128.barcode) AND (co_op_128.type_id = $0))
273. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

274. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice45; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

275. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_44 co_op_128 (cost=0.00..269.50 rows=1 width=0) (never executed)

276. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_129.barcode) AND (co_op_129.type_id = $0))
277. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

278. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice46; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

279. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_45 co_op_129 (cost=0.00..269.50 rows=1 width=0) (never executed)

280. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_130.barcode) AND (co_op_130.type_id = $0))
281. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

282. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice47; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

283. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_46 co_op_130 (cost=0.00..269.50 rows=1 width=0) (never executed)

284. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_131.barcode) AND (co_op_131.type_id = $0))
285. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

286. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice48; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

287. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_47 co_op_131 (cost=0.00..269.50 rows=1 width=0) (never executed)

288. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_132.barcode) AND (co_op_132.type_id = $0))
289. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

290. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice49; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

291. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_48 co_op_132 (cost=0.00..269.50 rows=1 width=0) (never executed)

292. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_133.barcode) AND (co_op_133.type_id = $0))
293. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

294. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice50; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

295. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_49 co_op_133 (cost=0.00..269.50 rows=1 width=0) (never executed)

296. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_134.barcode) AND (co_op_134.type_id = $0))
297. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

298. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice51; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

299. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_50 co_op_134 (cost=0.00..269.50 rows=1 width=0) (never executed)

300. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_135.barcode) AND (co_op_135.type_id = $0))
301. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

302. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice52; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

303. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_51 co_op_135 (cost=0.00..269.50 rows=1 width=0) (never executed)

304. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_136.barcode) AND (co_op_136.type_id = $0))
305. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

306. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice53; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

307. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_52 co_op_136 (cost=0.00..269.50 rows=1 width=0) (never executed)

308. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_137.barcode) AND (co_op_137.type_id = $0))
309. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

310. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice54; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

311. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_53 co_op_137 (cost=0.00..269.50 rows=1 width=0) (never executed)

312. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_138.barcode) AND (co_op_138.type_id = $0))
313. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

314. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice55; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

315. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_54 co_op_138 (cost=0.00..269.50 rows=1 width=0) (never executed)

316. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_139.barcode) AND (co_op_139.type_id = $0))
317. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

318. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice56; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

319. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_55 co_op_139 (cost=0.00..269.50 rows=1 width=0) (never executed)

320. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_140.barcode) AND (co_op_140.type_id = $0))
321. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

322. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice57; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

323. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_56 co_op_140 (cost=0.00..269.50 rows=1 width=0) (never executed)

324. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_141.barcode) AND (co_op_141.type_id = $0))
325. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

326. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice58; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

327. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_57 co_op_141 (cost=0.00..269.50 rows=1 width=0) (never executed)

328. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_142.barcode) AND (co_op_142.type_id = $0))
329. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

330. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice59; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

331. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_58 co_op_142 (cost=0.00..269.50 rows=1 width=0) (never executed)

332. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_143.barcode) AND (co_op_143.type_id = $0))
333. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

334. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice60; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

335. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_59 co_op_143 (cost=0.00..269.50 rows=1 width=0) (never executed)

336. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_144.barcode) AND (co_op_144.type_id = $0))
337. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

338. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice61; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

339. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_60 co_op_144 (cost=0.00..269.50 rows=1 width=0) (never executed)

340. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_145.barcode) AND (co_op_145.type_id = $0))
341. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

342. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice62; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

343. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_61 co_op_145 (cost=0.00..269.50 rows=1 width=0) (never executed)

344. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_146.barcode) AND (co_op_146.type_id = $0))
345. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

346. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice63; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

347. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_62 co_op_146 (cost=0.00..269.50 rows=1 width=0) (never executed)

348. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_147.barcode) AND (co_op_147.type_id = $0))
349. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

350. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice64; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

351. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_63 co_op_147 (cost=0.00..269.50 rows=1 width=0) (never executed)

352. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_148.barcode) AND (co_op_148.type_id = $0))
353. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

354. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice65; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

355. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_64 co_op_148 (cost=0.00..269.50 rows=1 width=0) (never executed)

356. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_149.barcode) AND (co_op_149.type_id = $0))
357. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

358. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice66; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

359. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_65 co_op_149 (cost=0.00..269.50 rows=1 width=0) (never executed)

360. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_150.barcode) AND (co_op_150.type_id = $0))
361. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

362. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice67; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

363. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_66 co_op_150 (cost=0.00..269.50 rows=1 width=0) (never executed)

364. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_151.barcode) AND (co_op_151.type_id = $0))
365. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

366. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice68; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

367. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_67 co_op_151 (cost=0.00..269.50 rows=1 width=0) (never executed)

368. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_152.barcode) AND (co_op_152.type_id = $0))
369. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

370. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice69; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

371. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_68 co_op_152 (cost=0.00..269.50 rows=1 width=0) (never executed)

372. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_153.barcode) AND (co_op_153.type_id = $0))
373. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

374. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice70; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

375. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_69 co_op_153 (cost=0.00..269.50 rows=1 width=0) (never executed)

376. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_154.barcode) AND (co_op_154.type_id = $0))
377. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

378. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice71; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

379. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_70 co_op_154 (cost=0.00..269.50 rows=1 width=0) (never executed)

380. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_155.barcode) AND (co_op_155.type_id = $0))
381. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

382. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice72; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

383. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_71 co_op_155 (cost=0.00..269.50 rows=1 width=0) (never executed)

384. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_156.barcode) AND (co_op_156.type_id = $0))
385. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

386. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice73; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

387. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_72 co_op_156 (cost=0.00..269.50 rows=1 width=0) (never executed)

388. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_157.barcode) AND (co_op_157.type_id = $0))
389. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

390. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice74; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

391. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_73 co_op_157 (cost=0.00..269.50 rows=1 width=0) (never executed)

392. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_158.barcode) AND (co_op_158.type_id = $0))
393. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

394. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice75; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

395. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_74 co_op_158 (cost=0.00..269.50 rows=1 width=0) (never executed)

396. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_159.barcode) AND (co_op_159.type_id = $0))
397. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

398. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice76; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

399. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_75 co_op_159 (cost=0.00..269.50 rows=1 width=0) (never executed)

400. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_160.barcode) AND (co_op_160.type_id = $0))
401. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

402. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice77; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

403. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_76 co_op_160 (cost=0.00..269.50 rows=1 width=0) (never executed)

404. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_161.barcode) AND (co_op_161.type_id = $0))
405. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

406. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice78; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

407. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_77 co_op_161 (cost=0.00..269.50 rows=1 width=0) (never executed)

408. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_162.barcode) AND (co_op_162.type_id = $0))
409. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

410. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice79; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

411. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_78 co_op_162 (cost=0.00..269.50 rows=1 width=0) (never executed)

412. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_163.barcode) AND (co_op_163.type_id = $0))
413. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

414. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice80; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

415. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_79 co_op_163 (cost=0.00..269.50 rows=1 width=0) (never executed)

416. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_164.barcode) AND (co_op_164.type_id = $0))
417. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

418. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice81; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

419. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_80 co_op_164 (cost=0.00..269.50 rows=1 width=0) (never executed)

420. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_165.barcode) AND (co_op_165.type_id = $0))
421. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

422. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice82; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

423. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_81 co_op_165 (cost=0.00..269.50 rows=1 width=0) (never executed)

424. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_166.barcode) AND (co_op_166.type_id = $0))
425. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

426. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice83; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

427. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_82 co_op_166 (cost=0.00..269.50 rows=1 width=0) (never executed)

428. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_167.barcode) AND (co_op_167.type_id = $0))
429. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

430. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice84; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

431. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_83 co_op_167 (cost=0.00..269.50 rows=1 width=0) (never executed)

432. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_168.barcode) AND (co_op_168.type_id = $0))
433. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

434. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice85; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

435. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_84 co_op_168 (cost=0.00..269.50 rows=1 width=0) (never executed)

436. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..269.50 rows=1 width=0) (never executed)

  • Filter: ((co.barcode = co_op_169.barcode) AND (co_op_169.type_id = $0))
437. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..269.50 rows=1 width=0) (never executed)

438. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice86; segments: 4) (cost=0.00..269.50 rows=1 width=0) (never executed)

439. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_85 co_op_169 (cost=0.00..269.50 rows=1 width=0) (never executed)

440. 0.000 0.000 ↓ 0.0 0

Materialize (cost=4.83..20,515.88 rows=241 width=32) (never executed)

441. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 4:4 (slice88; segments: 4) (cost=4.83..20,511.08 rows=241 width=32) (never executed)

442. 0.000 0.000 ↓ 0.0 0

Append (cost=4.83..20,511.08 rows=241 width=32) (never executed)

443.          

Initplan (for Append)

444. 0.000 0.000 ↓ 0.0 0 1

Gather Motion 4:1 (slice87; segments: 4) (cost=0.00..4.83 rows=1 width=4) (actual time=2.538..0.000 rows=0 loops=1)

445. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_type ope_typ_1 (cost=0.00..4.83 rows=1 width=4) (never executed)

  • Filter: (code = 'IM_CONTAINER_RECALCULATING'::text)
446. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_other_periods co_op_170 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
447. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_2 co_op_171 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
448. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_3 co_op_172 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
449. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_4 co_op_173 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
450. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_5 co_op_174 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
451. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_6 co_op_175 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
452. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_7 co_op_176 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
453. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_8 co_op_177 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
454. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_9 co_op_178 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
455. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_10 co_op_179 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
456. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_11 co_op_180 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
457. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_12 co_op_181 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
458. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_13 co_op_182 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
459. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_14 co_op_183 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
460. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_15 co_op_184 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
461. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_16 co_op_185 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
462. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_17 co_op_186 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
463. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_18 co_op_187 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
464. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_19 co_op_188 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
465. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_20 co_op_189 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
466. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_21 co_op_190 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
467. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_22 co_op_191 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
468. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_23 co_op_192 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
469. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_24 co_op_193 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
470. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_25 co_op_194 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
471. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_26 co_op_195 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
472. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_27 co_op_196 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
473. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_28 co_op_197 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
474. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_29 co_op_198 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
475. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_30 co_op_199 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
476. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_31 co_op_200 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
477. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_32 co_op_201 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
478. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_33 co_op_202 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
479. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_34 co_op_203 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
480. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_35 co_op_204 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
481. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_36 co_op_205 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
482. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_37 co_op_206 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
483. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_38 co_op_207 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
484. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_39 co_op_208 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
485. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_40 co_op_209 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
486. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_41 co_op_210 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
487. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_42 co_op_211 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
488. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_43 co_op_212 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
489. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_44 co_op_213 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
490. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_45 co_op_214 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
491. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_46 co_op_215 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
492. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_47 co_op_216 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
493. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_48 co_op_217 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
494. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_49 co_op_218 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
495. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_50 co_op_219 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
496. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_51 co_op_220 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
497. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_52 co_op_221 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
498. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_53 co_op_222 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
499. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_54 co_op_223 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
500. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_55 co_op_224 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
501. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_56 co_op_225 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
502. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_57 co_op_226 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
503. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_58 co_op_227 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
504. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_59 co_op_228 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
505. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_60 co_op_229 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
506. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_61 co_op_230 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
507. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_62 co_op_231 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
508. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_63 co_op_232 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
509. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_64 co_op_233 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
510. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_65 co_op_234 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
511. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_66 co_op_235 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
512. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_67 co_op_236 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
513. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_68 co_op_237 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
514. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_69 co_op_238 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
515. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_70 co_op_239 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
516. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_71 co_op_240 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
517. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_72 co_op_241 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
518. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_73 co_op_242 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
519. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_74 co_op_243 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
520. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_75 co_op_244 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
521. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_76 co_op_245 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
522. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_77 co_op_246 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
523. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_78 co_op_247 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
524. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_79 co_op_248 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
525. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_80 co_op_249 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
526. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_81 co_op_250 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
527. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_82 co_op_251 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
528. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_83 co_op_252 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
529. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_84 co_op_253 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
530. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_operation_1_prt_85 co_op_254 (cost=0.00..241.25 rows=3 width=32) (never executed)

  • Filter: (type_id = $3)
Planning time : 25.933 ms
Execution time : 4,091.743 ms