Is it possible to turn off prepared statements on a per query basis?
I am not using Arel, I am constructing a rather elaborate SQL statement
with window functions, CTEs and such and then using
ActiveRecord::Base.with_connection to execute that statement.
Looking at pg_stats I see that for every invocation of that query there
is
a prepare running with ? instead of the values in the query and that the
average time for the prepare is twice that of actually running the
query.
I’d like to turn off the prepare to see if it makes a difference.
Thanks.