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?.
word_permutations
ABCD
A BCD
AB CD
A B CD
ABC D
A BC D
AB C D
A B C D
word_permutations_yper
ABCD
AB CD
A BCD
A B CD
ABC D
AB C D
A BC D
A B C D
word_permutations2
ABCD
AB CD
A BCD
A B CD
ABC D
AB C D
A BC D
A B C D
QUERY PLAN
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=32768 loops=1)
  -> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1)
Planning Time: 0.012 ms
Execution Time: 27.925 ms
QUERY PLAN
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=32768 loops=1)
  -> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1)
Planning Time: 0.025 ms
Execution Time: 10.949 ms
QUERY PLAN
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=32768 loops=1)
  -> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1)
Planning Time: 0.019 ms
Execution Time: 11.564 ms
QUERY PLAN
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=65536 loops=1)
  -> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1)
Planning Time: 0.019 ms
Execution Time: 60.356 ms
QUERY PLAN
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=65536 loops=1)
  -> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1)
Planning Time: 0.028 ms
Execution Time: 28.819 ms
QUERY PLAN
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=65536 loops=1)
  -> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1)
Planning Time: 0.027 ms
Execution Time: 27.761 ms
QUERY PLAN
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=1048576 loops=1)
  -> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1)
Planning Time: 0.036 ms
Execution Time: 1014.899 ms
QUERY PLAN
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=1048576 loops=1)
  -> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1)
Planning Time: 0.029 ms
Execution Time: 420.173 ms
QUERY PLAN
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=1048576 loops=1)
  -> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1)
Planning Time: 0.028 ms
Execution Time: 407.697 ms