> On May 16, 2026, at 7:46 AM, Tom Lane <[email protected]> wrote:
>
> Igor Korot <[email protected]> writes:
>> Is there a way to see if the query has been prepared already (in libpq)?
>
> Use the pg_prepared_statements view. I don't think libpq keeps any
> client-side state about this.
>
>> Or is it better to run for all known parameterized queries
>> in the very beginning of the program and just execute them when needed?
>
> Very probably. Querying every time would be
> expensive.
>
If I am following correctly, one may query pg_prepared_statements with a
specific query in hand. Should it not then be possible to cache that query as
having been planned/prepared and proceed accordingly?
Might there be value in calling PQprepare as late as possible against most
up-to-dare data?
>