Open
Description
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 | Version | Schema | Description --------------------+---------+------------+------------------------------------------------------------------- pg_stat_statements | 1.6 | public | track execution statistics of all SQL statements executed pg_wait_sampling | 1.1 | public | sampling based statistics of wait events plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language timescaledb | 1.5.0 | public | Enables scalable inserts and complex queries for time-series data (4 rows) postgres=# show pg_wait_sampling.profile_queries ; pg_wait_sampling.profile_queries ---------------------------------- on (1 row)
I am forcing a lock like this:
session 1:
begin; truncate a;
session 2:
insert into a values (1)
This shows up as so:
postgres=# select * from pg_wait_sampling_current where event = 'relation'; pid | event_type | event | queryid -----+------------+----------+--------- 634 | Lock | relation | 0 (1 row)
Why is queryid not populated?