sushantrmishra

Jira Link: [DB-3147](https://yugabyte.atlassian.net/browse/DB-3147) ### Description As we are implementing `yb_terminated_queries` to track the queries which are being terminated due to abnormal reason. We should do the following enhancements 1. Allow...

Jira Link: [DB-3150](https://yugabyte.atlassian.net/browse/DB-3150) ### Description For analyzing the memory context, we upstream this diff from postgres 14: ``` Add pg_backend_memory_contexts system view (from postgres upstream commit 3e98c0bafb28de87ae095b341687dc082371af54) This view displays...

Jira Link: [DB-3044](https://yugabyte.atlassian.net/browse/DB-3044) ### Description PG14 CREATE STATISTICS commands support MCV also. From https://www.postgresql.org/docs/current/sql-createstatistics.html (PG14). `A multivariate statistics kind to be computed in this statistics object. Currently supported kinds are...

Jira Link: [DB-1027](https://yugabyte.atlassian.net/browse/DB-1027) ### Description `pg_cron` table creates two tables in system_platform database. 1. `job description` table which contain the information about scheduled jobs. 2. Another table named `job_run_details` which...

Jira Link: [DB-955](https://yugabyte.atlassian.net/browse/DB-955) ### Description Currently our explain (analyze) plan are borrowed from the PostrgreSQL. We should enhance the output of explain plans to display additional information distributed aspect of...

[YSQL] Add metrics to show queries terminated due to temp_file_limit reached

1

Jira Link: [DB-2656](https://yugabyte.atlassian.net/browse/DB-2656) ### Description Currently when the queries breaches the temporary file size exceeds `temp_file_limit` then following error is returned. `"temporary file size exceeds temp_file_limit (%dkB)", temp_file_limit; ` **For...