Man page - pgpool_adm_pcp_health_check_stats(3)
Packages contains this manual
- pcp_invalidate_query_cache(1)
- pgpool_adm_pcp_node_count(3)
- pcp_proc_info(1)
- pcp_recovery_node(1)
- pcp_common_options(1)
- pgpool_adm_pcp_pool_status(3)
- pcp_proc_count(1)
- pcp_log_rotate(1)
- pgpool_adm_pcp_node_info(3)
- pgpool_adm_pcp_attach_node(3)
- pcp_stop_pgpool(1)
- pcp_node_count(1)
- pgpool_setup(1)
- pcp_health_check_stats(1)
- pgpool_adm_pcp_detach_node(3)
- pgpool_adm_pcp_health_check_stats(3)
- pg_md5(1)
- pcp_promote_node(1)
- pcp_pool_status(1)
- pcp_detach_node(1)
- wd_cli(1)
- pg_enc(1)
- pcp_reload_config(1)
- pgpool_adm_pcp_proc_info(3)
- pcp_watchdog_info(1)
- pgproto(1)
- pgpool(8)
- watchdog_setup(1)
- pcp_node_info(1)
- pcp_attach_node(1)
apt-get install pgpool2
Manual
PGPOOL_ADM_PCP_HEALTH_CHECK_STAT
NAMESYNOPSIS
DESCRIPTION
ARGUMENTS
EXAMPLE
NAME
pgpool_adm_pcp_health_check_stats - a function to display health check statistics data on given node ID
SYNOPSIS
|
pcp_health_check_stats returns record(integer node_id , text host , integer port , text username , text password , out node_idĀ integer , out hostĀ text , out portĀ integer , out statusĀ text , out roleĀ text , out last_status_changeĀ timestamp , out total_countĀ bigint , out success_countĀ bigint , out fail_countĀ bigint , out skip_countĀ bigint , out retry_countĀ bigint , out average_retry_countĀ bigint , out max_retry_countĀ bigint , out max_health_check_durationĀ bigint , out min_health_check_durationĀ bigint , out average_health_check_durationĀ float4 , out last_health_checkĀ timestamp , out last_successful_health_checkĀ timestamp , out last_skip_health_checkĀ timestamp , out last_failed_health_checkĀ timestamp ); |
|
|
pcp_health_check_stats returns record(integer node_id , text pcp_server , out node_idĀ integer , out hostĀ text , out portĀ integer , out statusĀ text , out roleĀ text , out last_status_changeĀ timestamp , out total_countĀ bigint , out success_countĀ bigint , out fail_countĀ bigint , out skip_countĀ bigint , out retry_countĀ bigint , out average_retry_countĀ bigint , out max_retry_countĀ bigint , out max_health_check_durationĀ bigint , out min_health_check_durationĀ bigint , out average_health_check_durationĀ float4 , out last_health_checkĀ timestamp , out last_successful_health_checkĀ timestamp , out last_skip_health_checkĀ timestamp , out last_failed_health_checkĀ timestamp ); |
DESCRIPTION
pcp_health_check_stats displays health check statistics data on given node ID.
ARGUMENTS
node_id
The index of backend node to get information of.
pcp_server
The foreign server name for pcp server.
Other arguments
See pcp_common_options (1).
EXAMPLE
Here is an example output:
test=# select *
from pcp_health_check_stats(node_id => 0, host => '',
port => 11001, username => 't-ishii', password =>
't-ishii');
-[ RECORD 1 ]-----------------+--------------------
node_id | 0
host | /tmp
port | 11002
status | up
role | primary
last_status_change | 2020-02-25 16:05:29
total_count | 3
success_count | 3
fail_count | 0
skip_count | 0
retry_count | 0
average_retry_count | 0
max_retry_count | 0
max_health_check_duration | 5
min_health_check_duration | 3
average_health_check_duration | 4.333333
last_health_check | 2020-02-25 16:05:47
last_successful_health_check | 2020-02-25 16:05:47
last_skip_health_check |
last_failed_health_check |
See TableĀ 29, āStatistics data shown by pool_health_check_stats commandā for details of data.