Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

No per process wait stats #17

Open
@jamessewell

Description

@jamessewell

Hi,

I havepg_stat_statements andpg_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


      [8]ページ先頭

      ©2009-2025 Movatter.jp