php average time calculation algorithm?

Question

PHP

Guys, I have such a table. joxi.ru/Q2KGVxgU5kZN2j
It contains about 100 thousand entries in different categories. Which are parsed once a minute.
How can I determine the average time to add a record to the database for one category?
And all this in php? Are there any ready-made algorithms or scripts?
and What would I get as a result: the average time to add to the database is 5 minutes for category A.

Answer 1

MySQL table?
Something like:

SELECT (MAX(date) - MIN(date)) / (60 * 24 * COUNT(*)) FROM ... GROUP BY date