/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/pg_stat_statements/expected/parallel.out
34 строки
940 B
Michael Paquier
pg_stat_statements: Add columns to track parallel worker activity
09 окт 2024, 02:30
09 окт 2024, 02:30
cf54a2c
Код
Авторство
О чём код?
-- -- Tests for parallel statistics -- SET pg_stat_statements.track_utility = FALSE; -- encourage use of parallel plans SET parallel_setup_cost = 0; SET parallel_tuple_cost = 0; SET min_parallel_table_scan_size = 0; SET max_parallel_workers_per_gather = 2; CREATE TABLE pgss_parallel_tab (a int); SELECT pg_stat_statements_reset() IS NOT NULL AS t; t --- t (1 row) SELECT count(*) FROM pgss_parallel_tab; count ------- 0 (1 row) SELECT query, parallel_workers_to_launch > 0 AS has_workers_to_launch, parallel_workers_launched > 0 AS has_workers_launched FROM pg_stat_statements WHERE query ~ 'SELECT count' ORDER BY query COLLATE "C"; query | has_workers_to_launch | has_workers_launched ----------------------------------------+-----------------------+---------------------- SELECT count(*) FROM pgss_parallel_tab | t | t (1 row) DROP TABLE pgss_parallel_tab;