This repository has no description
1-- Create a simple function to get the total count of records
2-- This uses a different counting mechanism to avoid any potential caching issues
3
4CREATE OR REPLACE FUNCTION get_total_flush_count()
5RETURNS INTEGER
6LANGUAGE SQL
7AS $$
8 -- Simple, direct query to count all records
9 SELECT COUNT(id)::INTEGER
10 FROM flushing_records;
11$$;
12
13-- Test the function
14SELECT get_total_flush_count();