Introduction

eXperDB-Monitoring for PostgreSQL provide real time monitoring for PostgreSQL It enables various types of monitoring such as session, alive, resource, performance, and so on. It supports to monitoring not only Streaming Replication but also HA status. You can use eXperDB-Monitoring for PostgreSQL to quickly find various troubles, analyze troubles, and tune performance of PostgreSQL.

characteristic

Agentless

• eXperDB-Monitoring collect by installing only extension module on the target cluster of PostgreSQL server
• 3-tier : the client has no affect on the target servers.
• Easy installing and upinstaling.

Monitoring multi-cluster smultaneously.

Extensive collection of information

Maximizing user convenience

System Components

eXperDB-Monitoring for postgreSQL consists of a server for collecting database information, extension on PostgreSQL server, and a control screen as an integrated console.

Features

1) Dash-Board

2) Resource monitoring

3) Transaction monitoring

4) Health-Check by key performance indicator

• Long running SQL
• Unused index
• Last vacuum day
• Last analyze day
• Connection failed
• Idle in transaction
• Locked transaction
• Disk used ratio
• Swap used ratio
• CPU wait ratio
• Current connection
• Commit rate
• Buffer hit rate
• HA Status

5) Backend process monitoring

6) SQL Plan

7) Object statistics

8) Time-Line-View (Multiple Charts)

9) Alert Event

10) Control Session(Backend) and Lock

11) HA Status and Streaming Replication monitoring

12) Auto Scale-Out/In cluster auto detection

13) On-Premise Area, Public Cloud(AWS) Area Integrated Monitoring

TODO

• Transition to Web Version.

License

Installation

Installing eXperDB-Monitoring-Server

System Requirements

• OS : Linux
• JDK : JDK 1.7 or later
• CPU : At least 4core, recommended 8core
• HDD : 100GB or more

Installation procedure

1.Preparation eXperDB-Monitoring for PostgreSQL using PostgreSQL as as repository. so PostgreSQL must be installed on your linux machine before installing eXperDB-Monitoring-Server.

  
tar zxvf eXperDB_Server_xxx.tar.gz

2.Run install script

  
cd eXperDB_Server
./install.sh -h 127.0.0.1 -d postgres -p 5432 -U postgres -W postgres

Installing eXperDB-Monitoring-Extension

System Requirements

• OS : Linux
• PostgreSQL : Ver 9.1 or later

Installation procedure

1.Preparation

# tar zxvf eXperDB_PGMON_xxx.tar

2.Build

# tar zxvf eXperDB_PGMON_xxx.tar
# cd eXperDB_PGMON
# make USE_PGXS=1 install

3.Create extension.

• Create the database for monitoring.
• Create the role with super privileges for monitoring
• Create extension

  postgres=# create extension experdb_pgmon;
  

Installing eXperDB-Monitoring-Client

System Requirements

• OS : Windows 7 or later
• .Net Framwork : 4.5.1 or later (already contained in the installation package)
• Resolution : 1920x1080

Installation procedure

1. Run eXperDB.Monitoring_XXX.exe

Contribution

If you find a bug, please report to us by posting issues on Github.
Source code modifications via pull requests are welcome.
Also, if you would like to contact us directly, please send an email to experdb@inzent.com.

Copyright

Copyright (c) 2016-2020, eXperDB Development Team All rights reserved.

Community

• https://www.facebook.com/experdb
• http://cafe.naver.com/psqlmaster