May 2018
Intermediate to advanced
576 pages
30h 25m
English
The pg_stat_activity system view includes the wait_event_type and wait_event columns, which are set respectively to the kind of wait and to the kind of object that is blocked.
The preceding query uses the wait_event field to filter out only those queries that are waiting.