Find Ring Intersections

1. Run the trim_ring_xmr_xmv.py script that is located in the scripts/hardforks/monerov directory.

   python3 trim_ring_xmr_xmv.py
   

   This script will replace the fork_indices column in xmr_xmv_keyimages with the intersection of the transaction rings.

   Note: This script reads the Python dictionary mapping (ring_amount, index) pairs to the one-time addresses from the file called xmr_xmv_addr.dat. Ensure that this file is in the same directory as the script.

2. You can query the number of transaction rings where the actual output being spent has been identified by running the following query in the psql shell.

   SELECT COUNT(*) FROM xmr_xmv_keyimages WHERE ARRAY_LENGTH(fork_indices,1) = 1 AND ARRAY_LENGTH(distinct_ring_indices, 1) <> 1;
   

   The result of this query was 7287. Note that the query restricts the block height to 2530000.