Senin, 10 Juni 2024

PSQL-monitoring experdb

 https://github.com/experdb/eXperDB-Monitoring?tab=readme-ov-file

Repository files navigation

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.

intro intro2

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.

consist

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
  1. Backend process monitoring

  2. SQL Plan

  3. Object statistics

  4. Time-Line-View (Multiple Charts)

  5. Alert Event

  6. Control Session(Backend) and Lock

  7. HA Status and Streaming Replication monitoring

  8. Auto Scale-Out/In cluster auto detection

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

TODO

  • Transition to Web Version.

License

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

Tidak ada komentar:

Posting Komentar