View Issue Details

IDProjectCategoryView StatusLast Update
0000739Pgpool-IIEnhancementpublic2021-11-22 11:40
Reportern-oden Assigned Tot-ishii  
PriorityhighSeverityfeatureReproducibilityN/A
Status closedResolutionopen 
PlatformallOSallOS Versionall
Product Version4.2.5 
Summary0000739: pgpool should report the number of backend connections in use per child process
DescriptionPresently, pgpool (via SHOW POOL_PROCESSES) reports the total number of child processes and whether they are in use.

But it does not report how many of MAX_POOL backend connections each child process is currently using, which means that operators will have no warning that pgpool is approaching a state where it will have to turn away new client connections.
Steps To Reproducen/a
Tagsmonitoring

Activities

t-ishii

2021-11-20 08:09

developer   ~0003959

You can use SHOW POOL_POOLS instead.
https://www.pgpool.net/docs/latest/en/html/sql-show-pool-pools.html

n-oden

2021-11-21 00:48

reporter   ~0003960

@t-ishii oh good grief, my fault for not reading the documentation closely enough. Thank you!

t-ishii

2021-11-22 11:39

developer   ~0003961

Sure no problem. I am going to close this issue.

Issue History

Date Modified Username Field Change
2021-11-20 01:07 n-oden New Issue
2021-11-20 01:07 n-oden Tag Attached: monitoring
2021-11-20 08:09 t-ishii Note Added: 0003959
2021-11-21 00:48 n-oden Note Added: 0003960
2021-11-22 11:38 t-ishii Assigned To => t-ishii
2021-11-22 11:38 t-ishii Status new => assigned
2021-11-22 11:39 t-ishii Note Added: 0003961
2021-11-22 11:40 t-ishii Status assigned => closed