Top
Enterprise Postgres 17 Operation Guide

D.2 pgx_stat_lwlock

The pgx_stat_lwlock view displays statistics related to lightweight locks, with each type of content displayed on a separate line.

Table D.2 pgx_stat_lwlock view

Column

Type

Description

lwlock_name

name

Name of the lightweight lock

total_waits

bigint

Number of waits caused by the lightweight lock

total_wait_time

double precision

Number of milliseconds spent in waits caused by the lightweight lock

stats_reset

timestamp with timezone

Last time at which this statistics was reset