By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
CREATE INDEX
| QUERY PLAN |
|---|
| Subquery Scan on q1 (cost=0.15..104.48 rows=6 width=36) (actual time=0.016..0.017 rows=0 loops=1) |
| Filter: (q1.qualified = 1) |
| -> WindowAgg (cost=0.15..88.60 rows=1270 width=40) (actual time=0.015..0.016 rows=0 loops=1) |
| -> Index Only Scan Backward using idx_creativescheduleid_id on creative_schedule_status_histories cssh (cost=0.15..63.20 rows=1270 width=36) (actual time=0.013..0.013 rows=0 loops=1) |
| Heap Fetches: 0 |
| Planning Time: 0.467 ms |
| Execution Time: 0.074 ms |
EXPLAIN