[Pgpool-hackers] Admin interface, statistics views, etc

[Guillaume Lelarge]

Le 05/08/2010 15:30, Tatsuo Ishii a écrit :
>> Le 03/08/2010 13:29, Guillaume Lelarge a écrit :
>>> Le 03/08/2010 12:23, Tatsuo Ishii a écrit :
>>>>> Le 03/08/2010 03:48, Tatsuo Ishii a écrit :
>>>>>>>>> AFAICT, it works really good. We still miss pgsql_pid. And should I add
>>>>>>>>> some other reports? what do other people need?
>>>>>>>>>
>>>>>>>>
>>>>>>>> No comments on this patch? meaning I should commit it or not?
>>>>>>>
>>>>>>> I was waiting for you add pgsql_pid. Have you done it?
>>>>>>
>>>>>> I have added new function:
>>>>>> /*
>>>>>>  * Return pointer to i th child, j th connection pool and k th backend
>>>>>>  * of connection info on shmem.
>>>>>>  */
>>>>>> ConnectionInfo *pool_coninfo(int child, int connection_pool, int backend)
>>>>>>
>>>>>> I hope this will make your implementation regarding pgsql_pid easier.
>>>>>> For example, pool_coninfo(10, 0, 1) will return pointer to
>>>>>> ConnectionInfo corresponds to 1th backend pid which is in 0th
>>>>>> connection pool in 10th pgpool child.
>>>>>
>>>>> Sorry for not answering sooner. I thought you were working on adding
>>>>> pgsql_pid. There was a little misunderstanding :)
>>>>
>>>> Oh, I thought I woould work on pcp command, you would work on show
>>>> command. 
>>>>
>>>
>>> No problem :)
>>>
>>> I'll work on it ASAP.
>>>
>>
>> With your last commits, it makes it quite easy to do. Here is my new
>> patch.
> 
> Thanks. I will look into this.
> 
>> I still have an issue and perhaps you have an idea on how to
>> resolve it. Is there a way to know which connection is the active one in
>> a pool?
> 
> Good question:-) I never thought about it. Let me check...

Just to give you my idea. If you do a "SHOW pool_processes", it gives
you a list of all processes. It also shows the database and the username
of the first connection in the pool of the process. And it would be best
if it can show you the database of the currently active connection in
the pool. BTW, the same could apply to pcp_proc_info: adding a simple
column showing the active connection in the pool handled by the
specified process.


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com