category)::text = 'CASH'::text))
Filter: ((currency)::text =
(users.real_base_currency)::text)
Buffers: shared hit=67
Planning:
Buffers: shared hit=859
Planning Time: 50.833 ms
Execution Time: 5.480 ms
(85 rows)
On Fri, 9 Sept 2022 at 22:06, Max
We do have JIT enabled `jit=on` with `jit_above_cost=10`.
I am sorry but I don't quite understand what role JIT plays in
this situation with `auto_explain`. Could you please elaborate on that?
On Tue, 6 Sept 2022 at 00:29, Maxim Boguk wrote:
>
>
> On Tue, Aug 30, 2022 at 1
`auto_explain.log_min_duration` is set to 500 ms.
On Mon, 5 Sept 2022 at 12:35, Peter J. Holzer wrote:
> On 2022-09-02 10:58:58 +0100, Matheus Martin wrote:
> > Yes, we do see some plans logged by the auto_explain. We couldn't find a
> > `auto_explain.log_min_duration
ic we have, we cannot lower the
threshold for the auto_explain.
`log_lock_waits` is turned on and the logs do not indicate any locks
related to the tables in the query.
On Fri, 2 Sept 2022 at 05:49, Julien Rouhaud wrote:
> Hi,
>
> On Thu, Sep 01, 2022 at 08:20:13PM +0100, Matheus Martin
rt it?
On Tue, 30 Aug 2022 at 17:45, Alvaro Herrera
wrote:
> On 2022-Aug-30, Matheus Martin wrote:
>
> > Good idea on using an actual prepared statement but unfortunately it
> didn't
> > produce any different result.
>
> I should have also mentioned to try the EXPLA
The threshold for `auto_explain` was changed to 500 ms and explain plans
are still not being logged.
On Tue, 30 Aug 2022 at 13:30, Julien Rouhaud wrote:
> Hi,
>
> On Tue, Aug 30, 2022 at 01:16:43PM +0200, Alvaro Herrera wrote:
> > On 2022-Aug-30, Matheus Martin wrote:
> &g
> On 2022-Aug-30, Matheus Martin wrote:
>
> > Our Postgres recently started reporting considerably different
> > execution times for the same query. When executed from our JDBC
> > application the Postgres logs report an average execution time of 1500
> > ms but whe
Our Postgres recently started reporting considerably different
execution times for the same query. When executed from our JDBC
application the Postgres logs report an average execution time of 1500
ms but when the query is manually executed through `psql` it doesn't
take longer than 50 ms.
With a
