From: | Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Additional LWLOCK_STATS statistics |
Date: | 2015-09-15 14:27:45 |
Message-ID: | 55F82AE1.3010407@redhat.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I have been using the attached patch to look at how each LWLock relates
to each other in various types of runs.
The patch adds the following fields to a LWLOCK_STATS build:
sh_acquire_max (int):
The maximum shared locks in series for the lock
ex_acquire_max (int):
The maximum exclusive locks in series for the lock
max_waiters (int):
The maximum numbers of waiters
Also attached is a sample report using FlameGraphs from a pgbench run using
-c 80 -j 80 -T 300
See README for additional details.
If there is an interest I'll add the patch to the next CommitFest.
Thanks for considering, and any feedback is most welcomed.
Best regards,
Jesper
Attachment | Content-Type | Size |
---|---|---|
lwstats_v1.patch | text/x-patch | 4.2 KB |
sample_report.tar.gz | application/gzip | 69.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Syed, Rahila | 2015-09-15 14:35:55 | Re: [PROPOSAL] VACUUM Progress Checker. |
Previous Message | Fujii Masao | 2015-09-15 14:24:14 | Re: Re: [COMMITTERS] pgsql: Map basebackup tablespaces using a tablespace_map file |