Additional LWLOCK_STATS statistics

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

Responses

Browse pgsql-hackers by date

  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