Commita1a340f

committed

Add some dummy tests to check all pg_wait_sampling functions

1 parent4c7549e commita1a340fCopy full SHA for a1a340f

File tree

+23

-0

lines changed

+23

-0

lines changed

Lines changed: 19 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -20,6 +20,25 @@ WITH t as (SELECT sum(0) FROM pg_wait_sampling_profile)`
`20`	`20`	`0`
`21`	`21`	`(1 row)`
`22`	`22`
	`23`	`+-- Some dummy checks just to be sure that all our functions work and return something.`
	`24`	`+SELECT count(*) = 1 as test FROM pg_wait_sampling_get_current(pg_backend_pid());`
	`25`	`+ test`
	`26`	`+------`
	`27`	`+ t`
	`28`	`+(1 row)`
	`29`	`+`
	`30`	`+SELECT count(*) > 5 as test FROM pg_wait_sampling_get_profile();`
	`31`	`+ test`
	`32`	`+------`
	`33`	`+ t`
	`34`	`+(1 row)`
	`35`	`+`
	`36`	`+SELECT count(*) > 100 as test FROM pg_wait_sampling_get_history();`
	`37`	`+ test`
	`38`	`+------`
	`39`	`+ t`
	`40`	`+(1 row)`
	`41`	`+`
`23`	`42`	`SELECT pg_wait_sampling_reset_profile();`
`24`	`43`	`pg_wait_sampling_reset_profile`
`25`	`44`	`--------------------------------`

Lines changed: 4 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -9,6 +9,10 @@ WITH t as (SELECT sum(0) FROM pg_wait_sampling_history)`
`9`	`9`	`WITH tas (SELECTsum(0)FROM pg_wait_sampling_profile)`
`10`	`10`	`SELECTsum(0)FROM generate_series(1,2), t;`
`11`	`11`
	`12`	`+-- Some dummy checks just to be sure that all our functions work and return something.`
	`13`	`+SELECTcount(*)=1as testFROM pg_wait_sampling_get_current(pg_backend_pid());`
	`14`	`+SELECTcount(*)>5as testFROM pg_wait_sampling_get_profile();`
	`15`	`+SELECTcount(*)>100as testFROM pg_wait_sampling_get_history();`
`12`	`16`	`SELECT pg_wait_sampling_reset_profile();`
`13`	`17`
`14`	`18`	`DROP EXTENSION pg_wait_sampling;`

Comments

(0)