Table of Contents Previous Next


3 Built-In Packages : 3.11 DBMS_PROFILER : 3.11.8 Using DBMS_PROFILER : 3.11.8.2 DBMS_PROFILER - Reference

Table containing the performance statistics and the extended performance statistics for DRITA counters and timers.
The PLSQL_PROFILER_RUNS table contains the following columns:
Unique identifier (plsql_profiler_runnumber)
The runid of a related run.
The PLSQL_PROFILER_UNITS table contains the following columns:
Unique identifier (plsql_profiler_runnumber)
The PLSQL_PROFILER_DATA view contains the following columns:
Unique identifier (plsql_profiler_runnumber)
The PLSQL_PROFILER_RAWDATA table contains the statistical and wait events information that is found in the PLSQL_PROFILER_DATA view, as well as the performance statistics returned by the DRITA counters and timers.
A server has waited for the completion of the shared_plan_cache_collision event.
A server has waited for the completion of the shared_plan_cache_insert event.
A server has waited to update the postgresql.auto.conf file.
A server has waited for the bulkloadlock to bulk upload the data.
The edbresourcemanagerlock provides detail about edb resource manager lock module.
The amount of time that the server has waited for a wal_write wait event to write to the write-ahead log buffer (expect this value to be high).
The amount of time that the server has waited for a wal_flush wait event to write-ahead log to flush to disk.
The amount of time that the server has waited for a wal_file_sync wait event to write-ahead log to sync to disk (related to the wal_sync_method parameter which, by default, is 'fsync' - better performance can be gained by changing this parameter to open_sync).
The amount of time that the server has waited for the db_file_read wait event for completion of a read (from disk).
The amount of time that the server has waited for the db_file_write wait event for completion of a write (to disk).
The amount of time that the server has waited for the db_file_sync wait event to sync all changes to disk.
The amount of time that the server has waited for the db_file_extend wait event while adding a new page to the end of a file.
The amount of time that the server has waited for the sql_parse wait event to parse a SQL statement.
The amount of time that the server has waited for the query_plan wait event to compute the execution plan for a SQL statement.
The amount of time that the server has waited for the other_lwlock_acquire wait event to protect data.
The amount of time that the server has waited for the shared_plan_cache_collision wait event.
The amount of time that the server has waited for the shared_plan_cache_insert wait event.
The amount of time that the server has waited for the shmemindexlock wait event to find or allocate space in the shared memory.
The amount of time that the server has waited for the oidgenlock wait event to allocate or assign an OID.
The amount of time that the server has waited for xidgenlock wait event to allocate or assign a transaction ID.
The amount of time that the server has waited for a procarraylock wait event to clear a transaction ID at transaction end.
The amount of time that the server has waited for a sinvalreadlock wait event to retrieve or remove messages from shared invalidation queue.
The amount of time that the server has waited for a sinvalwritelock wait event to add a message to the shared invalidation queue.
The amount of time that the server has waited for a walbufmappinglock wait event to replace a page in WAL buffers.
The amount of time that the server has waited for a walwritelock wait event to write the WAL buffers to disk.
The amount of time that the server has waited for a controlfilelock wait event to read or update the control file or to create a new WAL file.
The amount of time that the server has waited for a checkpointlock wait event to perform a checkpoint.
The amount of time that the server has waited for a clogcontrollock wait event to read or update the transaction status.
The amount of time that the server has waited for the subtranscontrollock wait event to read or update the sub-transaction information.
The amount of time that the server has waited for the multixactgenlock wait event to read or update the shared multixact state.
The amount of time that the server has waited for the multixactoffsetcontrollock wait event to read or update multixact offset mappings.
The amount of time that the server has waited for the multixactmembercontrollock wait event to read or update multixact member mappings.
The amount of time that the server has waited for the relcacheinitlock wait event to read or write the relation cache initialization file.
The amount of time that the server has waited for the checkpointercommlock wait event to manage the fsync requests.
The amount of time that the server has waited for the twophasestatelock wait event to read or update the state of prepared transactions.
The amount of time that the server has waited for the tablespacecreatelock wait event to create or drop the tablespace.
The amount of time that the server has waited for the btreevacuumlock wait event to read or update the vacuum related information for a B-tree index.
The amount of time that the server has waited for the addinshmeminitlock wait event to manage space allocation in shared memory.
The amount of time that the server has waited for the autovacuumlock wait event to read or update the current state of autovacuum workers.
The amount of time that the server has waited for the autovacuumschedulelock wait event to ensure that the table selected for a vacuum still needs vacuuming.
The amount of time that the server has waited for the syncscanlock wait event to get the start location of a scan on a table for synchronized scans.
The amount of time that the server has waited for the relationmappinglock wait event to update the relation map file used to store catalog to file node mapping.
The amount of time that the server has waited for the asyncctllock wait event to read or update shared notification state.
The amount of time that the server has waited for the asyncqueuelock wait event to read or update the notification messages.
The amount of time that the server has waited for the serializablexacthashlock wait event to retrieve or store information about serializable transactions.
The amount of time that the server has waited for the serializablefinishedlistlock wait event to access the list of finished serializable transactions.
The amount of time that the server has waited for the serializablepredicatelocklistlock wait event to perform an operation on a list of locks held by serializable transactions.
The amount of time that the server has waited for the oldserxidlock wait event to read or record the conflicting serializable transactions.
The amount of time that the server has waited for the syncreplock wait event to read or update information about synchronous replicas.
The amount of time that the server has waited for the backgroundworkerlock wait event to read or update the background worker state.
The amount of time that the server has waited for the dynamicsharedmemorycontrollock wait event to read or update the dynamic shared memory state.
The amount of time that the server has waited for the autofilelock wait event to update the postgresql.auto.conf file.
The amount of time that the server has waited for the replicationslotallocationlock wait event to allocate or free a replication slot.
The amount of time that the server has waited for the replicationslotcontrollock wait event to read or update replication slot state.
The amount of time that the server has waited for the committscontrollock wait event to read or update transaction commit timestamps.
The amount of time that the server has waited for the committslock wait event to read or update the last value set for the transaction timestamp.
The amount of time that the server has waited for the replicationoriginlock wait event to set up, drop, or use replication origin.
The amount of time that the server has waited for the multixacttruncationlock wait event to read or truncate multixact information.
The amount of time that the server has waited for the oldsnapshottimemaplock wait event to read or update old snapshot control information.
The amount of time that the server has waited for the backendrandomlock wait event to generate a random number.
The amount of time that the server has waited for the logicalrepworkerlock wait event for an action on logical replication worker to finish.
The amount of time that the server has waited for the clogtruncationlock wait event to truncate the write-ahead log or waiting for write-ahead log truncation to finish.
The amount of time that the server has waited for the bulkloadlock wait event to bulk upload the data.

3 Built-In Packages : 3.11 DBMS_PROFILER : 3.11.8 Using DBMS_PROFILER : 3.11.8.2 DBMS_PROFILER - Reference

Table of Contents Previous Next