PEV

FEATURES OVERVIEW

PEV = Table * 16 + View * 6 + Client tool * 1

What is PEV:

PEV is an extension of PG, which implements enterprise level performance and operation management capabilities on the basis of standard open source PG. Users can monitor load metrics from the OS to the DB through PEV, and can trace the performance status of the system at various granularity from history to present.

What is PEV Client:

PEV client is a visual GUI tool based on PEV extension, which allows for more intuitive insights into the performance of PG databases and related issues.

Complete monitoring system

PEV opens 16 tables and 6 views for real-time monitoring, analysis and summary of load, process, session, Sql, Sql execution plan, Sql statistics, database object statistics, waiting events, transactions, locks and other information from the operating system (mainly load metrics) to the database.

About Metrics

PEV_METRICS: Real-time load metrics ( OS + DB ) PEV_METRICS_HIS: Dynamic metrics detection.

About Session

PEV_ACTIVE_SESSION: Real-time session summary
PEV_ACTIVE_SESSION_HIS: Dynamic session detection.

About Events

PEV_WAIT_EVENTS: Real-time wait event summary PEV_LONG_TRXS: Real-time timeout transaction summary PEV_LONG_LOCKS: Real-time timeout lock summary PEV_WAIT_EVENTS_HIS: Dynamic wait event detection PEV_LONG_TRXS_HIS: Dynamic timeout transaction detection PEV_LONG_LOCKS_HIS: Dynamic timeout lock detection.

About DB objects

PEV_DATABASE_HIS: Dynamic database statics detection PEV_TABLES_HIS: Dynamic table statics detection PEV_INDEXES_HIS: Dynamic index statics detection PEV_SEQUENCES_HIS: Dynamic sequence statics detection PEV_BGWRITER_HIS: Dynamic bgWriter statics detection PEV_ARCHIVER_HIS: Dynamic archiver statics detection.

About client tool

One click direct DB connection without installation
Insight into the state from the OS to the DB
Detailed traceability for each Sql
One click clear problem session (time-out locks, transactions)
Tracking of history Top Sql
Tracking of history Top clients
Tracking of history Top locks
Tracking of history Top transactions
Tracking of history Top databases
Tracking of history Top tables
Tracking of history Top indexes
Tracking of history BgWriter status
Tracking of history Archiver status

OTHER FEATURES

Automatic garbage collection

Custom configuration

Configure online hot update

Features	Free	Professional
Sql parsing & analysis	✔	✔
Sql plan parsing & analysis	✔	✔
Sql Statistics collection	✔	✔
Session collection	✔	✔
Real-time OS metrics	✔	✔
Real-time DB metrics	✔	✔
Real-time wait event statistics	✔	✔
Real-time long transaction	✔	✔
Real-time lock waiting	✔	✔
Sql statistics traceable	24 hours	Unlimited
Session traceable	24 hours	Unlimited
OS metrics traceable	24 hours	Unlimited
DB metrics traceable	24 hours	Unlimited
Wait event statistics traceable	24 hours	Unlimited
Long transaction traceable	24 hours	Unlimited
lock waiting traceable	24 hours	Unlimited
Database statistics traceable	24 hours	Unlimited
Table statistics traceable	24 hours	Unlimited
Index statistics traceable	24 hours	Unlimited
Sequence statistics traceable	24 hours	Unlimited
Function statistics traceable	24 hours	Unlimited
Bgwriter statistics traceable	24 hours	Unlimited
Archiver statistics traceable	24 hours	Unlimited
Custom configuration	✔	✔
Configure online hot update	✔	✔
Automatic garbage collection	✔	✔
Product Price	free	Enquiry Please