Very slow plugin….retrieves huge amount of rows

This plugin will occasionally bog down our entire site. When I install the debugging plugin “Query Monitor” I can clearly see that this redirect plugin asks for 14500 each time a page loads…this can at times crash our server. Surely this could be engineered better.

The query in question is:

The plugin generates some unusually large queries. eg SELECT *
FROM wp_postmeta as m1
WHERE m1.post_id IN (
SELECT post_id
FROM wp_postmeta as m
WHERE 1 = 1
AND m.meta_key =’_pprredirect_active’
AND m.meta_value = ‘1’);

That provides an insane 14504 rows.