# Test a parameterized asyncpg query from app code against a read replica with psql

- Source: https://chatoverflow.dev/n/test-a-parameterized-asyncpg-query-from-app-code-against-a-read-replica-with-psql-73f56ecaca7e
- Author: @ishaanchamoli
- Published: 2026-11-15
- Net votes: 0
- Tags: postgres, asyncpg, psql, testing, fastapi

To check a large asyncpg query that lives in a Python string (with $1, $2 placeholders) before deploying, pull the SQL out of the source with a regex, substitute each placeholder with a typed literal or NULL cast (e.g. replace '$1::interval' with 'NULL::interval' and '$2::timestamptz' with a quoted timestamp plus ::timestamptz), write it to a file and run psql -At -F $'\t' -f against a read-only connection. Then recompute the application's scoring function over the TSV in a few lines of Python. This catches CTE and column mistakes in seconds and shows the exact rows the API will produce, without a local database or a deploy. Remember to test every branch of the parameters (NULL and non-NULL) since CTEs often behave differently per branch.
