Reference¶
The following sections are provided for reference; please note that the items referred to in the following tables are subject to change.
PEM Server Configuration Parameters - Reference¶
You can use global configuration options to modify aspects of the PEM Server’s behavior. Please note that the list of configuration parameters is subject to change.
** Parameter name** |
Value and Unit |
Description |
|---|---|---|
audit_ log_reten tion_time |
30 days |
Specifies the number of days that an audit log will be retained on the PEM server. |
auto_c reate_age nt_alerts |
true |
Specifies whether to create default agent level alerts automatically when an agent is registered. |
auto_cr eate_serv er_alerts |
true |
Specifies whether to create default server level alerts automatically when a server is bound to an agent. |
cha rt_disabl e_bullets |
false |
Enable/disable bullets on line charts on dashboards and Capacity Manager reports. |
cm_data _points_p er_report |
50 |
Specifies the number of data points to plot on charts on Capacity Manager reports. |
cm_max _end_date _in_years |
5 years |
Specifies the maximum amount of time that the Capacity Manager will extrapolate data for. Ensures that threshold-based end dates of on reports do not get extrapolated indefinitely. |
d ash_alert s_timeout |
60 seconds |
Specifies the number of seconds after which the components of the Alerts dashboard are auto-refreshed. |
d ash_db_co mrol_span |
7 days |
Specifies the number of days worth of data to plot on the Commit/Rollback Analysis chart on the Database Analysis dashboard and Server Analysis dashboard. |
dash _db_comro l_timeout |
1800 seconds |
Specifies the number of seconds after which the Commits/Rollbacks line chart is auto-refreshed on the Database Analysis dashboard and Server Analysis dashboard. |
dash_db_ connoverv w_timeout |
300 seconds |
Specifies the number of seconds after which the Connection Overview pie chart is auto-refreshed in the Database Analysis dashboard. |
das h_db_even tlag_span |
7 days |
Specifies the number of days worth of data to plot on the Number of Events Lag chart for slony replication on the Database Analysis dashboard. |
dash_d b_eventla g_timeout |
1800 seconds |
Specifies the number of seconds after which the Number of Events Lag line chart for slony replication is auto-refreshed on the Database Analysis dashboard. |
das h_db_hott able_rows |
25 rows |
Specifies the number of rows to show on the HOT Table Analysis table on the Database Analysis dashboard. |
dash_d b_hottabl e_timeout |
300 seconds |
Specifies the number of seconds after which the Hot Tables table is auto-refreshed in the Database Analysis dashboard. |
dash_d b_io_span |
7 days |
Specifies the number of days worth of data to plot on the Database I/O Analysis chart on the Database Analysis dashboard and I/O Analysis dashboard. |
dash_db_i o_timeout |
1800 seconds |
Specifies the number of seconds after which the Database I/O line chart is auto-refreshed on the Database Analysis dashboard and I/O Analysis dashboard. |
d ash_db_ro wact_span |
7 days |
Specifies the number of days worth of data to plot on the Row Activity Analysis chart on the Database Analysis dashboard, the I/O Analysis dashboard, and the Server Analysis dashboard. |
dash _db_rowac t_timeout |
1800 seconds |
Specifies the number of seconds after which the Row Activity line chart is auto-refreshed on the Database Analysis dashboard, the I/O Analysis dashboard, and the Server Analysis dashboard. |
dash_ db_storag e_timeout |
300 seconds |
Specifies the number of seconds after which the Storage bar chart is auto-refreshed in the Database Analysis dashboard. |
da sh_db_tim elag_span |
7 days |
Specifies the number of days worth of data to plot on the Time Lag chart for Slony replication on the Database Analysis dashboard. |
dash_ db_timela g_timeout |
1800 seconds |
Specifies the number of seconds after which the Time Lag line chart for Slony replication is auto-refreshed on the Database Analysis dashboard. |
da sh_db_use ract_span |
7 days |
Specifies the number of days worth of data to plot on the User Activity Analysis chart on the Database Analysis dashboard. |
dash_ db_userac t_timeout |
1800 seconds |
Specifies the number of seconds after which the User Activity line chart is auto-refreshed in the Database Analysis dashboard. |
dash_ef m_timeout |
300 seconds |
Specifies the number of seconds after which the Failover Manager Node Status and Failover Manager Cluster Info line chart is auto-refreshed on the Streaming Replication dashboard. |
d ash_globa l_overvie w_timeout |
30 seconds |
Specifies the number of seconds after which the components of the Global Overview dashboard are auto-refreshed. |
d ash_heade r_timeout |
60 seconds |
Specifies the number of seconds after which the information on the header of all the dashboards are auto-refreshed. |
dash_io_c hkpt_span |
7 days |
Specifies the number of days worth of data to plot on the Checkpoints chart on the I/O Analysis dashboard. |
das h_io_chkp t_timeout |
1800 seconds |
Specifies the number of seconds after which the Checkpoints line chart is auto-refreshed on the I/O Analysis dashboard. |
dash_ io_hotind x_timeout |
300 seconds |
Specifies the number of seconds after which the Hot Indexes bar chart is auto-refreshed on the I/O Analysis dashboard. |
dash _io_hottb l_timeout |
300 seconds |
Specifies the number of seconds after which the Hot Tables bar chart is auto-refreshed on the I/O Analysis dashboard. |
dash_io_i ndex_obje ctio_rows |
25 rows |
Specifies the number of rows displayed on the Index Activity table on the I/O Analysis dashboard and the Object Activity Analysis dashboard. |
das h_io_inde x_objecti o_timeout |
60 seconds |
Specifies the number of seconds after which the Index Activity table is auto-refreshed on the I/O Analysis dashboard and the Object Activity Analysis dashboard. |
das h_io_obje ctio_rows |
25 rows |
Specifies the number of rows displayed in the Object I/O Details table on the I/O Analysis dashboard and Object Activity Analysis dashboard. |
dash_i o_objecti o_timeout |
300 seconds |
Specifies the number of seconds after which the Object I/O Details table is auto-refreshed on the I/O Analysis dashboard and Object Activity Analysis dashboard. |
dash_memo ry_hostme mact_span |
7 days |
Specifies the number of days worth of data to plot on the Host Memory Activity Analysis chart on the Memory Analysis dashboard. |
das h_memory_ hostmemac t_timeout |
1800 seconds |
Specifies the number of seconds after which the Host Memory Activity line chart is auto-refreshed on the Memory Analysis dashboard. |
dash _memory_h ostmemcon f_timeout |
300 seconds |
Specifies the number of seconds after which the Host Memory Configuration pie chart is auto-refreshed on the Memory Analysis dashboard and Server Analysis dashboard. |
dash_memo ry_servme mact_span |
7 days |
Specifies the number of days worth of data to plot on the server Memory Activity Analysis chart on the Memory Analysis dashboard. |
das h_memory_ servmemac t_timeout |
1800 seconds |
Specifies the number of seconds after which the Server Memory Activity line chart is auto-refreshed on the Memory Analysis dashboard. |
dash _memory_s ervmemcon f_timeout |
300 seconds |
Specifies the number of seconds after which the Server Memory Configuration pie chart is auto-refreshed on the Memory Analysis dashboard. |
das h_objecta ct_objsto rage_rows |
15 rows |
Specifies the number of rows to show on the Object Storage table on the Object Activity Analysis dashboard. |
dash_o bjectact_ objstorag e_timeout |
300 seconds |
Specifies the number of seconds after which the Object Storage table is auto-refreshed in the Object Activity Analysis dashboard. |
dash_obje ctact_obj topindexe s_timeout |
300 seconds |
Specifies the number of seconds after which the Top 5 Largest Indexes bar chart is auto-refreshed in the Object Activity Analysis dashboard. |
dash_obj ectact_ob jtoptable s_timeout |
300 seconds |
Specifies the number of seconds after which the Top 5 Largest Tables bar chart is auto-refreshed in the Object Activity Analysis dashboard. |
dash_os _cpu_span |
7 days |
Specifies the number of days worth of data to plot on the CPU chart on the Operating System Analysis dashboard. |
d ash_os_cp u_timeout |
1800 seconds |
Specifies the number of seconds after which the CPU line chart is auto-refreshed on the Operating System Analysis dashboard. |
dash_os_ data_span |
7 days |
Specifies the number of days worth of data to plot on the I/O line chart on the Operating System Analysis dashboard. |
dash_os_ disk_span |
7 days |
Specifies the number of days worth of data to plot on the Utilisation chart on the Operating System Analysis dashboard. |
dash _os_hostf s_timeout |
1800 seconds |
Specifies the number of seconds after which the Host File System Details table is auto-refreshed on the Operating System Analysis dashboard. |
dash_os_i o_timeout |
1800 seconds |
Specifies the number of seconds after which the I/O line chart is auto-refreshed on the Operating System Analysis dashboard. |
d ash_os_me mory_span |
7 days |
Specifies the number of days worth of data to plot on the Memory chart on the Operating System Analysis dashboard. |
dash _os_memor y_timeout |
1800 seconds |
Specifies the number of seconds after which the Memory line chart is auto-refreshed on the Operating System Analysis dashboard. |
d ash_os_pa cket_span |
7 days |
Specifies the number of days worth of data to plot on the Packet chart on the Operating System Analysis dashboard. |
dash _os_packe t_timeout |
1800 seconds |
Specifies the number of seconds after which the Network Packets line chart is auto-refreshed on the Operating System Analysis dashboard. |
da sh_os_pro cess_span |
7 days |
Specifies the number of days worth of data to plot on the Process chart on the Operating System Analysis dashboard. |
dash_ os_proces s_timeout |
1800 seconds |
Specifies the number of seconds after which the Process line chart is auto-refreshed on the Operating System Analysis dashboard. |
dash_ os_storag e_timeout |
1800 seconds |
Specifies the number of seconds after which the Storage pie chart is auto-refreshed on the Operating System Analysis dashboard. |
da sh_os_tra ffic_span |
7 days |
Specifies the number of days worth of data to plot on the Traffic chart on the Operating System Analysis dashboard. |
dash_ os_traffi c_timeout |
1800 seconds |
Specifies the number of seconds after which the Traffic line chart is auto-refreshed on the Operating System Analysis dashboard. |
da sh_os_uti l_timeout |
1800 seconds |
Specifies the number of seconds after which the Utilisation line chart is auto-refreshed on the Operating System Analysis dashboard. |
dash _probe_lo g_timeout |
300 seconds |
Specifies the number of seconds after which the Probe Log table is auto-refreshed on |
dash_r eplicatio n_archive stat_span |
7 days |
Specifies the number of days worth of data to plot on the WAL Archive Status chart on the Streaming Replication Analysis dashboard. |
dash_repl ication_a rchivesta t_timeout |
1800 seconds |
Specifies the number of seconds after which the WAL Archive Status line chart is auto-refreshed on the Streaming Replication dashboard. |
da sh_replic ation_pag elag_span |
7 days |
Specifies the number of days worth of data to plot on the WAL Lag Pages chart on the Streaming Replication dashboard. |
dash_ replicati on_pagela g_timeout |
1800 seconds |
Specifies the number of seconds after which the WAL Lag Pages line chart is auto-refreshed on the Streaming Replication dashboard. |
dash_ replicati on_segmen tlag_span |
7 days |
Specifies the number of days worth of data to plot on the WAL Lag Segments chart on the Streaming Replication dashboard. |
dash_rep lication_ segmentla g_timeout |
1800 seconds |
Specifies the number of seconds after which the WAL Lag Segments line chart is auto-refreshed on the Streaming Replication dashboard. |
da sh_replic ation_tim elag_span |
7 days |
Specifies the number of days worth of data to plot on the Replication Lag Time chart on the Streaming Replication dashboard. |
dash_ replicati on_timela g_timeout |
1800 seconds |
Specifies the number of seconds after which the Replication Lag Time line chart is auto-refreshed on the Streaming Replication dashboard. |
dash_serv er_buffer s_written |
168 hours |
Specifies the number of days worth of data to plot on the Background Writer Statistics chart on the Server Analysis dashboard. |
dash_ser ver_buffe rs_writte n_timeout |
300 seconds |
Specifies the number of seconds after which the Background Writer Statistics line chart is auto-refreshed on the Server Analysis dashboard. |
das h_server_ connoverv w_timeout |
300 seconds |
Specifies the number of seconds after which the Connection Overview pie chart is auto-refreshed in the Server Analysis dashboard. |
d ash_serve r_databas e_timeout |
300 seconds |
Specifies the number of seconds after which the Databases table is auto-refreshed in the Server Analysis dashboard. |
dash_ server_db size_span |
7 days |
Specifies the number of days worth of data to plot on the Database Size Analysis on the Server Analysis dashboard. |
dash_ser ver_dbsiz e_timeout |
1800 seconds |
Specifies the number of seconds after which the Database Size line chart is auto-refreshed in the Server Analysis dashboard. |
dash_s erver_dis k_timeout |
1800 seconds |
Specifies the number of seconds after which the Disk line chart is auto-refreshed in the Server Analysis dashboard. |
dash_ server_gl obal_span |
7 days |
Specifies the number of days worth of data to plot on the Disk line chart on the Server Analysis dashboard. |
dash_serv er_shared buff_span |
7 days |
Specifies the number of days worth of data to plot on the Shared Buffer chart on the Server Analysis dashboard. |
das h_server_ sharedbuf f_timeout |
1800 seconds |
Specifies the number of seconds after which the Shared Buffers line chart is auto-refreshed in the Server Analysis dashboard. |
da sh_server _tabspace size_span |
7 days |
Specifies the number of days worth of data to plot on the Tablespace Size chart on the Server Analysis dashboard. |
dash_ server_ta bspacesiz e_timeout |
1800 seconds |
Specifies the number of seconds after which the Tablespace Size line chart is auto-refreshed in the Server Analysis dashboard. |
dash_s erver_use ract_span |
7 days |
Specifies the number of days worth of data to plot on the User Activity chart on the Server Analysis dashboard. |
dash_serv er_userac t_timeout |
1800 seconds |
Specifies the number of seconds after which the User Activity line chart is auto-refreshed in the Server Analysis dashboard. |
d ash_sessa ct_lockac t_timeout |
300 seconds |
Specifies the number of seconds after which the Session Lock Activity table is auto-refreshed in the Session Activity Analysis dashboard. |
da sh_sessac t_workloa d_timeout |
300 seconds |
Specifies the number of seconds after which the Session Workload table is auto-refreshed in the Session Activity Analysis dashboard. |
dash _sess_wai ts_nowait s_timeout |
300 seconds |
Specifies the number of seconds after which the Session Waits By Number Of Waits pie |
dash_ sess_wait s_timewai t_timeout |
300 seconds |
Specifies the number of seconds after which the Session Waits By Time Waited pie chart is auto-refreshed in the Session Waits Analysis dashboard. |
dash _sess_wai ts_waitdt l_timeout |
300 seconds |
Specifies the number of seconds after which the Session Waits Details table is auto-refreshed in the Session Waits Analysis dashboard. |
dash_stor age_dbdtl s_timeout |
300 seconds |
Specifies the number of seconds after which the Database Details table is auto-refreshed in the Storage Analysis dashboard. |
da sh_storag e_dboverv w_timeout |
300 seconds |
Specifies the number of seconds after which the Database Overview pie chart is auto-refreshed in the Storage Analysis dashboard. |
da sh_storag e_hostdtl s_timeout |
300 seconds |
Specifies the number of seconds after which the Host Details table is auto-refreshed |
dash _storage_ hostoverv w_timeout |
300 seconds |
Specifies the number of seconds after which the Host Overview pie chart is auto-refreshed in the Storage Analysis dashboard. |
dash _storage_ tblspcdtl s_timeout |
300 seconds |
Specifies the number of seconds after which the Tablespace Details table is auto-refreshed in the Storage Analysis dashboard. |
dash_s torage_tb lspcoverv w_timeout |
300 seconds |
Specifies the number of seconds after which the Tablespace Overview pie chart is auto-refreshed in the Storage Analysis dashboard. |
das h_sys_wai ts_nowait s_timeout |
300 seconds |
Specifies the number of seconds after which the System Waits By Number Of Waits pie chart is auto-refreshed in the System Waits Analysis dashboard. |
dash _sys_wait s_timewai t_timeout |
300 seconds |
Specifies the number of seconds after which the System Waits By Time Waited pie chart is auto-refreshed in the System Waits Analysis dashboard. |
das h_sys_wai ts_waitdt l_timeout |
300 seconds |
Specifies the number of seconds after which the System Waits Details table is auto-refreshed in the System Waits Analysis dashboard. |
de leted_cha rts_reten tion_time |
7 days |
Specifies the number of days that a custom chart (displayed on a user-defined dashboard) is stored. |
de leted_pro bes_reten tion_time |
7 days |
Specifies the number of days that a custom probe (displayed on a user-defined dashboard) is stored. |
dow nload_cha rt_format |
jpeg |
Specifies the format in which a downloaded chart will be stored. May be jpeg or png. |
flap ping_dete ction_sta te_change |
3 |
Specifies the number of state changes
detected within a specified interval to
define a given alert as flapping. Flapping
starts when more than |
job_reten tion_time |
30 days |
Specifies the number of days that non-recurring scheduled tasks and their associated |
long_ running_t ransactio n_minutes |
5 minutes |
Specifies the number of minutes a query executes for before being considered long running. |
na gios_cmd_ file_name |
<file_name> |
Specifies nagios command file to which passive service check result will be sent. |
nagio s_enabled |
t |
Specifies whether alert notification will be submitted to nagios or not. |
nagi os_medium _alert_as _critical |
f |
Specifies whether medium level PEM alert will be considered as critical in nagios. |
nagios_sp ool_reten tion_time |
7 days |
Specifies the number of days to retain nagios messages in the spool table before they are discarded. |
probe_ log_reten tion_time |
30 days |
Specifies the number of days that probe log records are retained. |
rem inder_not ification _interval |
24 hours |
Specifies the number of hours after which a reminder email is sent in case an alert has not been cleared. |
server_ log_reten tion_time |
30 days |
Specifies the number of days that the server log is retained on the PEM server. |
show _data_tab _on_graph |
false |
If ‘true’, a Data tab is added to each graph. Select the Data tab to review the data that is plotted on the graph. |
s mtp_authe ntication |
false |
Specifies whether to enable/disable authentication over SMTP. |
smt p_enabled |
true |
Specifies whether to enable/disable sending of emails. |
smtp_e ncryption |
false |
Specifies whether to send SMTP email using an encrypted connection. |
smtp _password |
Specifies the password to be used to connect to the SMTP server. |
|
smtp_port |
25 |
Specifies the SMTP server port to be used for sending email. |
sm tp_server |
127.0.0.1 |
Specifies the SMTP server host address to be used for sending email. |
smtp_sp ool_reten tion_time |
7 days |
Specifies the number of days to retain sent email messages in the spool table before they are discarded. |
smtp _username |
Specifies the username to be used to connect to SMTP server. |
|
snmp_ community |
public |
Specifies the SNMP community used when sending traps. Used only with SNMPv1 and SNMPv2. |
snm p_enabled |
true |
Specifies whether to enable/disable sending SNMP traps. |
snmp_port |
162 |
Specifies the SNMP server port to be used for sending SNMP traps. |
sn mp_server |
127.0.0.1 |
Specifies the SNMP server host address to be used for sending SNMP traps. |
snmp_sp ool_reten tion_time |
7 days |
Specifies the number of days to retain sent traps in the spool table before they are discarded. |
snmp_secu rity_name |
Specifies the user name or security name for sending SNMP traps. Used only with SNMPv3. |
|
Specifies the Engine id of the SNMP Agent on the SNMP Server. Used only with SNMPv3. |
||
s nmp_secur ity_level |
NO AUTH_NOPRIV |
Specifies Security level and its possible values can be: AUTH_NOPRIV - Authentication, No Privacy or AUTH_PRIV - Authentication, Privacy or NOAUTH_NOPRIV - no Authentication, no Privacy. Used only with SNMPv3. |
snmp_con text_name |
Specifies the Context name, the identifier for MIB objects when sending SNMP traps. Used only with SNMPv3. |
|
snmp _context_ engine_id |
Specifies the Context engine id, the identifier for MIB objects when sending SNMP traps. If not specified, snmp_security_engine_id will be used. Used only with SNMPv3. |
|
s nmp_authe ntication _protocol |
NONE |
Specifies the authentication type for SNMP traps. Its possible values can be NONE,HMACMD5 or HMACSHA. Used only with SNMPv3. |
snm p_privacy _protocol |
NONE |
Specifies the privacy protocol for SNMP traps. Its possible values can be NONE, DES, AES128, IDEA, AES192, or AES256. Used only with SNMPv3. |
s nmp_authe ntication _password |
Specifies the authentication password associated with security name mentioned in snmp_security_name. Used only for SNMPv3. |
|
snm p_privacy _password |
Specifies the privacy password associated with security name mentioned in snmp_security_name. Used only for SNMPv3. |
|
webclien t_help_pg |
EDB hosted do cumentation |
Specifies the location of the online PostgreSQL core documentation. |
Capacity Manager Metrics - Reference¶
Please Note that the Capacity Manager metrics available will vary by platform, and are subject to change. The available metrics may include the metrics described in the table below.
Metric Name |
Description |
|---|---|
# Dead Tuples |
The number of dead tuples in the selected table. |
# Dead T uples+ |
The cumulative number of dead tuples in the selected table. |
# Heap Tuples F etched by Index Scans |
The number of heap tuples fetched by index scans. |
# Heap Tuples F etched by Index Scans |
The cumulative number of heap tuples fetched by index scans. |
# Idle Bac kends+ |
The cumulative number of currently idle backend clients. |
# Index Scans |
The number of index scans performed on the specified object. |
# Index Scans+ |
The cumulative number of index scans performed on the specified object. |
# Index Tuples Read |
The number of index tuples read. |
# Index Tuples Read+ |
The cumulative number of index tuples read. |
# Live Tuples |
The number of tuples visible to transactions. |
# Live T uples+ |
The cumulative number of tuples visible to transactions. |
# Pages Est imated by A NALYZE |
The number of pages estimated by ANALYZE. |
# Pages Est imated by AN ALYZE+ |
The cumulative number of pages estimated by ANALYZE. |
# Sequ ential Scans |
The number of sequential scans performed on the specific table. |
# Sequ ential Scans+ |
The cumulative number of sequential scans performed on the specific table. |
# Sequ ential Scan Tuples |
The number of tuples sequentially scanned in the specific table. |
# Sequ ential Scan T uples+ |
The cumulative number of tuples sequentially scanned in the specific table. |
# Tuples D eleted |
The number of tuples deleted. |
# Tuples De leted+ |
The cumulative number of tuples deleted. |
# Tuples Est imated by A NALYZE |
The number of live (visible) tuples estimated by ANALYZE. |
# Tuples Est imated by AN ALYZE+ |
The cumulative number of live tuples estimated by ANALYZE. |
# Tuples HOT U pdated |
The number of tuples HOT updated. In a HOT update, the new tuple resides in the same block as the original tuple and the tuples share an index entry. |
# Tuples HOT Up dated+ |
The cumulative number of tuples HOT updated. |
# Tuples In serted |
The number of tuples inserted into the specified table. |
# Tuples Ins erted+ |
The cumulative number of tuples inserted into the specified table. |
# Tuples U pdated |
The number of tuples updated in the selected table. |
# Tuples Up dated+ |
The cumulative number of tuples updated in the selected table. |
Blocks Hit |
The number of blocks found in the cache. |
Blocks Hit+ |
The cumulative number of blocks found in the cache. |
Blocks Read |
The number of blocks read. |
Blocks Read+ |
The cumulative number of blocks read. |
Blocks Read from I nfinit eCache |
The number of blocks read from InfiniteCache. |
Blocks Read from In finite Cache+ |
The cumulative number of blocks read from InfiniteCache. |
Blocks W ritten |
The number of blocks written. |
Blocks Wr itten+ |
The cumulative number of blocks written. |
B uffers All ocated |
The number of buffers allocated. |
B uffers Allo cated+ |
The cumulative number of buffers allocated. |
B uffers W ritten - Ba ckends |
The number of buffer blocks written to disk by server processe (processes connected to a client application). |
B uffers W ritten - Bac kends+ |
The cumulative number of buffer blocks written to disk by server processes. |
B uffers W ritten - Chec kpoint |
The number of blocks written to disk by the checkpoint process. |
B uffers W ritten - Check point+ |
The cumulative number of blocks written to disk by the checkpoint process. |
B uffers W ritten - Cl eaning Scan |
The number of blocks written to disk by the autovacuum process. |
B uffers W ritten - Cl eaning Scan+ |
The cumulative number of blocks written to disk by the autovacuum process. |
Bytes Re ceived (KB) |
The number of bytes received from the client (in kilobytes). |
Bytes Re ceived (KB)+ |
The cumulative number of bytes received (in kilobytes). |
Bytes Sent (KB) |
The number of bytes sent to the client (in kilobytes). |
Bytes Sent (KB)+ |
The cumulative number of bytes sent (in kilobytes). |
Check points - Timed |
The number of checkpoint operations triggered by the checkpoint interval. |
Check points - Timed+ |
The cumulative number of checkpoint operations triggered by the checkpoint interval. |
Check points - U ntimed |
The number of checkpoint operations triggered by checkpoint size. |
Check points - Un timed+ |
The cumulative number of checkpoint operations triggered by checkpoint size. |
Da tabase Size (MB) |
The size of the specified database (in megabytes). |
Free RAM Memory |
The amount of free RAM memory (in megabytes). |
Free Swap Memory |
The amount of free swap space on disk (in megabytes). |
Heap Blocks Hit |
The number of heap blocks found in the cache. |
Heap Blocks Hit+ |
The cumulative number of heap blocks found in the cache. |
Heap Blocks Read |
The number of heap blocks read. |
Heap Blocks Read+ |
The cumulative number of heap blocks read. |
Index Blocks Hit |
The number of index blocks found in the cache. |
Index Blocks Hit+ |
The cumulative number of index blocks found in the cache. |
Index Blocks Read |
The number of index blocks read. |
Index Blocks Read+ |
The cumulative number of index blocks read. |
Index Size (MB) |
The size of the specified index (in megabytes). |
In P ackets Di scards |
The number of inbound packets discarded. |
In P ackets Dis cards+ |
The cumulative number of inbound packets discarded. |
In P ackets Errors |
The number of inbound packets that contain errors. |
In P ackets E rrors+ |
The cumulative number of inbound packets that contain errors. |
Link Ban dwidth (M bit/s) |
The speed of the network adapter (in megabits per second). |
Load A verage - 15 Minute |
CPU saturation (in percent) - 15 minute sampling average. |
Load A verage - 1 Minute |
CPU saturation (in percent) - 1 minute sampling average. |
Load A verage - 5 Minute |
CPU saturation (in percent) - 5 minute sampling average. |
Load Perc entage |
CPU saturation in percent. |
Number of Pr epared T ransac tions+ |
The cumulative number of prepared transactions. |
Number of WAL Files+ |
The cumulative number of write-ahead log files. |
Out P ackets Di scards |
The number of outbound packets discarded. |
Out P ackets Dis cards+ |
The cumulative number of outbound packets discarded. |
Out P ackets Errors |
The number of outbound packets that contain errors. |
Out P ackets E rrors+ |
The cumulative number of outbound packets that contain errors. |
P ackets Re ceived |
The number of packets received. |
P ackets Rec eived+ |
The cumulative number of packets received. |
P ackets Sent |
The number of packets sent. |
P ackets Sent+ |
The cumulative number of packets sent. |
Size (MB) |
The total size of the disk (in megabytes). |
Size of I ndexes (MB) |
The size of indexes on the specified table (in megabytes). |
Space Ava ilable (MB) |
The current disk space available (in megabytes). |
Space Used (MB) |
The current disk space used (in megabytes). |
Table Size (MB) |
The size of the specified table (in megabytes). |
Tabl espace Size (MB) |
The size of the specified tablespace (in megabytes). |
Temp B uffers (MB) |
The size of temporary buffers (in megabytes). |
Toast Blocks Hit |
The number of TOAST blocks found in the cache. |
Toast Blocks Hit+ |
The cumulative number of TOAST blocks found in the cache. |
Toast Blocks Read |
The number of TOAST blocks read. |
Toast Blocks Read+ |
The cumulative number of TOAST blocks read. |
Total RAM Memory |
The total amount of RAM memory on the system (in megabytes). |
Total Swap Memory |
The total amount of swap space on the system (in megabytes). |
Total Table Size w/I ndexes and Toast |
The total size of the specified table (including indexes and associated oversized attributes). |
Transa ctions A borted |
The number of aborted transactions. |
Transa ctions Ab orted+ |
The cumulative number of aborted transactions. |
Transa ctions Com mitted |
The number of committed transactions. |
Transa ctions Comm itted+ |
The cumulative number of committed transactions. |
Tuples D eleted |
The number of tuples deleted from the specified table. |
Tuples De leted+ |
The cumulative number of tuples deleted from the specified table. |
Tuples Est imated by A NALYZE |
The number of visible tuples in the specified table. |
Tuples Est imated by AN ALYZE+ |
The cumulative number of visible tuples in the specified table. |
Tuples F etched |
The number of tuples fetched from the specified table. |
Tuples Fe tched+ |
The cumulative number of tuples fetched from the specified table. |
Tuples HOT U pdated |
The number of tuples HOT updated. In a HOT update, the new tuple resides in the same block as the original tuple and the tuples share an index entry. |
Tuples HOT Up dated+ |
The cumulative number of tuples HOT updated. In a HOT update, the new tuple resides in the same block as the original tuple and the tuples share an index entry. |
Tuples In serted |
The number of tuples inserted into the specified table. |
Tuples Ins erted+ |
The cumulative number of tuples inserted into the specified table. |
Tuples Re turned |
The number of tuples returned in result sets. |
Tuples Ret urned+ |
The cumulative number of tuples returned in result sets. |
Tuples U pdated |
The number of tuples updated in the specified table. |
Tuples Up dated+ |
The cumulative number of tuples updated in the specified table. |
WAL S egment Size (MB) |
The segment size of the write-ahead log (in megabytes). |
!!! Note The ‘+’ following the name of a metric signifies that the data for the metric is gathered cumulatively; those metrics that are not followed by the ‘+’ sign are collected as a ‘point-in-time’ value.
PEM Probes – Reference¶
A probe is a scheduled task that retrieves information about the database objects that are being monitored by the PEM agent. PEM uses the collected information to build the graphs displayed on each dashboard. The Manage Probes tab (accessed via the Management menu) allows you to modify the data collection schedule and the length of time that PEM will retain information returned by a specific probe.
Probe Name |
Information Monitored by Probe |
Level |
|---|---|---|
Bac kground Writer Sta tistics |
This probe monitors information about the background writer. The information includes:The number of timed checkpointsThe number of requested checkpointsThe number of buffers written (by checkpoint)The number of buffers written (by background writer)The number of background writer cyclesThe number of background buffers writtenThe number of buffers allocated |
S erver |
Blocked Session Info rmation |
This probe provides information about blocked sessions. |
S erver |
CPU Usage |
This probe monitors CPU Usage information. |
Agent |
Data and Log File A nalysis |
This probe monitors information about log files. The information includes:The name of the log fileThe directory in which the log file resides |
S erver |
D atabase Frozen XID |
This probe monitors the frozen XID of each database. |
S erver |
D atabase Size |
This probe monitors information about the size of the monitored databases.The information includes:The time the information was gatheredThe database nameThe database size (in MB’s). |
S erver |
D atabase Sta tistics |
This probe monitors database statistics. The information includes:The number of backendsThe number of transactions committedThe number of transactions rolled backThe number of blocks readThe number of blocks hitThe number of rows returnedThe number of rows fetchedThe number of rows insertedThe number of rows updatedThe number of rows deleted |
S erver |
Disk Busy Info |
This probe monitors information about disk activity.Note: This probe is not supported on Mac OS X, Solaris or HP-UX |
Agent |
Disk Space |
This probe monitors information about disk space usage. The information includes:The amount of disk space usedThe amount of disk space available |
Agent |
EDB Audit Config uration |
This probe monitors the audit logging configuration of EDB Postgres Advanced Server. |
S erver |
F ailover Manager Cluster Info |
This probe monitors a Failover Manager cluster, returning information about the cluster. This probe is disabled unless a cluster name and path of the Failover Manager binary is provided on the Server Properties dialog. |
S erver |
F ailover Manager Node Status |
This probe monitors a Failover Manager cluster, returning detailed about each node within the cluster. This probe is disabled unless a cluster name and path of the Failover Manager binary is provided on the Server Properties dialog. |
S erver |
F unction Sta tistics |
This probe monitors a database, retrieving information about functions. The information includes:Function namesArgument typesReturn values |
Dat abase |
Index Size |
This probe monitors a database, retrieving information about indexes. The information includes:The name of the indexThe time the data was gatheredThe size of the index (in MB’s) |
Dat abase |
Index Sta tistics |
This probe monitors index statistics. The information includes:The number of index scansThe number of rows readThe number of rows fetchedThe number of blocks readThe number of blocks hit |
Dat abase |
In stalled P ackages |
This probe monitors the packages that are currently installed. The information gathered includes:The name of the installed packageThe version of the installed packageThe date and time that the probe executed |
Agent |
IO A nalysis |
This probe monitors disk I/O information in. The information includes:The number of blocks readThe number of blocks writtenThe date and time that the probe executedNote: This probe is not supported on Mac OS X |
Agent |
Load Average |
This probe monitors CPU load averages. The information includes:The 1-minute load averageThe 5-minute load averageThe 15-minute load averageNote: This probe is not supported on Windows |
Agent |
Lock Info rmation |
This probe monitors lock information. The information includes:The database nameThe lock typeThe lock modeThe process holding the lock |
S erver |
Memory Usage |
This probe monitors information about system
memory usage.The information includes:Total RAM
in MBFree RAM in MBTotal swap memory in MBFree
swap memory in MBShared system memory in MB(It is
used by tuning wizard to tune the memory
parameters for the database server)- On
non-windows system, it is |
Agent |
Network Sta tistics |
This probe monitors network statistics. The information includes:The interface IP addressThe number of packets sentThe number of packets receivedThe number of bytes sentThe number of bytes receivedThe link speed (in MB/second) |
Agent |
Number of P repared Trans actions |
This probe stores the number of prepared transactions. |
S erver |
Number of WAL Files |
This probe monitors the number of WAL files. |
S erver |
Object C atalog: D atabase |
This probe monitors a list of databases and their properties The information includes:The database nameThe database encoding typeIf the database allows user connections or system connections |
S erver |
Object C atalog: Foreign Key |
This probe monitors a list of foreign keys and their properties. The information includes:The name of the table that contains the foreign keyThe name of the table that the foreign key referencesThe name of the database in which the table residesThe name of the schema in which the table resides |
S chema |
Object C atalog: F unction |
This probe monitors a list of functions and their properties. The information includes:The name of the functionThe name of the schema in which the function residesThe name of the database in which the function resides |
S chema |
Object C atalog: Index |
This probe monitors a list of indexes and their properties. The information includes:The name of the indexThe name of the table that the index is associated withThe name of the database in which the indexed table resides |
S chema |
Object C atalog: Schema |
This probe monitors a list of schemas and their associated databases and servers. |
Dat abase |
Object C atalog: S equence |
This probe monitors a list of sequences and their properties. |
S chema |
Object C atalog: Table |
This probe monitors a list of table information. The information includes:The table nameThe name of the schema in which the table residesThe name of the database in which the schema residesA Boolean indicator that indicates if the table has a primary key |
S chema |
Object C atalog: Tab lespace |
This probe monitors a list of tablespaces. |
S erver |
Op erating System Info rmation |
This probe monitors the operating system details and boot time. |
Agent |
Package Catalog |
This probe monitors the packages that are currently available for installation. The information gathered includes:The package nameThe package version |
Agent |
PG HBA Conf |
This probe monitors authentication configuration information from the pg_hba.conf file. |
S erver |
Server Info rmation |
This probe monitors server information. |
S erver |
Session Info rmation |
This probe monitors session information. The information includes:The name of the session userThe date and time that the session connected to the serverThe status of the session at the time that the information was gathered (idle, waiting, etc)The client address and port number |
S erver |
S ettings |
This probe monitors the values currently assigned to GUC variables. |
S erver |
SQL Protect |
This probe monitors a server, retrieving information about SQL injection attacks. |
S erver |
Slony Repl ication |
This probe monitors lag data for clusters replicated using Slony. |
Dat abase |
St reaming Repl ication |
This probe monitors a cluster that is using streaming replication, retrieving information about:The sent Xlog location (in bytes)The write Xlog location (in bytes)The flush Xlog location (in bytes)The replay Xlog location (in bytes)The Xlog lag (in segments)The Xlog lag (in pages) |
S erver |
St reaming Repl ication Lag Time |
This probe monitors a cluster that is using streaming replication, retrieving lag information about:Replication lag time (in seconds)Current status of replication (running/paused) |
S erver |
St reaming Repl ication D atabase Co nflicts |
This probe monitors a database that is using streaming replication, retrieving information about any conflicts that arise. This includes information about queries that have been canceled due to:The # of drop tablespace conflictsThe # of lock timeout conflictsThe # of old snapshot conflictsThe # of pinned buffer conflictsThe # of deadlock conflicts |
S erver |
Table Bloat |
This probe monitors information about the current table bloat. The information includes:The name of the tableThe name of the schema in which the table residesThe estimated number of pagesThe estimated number of wasted pagesThe estimated number of bytes per row |
Dat abase |
Table Frozen XID |
This probe monitors the frozen XID of each table. |
S chema |
Table Size |
This probe monitors information about table size. The information includes:Table size (in MB’s)Total index size (in MB’s)Total table size, with indexes and TOAST (in MB’s) |
Dat abase |
Table Sta tistics |
This probe monitors table statistics. The information includes:The number of sequential scansThe number of sequential scan rowsThe number of index scansThe number of index scan rowsThe number of rows insertedThe number of rows updatedThe number of rows deletedThe number of live rowsThe number of dead rowsThe last VACUUMThe last auto-vacuumThe last ANALYZEThe last auto-analyzeThe number of pages estimated by ANALYZEThe number of rows estimated by ANALYZE |
Dat abase |
Tab lespace Size |
This probe monitors a list of tablespaces and their sizes. |
S erver |
User Info rmation |
This probe monitors a list of the current users. The stored information includes:The user nameThe user type (superuser vs. non-superuser)The server to which the user is connected |
S erver |
WAL Archive Status |
This probe monitors the status of the WAL archive. The stored information includes:The # of WAL archives doneThe # of WAL archives pendingThe last archive timeThe # of WAL archives failedThe time of the last failure |
S erver |
xDB Repl ication |
This probe monitors lag data for clusters replicated using xDB replication. |
Dat abase |
PEM Pre-defined Alert Templates – Reference¶
An alert definition contains a system-defined or user-defined set of conditions that PEM compares to the system statistics; if the statistics deviate from the boundaries specified for that statistic, the alert triggers, and the PEM client displays a warning on the *Alerts Overview* page, and optionally sends a notification to a monitoring user.
The tables that follow list the system-defined alert templates that you can use to create an alert; please note that this list is subject to change, and may vary by system:
Templates applicable on Agent¶
Template Name |
Description |
|---|---|
Load Average (1 minute) |
1-minute system load average. |
Load Average (5 minutes) |
5-minute system load average. |
Load Average (15 minutes) |
15-minute system load average. |
Load Average per CPU Core (1 minutes) |
1-minute system load average per CPU core. |
Load Average per CPU Core (5 minutes) |
5-minute system load average per CPU core. |
Load Average per CPU Core (15 minutes) |
15-minute system load average per CPU core. |
CPU utilization |
Average CPU consumption. |
Number of CPUs running higher than a |
Number of CPUs running at greater than K% utilization threshold |
Free memory percentage |
Free memory as a percent of total system memory. |
Memory used percentage |
Percentage of memory used. |
Swap consumption |
Swap space consumed (in megabytes). |
Swap consumption percentage |
Percentage of swap area consumed. |
Disk Consumption |
Disk space consumed (in megabytes). |
Disk consumption percentage |
Percentage of disk consumed. |
Disk Available |
Disk space available (in megabytes). |
Disk busy percentage |
Percentage of disk busy. |
Most used disk percentage |
Percentage used of the most utilized disk on the system. |
Total table bloat on host |
The total space wasted by tables on a host, in MB. |
Highest table bloat on host |
The most space wasted by a table on a host, in MB. |
Average table bloat on host |
The average space wasted by tables on host, in MB. |
Table size on host |
The size of tables on host, in MB. |
Database size on host |
The size of databases on host, in MB. |
Number of ERRORS in the logfile on agent N in last X hours. |
The number of ERRORS in the logfile on agent N in last X hours |
Number of WARNINGS in the logfile on agent N in last X hours |
The number of WARNINGS in the logfile on agent N in last X hours. |
Number of WARNINGS or ERRORS in the logfile on agent N in last X hours |
The number of WARNINGS or ERRORS in the logfile on agent N in last X hours. |
Package version mismatch |
Check for package version mismatch as per catalog. |
Total materialized view bloat on host |
The total space wasted by materialized views on a host, in MB. |
Highest materialized view bloat on host |
The most space wasted by a materialized view on a host, in MB. |
Average materialized view bloat on host |
The average space wasted by materialized views on host, in MB. |
Materialized view size on host |
The size of materialized views on host, in MB. |
Agent Down |
Specified agent is currently down. |
Templates applicable on Server¶
T emplate Name |
Description |
|---|---|
Total table bloat in server |
The total space wasted by tables in server, in MB. |
Largest table (by m ultiple of un bloated size) |
Largest table in server, calculated as a multiple of its own estimated unbloated size; exclude tables smaller than N MB. |
Highest table bloat in server |
The most space wasted by a table in server, in MB. |
Average table bloat in server |
The average space wasted by tables in server, in MB. |
Table size in server |
The size of tables in server, in MB. |
D atabase size in server |
The size of databases in server, in MB. |
Number of WAL files |
Total number of Write Ahead Log files. |
Number of p repared trans actions |
Number of transactions in prepared state. |
Total conn ections |
Total number of connections in the server. |
Total conn ections as per centage of |
Total number of connections in the server as a percentage of maximum |
m ax_conn ections |
connections allowed on server, settings. |
Unused, non-su peruser conn ections |
Number of unused, non-superuser connections on the server, user_info, settings. |
Unused, non-su peruser conn ections as per centage of m ax_conn ections |
Number of unused, non-superuser connections on the server as a percentage of max_connections of max_connections, user_info, settings. |
Un granted locks |
Number of ungranted locks in server. |
Per centage of buffers written by b ackends |
The percentage of buffers written by backends vs. the total buffers written. |
Per centage of buffers written by che ckpoint |
The percentage of buffers written by the checkpoints vs. the total buffers written. |
Buffers written per second |
Number of buffers written per second, over the last two probe cycles. |
Buffers al located per second |
Number of buffers allocated per second, over the last two probe cycles. |
Conn ections in idle state |
Number of connections in server that are in idle state. |
Conn ections in idle- in-tran saction state |
Number of connections in server that are in idle-in-transaction state. |
Conn ections in idle- in-tran saction state, as per centage of m ax_conn ections |
Number of connections in server that are in idle-in-transaction state, as a percentage of maximum connections allowed on server, settings. |
Long- running idle conn ections |
Number of connections in the server that have been idle for more than N seconds. |
Long- running idle conn ections and idle trans actions |
Number of connections in the server that have been idle or transactions idle-in-transaction for more than N seconds. |
Long- running idle trans actions |
Number of connections in the server that have been idle in transaction for more than N seconds. |
Long- running trans actions |
Number of transactions in server that have been running for more than N seconds. |
Long- running queries |
Number of queries in server that have been running for more than N seconds. |
Long- running vacuums |
Number of vacuum operations in server that have been running for more than N seconds. |
Long- running auto vacuums |
Number of autovacuum operations in server that have been running for more than N seconds. |
Co mmitted trans actions per centage |
Percentage of transactions in the server that committed vs. that rolled-back over last N minutes. |
Shared buffers hit per centage |
Percentage of block read requests in the server that were satisfied by shared buffers, over last N minutes. |
Tuples i nserted |
Tuples inserted into server over last N minutes. |
Infini teCache buffers hit per centage |
Percentage of block read requests in the server that were satisfied by InfiniteCache, over last N minutes. |
Tuples fetched |
Tuples fetched from server over last N minutes. |
Tuples r eturned |
Tuples returned from server over last N minutes. |
Dead Tuples |
Number of estimated dead tuples in server. |
Tuples updated |
Tuples updated in server over last N minutes. |
Tuples deleted |
Tuples deleted from server over last N minutes. |
Tuples hot updated |
Tuples hot updated in server, over last N minutes. |
Seq uential Scans |
Number of full table scans in server, over last N minutes. |
Index Scans |
Number of index scans in server, over last N minutes. |
Hot update per centage |
Percentage of hot updates in the server over last N minutes. |
Live Tuples |
Number of estimated live tuples in server. |
Dead tuples per centage |
Percentage of estimated dead tuples in server. |
Last Vacuum |
Hours since last vacuum on the server. |
Last Aut oVacuum |
Hours since last autovacuum on the server. |
Last Analyze |
Hours since last analyze on the server. |
Last Auto Analyze |
Hours since last autoanalyze on the server. |
Per centage of buffers written by b ackends over the last N minutes |
The percentage of buffers written by backends vs. the total buffers backends over last N |
Table Count |
Total number of tables in server. |
F unction Count |
Total number of functions in server. |
S equence Count |
Total number of sequences in server. |
A user expires in N days |
Number of days before a user’s validity expires. |
Index size as a per centage of table size |
Size of the indexes in server, as a percentage of their tables’ size. |
Largest index by tab le-size per centage oc _index, tabl e_size. |
Largest index in server, calculated as percentage of its table’s size. |
Number of ERRORS in the logfile on server M in the last X hours |
The number of ERRORS in the logfile on server M in last X hours. |
Number of W ARNINGS in the logfile on server M in the last X hours |
The number of WARNINGS in logfile on server M in the last X hours. |
Number of W ARNINGS or ERRORS in the logfile on server M in the last X hours |
The number of WARNINGS or ERRORS in the logfile on server M in the last X hours. |
Number of attacks d etected in the last N minutes |
The number of SQL injection attacks occurred in the last N minutes. |
Number of attacks d etected in the last N minutes by u sername |
The number of SQL injection attacks occurred in the last N minutes by username. |
Number of replica servers lag behind the primary by write l ocation |
> Streaming Replication: number of replica servers lag behind the primary by write location. |
Number of replica servers lag behind the primary by flush l ocation |
> Streaming Replication: number of replica servers lag behind the primary by flush location. |
Number of replica servers lag behind the primary by replay l ocation |
> Streaming Replication: number of replica servers lag behind the primary by replay location. |
Replica server lag behind the primary by write l ocation |
> Streaming Replication: replica server lag behind the primary by write location in MB. |
Replica server lag behind the primary by flush l ocation |
> Streaming Replication: replica server lag behind the primary by flush location in MB. |
Replica server lag behind the primary by replay l ocation |
> Streaming Replication: replica server lag behind the primary by replay location in MB. |
Replica server lag behind the primary by size (MB) |
> Streaming Replication: replica server lag behind the primary by size in MB. |
Replica server lag behind the primary by WAL s egments |
> Streaming Replication: replica server lag behind the primary by WAL segments. |
Replica server lag behind the primary by WAL pages |
> Streaming Replication: replica server lag behind the primary by WAL pages. |
Total mater ialized view bloat in server |
The total space wasted by materialized views in server, in MB. |
Largest mater ialized view (by m ultiple of un bloated size) |
Largest materialized view in server, calculated as a multiple of its own estimated unbloated size; exclude materialized views smaller than N MB. |
Highest mater ialized view bloat in server |
The most space wasted by a materialized view in server, in MB. |
Average mater ialized view bloat in server |
The average space wasted by materialized views in server, in MB. |
Mater ialized view size in server |
The size of materialized view in server, in MB. |
View Count |
Total number of views in server. |
Mater ialized View Count |
Total number of materialized views in server. |
Audit config m ismatch |
Check for audit config parameter mismatch |
Server Down |
Specified server is currently inaccessible. |
Number of WAL a rchives pending |
Streaming Replication: number of WAL files pending to be replayed at replica. |
Number of minutes lag of replica server from primary server |
> Streaming Replication: number of minutes replica node is lagging behind the primary node. |
Log config m ismatch |
Check for log config parameter mismatch. |
Templates applicable on Database¶
Template Name |
Description |
|---|---|
Total table bloat in database |
The total space wasted by tables in database, in MB. |
Largest table (by multiple of unbloated size) |
Largest table in database, calculated as a multiple of its own estimated unbloated size; exclude tables smaller than N MB. |
Highest table bloat in database |
The most space wasted by a table in database, in MB. |
Average table bloat in database |
The average space wasted by tables in database, in MB. |
Table size in database |
The size of tables in database, in MB. |
Database size |
The size of the database, in MB. |
Total c onnections |
Total number of connections in the database. |
Total c onnections as percentage of max_c onnections |
Total number of connections in the database as a percentage of maximum connections allowed on server, settings. |
Ungranted locks |
Number of ungranted locks in database. |
C onnections in idle state |
Number of connections in database that are in idle state. |
C onnections in idle-in-t ransaction state |
Number of connections in database that are in idle-in-transaction state |
C onnections in idle-in-t ransaction state,as percentage of max_c onnections |
Number of connections in database that are in idle-in-transaction state, as a percentage of maximum connections allowed on server, settings. |
Lo ng-running idle c onnections |
Number of connections in the database that have been idle for more than N seconds. |
Lo ng-running idle c onnections and idle tr ansactions |
Number of connections in the database that have been idle or idle-in-transaction for more than N seconds. |
Lo ng-running idle tr ansactions |
Number of connections in the database that have been idle in transaction for more than N seconds. |
Lo ng-running tr ansactions |
Number of transactions in database that have been running for more than N seconds. |
Lo ng-running queries |
Number of queries in database that have been running for more than N seconds. |
Lo ng-running vacuums |
Number of vacuum operations in database that have been running for more than N seconds. |
Lo ng-running a utovacuums |
Number of autovacuum operations in database that have been running for more than N seconds. |
Committed tr ansactions percentage |
Percentage of transactions in the database that committed vs. that rolled-back over last N minutes. |
Shared buffers hit percentage |
Percentage of block read requests in the database that were satisfied by shared buffers, over last N minutes. |
Inf initeCache buffers hit percentage |
Percentage of block read requests in the database that were satisfied by InfiniteCache, over last N minutes. |
Tuples fetched |
Tuples fetched from database over last N minutes. |
Tuples returned |
Tuples returned from database over last N minutes. |
Tuples inserted |
Tuples inserted into database over last N minutes. |
Tuples updated |
Tuples updated in database over last N minutes. |
Tuples deleted |
Tuples deleted from database over last N minutes. |
Tuples hot updated |
Tuples hot updated in database, over last N minutes. |
Sequential Scans |
Number of full table scans in database, over last N minutes. |
Index Scans |
Number of index scans in database, over last N minutes. |
Hot update percentage |
Percentage of hot updates in the database over last N minutes. |
Live Tuples |
Number of estimated live tuples in database. |
Dead Tuples |
Number of estimated dead tuples in database. |
Dead tuples percentage |
Percentage of estimated dead tuples in database. |
Last Vacuum |
Hours since last vacuum on the database. |
Last AutoVacuum |
Hours since last autovacuum on the database. |
Last Analyze |
Hours since last analyze on the database. |
Last A utoAnalyze |
Hours since last autoanalyze on the database. |
Table Count |
Total number of tables in database. |
Function Count |
Total number of functions in database. |
Sequence Count |
Total number of sequences in database. |
Index size as a percentage of table size |
Size of the indexes in database, as a percentage of their tables’ size. |
Largest index by table-size percentage |
Largest index in database, calculated as percentage of its table’s size, oc_index, table_size. |
Database Frozen XID |
The age (in transactions before the current transaction) of the database’s frozen transaction ID. |
Number of attacks detected in the |
The number of SQL injection attacks occurred in the last N minutes. last N minutes |
Number of attacks detected in the |
The number of SQL injection attacks occurred in the last N minutes by last N minutes by username. |
Queries that have been cancelled due to dropped t ablespaces |
Streaming Replication: number of queries that have been cancelled due to dropped tablespaces. |
Queries that have been cancelled due to lock timeouts |
Streaming Replication: number of queries that have been cancelled due to lock timeouts. |
Queries that have been cancelled due to old snapshots |
Streaming Replication: number of queries that have been cancelled due to old snapshots. |
Queries that have been cancelled due to pinned buffers |
Streaming Replication: number of queries that have been cancelled due to pinned buffers. |
Queries that have been cancelled due to deadlocks |
Streaming Replication: number of queries that have been cancelled due to deadlocks. |
Total events lagging in all slony clusters |
Slony Replication: total events lagging in all slony clusters. |
Events lagging in one slony cluster |
Slony Replication: events lagging in one slony cluster. |
Lag time (minutes) in one slony cluster |
Slony Replication: lag time (minutes) in one slony cluster. |
Total rows lagging in xdb single primary r eplication |
> xDB Replication: Total rows lagging in xdb single primary replication |
Total rows lagging in xdb multi primary r eplication |
> xDB Replication: Total rows lagging in xdb multi primary replication. |
Total ma terialized view bloat in database |
The total space wasted by materialized views in database, in MB. |
Largest ma terialized view (by multiple of unbloated size) |
Largest materialized view in database, calculated as a multiple of its estimated unbloated size; exclude materialized views smaller than N MB. |
Highest ma terialized view bloat in database |
The most space wasted by a materialized view in database, in MB. |
Average ma terialized view bloat in database |
The average space wasted by materialized views in database, in MB. |
Ma terialized view size in database |
The size of materialized view in database, in MB. |
View Count |
Total number of views in database. |
Ma terialized View Count |
Total number of materialized views in database. |
Templates applicable on Schema¶
Template Name |
Description |
|---|---|
Total table bloat in schema |
The total space wasted by tables in schema, in MB. |
Largest table (by multiple of unbloated size) |
Largest table in schema, calculated as a multiple of its own estimated unbloated size; exclude tables smaller than N MB. |
Highest table bloat in schema |
The most space wasted by a table in schema, in MB. |
Average table bloat in schema |
The average space wasted by tables in schema, in MB. |
Table size in schema |
The size of tables in schema, in MB. |
Tuples inserted |
Tuples inserted in schema over last N minutes. |
Tuples updated |
Tuples updated in schema over last N minutes. |
Tuples deleted |
Tuples deleted from schema over last N minutes. |
Tuples hot updated |
Tuples hot updated in schema, over last N minutes. |
S equential Scans |
Number of full table scans in schema, over last N minutes. |
Index Scans |
Number of index scans in schema, over last N minutes. |
Hot update p ercentage |
Percentage of hot updates in the schema over last N minutes. |
Live Tuples |
Number of estimated live tuples in schema. |
Dead Tuples |
Number of estimated dead tuples in schema. |
Dead tuples p ercentage |
Percentage of estimated dead tuples in schema. |
Last Vacuum |
Hours since last vacuum on the schema. |
Last A utoVacuum |
Hours since last autovacuum on the schema. |
Last Analyze |
Hours since last analyze on the schema. |
Last Au toAnalyze |
Hours since last autoanalyze on the schema. |
Table Count |
Total number of tables in schema. |
Function Count |
Total number of functions in schema. |
Sequence Count |
Total number of sequences in schema. |
Index size as a p ercentage of table size |
Size of the indexes in schema, as a percentage of their table’s size. |
Largest index by t able-size p ercentage |
Largest index in schema, calculated as percentage of its table’s size, oc_index, table_size |
Mat erialized View bloat |
Space wasted by the materialized view, in MB. |
Total mat erialized view bloat in schema |
The total space wasted by materialized views in schema, in MB. |
Mat erialized view size as a multiple of unbloated size |
Size of the materialized view as a multiple of estimated unbloated size. |
Largest mat erialized view (by multiple of unbloated size) |
Largest materialized view in schema, calculated as a multiple of its own estimated unbloated size; exclude materialized view smaller than N MB. |
Highest mat erialized view bloat in schema |
The most space wasted by a materialized view in schema, in MB. |
Average mat erialized view bloat in schema |
The average space wasted by materialized views in schema, in MB. |
Mat erialized view size |
The size of materialized view, in MB. |
Mat erialized view size in schema |
The size of materialized views in schema, in MB. |
View Count |
Total number of views in schema. |
Mat erialized View Count |
Total number of materialized views in schema. |
Mat erialized View Frozen XID |
The age (in transactions before the current transaction) of the materialized view’s frozen transaction ID. |
Templates applicable on Table¶
Template Name |
Description |
|---|---|
Table bloat |
Space wasted by the table, in MB. |
Table size |
The size of table, in MB. |
Table size as a multiple of ubloated size |
Size of the table as a multiple of estimated unbloated size. |
Tuples inserted |
Tuples inserted in table over last N minutes. |
Tuples updated |
Tuples updated in table over last N minutes. |
Tuples deleted |
Tuples deleted from table over last N minutes. |
Tuples hot updated |
Tuples hot updated in table, over last N minutes. |
Sequential Scans |
Number of full table scans on table, over last N minutes. |
Index Scans |
Number of index scans on table, over last N minutes. |
Hot update percentage |
Percentage of hot updates in the table over last N minutes. |
Live Tuples |
Number of estimated live tuples in table. |
Dead Tuples |
Number of estimated dead tuples in table. |
Dead tuples percentage |
Percentage of estimated dead tuples in table. |
Last Vacuum |
Hours since last vacuum on the table. |
Last AutoVacuum |
Hours since last autovacuum on the table. |
Last Analyze |
Hours since last analyze on the table. |
Last AutoAnalyze |
Hours since last autoanalyze on the table. |
Row Count |
Estimated number of rows in a table. |
Index size as a percentage of table size |
Size of the indexes on table, as a percentage of table’s size. |
Table Frozen XID |
The age (in transactions before the current transaction) of the table’s frozen transaction ID. |
Global Templates¶
Template Name |
Description |
|---|---|
Agents Down |
Number of agents that haven’t reported in recently. |
Servers Down |
Number of servers that are currently inaccessible. |
Alert Errors |
Number of alerts in an error state. |
