cli: unredacted debug zip query for transaction_contention_events table too slow

[xinhaoz]

#118478 aimed to add the query texts for transactions in crdb_internal.transaction_contention_events to the debug zip. We've seen this query timeout for clusters experiencing a lot of contention. The join collecting the blocking transaction's query strings results in a full scan of the system.statement_statistics table and should be removed. We can investigate other options or queries that may preserve some of this information.

Update May 16:
We'll do 3 things to improve upon what was added:

1. Increase default timeout - a couple of of other queries (e.g. cluster locks table) are also timing out, so we should just increaes the default itmeout. Note that there's also a CLI flag for users to set this.
2. Include a fallback query in addition to the one that was added above that includes the non-expensive information
3. Improve runtime of the added query by using the index on statement fingerprint id (we'll have to join on the txn stats table to accomplish this)

Jira issue: CRDB-38628