JIT explain output

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: JIT explain output
Date: 2018-08-23 19:10:19
Message-ID: 21432f73-df45-139d-271c-81cbee15446b@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Some minor comments on the JIT explain output. For example:

Seq Scan on tenk1 (cost=0.00..483.00 rows=3333 width=244) (actual
time=5.564..8.755 rows=4960 loops=1)
Filter: (unique1 > unique2)
Rows Removed by Filter: 5040
Planning Time: 0.857 ms
JIT:
Functions: 2
Generation Time: 0.439 ms
Inlining: false
Inlining Time: 0.000 ms
Optimization: false
Optimization Time: 0.375 ms
Emission Time: 5.020 ms
Execution Time: 25.230 ms

Why is the optimization time nonzero when optimization is claimed to be off?

Could we perhaps save some vertical space by showing alternatively:

Optimization Time: 0.375 ms

and

Optimization Time: off

and omit the Optimization: line? Similarly for Inlining.

What is the Generation Time and Emissions Time? Could we document this?
Is there a benefit to the user to see them listed separately?

It might be useful to see a JIT total time somewhere, which would be the
sum of all the phases. Then it's easier to compare that against the
total run time.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2018-08-23 19:19:19 Re: JIT explain output
Previous Message Tom Lane 2018-08-23 19:05:53 Re: A really subtle lexer bug