By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
version |
---|
PostgreSQL 14.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-4), 64-bit |
string_agg |
---|
I, use, Python, SQL, C++, I, need, apples, and, oranges |
array_to_string |
---|
I, use, Python, SQL, C++, I, need, apples, and, oranges |
QUERY PLAN |
---|
ProjectSet (cost=17.52..5017.54 rows=1000000 width=36) (actual rows=1000000 loops=1) |
-> Aggregate (cost=17.52..17.53 rows=1 width=32) (actual rows=1 loops=1) |
-> ProjectSet (cost=0.00..5.02 rows=1000 width=64) (actual rows=10 loops=1) |
-> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1) |
Planning Time: 0.052 ms |
Execution Time: 59.652 ms |
QUERY PLAN |
---|
ProjectSet (cost=0.00..5000.02 rows=1000000 width=36) (actual rows=1000000 loops=1) |
-> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1) |
Planning Time: 0.052 ms |
Execution Time: 822.743 ms |