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
