PgSQL - 12 queries/sec - Tractus-X EDC 0.10.1
SELECT * FROM edc_contract_negotiation LEFT JOIN edc_contract_agreement agr ON edc_contract_negotiation.agreement_id = agr.agr_id WHERE state = $1 AND pending = $2 AND type = $3 AND (lease_id IS NULL OR lease_id IN (SELECT lease_id FROM edc_lease WHERE ($4 > (leased_at + lease_duration)))) ORDER BY state_timestamp ASC LIMIT $5 OFFSET $6edc.negotiation.consumer.state-machine.iteration-wait-millisedc.negotiation.consumer.state-machine.batch-sizeedc.negotiation.consumer.send.retry.limitedc.negotiation.consumer.send.retry.base-delay.ms
edc.negotiation.provider.state-machine.iteration-wait-millisedc.negotiation.provider.state-machine.batch-sizeedc.negotiation.provider.send.retry.limitedc.negotiation.provider.send.retry.base-delay.ms
edc.negotiation.state-machine.iteration-wait-millisedc.transfer.state-machine.batch-sizeedc.transfer.state-machine.iteration-wait-millis