Rework Profiling Docs

[maiadegraaf]

We should update the docs with all the recent changes around profiling.

Relevant PRs:

• https://github.com/duckdb/duckdb/pull/11101
• https://github.com/duckdb/duckdb/pull/12498
• https://github.com/duckdb/duckdb/pull/13234
• https://github.com/duckdb/duckdb/pull/13354
• https://github.com/duckdb/duckdb/pull/13430
• https://github.com/duckdb/duckdb/pull/13480
• https://github.com/duckdb/duckdb/pull/13497

Relevant Doc Pages

• Profiling
• EXPLAIN
• EXPLAIN ANALYZE
• Profiling Queries Pragmas

@taniabogatsch

[taniabogatsch]

I agree; maybe @szarnyasg can give input on how to (re?)structure our profiling/EXPLAIN ANALYZE documentation? And then this can go live with/around the upcoming release.

[szarnyasg]

This comment points out that the profiling page should mention the varios enable_profiling options.

[Tishj]

Was https://github.com/duckdb/duckdb/pull/13649 already covered?

[Tishj]

https://github.com/duckdb/duckdb/pull/13160 might also need to be covered on the C-API page