Summarize contention events in CockroachDB

contention.sql

  WITH c AS (
          SELECT DISTINCT ON (table_id, index_id)
                 table_id,
                 index_id,
                 num_contention_events AS events,
                 cumulative_contention_time AS times
            FROM crdb_internal.cluster_contention_events
         )
SELECT i.descriptor_name, i.index_name, c.events, c.times
  FROM crdb_internal.table_indexes AS i
  JOIN c ON i.descriptor_id = c.table_id AND i.index_id = c.index_id;