ClickHouse / ClickHouse/pg_clickhouse

EXPLAIN VERBOSE "FDW Time" does not look right

Open
#144 0 comments 0 reactions 0 assignees View on GitHub
benchmarks bug quality
Dominant language
C
Stars
283
Forks
21
Avg merge
2d 6h
Merged PRs (30d)
11

Description

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?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.