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?.
10 rows affected
QUERY PLAN |
---|
Bitmap Heap Scan on posts (cost=16.03..26.53 rows=4 width=36) (actual time=0.117..0.118 rows=1 loops=1) |
Recheck Cond: ('''discoveri'''::tsquery @@ to_tsvector('english'::regconfig, ((title || ' '::text) || content))) |
Heap Blocks: exact=1 |
-> Bitmap Index Scan on post_search (cost=0.00..16.03 rows=4 width=0) (actual time=0.014..0.014 rows=1 loops=1) |
Index Cond: ('''discoveri'''::tsquery @@ to_tsvector('english'::regconfig, ((title || ' '::text) || content))) |
Planning Time: 0.301 ms |
Execution Time: 0.152 ms |