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