Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

JIT detailed info #393

Open
pgiraud opened this issue Jun 7, 2021 · 1 comment
Open

JIT detailed info #393

pgiraud opened this issue Jun 7, 2021 · 1 comment
Labels
enhancement New feature or request

Comments

@pgiraud
Copy link
Member

pgiraud commented Jun 7, 2021

We show JIT total time in the UI but without detail. In could be nice to show detailed information.

In plans, we can have info looking like:

JIT:
   Functions: 2
   Options: Inlining false, Optimization false, Expressions true, Deforming true
   Timing: Generation 0.244 ms, Inlining 0.000 ms, Optimization 0.121 ms, Emission 1.397 ms, Total 1.762 ms

In a text plan:

                                                                  QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
 Insert on tutu  (cost=0.00..100000.00 rows=10000000 width=4) (actual time=11543.790..11543.791 rows=0 loops=1)
   Buffers: shared hit=10088481 read=12 dirtied=44248 written=66480, temp read=17090 written=17090
   WAL: records=10000000 fpi=1 bytes=590001027
   ->  Function Scan on generate_series i  (cost=0.00..100000.00 rows=10000000 width=4) (actual time=826.266..2089.643 rows=10000000 loops=1)
         Buffers: temp read=17090 written=17090
 Planning Time: 0.039 ms
 JIT:
   Functions: 2
   Options: Inlining false, Optimization false, Expressions true, Deforming true
   Timing: Generation 0.153 ms, Inlining 0.000 ms, Optimization 0.068 ms, Emission 0.574 ms, Total 0.795 ms
 Execution Time: 11560.132 ms
(11 lignes)
@Krysztophe
Copy link

Different warnings could appear if Generation or Inlining or Optimization are a big part of the total query time.

These are different jit_*_above_cost parameters.

@pgiraud pgiraud added the enhancement New feature or request label Aug 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants