search

paradedb / pg_analytics

DuckDB-powered analytics for Postgres
https://paradedb.com
PostgreSQL License
383 stars 15 forks source link

Enhance `EXPLAIN` Statement: Add `analyze` option, Support `style` option #124

Open kysshsy opened 2 months ago

kysshsy commented 2 months ago

What feature are you requesting?

After #64 is merged, we will only show Duckdb Scan: query to indicate that we have pushed down the query to DuckDB.

We could make the EXPLAIN statement more informative for users. Support analyze option and more options.

Why are you requesting this feature?

Make the EXPLAIN statement more informative for users.

What is your proposed implementation for this feature?

  1. We can display actual run times from the PostgreSQL side.
  2. Support a new style option. By default, we show the PostgreSQL style plan, but we can display the DuckDB style plan if the user specifies it. It may be more informative.

Full Name:

kyss

Affiliation:

NA

kysshsy commented 1 month ago

/take