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=13.532..13.538 rows=15 loops=1) |
-> Function Scan on crosstab ct (cost=0.00..10.00 rows=1000 width=52) (actual time=13.382..13.385 rows=15 loops=1) |
Planning Time: 0.057 ms |
Execution Time: 43.167 ms |
EXPLAIN