HomeMogDBMogDB StackUqbar
v5.0

Documentation:v5.0

Supported Versions:

Other Versions:

Viewing WDRs

Database Stat

The following table describes columns in the Database Stat report.

Table 1 Columns in the Database Stat report

Column Description
DB Name Database name.
Backends Number of backends connected to this database.
Xact Commit Number of transactions in this database that have been committed.
Xact Rollback Number of transactions in this database that have been rolled back.
Blks Read Number of disk blocks read in this database.
Blks Hit Number of times that disk blocks have been found in the cache.
Tuple Returned Number of rows sequentially scanned.
Tuple Fetched Number of rows randomly scanned.
Tuple Inserted Number of rows inserted by queries in this database.
Tuple Updated Number of rows updated by queries in this database.
Tup Deleted Number of rows deleted by queries in this database.
Conflicts Number of queries canceled due to conflicts.
Temp Files Number of temporary files created by queries in this database.
Temp Bytes Total amount of data written to temporary files by queries in this database.
Deadlocks Number of deadlocks detected in this database.
Blk Read Time Time spent reading data file blocks by backends in this database (unit: ms).
Blk Write Time Time spent writing into data file blocks by backends in this database (unit: ms).
Stats Reset Time at which the current statistics were reset.

Load Profile

The following table lists metrics in the Load Profile report.

Table 2 Metrics in the Load Profile report

Metric Description
DB Time(us) Total elapsed time of a job.
CPU Time(us) Total CPU time used for job running.
Redo size(blocks) Size of the generated WAL (blocks).
Logical read (blocks) Number of logical reads (blocks) on a table or an index.
Physical read (blocks) Number of physical reads (blocks) on a table or an index.
Physical write (blocks) Number of physical writes (blocks) on a table or an index.
Read IO requests Number of times that a table or an index is read.
Write IO requests Number of times that a table or an index is written.
Read IO (MB) Table or index read size (MB).
Write IO (MB) Table or index write size (MB).
Logons Number of logins.
Executes (SQL) Number of times the SQL statement is executed.
Rollbacks Number of rolled-back transactions.
Transactions Number of transactions.
SQL response time P95(us) Response time of 95% SQL statements.
SQL response time P80(us) Response time of 80% SQL statements.

Instance Efficiency Percentages

The following table lists metrics in the Instance Efficiency Percentages report.

Table 3 Metrics in the Instance Efficiency Percentages report

Metric Description
Buffer Hit % Hit ratio of the buffer pool.
Effective CPU % Ratio of the CPU time to the DB time.
WalWrite NoWait % Ratio of the number of events that access the WAL buffer to the total number of wait events.
Soft Parse % Ratio of the number of soft parsing times to the total number of parsing times.
Non-Parse CPU % Ratio of the non-parse time to the total execution time.

Top 10 Events by Total Wait Time

The following table lists columns in the Top 10 Events by Total Wait Time report.

Table 4 Columns in the Top 10 Events by Total Wait Time report

Column Description
Event Name of a wait event.
Waits Number of wait times.
Total Wait Time(us) Total wait time, in microseconds.
Avg Wait Time(us) Average wait time, in microseconds.
Type Wait event type.

Wait Classes by Total Wait Time

The following table lists columns in the Wait Classes by Total Wait Time report.

Table 5 Columns in the Wait Classes by Total Wait Time report

Column Description
Type Wait events are classified as follows:
- STATUS。
- LWLOCK_EVENT。
- LOCK_EVENT。
- IO_EVENT。
Waits Number of wait times.
Total Wait Time(us) Total wait time, in microseconds.
Avg Wait Time(us) Average wait time, in microseconds.

Host CPU

The following table describes columns in the Host CPU report.

Table 6 Columns in the Host CPU report

Column Description
Cpus Number of processors.
Cores Number of CPU cores.
Sockets Number of CPU sockets.
Load Average Begin Load average value of the start snapshot.
Load Average End Load average value of the end snapshot.
%User Percentage of CPU time spent in the user mode.
%System Percentage of CPU time spent in the kernel mode.
%WIO Percentage of CPU time spent in wait I/O.
%Idle Percentage of CPU idle time.

IO Profile

The following table lists metrics in the IO Profile report.

Table 7 Metrics in the IO Profile report

Metric Description
Database requests Number of database I/O times.
Database (MB) Database I/O data volume.
Database (blocks) Number of database I/O data blocks.
Redo requests Number of redo I/O times.
Redo (MB) Redo I/O data volume.

Memory Statistics

The following table lists metrics in the Memory Statistics report.

Table 8 Columns in the Memory Statistics report

Metric Description
shared_used_memory Size of used shared memory (MB).
max_shared_memory Maximum shared memory (MB).
process_used_memory Memory used by processes (MB).
max_process_memory Maximum memory that can be allocated to a process (MB).

Time Model

The following table describes metrics in the Time Model report.

Table 9 Metrics in the Time Model report

Metric Description
DB_TIME Total end-to-end wall time consumed by all threads (unit: μs).
EXECUTION_TIME Total time consumed on the executor (unit: μs).
PL_EXECUTION_TIME Total time consumed for executing PL/SQL statements (unit: μs).
CPU_TIME Total CPU time consumed by all threads (unit: μs).
PLAN_TIME Total time consumed for generating an execution plan (unit: μs).
REWRITE_TIME Total time consumed on query rewriting (unit: μs).
PL_COMPILATION_TIME Total time consumed for SQL compilation (unit: μs).
PARSE_TIME Total time consumed for parsing SQL statements (unit: μs).
NET_SEND_TIME Total time consumed for sending data over network (unit: μs).
DATA_IO_TIME Total time consumed for data read and write (unit: μs).

SQL Statistics

The following table describes columns in the SQL Statistics report.

Table 10 Columns in the SQL Statistics report

Column Description
Unique SQL Id ID of the normalized SQL statement.
Node Name Node name.
User Name Username.
Tuples Read Number of tuples that are read.
Calls Number of calls.
Min Elapse Time(us) Minimum execution time (unit: us).
Max Elapse Time(us) Maximum execution time (unit: us).
Total Elapse Time(us) Total execution time (unit: us).
Avg Elapse Time(us) Average execution time (unit: us).
Returned Rows Number of rows returned by SELECT.
Tuples Affected Number of rows affected by INSERT, UPDATE, and DELETE.
Logical Read Number of logical reads on the buffer.
Physical Read Number of physical reads on the buffer.
CPU Time(us) CPU time (unit: us).
Data IO Time(us) Time spent on I/O (unit: us).
Sort Count Number of sorting execution times.
Sort Time(us) Sorting execution time (unit: us).
Sort Mem Used(KB) Size of work memory used during sorting (unit: KB).
Sort Spill Count Number of file writes when data is flushed to disks during sorting.
Sort Spill Size(KB) File size used when data is flushed to disks during sorting (unit: KB).
Hash Count Number of hashing execution times.
Hash Time(us) Hashing execution time (unit: us).
Hash Mem Used(KB) Size of work memory used during hashing (unit: KB).
Hash Spill Count Number of file writes when data is flushed to disks during hashing.
Hash Spill Size(KB) File size used when data is flushed to disks during hashing (unit: KB).
SQL Text Normalized SQL character string.

Wait Events

The following table describes columns in the Wait Events report.

Table 11 Columns in the Wait Events report

Column Description
Type Wait events are classified as follows:
- STATUS
- LWLOCK_EVENT
- LOCK_EVENT
- IO_EVENT
Event Name of a wait event.
Total Wait Time (us) Total wait time (unit: us).
Waits Total number of wait times.
Failed Waits Number of wait failures.
Avg Wait Time (us) Average wait time (unit: us).
Max Wait Time (us) Maximum wait time (unit: us).

Cache IO Stats

Cache IO Stats contains two tables: User table and User index. The columns in the tables are described as follows.

User table IO activity ordered by heap blks hit ratio

Table 12 Columns in the User table IO activity ordered by heap blks hit ratio report

Column Description
DB Name Database name.
Schema Name Schema name.
Table Name Table name.
%Heap Blks Hit Ratio Buffer pool hit ratio of the table.
Heap Blks Read Number of disk blocks read from the table.
Heap Blks Hit Number of cache hits in the table.
Idx Blks Read Number of disk blocks read from all indexes on the table.
Idx Blks Hit Number of cache hits in the table .
Toast Blks Read Number of disk blocks read from the TOAST table (if any) in the table.
Toast Blks Hit Number of buffer hits in the TOAST table (if any) in the table.
Tidx Blks Read Number of disk blocks read from the TOAST table index (if any) in the table.
Tidx Blks Hit Number of buffer hits in the TOAST table index (if any) in the table.

User index IO activity ordered by idx blks hit ratio

Table 13 Columns in the User index IO activity ordered by idx blks hit ratio report

Column Description
DB Name Database name.
Schema Name Schema name.
Table Name Table name.
Index Name Index name.
%Idx Blks Hit Ratio Index hit ratio.
Idx Blks Read Number of disk blocks read from all indexes on the table.
Idx Blks Hit Number of cache hits in the table.

Utility status

Utility status contains two tables: Replication slot and Replication stat. Columns in the tables are described as follows:

Replication slot

Table 14 Columns in the Replication slot report

Column Description
Slot Name Replication node name.
Slot Type Type of the replication node.
DB Name Name of the database on the replication node.
Active Replication node status.
Xmin Transaction ID of the replication node.
Restart Lsn Xlog file information on the replication node.
Dummy Standby Replication node as a dummy standby.

Replication stat

Table 15 Columns in the Replication stat report

Column Description
Thread Id PID of the thread.
Usesys Id User system ID.
Username Username.
Application Name Application name.
Client Addr Client address.
Client Hostname Client host name.
Client Port Port of the client.
Backend Start Start time of an application.
State Log replication status.
Sender Sent Location Location where the sender sends logs.
Receiver Write Location Location where the receiver writes logs.
Receiver Flush Location Location where the receiver flushes logs.
Receiver Replay Location Location where the receiver replays logs.
Sync Priority Synchronization priority.
Sync State Synchronization status.

Object stats

Object stats contains three tables: User Tables stats, User index stats, and Bad lock stats. Columns in the tables are described as follows:

User Tables stats

Table 16 Columns in the User Tables stats report

Column Description
DB Name Database name.
Schema Schema name.
Relname Relation name.
Seq Scan Number of sequential scans initiated on this table.
Seq Tup Read Number of live rows fetched by sequential scans.
Index Scan Number of index scans initiated on the table.
Index Tup Fetch Number of live rows fetched by index scans.
Tuple Insert Number of rows inserted.
Tuple Update Number of rows updated.
Tuple Delete Number of rows deleted.
Tuple Hot Update Number of rows HOT updated (with no separate index updated).
Live Tuple Estimated number of live rows.
Dead Tuple Estimated number of dead rows.
Last Vacuum Last time at which this table was manually vacuumed (not counting VACUUM FULL).
Last Autovacuum Last time at which this table was vacuumed by the autovacuum daemon.
Last Analyze Last time at which this table was manually analyzed.
Last Autoanalyze Last time at which this table was analyzed by the autovacuum daemon.
Vacuum Count Number of times the table has been manually vacuumed (not counting VACUUM FULL).
Autovacuum Count Number of times the table has been vacuumed by the autovacuum daemon.
Analyze Count Number of times the table has been manually analyzed.
Autoanalyze Count Number of times the table has been analyzed by the autovacuum daemon.

User index stats

Table 17 Columns in the User index stats report

Column Description
DB Name Database name.
Schema Schema name.
Relname Relation name.
Index Relname Index name.
Index Scan Number of index scans initiated on the index.
Index Tuple Read Number of index entries returned by scans on the index.
Index Tuple Fetch Number of live table rows fetched by simple index scans using the index.

Bad lock stats

Table 18 Columns in the Bad lock stats report

Column Description
DB Id OID of the database.
Tablespace Id Tablespace OID.
Relfilenode File object ID.
Fork Number File type.
Error Count Number of failures.
First Time First occurrence time.
Last Time Last occurrence time.

Configuration settings

The following table describes columns in the Configuration settings report.

Table 19 Columns in the Configuration settings report

Column Description
Name GUC name.
Abstract GUC description.
Type Data type.
Curent Value Current value.
Min Value Valid minimum value.
Max Value Valid maximum value.
Category GUC type.
Enum Values All enumerated values.
Default Value Default parameter value used upon the database startup.
Reset Value Default parameter value used upon the database reset.

SQL Detail

The following table describes columns in the SQL Detail report.

Table 20 Columns in the SQL Detail report

Column Description
Unique SQL Id ID of the normalized SQL statement.
User Name Username.
Node Name Node name. This column is not displayed in node mode.
SQL Text Normalized SQL text.
Copyright © 2011-2024 www.enmotech.com All rights reserved.