Re: Postgresql 14 performance

On 8/21/22 16:13, Kenny Bachman wrote:
> Hi again,
>
> JIT is already enabled. And here is the perf top output:
>
Kenny, JIT is not mentioned in any of your plans. Look how it looks,
with JIT enabled:

QUERY PLAN
-------------------------------------------------------------------------------------------------------
 Aggregate  (cost=1682569.70..1682569.71 rows=1 width=8)
   ->  Nested Loop  (cost=0.00..1419035.94 rows=105413504 width=0)
         ->  Nested Loop  (cost=0.00..101365.96 rows=7529536 width=0)
               ->  Nested Loop  (cost=0.00..7245.59 rows=537824 width=0)
                     ->  Nested Loop  (cost=0.00..521.62 rows=38416
width=0)
                           ->  Nested Loop  (cost=0.00..40.24 rows=2744
width=0)
                                 ->  Nested Loop (cost=0.00..4.77
rows=196 width=0)
                                       ->  Seq Scan on emp e1 
(cost=0.00..1.14 rows=14 width=0)
                                       ->  Materialize (cost=0.00..1.21
rows=14 width=0)
                                             ->  Seq Scan on emp e2 
(cost=0.00..1.14 rows=14 width=0)
                                 ->  Materialize (cost=0.00..1.21
rows=14 width=0)
                                       ->  Seq Scan on emp e3 
(cost=0.00..1.14 rows=14 width=0)
                           ->  Materialize  (cost=0.00..1.21 rows=14
width=0)
                                 ->  Seq Scan on emp e4
(cost=0.00..1.14 rows=14 width=0)
                     ->  Materialize  (cost=0.00..1.21 rows=14 width=0)
                           ->  Seq Scan on emp e5 (cost=0.00..1.14
rows=14 width=0)
               ->  Materialize  (cost=0.00..1.21 rows=14 width=0)
                     ->  Seq Scan on emp e6  (cost=0.00..1.14 rows=14
width=0)
         ->  Materialize  (cost=0.00..1.21 rows=14 width=0)
               ->  Seq Scan on emp e7  (cost=0.00..1.14 rows=14 width=0)
* JIT:**
**   Functions: 14**
**   Options: Inlining true, Optimization true, Expressions true,
Deforming true**
**(23 rows)*

Look at the end. There is no such section in any of your plans.

Regards

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com