[New Feature][Query Diagnostics] Bundle of troubleshooting data per query

[IshanChhangani]

Description

Solving query issues in customer environments can be cumbersome. The Query Diagnostics feature aims to streamline this process. In the first phase, offers̄ support personnel with a comprehensive solution to gather all necessary data from the customer in one go. This data includes:

• Explain plan (.txt)
• Bind variables (.csv)
• PG stat statements (.csv)
• Schema details (.txt)
• Active Session History (.csv)
• Queryid to QueryString (.csv)

The process involves initiating a function within the SQL shell along with the required parameters. Subsequently, the collected data is dumped into a folder within the file system.

This issue tracks DB side changes needed for query diagnostics:

• [YSQL][Query Diagnostics] Establish Infrastructure for yb_query_diagnostics #22144
• [YSQL][Query Diagnostics] Collect bind variables data #22145
• [YSQL][Query Diagnostics] Collect schema information #22146
• [YSQL][Query Diagnostics] Collect pg_stat_statements data #22147
• [YSQL][Query Diagnostics] Collect ASH data #22148
• [YSQL][Query Diagnostics] QueryId and Query-string Mapping #22149
• [YSQL][Query Diagnostics] Collect Explain plans #22150
• [YSQL][Query Diagnostics] Add support for EXPLAIN (ANALYZE, DIST, DEBUG) #22151
• [YSQL][Query Diagnostics] Sampling and timing limits #22152
• [YSQL][Query Diagnostics] Flush Mechanism #22153

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.