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?.
| function_signature | return_type |
|---|---|
| generate_series(integer,integer,integer) | integer |
| generate_series(integer,integer) | integer |
| generate_series(bigint,bigint,bigint) | bigint |
| generate_series(bigint,bigint) | bigint |
| generate_series(numeric,numeric,numeric) | numeric |
| generate_series(numeric,numeric) | numeric |
| generate_series(timestamp without time zone,timestamp without time zone,interval) | timestamp without time zone |
| generate_series(timestamp with time zone,timestamp with time zone,interval) | timestamp with time zone |
SELECT 8
| QUERY PLAN |
|---|
| Function Scan on pg_catalog.generate_series t (cost=0.01..12.51 rows=1000 width=4) (actual time=0.078..0.107 rows=163 loops=1) |
| Output: (day)::date |
| Function Call: generate_series(('2004-03-07'::date)::timestamp with time zone, ('2004-08-16'::date)::timestamp with time zone, '1 day'::interval) |
| Planning Time: 0.025 ms |
| Execution Time: 0.149 ms |
EXPLAIN
| QUERY PLAN |
|---|
| Function Scan on pg_catalog.generate_series t (cost=0.00..12.50 rows=1000 width=4) (actual time=0.027..0.048 rows=163 loops=1) |
| Output: (day)::date |
| Function Call: generate_series('2004-03-07 00:00:00'::timestamp without time zone, '2004-08-16 00:00:00'::timestamp without time zone, '1 day'::interval) |
| Planning Time: 0.014 ms |
| Execution Time: 0.068 ms |
EXPLAIN
| QUERY PLAN |
|---|
| Function Scan on generate_series day (actual rows=163 loops=1) |
| Planning Time: 0.013 ms |
| Execution Time: 0.049 ms |
EXPLAIN
| QUERY PLAN |
|---|
| Result (actual rows=163 loops=1) |
| -> ProjectSet (actual rows=163 loops=1) |
| -> Result (actual rows=1 loops=1) |
| Planning Time: 0.013 ms |
| Execution Time: 0.047 ms |
EXPLAIN