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?