Skip to content

No per process wait stats #17

Open
@jamessewell

Description

@jamessewell

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?

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      close