Version: 3.1
Issue: The bellow query is top in our database server.
Need help identify the opportunity is this query is cached in latest 6.2 or it is an opportunity improve latest version.
can you help validate this issue ?
norbert
Ready, implemented cache in MReference and MRefTable
We tested in last 24h in production. Result: approx 2mill queries.
IMHO i assume the caching not working yet.
SELECT
calls,
(total_time / 1000 / 60)::decimal as total_minutes,
(total_time/calls)::decimal as average_time,
query
FROM pg_stat_statements
-- WHERE Query ilike '%1001231%'
ORDER BY 1 DESC
LIMIT 100;
Â
Hi , could be something in your custom code using new X_AD_Reference or new MReference
Regards,
Carlos Ruiz