Skip to content

EXPLAIN VERBOSE "FDW Time" does not look right #144

@theory

Description

@theory

Example:

EXPLAIN (ANALYZE, VERBOSE) SELECT COUNT(*) FROM hits WHERE "URL" LIKE '%google%';
 Foreign Scan  (cost=1.00..0.20 rows=1000 width=8) (actual time=10.212..10.214 rows=1 loops=1)
   Output: (count(*))
   Relations: Aggregate on (hits)
   Remote SQL: SELECT count(*) FROM "default".hits WHERE (("URL" LIKE '%google%'))
   FDW Time: 0.017 ms
 Planning Time: 0.998 ms
 Execution Time: 10.511 ms

Seems like pg_clickhouse is not properly recording the full time it spends planning and executing. Should that be its full time? Just planning?

Metadata

Metadata

Assignees

No one assigned

    Labels

    benchmarksBenchmark and standard test improvementsbugSomething isn't workingqualityQuality controls, testing, test coverage

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions