Postgres Pro
Downloads
Home   >   mailing lists

Add the number of pinning backends to pg_buffercache's output - Mailing list pgsql-hackers

From Andres Freund
Subject Add the number of pinning backends to pg_buffercache's output
Date
Msg-id 20140412122501.GS14419@alap3.anarazel.de
Whole thread Raw
Responses Re: Add the number of pinning backends to pg_buffercache's output
List pgsql-hackers
Tree view 
Hi,

The last week I twice had the need to see how many backends had some
buffers pinned. Once during development and once while analyzing a stuck
vacuum (waiting for a cleanup lock).
I'd like to add a column to pg_buffercache exposing that. The name I've
come up with is 'pinning_backends' to reflect the fact that it's not the
actual pincount due to the backend private arrays.

I'll add this patch to to 2014-06 CF.

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
Attachment

pgsql-hackers by date:

Previous
From: "MauMau"
Date:
Subject: Re: [bug fix] pg_ctl always uses the same event source
Next
From: Jan Wieck
Date:
Subject: Re: Problem with txid_snapshot_in/out() functionality