Something went wrong. Try again.
Something went wrong. Try again.
3.0 kB · 90 lines
SQL
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091BEGIN;SELECT plan(20);
SELECT ok((SELECT count(*) >= 0 FROM pg_firstAid()), 'pg_firstAid() executes');SELECT ok((SELECT count(*) >= 0 FROM v_pgfirstaid), 'v_pgfirstaid executes');
SELECT ok( (SELECT count(*) >= 0 FROM pg_firstAid() WHERE check_name IS NOT NULL), 'Function returns non-null check names');
SELECT ok( (SELECT count(*) >= 0 FROM v_pgfirstaid WHERE check_name IS NOT NULL), 'View returns non-null check names');
SELECT ok( (SELECT count(*) >= 1 FROM pg_firstAid() WHERE check_name = 'shared_buffers Setting'), 'Function executes shared_buffers Setting check');SELECT ok( (SELECT count(*) >= 1 FROM v_pgfirstaid WHERE check_name = 'shared_buffers Setting'), 'View executes shared_buffers Setting check');
SELECT ok( (SELECT count(*) >= 1 FROM pg_firstAid() WHERE check_name = 'work_mem Setting'), 'Function executes work_mem Setting check');SELECT ok( (SELECT count(*) >= 1 FROM v_pgfirstaid WHERE check_name = 'work_mem Setting'), 'View executes work_mem Setting check');
SELECT ok( (SELECT count(*) >= 1 FROM pg_firstAid() WHERE check_name = 'effective_cache_size Setting'), 'Function executes effective_cache_size Setting check');SELECT ok( (SELECT count(*) >= 1 FROM v_pgfirstaid WHERE check_name = 'effective_cache_size Setting'), 'View executes effective_cache_size Setting check');
SELECT ok( (SELECT count(*) >= 1 FROM pg_firstAid() WHERE check_name = 'maintenance_work_mem Setting'), 'Function executes maintenance_work_mem Setting check');SELECT ok( (SELECT count(*) >= 1 FROM v_pgfirstaid WHERE check_name = 'maintenance_work_mem Setting'), 'View executes maintenance_work_mem Setting check');
SELECT ok( (SELECT count(*) >= 1 FROM pg_firstAid() WHERE check_name = 'Transaction ID Wraparound Risk'), 'Function executes Transaction ID Wraparound Risk check');SELECT ok( (SELECT count(*) >= 1 FROM v_pgfirstaid WHERE check_name = 'Transaction ID Wraparound Risk'), 'View executes Transaction ID Wraparound Risk check');
SELECT ok( (SELECT count(*) >= 1 FROM pg_firstAid() WHERE check_name = 'Checkpoint Stats'), 'Function executes Checkpoint Stats check');SELECT ok( (SELECT count(*) >= 1 FROM v_pgfirstaid WHERE check_name = 'Checkpoint Stats'), 'View executes Checkpoint Stats check');
SELECT ok( (SELECT count(*) >= 1 FROM pg_firstAid() WHERE check_name = 'Server Role'), 'Function executes Server Role check');SELECT ok( (SELECT count(*) >= 1 FROM v_pgfirstaid WHERE check_name = 'Server Role'), 'View executes Server Role check');
SELECT ok( (SELECT count(*) >= 1 FROM pg_firstAid() WHERE check_name = 'Connection Utilization'), 'Function executes Connection Utilization check');SELECT ok( (SELECT count(*) >= 1 FROM v_pgfirstaid WHERE check_name = 'Connection Utilization'), 'View executes Connection Utilization check');
SELECT * FROM finish();ROLLBACK;