High memory consumption in file import with 400k records

[belchiorplan]

I'm trying to import a file with 400k lines and 130MB, but there's always a lack of memory, even with 12gb of VRAM and 3gb of Swap in docker, always giving me the error: The process has been signaled with signal "9".

class MarginServeImports implements ToCollection, WithHeadingRow, WithBatchInserts, WithChunkReading, ShouldQueue, WithEvents
{
    use Importable, SkipsErrors, SkipsFailures, RegistersEventListeners;

    public function collection(Collection $rows)
    {
        try {

            DB::beginTransaction();

            foreach ($rows as $value) {

                $client               = Cliente::where('codigo', $value['codigo'])->first();

                $representativeId     = null;
                $clientId             = null;
                $date                 = null;

                if ($client){
                    $clientId         = $client->id;
                }

                if ($client) {
                    $representative   = $client->representanterelacionado->first();
                    $representativeId = $representative->representante_id;
                }

                if ($value['mes'] && $value['ano']) {
                    if (strlen($value['mes']) == 1) {
                        $value['mes'] = '0' . $value['mes'];
                    }
                    $date = $value['ano'] . '-' .$value['mes'] . '-' . '01';
                }

                AnalyticsMarginServe::create([
                    'representative_id'       => $representativeId,
                    'client_id'               => $clientId,
                    'date'                    => $date,
                    'volume'                  => $value['volume'],
                    'bonus'                   => $value['bonificacao'],
                    'gross_revenue'           => $value['receita_bruta'],
                    'ICMS'                    => $value['icms'],
                    'PIS'                     => $value['pis'],
                    'cofins'                  => $value['cofins'],
                    'INSS'                    => $value['inss'],
                    'devolution'              => $value['devolucao'],
                    'liquid_revenue'          => $value['receita_liquida'],
                    'CPV'                     => $value['cpv'],
                    'fixed'                   => $value['fixo'],
                    'variable'                => $value['variavel'],
                    'sales_administrative'    => $value['administrativo_vendas'],
                    'regional_group'          => $value['equipe_regional'],
                    'third_commission'        => $value['comissao_terceiros'],
                    'third_award'             => $value['premiacao_terceiros'],
                    'exportation'             => $value['exportacao'],
                    'logistic_administrative' => $value['administrativo_logistica'],
                    'expedition_storage'      => $value['armaz_e_exped'],
                    'transference'            => $value['transferencia'],
                    'supply'                  => $value['entrega'],
                    'trade_administrative'    => $value['administrativo_trade'],
                    'regional_trade_group'    => $value['eq_reg_trades'],
                    'promoter_group'          => $value['equipe_promotores'],
                    'trade_investiment'       => $value['investimento_trade'],
                    'margin_serve'            => $value['margem_servir'],
                    'contract'                => $value['contrato'],
                    'sales'                   => $value['vendas'],
                    'logistic'                => $value['logistica'],
                    'trade'                   => $value['trade'],
                    'promotion'               => $value['promocoes'],
                    'AVP'                     => $value['avp'],
                    'sandene_profit_gross'    => $value['lucro_bruto_sandene'],
                    'proper_group'            => $value['equipe_propria'],
                    'proper_award'            => $value['premiacao_proprios']
                ]);
            }

            DB::commit();

        } catch (Exception $e) {
            DB::rollBack();
            dd($e);
            // throw new Exception('Problema ao importar planilha.');
        }
    }

    public function batchSize(): int
    {
        return 200;
    }

    public function chunkSize(): int
    {
        return 200;
    }

    public static function afterImport(AfterImport $event)
    {
    }

    public function onFailure(Failure ...$failure)
    {
    }
}`