Expose JIT counters/timing in pg_stat_statements

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Expose JIT counters/timing in pg_stat_statements
Date: 2022-02-25 13:06:29
Message-ID: CABUevEySt4NTYqvWzwyAW_0-jG1bjN-y+tykapAnA0FALOs+Lw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Here's a patch to add the sum of timings for JIT counters to
pg_stat_statements, as a way to follow-up on if JIT is doing a good or
a bad job in a configuration.

I decided to only store the total time for the timings, since there
are 4 different timings and storing max/min/etc for each one of them
would lead to a bit too much data. This can of course be reconsidered,
but I think that's a reasonable tradeoff.

Another option I guess could be to store the max/min/etc, but only
store for the total jit time instead of for each individual one. Maybe
that'd actually be more useful?

--
Magnus Hagander
Me: https://www.hagander.net/
Work: https://www.redpill-linpro.com/

Attachment Content-Type Size
pg_stat_statements_jit.patch text/x-patch 11.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Japin Li 2022-02-25 13:08:20 Re: [PATCH] add relation and block-level filtering to pg_waldump
Previous Message Dilip Kumar 2022-02-25 13:05:57 Re: should vacuum's first heap pass be read-only?