12.6 Catalog Views

Table of Contents Previous Next



The edb$system_waits view summarizes the number of waits and the total wait time per session for each wait named. It also displays the average and max wait times. The following example shows the result of a SELECT statement on the edb$system_waits view:
edb$system_waits summarizes the following information:
The edb$session_waits view summarizes the number of waits and the total wait time per session for each wait named and identified by backend ID. It also displays the average and max wait times. The following code sample shows the result of a SELECT statement on the edb$session_waits view:
edb$session_waits summarizes the following information:
The edb$session_wait_history view contains the last 25 wait events for each backend ID active during the session. The following code sample shows the result of a SELECT statement on the edb$session_wait_history view:
The edb$session_wait_history view includes the following information:
The values contained in the p1, p2, and p3 columns are wait-specific. The following waits include information in those columns:
The file ID from pg_class.relfilenode
The file ID from pg_class.relfilenode
The file ID from pg_class.relfilenode
1 if True, 0 if False
The file ID from pg_class.relfilenode
The file ID from pg_class.relfilenode
For all other event types, the p1, p2, and p3 columns are unused.


Table of Contents Previous Next