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.
- 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.
eXperDB-Monitoring for postgreSQL consists of a server for collecting database information, extension on PostgreSQL server, and a control screen as an integrated console.
-
Dash-Board
-
Resource monitoring
-
Transaction monitoring
-
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
-
Backend process monitoring
-
SQL Plan
-
Object statistics
-
Time-Line-View (Multiple Charts)
-
Alert Event
-
Control Session(Backend) and Lock
-
HA Status and Streaming Replication monitoring
-
Auto Scale-Out/In cluster auto detection
-
On-Premise Area, Public Cloud(AWS) Area Integrated Monitoring
- Transition to Web Version.
- OS : Linux
- JDK : JDK 1.7 or later
- CPU : At least 4core, recommended 8core
- HDD : 100GB or more
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
- OS : Linux
- PostgreSQL : Ver 9.1 or later
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;
- OS : Windows 7 or later
- .Net Framwork : 4.5.1 or later (already contained in the installation package)
- Resolution : 1920x1080
- Run eXperDB.Monitoring_XXX.exe
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 [email protected].
Copyright (c) 2016-2020, eXperDB Development Team All rights reserved.