pg_wait_sampling
pg_wait_sampling copied to clipboard
postgrespro
Sampling based statistics of wait events
Hi, I have `pg_stat_statements` and `pg_wait_sampling` loaded on PostgreSQL 11.5 ``` postgres=# show shared_preload_libraries ; shared_preload_libraries --------------------------------------------------- timescaledb, pg_stat_statements, pg_wait_sampling (1 row) postgres=# \dx List of installed extensions Name |...
The case of _not waiting_ (`wait_event_info == 0`) is no less important than the case of waiting. Absence of "no wait" counts in profile make it impossible to compare waiting...
To simplify interaction between collector process and client backends requesting profile or history data the current patch adds shared data structures to store statistics: the fixed-size shared hash table to...
postgres=# select version(); version --------------------------------------------------------------------------------------------------------- PostgreSQL 12.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit (1 row) postgres=# select name,setting from pg_settings where name like 'pg_wait_sampling%';...
wait events of idle processes reported in the same as wait events of active process (state from pg_stat_activity) ``` select wait_event, state from pg_stat_activity where state = 'idle'; wait_event |...
The worker might have not started yet or it may never start, because its registration was cancelled due to worker limit. This commit adds a check for NULL value of...
Following the discussion in #94, I decided to add more columns to pg_wait_sampling_current/history/profile I've added most of the columns from request in #94, but some fields from "pg_stat_activity" (= `localBackendStatusTable`)...
The only dimensions captured right now for wait events are `pid` and `queryid`. It would be helpful to capture additional dimensions for troubleshooting issues. `roleId` and `databaseId` should be easy...
