Re: Strange "actual time" in simple CTE

2023-12-03 Thread Jeff Janes
On Sat, Dec 2, 2023 at 11:50 AM Jean-Christophe Boggio < postgre...@thefreecat.org> wrote: > Hello, > > I am trying to optimize a complex query and while doing some explains, I > stumbled upon this : > >CTE cfg > -> Result (cost=2.02..2.03 rows=1 width=25) (actual > time=7167.478..7167.

Strange "actual time" in simple CTE

2023-12-02 Thread Jean-Christophe Boggio
Hello, I am trying to optimize a complex query and while doing some explains, I stumbled upon this :   CTE cfg     ->  Result  (cost=2.02..2.03 rows=1 width=25) (actual time=7167.478..7167.481 rows=1 loops=1)   Buffers: shared hit=2   InitPlan 1 (returns $0)     ->  L