Added minimal test for pg_wait_sampling

vbwagner · vbwagner · commit 3fbf70773448 · 2017-01-27T10:06:19.000+03:00
diff --git a/Makefile b/Makefile
@@ -6,6 +6,10 @@ OBJS = pg_wait_sampling.o collector.o
 EXTENSION = pg_wait_sampling
 DATA = pg_wait_sampling--1.0.sql
 
+REGRESS = load
+
+EXTRA_REGRESS_OPTS=--temp-config=$(top_srcdir)/$(subdir)/conf.add
+
 ifdef USE_PGXS
 PG_CONFIG = pg_config
 PGXS := $(shell $(PG_CONFIG) --pgxs)
diff --git a/conf.add b/conf.add
@@ -0,0 +1 @@
+shared_preload_libraries = 'pg_wait_sampling'
diff --git a/expected/load.out b/expected/load.out
@@ -0,0 +1,19 @@
+CREATE EXTENSION pg_wait_sampling;
+\d pg_wait_sampling_current
+View "public.pg_wait_sampling_current"
+   Column   |  Type   | Modifiers 
+------------+---------+-----------
+ pid        | integer | 
+ event_type | text    | 
+ event      | text    | 
+
+\d pg_wait_sampling_history
+      View "public.pg_wait_sampling_history"
+   Column   |           Type           | Modifiers 
+------------+--------------------------+-----------
+ pid        | integer                  | 
+ ts         | timestamp with time zone | 
+ event_type | text                     | 
+ event      | text                     | 
+
+DROP EXTENSION pg_wait_sampling;
diff --git a/sql/load.sql b/sql/load.sql
@@ -0,0 +1,7 @@
+CREATE EXTENSION pg_wait_sampling;
+
+\d pg_wait_sampling_current
+
+\d pg_wait_sampling_history
+
+DROP EXTENSION pg_wait_sampling;

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+shared_preload_libraries = 'pg_wait_sampling'`