Skip to content

EXPLAIN ANALYZE returns a wrong number of pruned and matched Parquet pages #22030

@nuno-faria

Description

@nuno-faria

Describe the bug

The number of pruned and matched Parquet pages shown by the EXPLAIN ANALYZE is wrong when the scan contains multiple pruning predicates.

To Reproduce

copy (select i as k, i as v from generate_series(1, 10) t(i))
to 't.parquet'
options (DATA_PAGE_ROW_COUNT_LIMIT 1, WRITE_BATCH_SIZE 1);

create external table t stored as parquet location 't.parquet';

explain analyze select * from t where k > 5 and v > 5;
    -- shows 20 pages total and 10 matched, but should be 10 total and 5 matched
    -- page_index_pages_pruned=20 total → 10 matched

Expected behavior

No response

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No fields configured for Bug.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions