cancel
Showing results for 
Search instead for 
Did you mean: 

PEM query on lag time

SOLVED
Level 3 Adventurer

PEM query on lag time

Hi,

I write a query to display lag time from efm clusters but it's not updated except if I pause the WAL apply on standby instance.

SELECT s.efm_cluster_name, s.description,t.* FROM pemdata.streaming_replication_lag_time t,pem.server s where t.server_id = s.id order by efm_cluster_name,description;

Kind regards

Paul-Emmanuel Devadder

1 ACCEPTED SOLUTION

Accepted Solutions
EDB Team Member

Re: PEM query on lag time

Hi @Polem,

 

We have discussed this with our development, the table updates only if the lag is present and it is calculated in minutes.

 

So, if you have more than 1 minutes lag then pemdata.streaming_replication_lag_time table updates with the lag_time value.

 

I have tested in our local environment and it is working fine, I used the pgbench to generate enough lag between Master and Stabndby server.

 

Please check the values of pemdata.streaming_replication_lag_time after generating the lag in several minutes.

 

Please get back to us in case of any issues/queries.

 

Regards,

Sudhir

6 REPLIES 6
EDB Team Member

Re: PEM query on lag time

Hi @Polem ,

 

Thanks for the raising the issue with us, looks like the probe is not executed on the agent side to gather the data.

 

For further analysis could you please share the below details with us :

 

1) PEM server and PEM agent versions.

2) Output from the PEM database for the below queries:

 

\! date

select * from pem.probe where display_name ilike 'streaming_replication_lag_time';

select * from pem.alert_template where display_name ilike '%Number of minutes lag%';

select * from pemdata.streaming_replication_lag_time;

 

Please revert with the above information.

 

Regards,

Sudhir

Level 3 Adventurer

Re: PEM query on lag time

Hi,

PEM server and agent: 7.4.0

pem=# \! date

Fri Jan 18 13:15:25 CET 2019

 

id |          display_name          |         internal_name          | collection_method | target_type_id | applies_to_id | agent_capability |                                                         probe_code                                                          | enabled_by_default | default_execution_frequency | default_lifetime | any_server_version | force_enabled | probe_key_list | discard_history | is_system_probe | deleted | deleted_time | platform | is_chartable | jstid 
----+--------------------------------+--------------------------------+-------------------+----------------+---------------+------------------+-----------------------------------------------------------------------------------------------------------------------------+--------------------+-----------------------------+------------------+--------------------+---------------+----------------+-----------------+-----------------+---------+--------------+----------+--------------+-------
 56 | Streaming Replication Lag Time | streaming_replication_lag_time | s                 |            200 |           200 |                  | SELECT (CASE WHEN pg_last_xlog_receive_location() = pg_last_xlog_replay_location() THEN 0                                  +| f                  |                         300 |              180 | f                  | f             | {}             | f               | t               | f       |              |          | t            |    64
    |                                |                                |                   |                |               |                  |                 ELSE COALESCE(EXTRACT (EPOCH FROM now() - pg_last_xact_replay_timestamp())/60, 0) END)::bigint AS lag_time,+|                    |                             |                  |                    |               |                |                 |                 |         |              |          |              | 
    |                                |                                |                   |                |               |                  |                 pg_is_xlog_replay_paused() AS replication_paused WHERE true = pg_is_in_recovery()                           |                    |                             |                  |                    |               |                |                 |                 |         |              |          |              | 
(1 row)

 id  |                        display_name                        |                                        description                                        |                                            sql                                             | object_type | param_names | param_types | param_units | threshold_unit | default_check_frequency | default_history_retention |      probe_dependency_list       | snmp_oid | applicable_on_server | is_system_template | operator | thresholds | is_auto_create | info_sql 
-----+------------------------------------------------------------+-------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------+-------------+-------------+-------------+-------------+----------------+-------------------------+---------------------------+----------------------------------+----------+----------------------+--------------------+----------+------------+----------------+----------
 237 | Number of minutes lag of standby server from master server | In streaming replication number of minutes standby node is lagging behind the master node |                                                                                           +|         200 |             |             |             | Minutes        |                       1 |                        30 | {streaming_replication_lag_time} |       80 | ALL                  | t                  | >        |            | f              | 
     |                                                            |                                                                                           | SELECT lag_time FROM pemdata.streaming_replication_lag_time WHERE server_id = ${server_id} |             |             |             |             |                |                         |                           |                                  |          |                      |                    |          |            |                | 
(1 row)

         recorded_time         | server_id | lag_time | replication_paused 
-------------------------------+-----------+----------+--------------------
 2018-12-06 08:17:48.36858+01  |         7 |        0 | f
 2018-12-06 08:18:48.586397+01 |        16 |        0 | f
 2018-12-06 08:19:06.990941+01 |        17 |        0 | f
 2018-12-06 08:19:23.213643+01 |        22 |        0 | f
 2019-01-17 11:10:28.085645+01 |        20 |        0 | f
 2019-01-18 12:51:24.643276+01 |        15 |        0 | f
(6 rows)

Kind regards,

Paul-Emmanuel

EDB Team Member

Re: PEM query on lag time

Hi @Polem,

 

Thanks for sharing the requested information. I am also able to reproduce the issue.

 

We will discuss this with our development team, could you please share the worker.log file from the agent side and PEM configuration report.

 

You can get the configuration report from PEM dashboard, go to help -> About Postgres Enterprise Manager.

 

Copy the configuration report, paste it in .txt file and attach here.

 

Please get back to us in case of any issues/queries.

 

Regards,

Sudhir

Level 3 Adventurer

Re: PEM query on lag time

<?xml version="1.0" encoding="UTF-8"?>
<pem_config_report>
   <version>
      <pem>7.4.0</pem>
      <schema>201808231</schema>
      <database>EnterpriseDB 10.5.12 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit</database>
      <python>2.7.5</python>
      <flask>0.11.1</flask>
   </version>
   <platform>
      <system>Linux</system>
      <node>pgsqlmonitor-001.pol.be</node>
      <release>3.10.0-514.2.2.el7.x86_64</release>
      <version>#1 SMP Wed Nov 16 13:15:13 EST 2016</version>
      <machine>x86_64</machine>
      <processor>x86_64</processor>
   </platform>
   <timezone>
      <timezone>1.0</timezone>
      <timezoneid>CET</timezoneid>
   </timezone>
   <agents>
      <counts>37</counts>
      <active>
         <count>37</count>
         <agent>
            <id>1</id>
            <version>7.4.0</version>
            <description>Postgres Enterprise Manager Host</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>pgsqlmonitor-001.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>1</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>2</id>
            <version>7.4.0</version>
            <description>kitericedb95</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.5 (Maipo)</details>
               <hostname>kitericedb95.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>3</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>3</id>
            <version>7.4.0</version>
            <description>csigdidb001</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>csigdidb001.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>4</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>4</id>
            <version>7.4.0</version>
            <description>csigdidb002</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>csigdidb002.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>5</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>5</id>
            <version>7.4.0</version>
            <description>dipodb-acc01</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>dipodb-acc01.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>6</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>6</id>
            <version>7.4.0</version>
            <description>dipodb-acc02</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>dipodb-acc02.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>7</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>7</id>
            <version>7.4.0</version>
            <description>dipodb-tra01</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>dipodb-tra01.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>8</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>8</id>
            <version>7.4.0</version>
            <description>dipodb-tra02</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>dipodb-tra02.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>9</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>9</id>
            <version>7.4.0</version>
            <description>dwh-accdb</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>dwh-accdb.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>10</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>10</id>
            <version>7.4.0</version>
            <description>dwh-prddb</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>dwh-prddb.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>11</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>11</id>
            <version>7.4.0</version>
            <description>fcahprdedb01-acc</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>fcahprdedb01-acc.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>12</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>12</id>
            <version>7.4.0</version>
            <description>fcahprdedb01-prd</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>fcahprdedb01-prd.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>13</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>13</id>
            <version>7.4.0</version>
            <description>fcahprdedb01-trg</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>fcahprdedb01-trg.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>14</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>14</id>
            <version>7.4.0</version>
            <description>fcbhprdedb02-acc</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>fcbhprdedb02-acc.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>15</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>15</id>
            <version>7.4.0</version>
            <description>fcbhprdedb02-prd</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>fcbhprdedb02-prd.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>16</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>16</id>
            <version>7.4.0</version>
            <description>fcbhprdedb02-trg</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>fcbhprdedb02-trg.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>17</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>17</id>
            <version>7.4.0</version>
            <description>focustgdb-tst</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>focustgdb-tst.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>18</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>18</id>
            <version>7.4.0</version>
            <description>pcn-prddba</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>pcn-prddba.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>19</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>19</id>
            <version>7.4.0</version>
            <description>pcn-prddbb</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>pcn-prddbb.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>20</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>20</id>
            <version>7.4.0</version>
            <description>plmgisdb01</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmgisdb01.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>21</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>21</id>
            <version>7.4.0</version>
            <description>plmgisdb02</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmgisdb02.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>22</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>22</id>
            <version>7.4.0</version>
            <description>plmtgdb01</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgdb01.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>23</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>23</id>
            <version>7.4.0</version>
            <description>plmtgdb02</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgdb02.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>24</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>24</id>
            <version>7.4.0</version>
            <description>plmtgdb-acc01</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgdb-acc01.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>25</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>25</id>
            <version>7.4.0</version>
            <description>plmtgdb-acc02</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgdb-acc02.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>26</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>26</id>
            <version>7.4.0</version>
            <description>plmtgdb-dev</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgdb-dev.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>27</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>27</id>
            <version>7.4.0</version>
            <description>plmtgdb-tra01</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgdb-tra01.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>28</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>28</id>
            <version>7.4.0</version>
            <description>plmtgdb-tra02</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgdb-tra02.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>29</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>29</id>
            <version>7.4.0</version>
            <description>plmtgdb-tst</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgdb-tst.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>30</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>30</id>
            <version>7.4.0</version>
            <description>plmtgpth-dev</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgpth-dev.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>31</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>31</id>
            <version>7.4.0</version>
            <description>plmtgpth-dev02</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgpth-dev02.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>32</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>32</id>
            <version>7.4.0</version>
            <description>plmtgpth-dev03</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgpth-dev03.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>33</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>33</id>
            <version>7.4.0</version>
            <description>plmtgpth-dev04</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgpth-dev04.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>34</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>34</id>
            <version>7.4.0</version>
            <description>plmtgpth-dev05</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgpth-dev05.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>35</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>35</id>
            <version>7.4.0</version>
            <description>plmtgpth-dev06</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgpth-dev06.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>36</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>36</id>
            <version>7.4.0</version>
            <description>plmtgpth-dev07</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgpth-dev07.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>37</server>
               </local>
            </bound_servers>
         </agent>
         <agent>
            <id>37</id>
            <version>7.4.0</version>
            <description>plmtgpth-dev08</description>
            <capability_list>unix, getloadavg, disk_space, memory_usage, cpu_usage, network_statistics, io_analysis, data_log_file_analysis, disk_busy_info, os_statistics, os_info, slony_replication, auto_discover_servers, allow_server_restart</capability_list>
            <OS>
               <details>Red Hat Enterprise Linux Server release 7.3 (Maipo)</details>
               <hostname>plmtgpth-dev08.pol.be</hostname>
               <domainname>(none)</domainname>
               <windows_domain/>
            </OS>
            <bound_servers>
               <count>1</count>
               <local>
                  <count>1</count>
                  <server>38</server>
               </local>
            </bound_servers>
         </agent>
      </active>
      <inactive>
         <count>0</count>
      </inactive>
   </agents>
   <servers>
      <count>39</count>
      <server>
         <id>1</id>
         <version>EnterpriseDB 10.5.12 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit</version>
         <description>Postgres Enterprise Manager Server</description>
         <agent_id>1</agent_id>
         <host>127.0.0.1</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id>None</service_id>
      </server>
      <server>
         <id>2</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>kitericedb95</description>
         <agent_id>None</agent_id>
         <host>10.27.105.7</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>3</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>kitericedb95</description>
         <agent_id>2</agent_id>
         <host>10.27.105.7</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>4</id>
         <version>EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>csigdidb001</description>
         <agent_id>3</agent_id>
         <host>csigdidb001</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>5</id>
         <version>EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>csigdidb002</description>
         <agent_id>4</agent_id>
         <host>csigdidb002</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>6</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>dipodb-acc01</description>
         <agent_id>5</agent_id>
         <host>dipodb-acc01</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>7</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>dipodb-acc02</description>
         <agent_id>6</agent_id>
         <host>dipodb-acc02</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>8</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>dipodb-tra01</description>
         <agent_id>7</agent_id>
         <host>dipodb-tra01</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>9</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>dipodb-tra02</description>
         <agent_id>8</agent_id>
         <host>dipodb-tra02</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>10</id>
         <version>EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>dwh-accdb</description>
         <agent_id>9</agent_id>
         <host>dwh-accdb</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>11</id>
         <version>EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>dwh-prddb</description>
         <agent_id>10</agent_id>
         <host>dwh-prddb</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>12</id>
         <version>EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>fcahprdedb01-acc</description>
         <agent_id>11</agent_id>
         <host>fcahprdedb01-acc</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>13</id>
         <version>EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>fcahprdedb01-prd</description>
         <agent_id>12</agent_id>
         <host>fcahprdedb01-prd</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>14</id>
         <version>EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>fcahprdedb01-trg</description>
         <agent_id>13</agent_id>
         <host>fcahprdedb01-trg</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>15</id>
         <version>EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>fcbhprdedb02-acc</description>
         <agent_id>14</agent_id>
         <host>fcbhprdedb02-acc</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>16</id>
         <version>EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>fcbhprdedb02-prd</description>
         <agent_id>15</agent_id>
         <host>fcbhprdedb02-prd</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>17</id>
         <version>EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>fcbhprdedb02-trg</description>
         <agent_id>16</agent_id>
         <host>fcbhprdedb02-trg</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>18</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>focustgdb-tst</description>
         <agent_id>17</agent_id>
         <host>focustgdb-tst</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>19</id>
         <version>EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>pcn-prddba</description>
         <agent_id>18</agent_id>
         <host>pcn-prddba</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>20</id>
         <version>EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>pcn-prddbb</description>
         <agent_id>19</agent_id>
         <host>pcn-prddbb</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>21</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmgisdb01</description>
         <agent_id>20</agent_id>
         <host>plmgisdb01</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>22</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmgisdb02</description>
         <agent_id>21</agent_id>
         <host>plmgisdb02</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>23</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgdb01</description>
         <agent_id>22</agent_id>
         <host>plmtgdb01</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>24</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgdb02</description>
         <agent_id>23</agent_id>
         <host>plmtgdb02</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>25</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgdb-acc01</description>
         <agent_id>24</agent_id>
         <host>plmtgdb-acc01</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>26</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgdb-acc02</description>
         <agent_id>25</agent_id>
         <host>plmtgdb-acc02</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>27</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgdb-dev</description>
         <agent_id>26</agent_id>
         <host>plmtgdb-dev</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>28</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgdb-tra01</description>
         <agent_id>27</agent_id>
         <host>plmtgdb-tra01</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>29</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgdb-tra02</description>
         <agent_id>28</agent_id>
         <host>plmtgdb-tra02</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>30</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgdb-tst</description>
         <agent_id>29</agent_id>
         <host>plmtgdb-tst</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>31</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgpth-dev</description>
         <agent_id>30</agent_id>
         <host>plmtgpth-dev</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>32</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgpth-dev02</description>
         <agent_id>31</agent_id>
         <host>plmtgpth-dev02</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>33</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgpth-dev03</description>
         <agent_id>32</agent_id>
         <host>plmtgpth-dev03</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>34</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgpth-dev04</description>
         <agent_id>33</agent_id>
         <host>plmtgpth-dev04</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>35</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgpth-dev05</description>
         <agent_id>34</agent_id>
         <host>plmtgpth-dev05</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>36</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgpth-dev06</description>
         <agent_id>35</agent_id>
         <host>plmtgpth-dev06</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>37</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgpth-dev07</description>
         <agent_id>36</agent_id>
         <host>plmtgpth-dev07</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>38</id>
         <version>EnterpriseDB 9.5.12.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit</version>
         <description>plmtgpth-dev08</description>
         <agent_id>37</agent_id>
         <host>plmtgpth-dev08</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
      <server>
         <id>41</id>
         <version>None</version>
         <description>Essai</description>
         <agent_id>None</agent_id>
         <host>10.27.105.12</host>
         <port>5432</port>
         <database>postgres</database>
         <service_id/>
      </server>
   </servers>
   <remote_servers>
      <count>0</count>
   </remote_servers>
   <configurations>
      <config param="audit_log_retention_time" value="30 (days)"/>
      <config param="auto_create_agent_alerts" value="TRUE (t/f)"/>
      <config param="auto_create_server_alerts" value="TRUE (t/f)"/>
      <config param="cm_data_points_per_report" value="50"/>
      <config param="cm_max_end_date_in_years" value="5 (years)"/>
      <config param="dash_alerts_timeout" value="60 (seconds)"/>
      <config param="dash_db_comrol_span" value="168 (hours)"/>
      <config param="dash_db_comrol_timeout" value="1800 (seconds)"/>
      <config param="dash_db_connovervw_timeout" value="300 (seconds)"/>
      <config param="dash_db_eventlag_span" value="7 (days)"/>
      <config param="dash_db_eventlag_timeout" value="1800 (seconds)"/>
      <config param="dash_db_hottable_rows" value="25 (rows)"/>
      <config param="dash_db_hottable_timeout" value="300 (seconds)"/>
      <config param="dash_db_io_span" value="168 (hours)"/>
      <config param="dash_db_io_timeout" value="1800 (seconds)"/>
      <config param="dash_db_rowact_span" value="168 (hours)"/>
      <config param="dash_db_rowact_timeout" value="1800 (seconds)"/>
      <config param="dash_db_storage_timeout" value="300 (seconds)"/>
      <config param="dash_db_timelag_span" value="7 (days)"/>
      <config param="dash_db_timelag_timeout" value="1800 (seconds)"/>
      <config param="dash_db_useract_span" value="168 (hours)"/>
      <config param="dash_db_useract_timeout" value="1800 (seconds)"/>
      <config param="dash_efm_timeout" value="300 (seconds)"/>
      <config param="dash_global_overview_timeout" value="60 (seconds)"/>
      <config param="dash_header_timeout" value="60 (seconds)"/>
      <config param="dash_io_chkpt_span" value="168 (hours)"/>
      <config param="dash_io_chkpt_timeout" value="1800 (seconds)"/>
      <config param="dash_io_hotindx_timeout" value="300 (seconds)"/>
      <config param="dash_io_hottbl_timeout" value="300 (seconds)"/>
      <config param="dash_io_index_objectio_rows" value="25 (rows)"/>
      <config param="dash_io_index_objectio_timeout" value="60 (seconds)"/>
      <config param="dash_io_objectio_rows" value="25 (rows)"/>
      <config param="dash_io_objectio_timeout" value="300 (seconds)"/>
      <config param="dash_memory_hostmemact_span" value="168 (hours)"/>
      <config param="dash_memory_hostmemact_timeout" value="1800 (seconds)"/>
      <config param="dash_memory_hostmemconf_timeout" value="300 (seconds)"/>
      <config param="dash_memory_servmemact_span" value="168 (hours)"/>
      <config param="dash_memory_servmemact_timeout" value="1800 (seconds)"/>
      <config param="dash_memory_servmemconf_timeout" value="300 (seconds)"/>
      <config param="dash_objectact_objstorage_rows" value="15 (rows)"/>
      <config param="dash_objectact_objstorage_timeout" value="300 (seconds)"/>
      <config param="dash_objectact_objtopindexes_timeout" value="300 (seconds)"/>
      <config param="dash_objectact_objtoptables_timeout" value="300 (seconds)"/>
      <config param="dash_os_cpu_span" value="168 (hours)"/>
      <config param="dash_os_cpu_timeout" value="1800 (seconds)"/>
      <config param="dash_os_data_span" value="168 (hours)"/>
      <config param="dash_os_disk_span" value="168 (hours)"/>
      <config param="dash_os_hostfs_timeout" value="1800 (seconds)"/>
      <config param="dash_os_io_timeout" value="1800 (seconds)"/>
      <config param="dash_os_memory_span" value="168 (hours)"/>
      <config param="dash_os_memory_timeout" value="1800 (seconds)"/>
      <config param="dash_os_packet_span" value="168 (hours)"/>
      <config param="dash_os_packet_timeout" value="1800 (seconds)"/>
      <config param="dash_os_process_span" value="168 (hours)"/>
      <config param="dash_os_process_timeout" value="1800 (seconds)"/>
      <config param="dash_os_storage_timeout" value="1800 (seconds)"/>
      <config param="dash_os_traffic_span" value="168 (hours)"/>
      <config param="dash_os_traffic_timeout" value="1800 (seconds)"/>
      <config param="dash_os_util_timeout" value="1800 (seconds)"/>
      <config param="dash_probe_log_timeout" value="300 (seconds)"/>
      <config param="dash_replication_archivestat_span" value="7 (days)"/>
      <config param="dash_replication_archivestat_timeout" value="1800 (seconds)"/>
      <config param="dash_replication_pagelag_span" value="7 (days)"/>
      <config param="dash_replication_pagelag_timeout" value="1800 (seconds)"/>
      <config param="dash_replication_segmentlag_span" value="7 (days)"/>
      <config param="dash_replication_segmentlag_timeout" value="1800 (seconds)"/>
      <config param="dash_replication_timelag_span" value="7 (days)"/>
      <config param="dash_replication_timelag_timeout" value="1800 (seconds)"/>
      <config param="dash_server_buffers_written" value="168 (hours)"/>
      <config param="dash_server_buffers_written_timeout" value="300 (seconds)"/>
      <config param="dash_server_connovervw_timeout" value="300 (seconds)"/>
      <config param="dash_server_database_timeout" value="300 (seconds)"/>
      <config param="dash_server_dbsize_span" value="168 (hours)"/>
      <config param="dash_server_dbsize_timeout" value="1800 (seconds)"/>
      <config param="dash_server_disk_timeout" value="1800 (seconds)"/>
      <config param="dash_server_global_span" value="168 (hours)"/>
      <config param="dash_server_sharedbuff_span" value="168 (hours)"/>
      <config param="dash_server_sharedbuff_timeout" value="1800 (seconds)"/>
      <config param="dash_server_tabspacesize_span" value="168 (hours)"/>
      <config param="dash_server_tabspacesize_timeout" value="1800 (seconds)"/>
      <config param="dash_server_useract_span" value="168 (hours)"/>
      <config param="dash_server_useract_timeout" value="1800 (seconds)"/>
      <config param="dash_sessact_lockact_timeout" value="300 (seconds)"/>
      <config param="dash_sessact_workload_timeout" value="300 (seconds)"/>
      <config param="dash_sess_waits_nowaits_timeout" value="300 (seconds)"/>
      <config param="dash_sess_waits_timewait_timeout" value="300 (seconds)"/>
      <config param="dash_sess_waits_waitdtl_timeout" value="300 (seconds)"/>
      <config param="dash_storage_dbdtls_timeout" value="300 (seconds)"/>
      <config param="dash_storage_dbovervw_timeout" value="300 (seconds)"/>
      <config param="dash_storage_hostdtls_timeout" value="300 (seconds)"/>
      <config param="dash_storage_hostovervw_timeout" value="300 (seconds)"/>
      <config param="dash_storage_tblspcdtls_timeout" value="300 (seconds)"/>
      <config param="dash_storage_tblspcovervw_timeout" value="300 (seconds)"/>
      <config param="dash_sys_waits_nowaits_timeout" value="300 (seconds)"/>
      <config param="dash_sys_waits_timewait_timeout" value="300 (seconds)"/>
      <config param="dash_sys_waits_waitdtl_timeout" value="300 (seconds)"/>
      <config param="deleted_charts_retention_time" value="7 (days)"/>
      <config param="deleted_probes_retention_time" value="7 (days)"/>
      <config param="download_chart_format" value="jpeg (jpeg/png)"/>
      <config param="flapping_detection_state_change" value="3"/>
      <config param="job_retention_time" value="30 (days)"/>
      <config param="long_running_transaction_minutes" value="5 (minutes)"/>
      <config param="max_metrics_per_group_chart" value="16"/>
      <config param="nagios_cmd_file_name" value="/usr/local/nagios/var/rw/nagios.cmd"/>
      <config param="nagios_enabled" value="TRUE (t/f)"/>
      <config param="nagios_medium_alert_as_critical" value="FALSE (t/f)"/>
      <config param="nagios_spool_retention_time" value="7 (days)"/>
      <config param="package_catalog_xml" value="https://sbp.enterprisedb.com/applications.xml"/>
      <config param="package_download_chunk_size" value="1048576 (Bytes)"/>
      <config param="probe_log_retention_time" value="30 (days)"/>
      <config param="proxy_server" value="127.0.0.1"/>
      <config param="proxy_server_authentication" value="FALSE (t/f)"/>
      <config param="proxy_server_enabled" value="FALSE (t/f)"/>
      <config param="proxy_server_password" value="EMPTY"/>
      <config param="proxy_server_port" value="80"/>
      <config param="proxy_server_username" value=""/>
      <config param="reminder_notification_interval" value="24 (hours)"/>
      <config param="server_log_retention_time" value="30 (days)"/>
      <config param="show_data_points_on_graph" value="FALSE (t/f)"/>
      <config param="show_data_tab_on_graph" value="FALSE (t/f)"/>
      <config param="smtp_authentication" value="FALSE (t/f)"/>
      <config param="smtp_enabled" value="TRUE (t/f)"/>
      <config param="smtp_encryption" value="FALSE (t/f)"/>
      <config param="smtp_password" value="EMPTY"/>
      <config param="smtp_port" value="25"/>
      <config param="smtp_server" value="127.0.0.1"/>
      <config param="smtp_spool_retention_time" value="7 (days)"/>
      <config param="smtp_username" value=""/>
      <config param="snmp_community" value="public"/>
      <config param="snmp_enabled" value="TRUE (t/f)"/>
      <config param="snmp_port" value="162"/>
      <config param="snmp_server" value="127.0.0.1"/>
      <config param="snmp_spool_retention_time" value="7 (days)"/>
      <config param="webclient_help_pg" value="https://www.enterprisedb.com/docs/en/10/pg/index.html"/>
   </configurations>
</pem_config_report>

The worker.log of PEM server and both node of one EFM cluster are all empty.

KR,

Paulem

EDB Team Member

Re: PEM query on lag time

Hi @Polem,

 

Thanks for sharing the PEM configuration report with us, we are discussing this issue with our development team.

 

We will update to you as soon as possible.

 

Regards,

Sudhir

EDB Team Member

Re: PEM query on lag time

Hi @Polem,

 

We have discussed this with our development, the table updates only if the lag is present and it is calculated in minutes.

 

So, if you have more than 1 minutes lag then pemdata.streaming_replication_lag_time table updates with the lag_time value.

 

I have tested in our local environment and it is working fine, I used the pgbench to generate enough lag between Master and Stabndby server.

 

Please check the values of pemdata.streaming_replication_lag_time after generating the lag in several minutes.

 

Please get back to us in case of any issues/queries.

 

Regards,

Sudhir