<div dir="ltr">Hi!<div><br></div><div>By occupation I mean utilization.. Something that I can see that the pgpool are with '98% of connections slots in use'. I use the pgpool into a docker container, so I like to 'kill' the container when pgpool get 99% of utilization, so docker swarm (docker orchestrator) will launch a brand new container. When I do this, the vacuum in database nodes are more effective, the cache are released, I guarantee that all the requests will be executed because it will have free connections to use always. I do this 'kill' frequently by crontab, but it consume some host resources that are not so good. Basically I need to now if the pgpool has slot to receive more connections, if don't, I'll kill the container.</div><div><br></div><div>I like to propose the following features to monitoring:</div><div><br></div><div>- A metric that calculates the utilization of pgpool, calculating a percentage using num_init_children, max_pool and child_max_connections</div><div>- A metric that show the query execution time</div><div>- A metric that show the 'tps', like in pg_top. So I can monitor how many transactions has been executed in the pool to measure the efficiency</div><div><br></div><div>ahhhh, thank you for the fast return! You rock!</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Em qua, 11 de set de 2019 às 19:46, Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>> escreveu:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">> Hi!<br>
> <br>
> I have 3 questions:<br>
> <br>
> 1. How can I get node occupation? I have pgpools in docker containers, and<br>
> I want to recycle the container when the occupation gets 95~99% to avoid<br>
> that the requests are denied.<br>
<br>
What is "occupation"? I am not familiar with docker.<br>
<br>
> 2. Is there any way to get the execution time from statements? My system<br>
> has some users in Oracle and anothers in Postgres .. We are migrating to<br>
> Postgres. But the requests to Postgres have twice the time to the same<br>
> request that Oracle, but the Postgres servers (1 master and 1 slave in<br>
> native stream replication) are more robust then the Oracle's and it has<br>
> resources left. We're using about 30% of memory and 10% of CPU. I want to<br>
> find out if the pgpool configuration are satisfactory by comparing the<br>
> response time from postgres node log and the response time on pgpool.<br>
<br>
There's no such a feature in pgpool. I think it's not terribly hard to<br>
implement it though.<br>
<br>
> 3. May I try to improve the tool by contribuiting in the project? How can I<br>
> do this?<br>
<br>
We mostly follow PostgreSQL's way. You can propose design of new<br>
feature in this mailing list to start discussion, along with patches<br>
against git repository if possible. Developers, including me, will<br>
reply to your postings to continue the discussion. Once developers<br>
agree with the patch, one of committers will commit/push the patch. We<br>
always welcome contributions to the project. Please don't hesitate to<br>
ask questions regarding contribution works.<br>
<br>
> I hope you made me understand.<br>
> <br>
> Thanks guys!<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr">Abraços!<br><br>=============================<br>José Roberto Emerich Junior<br>=============================</div></div></div></div>