English
描述
pg_enterprise_views
From OS to DB, From Past to Present
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 Sql
PEV_SQL: Global Sql summary
PEV_SQL_PLAN: Global Sql plan summary
PEV_SQL_STATS: Global Sql stats summary
PEV_SQL_STATS_HIS: Dynamic Sql stats 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 SqlTracking 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
FeaturesFreeProfessional
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 traceable24 hoursUnlimited
Session traceable24 hoursUnlimited
OS metrics traceable24 hoursUnlimited
DB metrics traceable24 hoursUnlimited
Wait event statistics traceable24 hoursUnlimited
Long transaction traceable24 hoursUnlimited
lock waiting traceable24 hoursUnlimited
Database statistics traceable24 hoursUnlimited
Table statistics traceable24 hoursUnlimited
Index statistics traceable24 hoursUnlimited
Sequence statistics traceable24 hoursUnlimited
Function statistics traceable24 hoursUnlimited
Bgwriter statistics traceable24 hoursUnlimited
Archiver statistics traceable24 hoursUnlimited
Custom configuration
Configure online hot update
Automatic garbage collection
Product PricefreeEnquiry Please