PostgreSQL

Database

postgres://postgresql://

The query is the request. Parameterised SELECT/INSERT/UPDATE, bound safely with $1, $2, … and pooled per VU via sqlx. Built with only the postgres feature — no rsa advisory.

Install

$ loadr plugin install postgres

postgres.yaml

plugins:
  - name: postgres       # resolves postgres:// at runtime

scenarios:
  reads:
    executor: constant-vus
    vus: 10
    duration: 30s
    flow:
      - request:
          url: postgres://loadr:loadr@db:5432/loadr
          sql:
            query: SELECT id, name FROM products WHERE price < $1
            params: ["50"]
          checks:
            - { type: status, equals: 1 }
            - { type: duration, max: 250ms }

thresholds:
  postgres_req_duration: [ "p(95)<300ms" ]
  postgres_reqs: [ "count>0" ]

Metrics: postgres_reqs · postgres_req_duration · postgres_rows.

Read the docs → Watch the demo

Install the plugin, then drive parameterised queries against PostgreSQL — see demo #16.

A runtime plugin, never in the binary

Installing pulls a per-platform driver from the signed index, verifies its SHA-256 and checks its ABI before it ever loads. Remove it any time with loadr plugin remove postgres.

← MongoDB All plugins MySQL →