Something went wrong. Try again.
Something went wrong. Try again.
3.3 kB · 93 lines
SQL
at main
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394BEGIN;-- Cache results once; querying inline per-assertion multiplies execution cost by N.CREATE TEMP TABLE _pgfa_func_results AS SELECT * FROM pg_firstAid();CREATE TEMP TABLE _pgfa_view_results AS SELECT * FROM v_pgfirstaid;SELECT plan(20);
SELECT ok((SELECT count(*) >= 0 FROM _pgfa_func_results), 'pg_firstAid() executes');SELECT ok((SELECT count(*) >= 0 FROM _pgfa_view_results), 'v_pgfirstaid executes');
SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_func_results WHERE check_name IS NOT NULL), 'Function returns non-null check names');
SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_view_results WHERE check_name IS NOT NULL), 'View returns non-null check names');
SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_func_results WHERE check_name = 'shared_buffers Setting'), 'Function executes shared_buffers Setting check');SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_view_results WHERE check_name = 'shared_buffers Setting'), 'View executes shared_buffers Setting check');
SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_func_results WHERE check_name = 'work_mem Setting'), 'Function executes work_mem Setting check');SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_view_results WHERE check_name = 'work_mem Setting'), 'View executes work_mem Setting check');
SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_func_results WHERE check_name = 'effective_cache_size Setting'), 'Function executes effective_cache_size Setting check');SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_view_results WHERE check_name = 'effective_cache_size Setting'), 'View executes effective_cache_size Setting check');
SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_func_results WHERE check_name = 'maintenance_work_mem Setting'), 'Function executes maintenance_work_mem Setting check');SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_view_results WHERE check_name = 'maintenance_work_mem Setting'), 'View executes maintenance_work_mem Setting check');
SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_func_results WHERE check_name = 'Transaction ID Wraparound Risk'), 'Function executes Transaction ID Wraparound Risk check');SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_view_results WHERE check_name = 'Transaction ID Wraparound Risk'), 'View executes Transaction ID Wraparound Risk check');
SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_func_results WHERE check_name = 'Checkpoint Stats'), 'Function executes Checkpoint Stats check');SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_view_results WHERE check_name = 'Checkpoint Stats'), 'View executes Checkpoint Stats check');
SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_func_results WHERE check_name = 'Server Role'), 'Function executes Server Role check');SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_view_results WHERE check_name = 'Server Role'), 'View executes Server Role check');
SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_func_results WHERE check_name = 'Connection Utilization'), 'Function executes Connection Utilization check');SELECT ok( (SELECT count(*) >= 1 FROM _pgfa_view_results WHERE check_name = 'Connection Utilization'), 'View executes Connection Utilization check');
SELECT * FROM finish();ROLLBACK;