queries.out

CREATE EXTENSION pg_wait_sampling;
WITH t as (SELECT sum(0) FROM pg_wait_sampling_current)
	SELECT sum(0) FROM generate_series(1, 2), t;
 sum 
-----
   0
(1 row)

WITH t as (SELECT sum(0) FROM pg_wait_sampling_history)
	SELECT sum(0) FROM generate_series(1, 2), t;
 sum 
-----
   0
(1 row)

WITH t as (SELECT sum(0) FROM pg_wait_sampling_profile)
	SELECT sum(0) FROM generate_series(1, 2), t;
 sum 
-----
   0
(1 row)

-- Some dummy checks just to be sure that all our functions work and return something.
SELECT count(*) = 1 as test FROM pg_wait_sampling_get_current(pg_backend_pid());
 test 
------
 t
(1 row)

SELECT count(*) >= 0 as test FROM pg_wait_sampling_get_profile();
 test 
------
 t
(1 row)

SELECT count(*) >= 0 as test FROM pg_wait_sampling_get_history();
 test 
------
 t
(1 row)

SELECT pg_wait_sampling_reset_profile();
 pg_wait_sampling_reset_profile 
--------------------------------
 
(1 row)

DROP EXTENSION pg_wait_sampling;