add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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