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?.
CREATE TABLE
INSERT 0 1100
ERROR: unterminated quoted string at or near "'SELECT generate_series(1,5)$$ -- more? ) AS ct (row_name int, localt timestamp, entity int , msrmnt01 float8, msrmnt02 float8, msrmnt03 float8, msrmnt04 float8, msrmnt05 float8 -- , more? ) LIMIT 15;" LINE 9: , 'SELECT generate_series(1,5)$$ -- more? ^
QUERY PLAN |
---|
Limit (cost=0.00..0.15 rows=15 width=52) (actual time=4.958..4.962 rows=15 loops=1) |
-> Function Scan on crosstab ct (cost=0.00..10.00 rows=1000 width=52) (actual time=4.957..4.959 rows=15 loops=1) |
Planning Time: 0.037 ms |
Execution Time: 5.391 ms |
EXPLAIN