Nobody hurts a payments database with fraud checks. They hurt it with the month-end revenue dashboard.
Postgres is a row store, built for OLTP. All 8 columns of a payment sit together on disk. To SUM one column it reads all 8. 7 are waste. And that scan fights your checkout...